[ORACLE] ORA-01078, LRM-00109 Error.

ORACLE ORA-01078, LRM-00109 Error.

SQL> startup

ORA-01078: failure in processing system parameters

LRM-00109: could not open parameter file '/oracle/product/11g/dbs/initora11.ora'

즉 control 파일 및 여러 시스템 파라미터를 설정한 init file이 없어서 발생한 오류.

그리하여 파일생성.

/oracle/product/11g/dbs/init<$ORACLE_SID>.ora

db_name=orcl

shared_pool_size = 123232153

control_files = (/oracle/oradata/orcl/control01.ctl,

/oracle/oradata/orcl/control02.ctl,

/oracle/oradata/orcl/control03.ctl)

compatible = 11.1.0.6.0

하지만 산넘어 산.

ORCL Instance 시작은 되나 DB Mount가 안되는 오류발생. 

SQL> startup

ORACLE instance started.

Total System Global Area  208805888 bytes

Fixed Size                  2142896 bytes

Variable Size             150998352 bytes

Database Buffers           50331648 bytes

Redo Buffers                5332992 bytes

ORA-01102: cannot mount database in EXCLUSIVE mode

SQL> shutdown

ORA-01507: database not mounted

$ ps -ef | grep ora_

oracle   19167     1  0 18:14 ?        00:00:00 ora_pmon_ora11

oracle   19169     1  0 18:14 ?        00:00:00 ora_vktm_ora11

oracle   19173     1  0 18:14 ?        00:00:00 ora_diag_ora11

oracle   19175     1  0 18:14 ?        00:00:00 ora_dbrm_ora11

oracle   19177     1  0 18:14 ?        00:00:00 ora_psp0_ora11

oracle   19181     1  0 18:14 ?        00:00:00 ora_dia0_ora11

oracle   19183     1  0 18:14 ?        00:00:00 ora_mman_ora11

oracle   19185     1  0 18:14 ?        00:00:00 ora_dbw0_ora11

oracle   19187     1  0 18:14 ?        00:00:00 ora_lgwr_ora11

oracle   19189     1  0 18:14 ?        00:00:00 ora_ckpt_ora11

oracle   19191     1  0 18:14 ?        00:00:00 ora_smon_ora11

oracle   19193     1  0 18:14 ?        00:00:00 ora_reco_ora11

oracle   19195     1  0 18:14 ?        00:00:00 ora_mmon_ora11

oracle   19197     1  0 18:14 ?        00:00:00 ora_mmnl_ora11

oracle   19239     1  0 18:14 ?        00:00:00 ora_p000_ora11

oracle   19241     1  0 18:14 ?        00:00:00 ora_p001_ora11

oracle   19243     1  0 18:14 ?        00:00:00 ora_p002_ora11

oracle   19245     1  0 18:14 ?        00:00:00 ora_p003_ora11

oracle   19247     1  0 18:14 ?        00:00:00 ora_p004_ora11

oracle   19249     1  0 18:14 ?        00:00:00 ora_p005_ora11

oracle   19251     1  0 18:14 ?        00:00:00 ora_p006_ora11

oracle   19258     1  0 18:14 ?        00:00:00 ora_smco_ora11

oracle   19260     1  0 18:14 ?        00:00:00 ora_fbda_ora11

oracle   19262     1  0 18:14 ?        00:00:00 ora_qmnc_ora11

oracle   19283     1  0 18:14 ?        00:00:00 ora_w000_ora11

oracle   19311     1  0 18:14 ?        00:00:00 ora_q000_ora11

oracle   19469     1  0 18:15 ?        00:00:00 ora_q001_ora11

전원 kill

$ kill -9  <pid>

SQL> startup

ORACLE instance started.

Total System Global Area  208805888 bytes

Fixed Size                  2142896 bytes

Variable Size             150998352 bytes

Database Buffers           50331648 bytes

Redo Buffers                5332992 bytes

Database mounted.

Database opened.

감격의 눈물...ㅠㅠ

Oracle 설치를 정말로 오랜만에 한듯 하다.

.by rocksea