[ORACLE] RAC password file 변경

1. password file 설정 유무 확인

$srvctl config database -d orcl

Database unique name: orcl Database name: orcl Oracle home: /oracle/base/product/19 Oracle user: oracle Spfile: +DATA/ORCL/PARAMETERFILE/spfile.268.1106093209 Password file: +DATA/ORCL/PASSWORD/pwdorcl.256.1106091249 Domain: Start options: open Stop options: immediate Database role: PRIMARY Management policy: AUTOMATIC Server pools: Disk Groups: DATA Mount point paths: Services: Type: RAC Start concurrency: Stop concurrency: OSDBA group: dba OSOPER group: Database instances: orcl1,orcl2 Configured nodes: rac1,rac2 CSS critical: no CPU count: 0 Memory target: 0 Maximum memory: 0 Default network number for database services: Database is administrator managed

--> resource에 password file이 지정되어있을 경우 생성이 안됨

$srvctl modify database -d orcl -pwfile

--> password file이 있을 경우 제거!!

 

2. password file 생성

ASMCMD>pwcreate --dbuniquename ORCL --format 12 +DATA/ORCL/PASSWORD/orapwdORCL oracle_4U!@#

$orapwd file='+DATA/rac/PASSWORD/orapwdrac2' dbuniquename='ORCL' password='oracle!@#' format=12

 

3. password file 생성 유무 확인

 

$crsctl stat res ora.rac.db -f | grep PWFILE PWFILE=+DATA/orcl/PASSWORD/orapwdorcl ASMCMD [+DATA/rac/PASSWORD] > pwget --dbuniquename orcl +DATA/orcl/PASSWORD/orapwdorcl

 

 

4. user의 password file 유무 확인

SQL> select * from v$pwfile_users   USERNAME   SYSDB SYSOP SYSAS SYSBA SYSDG SYSKM ACCOUNT_STATUS              PASSWORD_P LAST_LOGIN LOCK_DATE           EXPIRY_DATE      EXTERNAL_N AUTHENTI COM     CON_ID ---------- ----- ----- ----- ----- ----- ----- ------------------------------ ---------- ---------- ------------------ ------------------ ---------- -------- --- ---------- SYS       TRUE  TRUE  FALSE FALSE FALSE FALSE OPEN                                        PASSWORD NO       0

 

* 일반 유저에 sysdba 권한 부여

SQL> create user rman identified by "oracle!@#$"; User created.   SQL> grant sysdba to rman;   Grant succeeded.   SQL> select * from v$pwfile_users;   USERNAME   SYSDB SYSOP SYSAS SYSBA SYSDG SYSKM ACCOUNT_STATUS              PASSWORD_P LAST_LOGIN LOCK_DATE           EXPIRY_DATE      EXTERNAL_N AUTHENTI COM     CON_ID ---------- ----- ----- ----- ----- ----- ----- ------------------------------ ---------- ---------- ------------------ ------------------ ---------- -------- --- ---------- SYS       TRUE  TRUE  FALSE FALSE FALSE FALSE OPEN                                        PASSWORD NO       0 RMAN       TRUE  FALSE FALSE FALSE FALSE FALSE OPEN                                        PASSWORD NO       0