这是我的登录情况
[oracle@IC oracle]$ sqlplus "/as sysdba"SQL*Plus: Release 9.0.1.0.0 - Production on Tue Apr 3 11:35:39 2007(c) Copyright 2001 Oracle Corporation. All rights reserved.Connected to an idle instance.SQL> startup
ORACLE instance started.Total System Global Area 336356520 bytes
Fixed Size 279720 bytes
Variable Size 268435456 bytes
Database Buffers 67108864 bytes
Redo Buffers 532480 bytes
Database mounted.
Database opened.
SQL> exit
Disconnected from Oracle9i Enterprise Edition Release 9.0.1.0.0 - Production
With the Partitioning option
JServer Release 9.0.1.0.0 - Production
[oracle@IC oracle]$ lsnrctlLSNRCTL for Linux: Version 9.0.1.0.0 - Production on 03-APR-2007 11:36:16Copyright (c) 1991, 2001, Oracle Corporation. All rights reserved.Welcome to LSNRCTL, type "help" for information.LSNRCTL> start
Starting /home/oracle/product/9.0.1/bin/tnslsnr: please wait...TNSLSNR for Linux: Version 9.0.1.0.0 - Production
System parameter file is /home/oracle/product/9.0.1/network/admin/listener.ora
Log messages written to /home/oracle/product/9.0.1/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=IC)(PORT=1521)))Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 9.0.1.0.0 - Production
Start Date 03-APR-2007 11:36:20
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security OFF
SNMP OFF
Listener Parameter File /home/oracle/product/9.0.1/network/admin/listener.ora
Listener Log File /home/oracle/product/9.0.1/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=IC)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "oracle" has 1 instance(s).
Instance "oracle", status UNKNOWN, has 1 handler(s) for this service...
Service "orcl" has 1 instance(s).
Instance "orcl", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
LSNRCTL> exit然后我用第三方的toad连数据库,其中database中有四个选项,有一个可以连接,两个报告没有监听,我想连接的那个报错如下
ORA-01034:ORACLE not available
ORA-27101:shared memory realm does not exist
Linux Error:2:No such file or directory
请高手指教,不胜感激。
ORACLE_HOME=/home/oracle/product/9.0.1
ORACLE_SID=oracle 应该不是这个问题吧?
[oracle@IC oracle]$ sqlplus "/as sysdba"SQL*Plus: Release 9.0.1.0.0 - Production on Tue Apr 3 11:35:39 2007(c) Copyright 2001 Oracle Corporation. All rights reserved.Connected to an idle instance.SQL> startup
ORACLE instance started.Total System Global Area 336356520 bytes
Fixed Size 279720 bytes
Variable Size 268435456 bytes
Database Buffers 67108864 bytes
Redo Buffers 532480 bytes
Database mounted.
Database opened.
SQL> exit
Disconnected from Oracle9i Enterprise Edition Release 9.0.1.0.0 - Production
With the Partitioning option
JServer Release 9.0.1.0.0 - Production
[oracle@IC oracle]$ lsnrctlLSNRCTL for Linux: Version 9.0.1.0.0 - Production on 03-APR-2007 11:36:16Copyright (c) 1991, 2001, Oracle Corporation. All rights reserved.Welcome to LSNRCTL, type "help" for information.LSNRCTL> start
Starting /home/oracle/product/9.0.1/bin/tnslsnr: please wait...TNSLSNR for Linux: Version 9.0.1.0.0 - Production
System parameter file is /home/oracle/product/9.0.1/network/admin/listener.ora
Log messages written to /home/oracle/product/9.0.1/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=IC)(PORT=1521)))Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 9.0.1.0.0 - Production
Start Date 03-APR-2007 11:36:20
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security OFF
SNMP OFF
Listener Parameter File /home/oracle/product/9.0.1/network/admin/listener.ora
Listener Log File /home/oracle/product/9.0.1/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=IC)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "oracle" has 1 instance(s).
Instance "oracle", status UNKNOWN, has 1 handler(s) for this service...
Service "orcl" has 1 instance(s).
Instance "orcl", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
LSNRCTL> exit然后我用第三方的toad连数据库,其中database中有四个选项,有一个可以连接,两个报告没有监听,我想连接的那个报错如下
ORA-01034:ORACLE not available
ORA-27101:shared memory realm does not exist
Linux Error:2:No such file or directory
请高手指教,不胜感激。
ORACLE_HOME=/home/oracle/product/9.0.1
ORACLE_SID=oracle 应该不是这个问题吧?
怎么配置服务名啊
我不懂一个可以连接而另一个不可以客户端安装了,以前只要服务器启动就行了,现在出问题了
没报错 显示
Connected to:
Oracle9i Enterprise Edition Release 9.0.1.0.0 - Production
With the Partitioning option
JServer Release 9.0.1.0.0 - Production是不是ORACLE_SID的问题啊 可以设置多个sid吗?
我想是不是
[oracle@IC oracle]$ sqlplus "/as sysdba"SQL*Plus: Release 9.0.1.0.0 - Production on Tue Apr 3 13:37:49 2007(c) Copyright 2001 Oracle Corporation. All rights reserved.Connected to an idle instance.SQL> startup
ORACLE instance started.Total System Global Area 336356520 bytes
Fixed Size 279720 bytes
Variable Size 268435456 bytes
Database Buffers 67108864 bytes
Redo Buffers 532480 bytes
Database mounted.
Database opened.只开启了一个例程
所以toad中两个其中的一个可用
另一个不可用
怎么能全打开呢 是要去设置ORACLE_SID吗
大家帮帮忙啊