[oracle] ORA-01034, ORA-27101 해결 방법.

2023. 9. 1. 17:25Database/oracle

728x90
728x90

sqlplus로 오라클 접속 시, ORA-01034 & ORA-27101 에러가 발생하는 것을 확인. 

…
$ sqlplus system/passwd
SQL*Plus: Release 19.0.0.0.0 - Production on Fri Sep 1 07:54:51 2023
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle.  All rights reserved.

ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux-x86_64 Error: 2: No such file or directory
Additional information: 4376
Additional information: 1135834575
Process ID: 0
Session ID: 0 Serial number: 0
...

*에러 원인 

  • 기동되지 않은 오라클 서버에 접속을 시도해서 발생한 에러.

*해결 방법

  1. $ sqlplus sys/change_on_install as sysdba 오라클에 접속.
  2. SQL> startup 오라클을 기동.
…
$ sqlplus sys/change_on_install as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Fri Sep 1 07:55:30 2023
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle.  All rights reserved.
Connected to an idle instance.

SQL> startup
ORACLE instance started.
Total System Global Area 1610609928 bytes
Fixed Size     9135368 bytes
Variable Size   486539264 bytes
Database Buffers  1107296256 bytes
Redo Buffers     7639040 bytes
Database mounted.
Database opened.

SQL> exit
Disconnected from Oracle Database 19c Standard Edition 2 Release 19.0.0.0.0 - Production Version 19.3.0.0.0
...

상단의 커맨드 수행 후, 정상적으로 접속되는 것을 확인.

...
$ sqlplus system/passwd                
SQL*Plus: Release 19.0.0.0.0 - Production on Fri Sep 1 08:09:48 2023
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle.  All rights reserved.
Last Successful login time: Fri Sep 01 2023 07:55:58 +00:00
Connected to:
Oracle Database 19c Standard Edition 2 Release 19.0.0.0.0 - Production
Version 19.3.0.0.0

SQL> 
…





728x90
728x90