关闭

ORA-01034:ORACLE not available问题的解决方法

标签: oracle
327人阅读 评论(0) 收藏 举报
分类:

刚装上的oracle9i,上次还能用呢,这次突然用不了.

[oracle@R39i oracle]$ sqlplus scott/tiger

SQL*Plus: Release 9.2.0.4.0 - Production on Mon Nov 24 11:06:50 2008

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux Error: 2: No such file or directory

[root@R39i root]# id oracle
uid=500(oracle) gid=501(dba) groups=501(dba)
[root@R39i root]# su - oracle
[oracle@R39i oracle]$ lsnrctl start

LSNRCTL for Linux: Version 9.2.0.4.0 - Production on 24-NOV-2008 10:57:29

Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.

Starting /oracle/product/9i/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 9.2.0.4.0 - Production
System parameter file is /oracle/product/9i/network/admin/listener.ora
Log messages written to /oracle/product/9i/network/log/listener.log
Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
TNS-12542: TNS:address already in use
TNS-12560: TNS:protocol adapter error
TNS-00512: Address already in use
   Linux Error: 98: Address already in use

Listener failed to start. See the error message(s) above...

[oracle@R39i oracle]$ lsnrctl status

LSNRCTL for Linux: Version 9.2.0.4.0 - Production on 24-NOV-2008 11:21:13

Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
STATUS of the LISTENER
==============================================
[oracle@R39i oracle]$ lsnrctl status

LSNRCTL for Linux: Version 9.2.0.4.0 - Production on 24-NOV-2008 11:21:13

Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 9.2.0.4.0 - Production
Start Date                24-NOV-2008 10:52:27
Uptime                    0 days 0 hr. 28 min. 45 sec
Trace Level               off
Security                  OFF
SNMP                      OFF
Listener Parameter File   /oracle/product/9i/network/admin/listener.ora
Listener Log File         /oracle/product/9i/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=R39i)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "mydata" has 1 instance(s).
Instance "mydata", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully

呵呵,原来监听已经启动了.
[oracle@R39i oracle]$ sqlplus /nolog

SQL*Plus: Release 9.2.0.4.0 - Production on Mon Nov 24 12:01:37 2008

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

SQL> connect /as sysdba
Connected to an idle instance.
SQL> startup
ORACLE instance started.

Total System Global Area 122754448 bytes
Fixed Size                   451984 bytes
Variable Size              88080384 bytes
Database Buffers           33554432 bytes
Redo Buffers                 667648 bytes
Database mounted.
Database opened.

数据库就可以用了。

总结,

1,数据库没有打开时,其它用户是联不上的。
2,如果用sys也打不开数据库,则可能是坏境变量的事了。

可用下面的方法来检查,看是否和你预想的一样。

env |grep ORACLE

0
0
查看评论
发表评论
* 以上用户言论只代表其个人观点,不代表CSDN网站的观点或立场

RAC监听,实例名与服务名不一致一例 [(原创)](ORA-27101,ORA-01034)

11.2.0.3for RHEL5.6 [oracle@lxasm ~]$ sqlplus system/qazwsx@lxasmorc1 SQL*Plus: Release 11.2...
  • Hank_dai
  • Hank_dai
  • 2013-04-05 22:35
  • 3291

ORA-01034和ORA-27101的解决方法

1 先看oracle的监听和oracle的服务是否都启动了。启动oracle监听: cmd的命令行窗口下,输入lsnrctl start,回车即启动监听。 2 查看oracle的sid叫什...
  • u013519551
  • u013519551
  • 2016-12-06 11:53
  • 7515

记一次解决Oracle数据库连接失败

问题背景:使用PL/SQL Developer连接本地虚拟机(RedHat6.7)中的Oracle服务,报错如下:ERROR: ORA-01034: ORACLE not available ORA-...
  • u011161786
  • u011161786
  • 2017-03-21 23:52
  • 1145

ORA-01034: ORACLE not available这个问题怎么搞?折腾了一上午了。

C:\Users\lenovo>sqlplus / as sysdba; SQL*Plus: Release 11.2.0.1.0 Production on 星期三 7月 12 14:38...
  • JnGg366
  • JnGg366
  • 2017-07-12 15:15
  • 595

ORA-01034: ORACLE not available如何解决

ORA-01034: ORACLE not available如何解决 TNS-12535:TNS:操作超时
  • zzhiyun
  • zzhiyun
  • 2017-03-14 11:12
  • 6897

ORA-01034: ORACLE not available

解决方法一: ERROR: ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist 进程 I...
  • zhanghai412
  • zhanghai412
  • 2012-09-05 17:21
  • 76793

ORA-01034: ORACLE not available

打开数据库,用SQL Plus登入数据库失败,错误信息 ORA-01034: ORACLE not available ORA-27101:sharedmemory realm does no...
  • askyouque
  • askyouque
  • 2015-01-12 18:55
  • 220

Oralce - ORA-01034: ORACLE not available

解决方法一: ERROR: ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist 进程 I...
  • kevin_spa
  • kevin_spa
  • 2014-09-01 11:25
  • 390

RMAN-04006: error from auxiliary database: ORA-01034: ORACLE not available

昨天安装oracle 11g ADG的时候,遇到了错误:RMAN-04006: error from auxiliary database: ORA-01034: ORACLE not availab...
  • huangliang0703
  • huangliang0703
  • 2014-11-11 10:03
  • 1568

ORA-01034: ORACLE not available ORA-27101

出现ORA-01034和ORA-27101的错误的几种原因及解决方法
  • wangfayinn
  • wangfayinn
  • 2016-01-27 17:36
  • 494
    个人资料
    • 访问:18036次
    • 积分:541
    • 等级:
    • 排名:千里之外
    • 原创:36篇
    • 转载:11篇
    • 译文:0篇
    • 评论:0条