Oracle 11g 기동 시 오류

• 오류 ORA-01034

ORA-01034: ORACLE not available

해결 : 데이터베이스 켜주기

SQL> startup

ORACLE instance started.

Total System Global Area 2622255104 bytes
Fixed Size		    2256112 bytes
Variable Size		  637534992 bytes
Database Buffers	 1979711488 bytes
Redo Buffers		    2752512 bytes
Database mounted.
Database opened.

 

• 오류 LRM-00109

ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/home/oracle/engine/product/11g/dbs/initorcl.ora'

 

해결 : spfile 경로 잡아주기

SQL> startup pfile=/home/oracle/engine/product/11g/dbs/init.ora

 

• 오류 ORA-48108, ORA-48140

ORA-48108: invalid value given for the diagnostic_dest init.ora parameter
ORA-48140: the specified ADR Base directory does not exist [/home/oracle/engine/product/11g/dbs/<ORACLE_BASE>]
ORA-48187: specified directory does not exist
Linux-x86_64 Error: 2: No such file or directory

해결 : init.ora 파일의 <OracleBase> 부분 db_recovery_file_dest='/home/oracle/engine/flash_recovery_area' 로 수정

 

• 오류 ORA-01261

ORA-01261: Parameter db_recovery_file_dest destination string cannot be translated
ORA-01262: Stat failed on a file destination directory
Linux-x86_64 Error: 2: No such file or directory

해결 : db_recovery_file_dest 디렉토리 만들어주기

$ cd $ORACLE_BASE
$ mkdir flash_recovery_area

 

• 오류ORA-00201

ORACLE instance started.

Total System Global Area 1068937216 bytes
Fixed Size		    2260088 bytes
Variable Size		  671089544 bytes
Database Buffers	  390070272 bytes
Redo Buffers		    5517312 bytes
ORA-00201: control file version 11.2.0.4.0 incompatible with ORACLE version
11.2.0.0.0
ORA-00202: control file: '/home/oracle/engine/oradata/ORCL/control01.ctl'

해결 : init.ora 파일에서 compatible ='11.2.0.4.0' 수정