ORA-01034: ORACLE not available

最新推荐文章于 2023-09-25 14:34:45 发布

skyuck

最新推荐文章于 2023-09-25 14:34:45 发布

阅读量170

点赞数

文章标签：数据库

本文链接：https://blog.csdn.net/skyuck/article/details/84913750

版权

服务器异常关机经常会导致下面的错误
[quote]
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux-x86_64 Error: 2: No such file or directory
Process ID: 0
Session ID: 0 Serial number: 0

Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
[/quote]

解决办法：


[oracle@database ~]$ set oracle_sid=orcl
[oracle@database ~]$ sqlplus /nolog

SQL*Plus: Release 11.2.0.1.0 Production on Wed Dec 20 08:59:20 2017

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

SQL> conn sys/sys as sysdba
Connected to an idle instance.
SQL> shutdown abort
ORACLE instance shut down.
SQL> startup
ORACLE instance started.