ORA-01033: ORACLE initialization or shutdown in progress

OS환경 : Oracle Linux 7.9 (64bit)

 

DB 환경 : Oracle Database 19.3.0.0

 

에러 : ORA-01033: ORACLE initialization or shutdown in progress

일반유저로 db 접속시 발생하는 에러

$ sqlplus imsi/imsi
 
SQL*Plus: Release 19.0.0.0.0 - Production on Wed Mar 27 14:04:20 2024
Version 19.3.0.0.0
 
Copyright (c) 1982, 2019, Oracle.  All rights reserved.
 
ERROR:
ORA-01033: ORACLE initialization or shutdown in progress
Process ID: 0
Session ID: 0 Serial number: 0

 

 

해결 방법 : db 상태 확인 및 기동

sysdba로 접속 후 db 상태 확인

$ sqlplus / as sysdba
SQL> select status from v$instance;
 
STATUS
------------
MOUNTED

마운트 상태임

 

 

db open 상태로 변경

SQL> alter database open;
 
Database altered.

 

 

일반유저로 접속 테스트

$ sqlplus imsi/imsi
 
SQL*Plus: Release 19.0.0.0.0 - Production on Wed Mar 27 14:07:38 2024
Version 19.3.0.0.0
 
Copyright (c) 1982, 2019, Oracle.  All rights reserved.
 
Last Successful login time: Wed Mar 27 2024 13:52:26 +09:00
 
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
 
SQL>

정상 접속됨

 

 

원인 : db가 open 상태가 아니었음

아카이브 로그 모드로 전환하기 위해 shutdown 후 mount 모드로 db를 기동하고
이후에 아카이브 로그 모드 전환 후 open 명령까지 입력해주지 않아 발생한 문제
만약 상태가 nomount 상태로 나오는 경우 alter database mount; 명령 입력 후 alter database open; 명령을 입력해주면됨

 

 

참조 :