0%

oracle系统错误修复

某次重启服务器后,oracle提示:

ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux-x86_64 Error: 2: No such file or directory

google查询知道 https://stackoverflow.com/questions/6555827/ora-01034-oracle-not-available-ora-27101-shared-memory-realm-does-not-exist

Open command prompt and execute the below commands:

1
2
3
4
5
set oracle_sid=DATABASE NAME
sqlplus /nolog
conn sys/sys as sysdba
shutdown abort
startup

按照上面执行命令后,问题得以解决。