ORACLE not available

2023-01-14 01:48| 来源: 网络整理| 查看: 265

ORACLE not available 转载

mr_chenping 2021-08-06 13:56:05

文章标签 oracle sql 解决方案序列号 Oracle 文章分类 Oracle 数据库

错误详细描写叙述： ERROR: ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist 进程 ID: 0 会话 ID: 0 序列号: 0

解决方案：

1.运行

[oracle@AY140316135826Z admin]$ sqlplus 'sys/Hello54987663@localhost:1521/orcl as sysdba'

2.运行：

SQL>startup

3.測试一下：

SQL>select * from user_tables;

ok显示除了非常多结果！

此时tnsnames.ora内容：

# tnsnames.ora Network Configuration File: /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/tnsnames.ora # Generated by Oracle configuration tools. orcl = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) (CONNECT_DATA = (SID = orcl) ) )

listener.ora内容：

# listener.ora Network Configuration File: /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora # Generated by Oracle configuration tools. LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) ) ) SID_LIST_LISTENER= (SID_LIST= (SID_DESC= (GLOBAL_DBNAME=orcl) (SID_NAME=orcl) (ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1/) ) )

附录：

oracle监听启动运行：

lsnrctl start

赞收藏评论分享举报

上一篇：虚拟机oracle virtualbox 上安装centos6.5 网络设置

下一篇：Oracle字符乱码、数据越界訪问典型Bug分析

【本文地址】

公司简介

联系我们