首页 诗词 字典 板报 句子 名言 友答 励志 学校 网站地图
当前位置: 首页 > 教程频道 > 数据库 > oracle >

linux下oracle登录有关问题,请高手指教

2012-03-06 
linux下oracle登录问题,急,请高手指教这是我的登录情况[oracle@ICoracle]$sqlplus/assysdba SQL*Plus:Re

linux下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]$   lsnrctl

LSNRCTL   for   Linux:   Version   9.0.1.0.0   -   Production   on   03-APR-2007   11:36:16

Copyright   (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   应该不是这个问题吧?

[解决办法]
安装客户端了吗?或者是net configuration配置的不对
[解决办法]
你用SQLPLUS登陆下 看看报什么错误

热点排行