Password File Creation

[jtanner]

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

 

[SantaMufasa]

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.

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]

 

[tmf33uk]

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.