PL/SQL 连接oracle数据库老报ora-12541：TNS:无监听程序

今天用PL/SQL连接某数据库老报ora-12541：TNS:无监听程序 错。

解决办法：

Refer to the SQL*Plus User's Guide and Reference for more information.
[oracle@vserever75 ~]$ sqlplus /nolog

SQL*Plus: Release 10.2.0.4.0 - Production on Thu Apr 25 10:28:11 2013

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.

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

Total System Global Area 2147483648 bytes
Fixed Size                  2085320 bytes
Variable Size            1308626488 bytes
Database Buffers          822083584 bytes
Redo Buffers               14688256 bytes
Database mounted.
Database opened.
SQL> quit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@vserever75 ~]$ lsnrctl start

LSNRCTL for Linux: Version 10.2.0.4.0 - Production on 25-APR-2013 10:29:35

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

Starting /oracle/app/db/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 10.2.0.4.0 - Production
System parameter file is /oracle/app/db/network/admin/listener.ora
Log messages written to /oracle/app/db/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=XXX.XXX.3.75)(PORT=1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC0)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=XXX.XXX.3.75)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 10.2.0.4.0 - Production
Start Date                25-APR-2013 10:29:35
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /oracle/app/db/network/admin/listener.ora
Listener Log File         /oracle/app/db/network/log/listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=XXX.XXX.3.75)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC0)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "boss1" has 1 instance(s).
  Instance "boss1", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
[oracle@vserever75 ~]$

PL/SQL 登陆成功！