ERROR: ORA-01034: ORACLE not available ERROR:ORA-01034ORA-27101怎样搞定?

yaohanping

[oracle@tsg root]$ lsnrctl start

LSNRCTL for Linux: Version 10.1.0.3.0 - Production on 17-MAY-2005 19:04:50

Copyright (c) 1991, 2004, Oracle.  All rights reserved.

Starting /opt/ora10/product/10g/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 10.1.0.3.0 - Production
System parameter file is /opt/ora10/product/10g/network/admin/listener.ora
Log messages written to /opt/ora10/product/10g/network/log/listener.log
Trace information written to /tmp/listener.trc
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 10.1.0.3.0 - Production
Start Date                17-MAY-2005 19:04:50
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               support
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /opt/ora10/product/10g/network/admin/listener.ora
Listener Log File         /opt/ora10/product/10g/network/log/listener.log
Listener Trace File       /tmp/listener.trc
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
Services Summary...
Service "LSExtProc" has 1 instance(s).
  Instance "LSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully




[oracle@tsg root]$ sqlplus

SQL*Plus: Release 10.1.0.3.0 - Production on Tue May 17 18:55:37 2005

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


SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus
[oracle@tsg root]$ echo $ORACLE_SID
ora10g


我的用户名和密码都没有错的,这两个错误如何解决阿!救我

mayaxteam

似乎是数据库还没有启动。
应该这样启动：

sqlplus sys/sys_password as sysdba

接下来输入
startup;

yaohanping

已经搞定,问题很简单,只怪自己知识太少,学习ing!

abc8u8619

楼主你是怎么解决的饿,我也遇到你一样的问题,如下:
[oracle@yndx133 /]$ echo $ORACLE_SID
bill
[oracle@yndx133 /]$ sqlplus system/manager

SQL*Plus: Release 9.2.0.4.0 - Production on Fri Sep 2 16:24:56 2005

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

blue_stone

需要使用具有sysdba权限的用户登陆
可以使用
sqlplus sys/syspassword as sysdba
sqlplus / as sysdba
登陆的