服务中oracle监听无法开启,解决Oracle监听器服务不能启动的问题

解决Oracle监听器服务不能启动的问题

从客户端连接到服务器,出现了这个错误,ora12541-TNS : 没有监听器

启动secure CRT

Last login: Tue Jun 10 11:18:03 2008 from

dengyu.9251.cn

[root@linux root]# su-

-bash: su-: command not found

[root@linux root]# su -

[root@linux root]# su - oracle

[oracle@linux oracle]$ isnrctl start

-bash: isnrctl: command not found

[oracle@linux oracle]$ lsnrctl start

LSNRCTL for Linux: Version 9.2.0.4.0 -

Production on 10-JUN-2008 11:21:18

Copyright (c) 1991, 2002, Oracle

Corporation. All rights reserved.

Starting /opt/ora9/product/9.2/bin/tnslsnr:

please wait...

TNSLSNR for Linux: Version 9.2.0.4.0 -

Production

System parameter file is

/opt/ora9/product/9.2/network/admin/listener.ora

Log messages written to

/opt/ora9/product/9.2/network/log/listener.log

Listening on:

(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))

Listening on:

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=linux.test.9251.cn)(PORT=1521)))

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 10-JUN-2008 11:21:18

Uptime 0 days 0 hr. 0 min. 0 sec

Trace

Level off

Security OFF

SNMP OFF

Listener Parameter File /opt/ora9/product/9.2/network/admin/listener.ora

Listener Log

File /opt/ora9/product/9.2/network/log/listener.log

Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=linux.test.9251.cn)(PORT=1521)))

Services Summary...

Service "PLSExtProc" has 1 instance(s).

Instance "PLSExtProc", status UNKNOWN, has 1

handler(s) for this service...

Service "ora9204" has 1 instance(s).

Instance "ora9i", status UNKNOWN, has 1

handler(s) for this service...

The command completed successfully

[oracle@linux oracle]$ sqlplus /nolog

SQL*Plus: Release 9.2.0.4.0 - Production on

Tue Jun 10 11:23:59 2008

Copyright (c) 1982, 2002, Oracle

Corporation. All rights reserved.

SQL> startup

ORA-01031: insufficient privileges

SQL> connnect / as sysdba

SP2-0734: unknown command beginning "connnect /..." - rest of line

ignored.

SQL> connect /as sysdba

Connected to an idle instance.

SQL> startup

ORACLE instance started.

Total System Global Area 236000356 bytes

Fixed

Size 451684 bytes

Variable

Size 201326592 bytes

Database

Buffers 33554432 bytes

Redo

Buffers 667648 bytes

Database mounted.

Database opened.