自己收集oracle報(bào)錯(cuò)代碼及解決辦法

ORA-28547：connection to server failed,probable Oracle Net admin

listener.ora中注釋掉PROGRAM = extproc

ORA-09925: Unable to create audit trail file

show parameter audit_file_dest

mkdir parameter audit_file_dest中位置

ORA-01157/ORA-01110:

RAC1搭建DG后，關(guān)閉RAC1+DG庫(kù)，RAC2數(shù)據(jù)庫(kù)無(wú)法打開(kāi)到open狀態(tài)

startup nomount;

alter database mount;

alter database open;

ERROR at line 1:

ORA-01157: cannot identify/lock data file 6 - see DBWR trace file

ORA-01110: data file 6:

'/oracle/app/oracle/product/11.2.0/db_1/dbs/<oracle_base>oradataorclGLOBAL.DBF'

alter database datafile 6 offline;

alter database open;

Database altered.

ORA-10456:

SQL> startup nomount  

ORACLE instance started.  

Total System Global Area  417546240 bytes  

Fixed Size                  2228944 bytes  

Variable Size             318770480 bytes  

Database Buffers           92274688 bytes  

Redo Buffers                4272128 bytes  

SQL> alter database mount standby database;  

Database altered.  

SQL> alter database open read only;  

Database altered.  

SQL>  alter database recover managed standby database using current logfile disconnect from session;  

Database altered. 

PRVG-1013：

rac環(huán)境添加節(jié)點(diǎn)，預(yù)檢不通過(guò)，無(wú)法繼續(xù)安裝，但實(shí)際已滿足安裝條件，比如：/u01/11.2.0/grid目錄存在，但預(yù)檢時(shí)卻檢查失敗

設(shè)置環(huán)境變量IGNORE_PREADDNODE_CHECKS=Y