[증상]
Oracle RAC ocssd.bin Process를 Kill 하는 경우 전체 Node 또는 일부 Node가 Reboot 발생
[환경]
IBM AIX + Oracle RAC 19c + Veritas CFS
[원인]
Oracle CSS misscount 값이 30, disktimeout 597로 Setting 되어 있음
[해결책]
Oracle CSS misscount 값을 600으로 변경
[기타사항]
Oracle RAC 19c 구성 후 Veritas Relink 단계에서 Oracle CRS가 기동 되어 있어야 함.
만약, Oracle CRS가 중자 상태에서 Veritas Relink를 수행 하면 Oracle CSS misscount 값을 600으로 변경 하라는 안내 메시지가 나옴.
[참고문서]
Oracle Clusterware에서 CSS Timeout 계산 (Doc ID 2158867.1)
분류 전체보기
Oracle RAC ocssd.bin Process를 Kill 하는 경우 전체 Node 또는 일부 Node가 Reboot 발생
2023. 3. 6. 09:00
반응형
반응형
$GI_HOME/crs/install/rootcrs.pl -patch 실행 시 crsconfig_lib.pm line 11821 발생
2022. 11. 28. 09:00
반응형
[환경]
IBM AIX 7.2 + Oracle CRS/DB 11.2.0.4 + 2-Node RAC + ASM + PSU 11.2.0.4.201020
[증 상]
PSU 11.2.0.4.201020 적용 마지막 단계인 rootcrs.pl -patch 실행 하면 약 10분~15분간 대기 하다 crsconfig_lib.pm line 11821 발생 하며 실패
Oracle ASM Instance 기동 되지 않음
[원 인]
BUG 32123313 - SMR FILE KEEPS GETTING CORRUPTED AFTER APPLYING OCT 2020 DBPSU IN AIX7
Bug 32109594 - ASM IS UNABLE TO START WITH SMR CORRUPTED ERROR POST OCT 2020 PSU APPLY
[해결방법]
Patch 32109594 적용 전 rootcrs.pl -unlock
Patch 32109594를 $GRID_HOME과 $ORACLE_DB_HOME모두 적용
Patch 32109594 적용 후 rootcrs.pl -patch
[참고문서]
AIX:11.2.0.4 :ASM&DB Instance Not Starting Up Due to SMR Corrupt After OCT 2020 PSU (문서 ID 2732507.1)
Oracle MOS를 찾아 보니 IBM AIX 7.2에 PSU 11.2.0.4.201020 이상을 적용하면 발생 하는 것 같다.
반응형
PDB DBF File 경로 변경 하기
2022. 11. 21. 09:00
반응형
현 상태 확인
[oracle@ol7 ~]$ id
uid=54321(oracle) gid=54322(dba) groups=54322(dba) context=unconfined_u:unconfined_r:unconfined_t:s0-s0:c0.c1023
[oracle@ol7 ~]$
[oracle@ol7 ~]$ env | grep SID
ORACLE_SID=CDBTST
[oracle@ol7 ~]$
[oracle@ol7 ~]$ sqlplus "/as sysdba"
SQL*Plus: Release 19.0.0.0.0 - Production on Thu Oct 6 14:49:50 2022
Version 19.16.0.0.0
Copyright (c) 1982, 2022, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.16.0.0.0
SQL> show con_name
CON_NAME
------------------------------
CDB$ROOT
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 PDBTST READ WRITE NO
SQL>
SQL> set linesize 150
SQL> col name for a10
SQL> col FILE_NAME for a20
col file_name for a70
SQL> SELECT VP.NAME, CDF.TABLESPACE_NAME, CDF.FILE_NAME
2 FROM CDB_DATA_FILES CDF, V$PDBS VP
3 WHERE CDF.CON_ID = VP.CON_ID;
NAME TABLESPACE_NAME FILE_NAME
---------- ------------------------------ ----------------------------------------------------------------------
PDBTST SYSTEM /orapdbtst/system/sytem01.dbf
PDBTST SYSAUX /orapdbtst/system/sysaux01.dbf
PDBTST UNDOTBS1 /orapdbtst/system/unotodb01.dbf
PDBTST USERS /orapdbtst/system/user01.dbf
PDBTST TS_DATA /orapdbtst/data/ts_data_01.dbf
PDBTST TS_IDX /u01/app/oracle/product/19.0.0.0/dbs/ /orapdbtst/idx/ts_indx_01.dbf --> 이 것을 변경 하려 함
6 rows selected.
SQL>
SQL> !ls -a /u01/app/oracle/product/19.0.0.0/dbs/
. .. hc_CDBTST.dat hc_TST.dat init.ora lkCDBTST lkTST orapwCDBTST orapwTST spfileCDBTST.ora spfileTST.ora
SQL> !ls -a /u01/app/oracle/product/19.0.0.0/dbs/ /orapdbtst/idx/
/orapdbtst/idx/:
. ..
/u01/app/oracle/product/19.0.0.0/dbs/:
. .. hc_CDBTST.dat hc_TST.dat init.ora lkCDBTST lkTST orapwCDBTST orapwTST spfileCDBTST.ora spfileTST.ora
SQL> !ls -a '/u01/app/oracle/product/19.0.0.0/dbs/ /orapdbtst/idx/'
. .. ts_indx_01.dbf
SQL>
SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.16.0.0.0
[oracle@ol7 ~]$
DBF File Move
[oracle@ol7 ~]$ sqlplus "/as sysdba"
SQL*Plus: Release 19.0.0.0.0 - Production on Thu Oct 6 14:55:47 2022
Version 19.16.0.0.0
Copyright (c) 1982, 2022, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.16.0.0.0
SQL> show con_name
CON_NAME
------------------------------
CDB$ROOT
SQL>
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 PDBTST READ WRITE NO
SQL>
SQL> ALTER SESSION SET CONTAINER=PDBTST;
Session altered.
SQL> show con_name
CON_NAME
------------------------------
PDBTST
SQL>
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
3 PDBTST READ WRITE NO
SQL> select file_name from dba_data_files;
FILE_NAME
--------------------------------------------------------------------------------
/orapdbtst/system/sytem01.dbf
/orapdbtst/system/sysaux01.dbf
/orapdbtst/system/unotodb01.dbf
/orapdbtst/system/user01.dbf
/orapdbtst/data/ts_data_01.dbf
/u01/app/oracle/product/19.0.0.0/dbs/ /orapdbtst/idx/ts_indx_01.dbf
6 rows selected.
SQL> alter database move datafile '/u01/app/oracle/product/19.0.0.0/dbs/ /orapdbtst/idx/ts_indx_01.dbf' to '/orapdbtst/idx/ts_indx_01.dbf';
Database altered.
SQL> !ls -al '/u01/app/oracle/product/19.0.0.0/dbs/ /orapdbtst/idx/ts_indx_01.dbf'
ls: cannot access /u01/app/oracle/product/19.0.0.0/dbs/ /orapdbtst/idx/ts_indx_01.dbf: No such file or directory
SQL> !ls -al /orapdbtst/idx/ts_indx_01.dbf
-rw-r-----. 1 oracle dba 1048584192 Oct 6 15:02 /orapdbtst/idx/ts_indx_01.dbf
SQL>
SQL> select file_name from dba_data_files;
FILE_NAME
--------------------------------------------------------------------------------
/orapdbtst/system/sytem01.dbf
/orapdbtst/system/sysaux01.dbf
/orapdbtst/system/unotodb01.dbf
/orapdbtst/system/user01.dbf
/orapdbtst/data/ts_data_01.dbf
/orapdbtst/idx/ts_indx_01.dbf
6 rows selected.
SQL>
SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.16.0.0.0
[oracle@ol7 ~]$
반응형