Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Add passwordfile=... option to sqlplus startup command for 12c

User51642 Yong HuangJan 26 2018 — edited Jan 26 2018

By default, the database password file is stored in ASM instead of on the file system in Oracle 12c (if ASM is used). If the ASM instance cannot be brought up due to loss or corruption of the password file, creating a password file on the file system (with command orapwd) is not helpful. You can't run any asmcmd command to tell ASM to use the password file on the file system because asmcmd needs ASM to be up. Even a command like `crsctl query credmaint' (Ref: Doc ID 1313657.1) won't work. This chicken-and-egg problem can be solved by a passwordfile option for the sqlplus startup command, much like the pfile option.

Alternatively, allow certain very basic asmcmd commands to run even when ASM is down, much like the function provided by -init of crsctl, or -prelim of sqlplus.

Comments
Post Details
Added on Jan 26 2018
4 comments
1,061 views