📋Steps in this guide1/3

Create password files for database in ASM diskgroup DBACLASS

Below are the steps for creating password file for database in ASM diskgroup . This method is valid only for oracle 12c onwards. SYNTAX – ASMCMD> pwcreate –dbuniquename {db_unique_name} {file_path} {sys_password} Example: Here we will create a password file with dbuniquename PRDPRE. ASMCMD> pwcreate --dbuniquename PRDPRE +DATA/PWDFILE/pwdPRDPRE oracle Check whether new pwdfile is created or […]

oracle clusteringintermediate

by OracleDba

22 views

Overview

Below are the steps for creating password file for database in ASM diskgroup . This method is valid only for oracle 12c onwards. ASMCMD> pwcreate –dbuniquename {db_unique_name} {file_path} {sys_password} Example: Here we will create a password file with dbuniquename PRDPRE.

Section 2

Check whether new pwdfile is created or not: We can check the database config using srvctl also: Another alternative way to create password file inside asm diskgroup is:

Code/Command (click line numbers to comment):

ASMCMD> pwcreate --dbuniquename PRDPRE +DATA/PWDFILE/pwdPRDPRE oracle

ASMCMD> pwget --dbuniquename PRDPRE
+DATA/PWDFILE/pwdPRDPRE

srvctl config database -d PRDPRE


Database unique name: PRDPRE
Database name: PRDPRE
Oracle home: /oracle/app/oracle/product/12.1.0.2/dbhome_1
Oracle user: oracle
Spfile: +DATA/PRDPRE/PARAMETERFILE/spfile.269.943055251
Password file: +DATA/PWDFILE/pwdPRDPRE            --------->>>>>>>>>>>>>>>>>> password file location 
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools:
Disk Groups: DATA,REDOA,REDOB
Mount point paths:
Services:
Type: RAC
Start concurrency:
Stop concurrency:
OSDBA group: dba
OSOPER group: dba
Database instances: PRDPRE1,PRDPRE2

Section 3

Code/Command (click line numbers to comment):

orapwd file='+DATA/orapwPRODPRE' ENTRIES=10 DBUNIQUENAME='PRODPRE'

Comments (0)

Please to add comments

No comments yet. Be the first to comment!