• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 581
  • Last Modified:

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
0
hussainkhan22
Asked:
hussainkhan22
  • 4
  • 2
1 Solution
 
logictankCommented:
The password file is an operating system file used to store passwords for database SYSDBA or SYSOPER access. The password file is used to authenticate DBAs who must connect remotely to a database and need to perform administrative tasks such as starting and stopping the database. To perform SYSDBA or SYSOPER tasks you need to be able to connect when the database is not open. If a database is not open the passwords stored within that database are not accessible. By storing the administrative passwords in a separate file (orapwSID), Oracle enables remote authentication even when the database is not running.

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.
0
 
hussainkhan22Author Commented:
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
0
 
Franck PachotCommented:
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.
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
logictankCommented:
As long as the dabase user has been granted SYSDBA or SYSOPER they can connect remotely  "as sysdba" with THEIR username/password.  When you create the password file and then grant SYSDBA or SYSOPER to a user it gets added to the password file.  So in your example SAM would connect with:
CONNECT SAM/SAM@ORCL AS SYSDBA;
Make sure the database init.ora parameter is set as follows:
remote_login_passwordfile=EXCLUSIVE
Correct, the password file is used for remote users who need to run SYSDBA or SYSOPER commands against the database (opened or closed).
0
 
logictankCommented:
Addition:
Of course if the role was SYSOPER the connection would be:
CONNECT SAM/SAM@ORCL AS SYSOPER;
0
 
hussainkhan22Author Commented:
What is the use of
remote_login_passwordfile=EXCLUSIVE or shared or none.
Difference between them and which one is used when
0
 
logictankCommented:
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now