Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Password File Creation

Status
Not open for further replies.

jtanner

Technical User
Feb 18, 2007
39
US
Hello,

I need to ensure my new database has a password file.

When the DBCA is run to create a database is a password file automatically created or do I need to manually create one using orapwd file=orapwMYDB password=secret?

Thanks for confirming,

JT
 
Mufasa said:
One test is worth 1000 expert opinions.
Try it and see. I cannot tell you since I run my own "home-grown" scripts to create databases with the least amount of unnecessary overhead, so I don't know what DBCA does. If you run DBCA and it doesn't create a password file, then you know you must run orapwd.

[santa]Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]
 
JT,
you will have to create a password file as this is only necessary if remote_login_passwordfile is set to EXCLUSIVE or SHARED. Other values ignore the existence of the password file, hence I doubt very much DBCA will create it.

T.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top