hussainkhan22
asked on
Oracle Password file
Hey guys when we create password file like
orapwd file=abc password=xyz entries=10
What does exactly this password file does can you tell me in detail.
one last question on this as i mention xyz as password for sysdba, so all users having sysdba privilege, likes to do sysdba activities must use "xyz" as the password or thyere own password. Thanks alot for your help in advance
orapwd file=abc password=xyz entries=10
What does exactly this password file does can you tell me in detail.
one last question on this as i mention xyz as password for sysdba, so all users having sysdba privilege, likes to do sysdba activities must use "xyz" as the password or thyere own password. Thanks alot for your help in advance
ASKER
Suppose a user sam with password sam. I created a password file. Orapwd file:abc.com password:boy entries:10. Now if user sam needs to do sysdba activity so sam needs to give which password sam or boy. Lastly is this password file used for remote users only and when database closed or database open also
Hi,
When the password you give when you create the password file is the sys password, so it cannot be sam's password.
password file is used to check remote connections as sysdba - wether the database is open or not.
You may have cases where the password si different in database and in password file (if you copy an old password file for example) and then: password file password is used for sysdba connections and database password is used for non-sysdba connections.
But when you change password with alter user, then both are changed.
Regards,
Franck.
When the password you give when you create the password file is the sys password, so it cannot be sam's password.
password file is used to check remote connections as sysdba - wether the database is open or not.
You may have cases where the password si different in database and in password file (if you copy an old password file for example) and then: password file password is used for sysdba connections and database password is used for non-sysdba connections.
But when you change password with alter user, then both are changed.
Regards,
Franck.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Addition:
Of course if the role was SYSOPER the connection would be:
CONNECT SAM/SAM@ORCL AS SYSOPER;
Of course if the role was SYSOPER the connection would be:
CONNECT SAM/SAM@ORCL AS SYSOPER;
ASKER
What is the use of
remote_login_passwordfile= EXCLUSIVE or shared or none.
Difference between them and which one is used when
remote_login_passwordfile=
Difference between them and which one is used when
Here's the detail on remote_login_passwordfile:
http://download.oracle.com/docs/cd/B28359_01/server.111/b28320/initparams198.htm
http://download.oracle.com/docs/cd/B28359_01/server.111/b28320/initparams198.htm
An example of this would be Oracle Grid/Enterprise Manager starting and stopping a database.
Users connecting remotely that need to run SYSDBA or SYSOPER tasks must use the password stored in the password file.