ORA-00700 ORA-48209 ORA-48122 ORA-48126

Error Messeages

ORA-00700: soft internal error, arguments: [dbgrmblcp_corrupt_page], [/oracle/app/oracle/diag/rdbms/test/test/metadata/INC_METER_CONFIG.ams], [0], [], [], [], [], [], [], [], [], []
ORA-48209: Relation Already Exists
ORA-48122: error with opening the ADR block file [/oracle/app/oracle/diag/rdbms/test/test/metadata/INC_METER_CONFIG.ams] [0]
ORA-48126: attempting to create a file that already exists
Incident details in: /oracle/app/oracle/diag/rdbms/test/test/incident/incdir_64300/test_ora_15645_i64300.trc
Errors in file /oracle/app/oracle/diag/rdbms/test/test/trace/test_ora_15645.trc  (incident=64301):
ORA-00600: internal error code, arguments: [dbgrmblgp_get_page_1], [0], [11], [1], [], [], [], [], [], [], [], []
ORA-48209: Relation Already Exists
ORA-48122: error with opening the ADR block file [/oracle/app/oracle/diag/rdbms/test/test/metadata/INC_METER_CONFIG.ams] [0]
ORA-48126: attempting to create a file that already exists
Incident details in: /oracle/app/oracle/diag/rdbms/test/test/incident/incdir_64301/test_ora_15645_i64301.trc

 

 

원인

 

●  ADRCI가 이미 존재하거나 손상된 파일을 생성할 경우 발생

●  이 파일은 ADRCI를 통해 자동으로 다시 생성되므로 파일 이름 변경 후 DB 재기동

 

 

해결 방법

 

1. INC_METER_CONFIG.ams 해당 파일 이름 변경

위치 : $ORACLE_BASE/ diag/rdbms/test/test/metadata/INC_METER_CONFIG.ams

mv /oracle/app/oracle/diag/rdbms/test/test/metadata/INC_METER_CONFIG.ams /oracle/app/oracle/diag/rdbms/test/test/metadata/INC_METER_CONFIG.ams_bak

 

2. DB 재기동

$ sqlplus "/as sysdba"
SQL> shutdown immediate;
SQL> startup;

 

 

 

참고

1. oracle support [  문서 ID 2278705.1 ]

https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=76049006843059&parent=EXTERNAL_SEARCH&sourceId=PROBLEM&id=2278705.1&_afrWindowMode=0&_adf.ctrl-state=13jxz478d0_4