一个空格导致的ORA-12516错误

系统报如下错误：Timestamp: 1/17/2012 4:36:24 PM
Message: PROV_OUTPUT_10: Error occurred while polling for new messages. QUEUEDATA schema may be inaccessible.
Waiting 60 seconds before retrying. --> ORA-12516: TNS:listener could not find available handler with matching protocol stack
Category: Exception
下面是检查步骤：C:Documents and Settingsibsadmin>tnsping orclTNS Ping Utility for 32-bit Windows: Version 11.2.0.1.0 - Production on 18-JAN-2012 10:59:31Copyright （c） 1997, 2010, Oracle. All rights reserved.Used parameter files:
F:appibsadminproduct11.2.0dbhome etworkadminsqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact （DESCRIPTION = （ADDRESS_LIST = （ADDRESS = （PROTOCOL = TCP）（HOST = irdeto-IBSvm）（PORT = 1521）））（CONNECT_DATA = （S
ERVICE_NAME = baseline）））
OK （50 msec）C:Documents and Settingsibsadmin>sqlplus queuedata/queuedata@orclSQL*Plus: Release 11.2.0.1.0 Production on Wed Jan 18 10:59:40 2012Copyright （c） 1982, 2010, Oracle. All rights reserved.ERROR:
ORA-12516: TNS:listener could not find available handler with matching protocol
stack
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied
SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*PlusC:Documents and Settingsibsadmin>
C:Documents and Settingsibsadmin>lsnrctlLSNRCTL for 32-bit Windows: Version 11.2.0.1.0 - Production on 18-JAN-2012 11:00:33Copyright （c） 1991, 2010, Oracle. All rights reserved.Welcome to LSNRCTL, type "help" for information.LSNRCTL> status
Connecting to （ADDRESS=（PROTOCOL=tcp）（HOST=）（PORT=1521））
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for 32-bit Windows: Version 11.2.0.1.0 - Production
Start Date                13-JAN-2012 11:15:44
Uptime                    4 days 23 hr. 44 min. 53 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   D:appibsadminproduct11.2.0dbhome_1 etworkadminlistener.ora
Listener Log File         d:appibsadmindiag nslsnrirdeto-IBSvmlisteneralertlog.xml
Listening Endpoints Summary...
（DESCRIPTION=（ADDRESS=（PROTOCOL=tcp）（HOST=10.86.7.18）（PORT=1521）））
Services Summary...
Service "ORCL" has 1 instance（s）.
Instance "ORCL", status UNKNOWN, has 1 handler（s） for this service...
Service "baseline" has 1 instance（s）.
Instance "baseline", status READY, has 1 handler（s） for this service...
Service "baselineXDB" has 1 instance（s）.
Instance "baseline", status READY, has 1 handler（s） for this service...
The command completed successfully
LSNRCTL>
LSNRCTL>
LSNRCTL> exit
C:Documents and Settingsibsadmin>sqlplus / as sysdbaSQL*Plus: Release 11.2.0.1.0 Production on Wed Jan 18 11:01:25 2012Copyright （c） 1982, 2010, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing optionsSQL> show parameter serviceNAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
service_names                        string      baseline
SQL> show parameter listenerNAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
listener_networks                    string
local_listener                       string
remote_listener                      string
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing optionsF:appibsadminproduct11.2.0dbhomeNETWORKADMIN>notepad tnsnames.oraORCL =
（DESCRIPTION =
    （ADDRESS_LIST =
      （ADDRESS = （PROTOCOL = TCP）（HOST = irdeto-IBSvm）（PORT = 1521））
    ）
    （CONNECT_DATA =
      （SERVICE_NAME =baseline） ---去掉baseline和等号之间的空格保存。
    ）
） F:appibsadminproduct11.2.0dbhomeNETWORKADMIN>sqlplus queuedata/queuedata@orclSQL*Plus: Release 11.2.0.1.0 Production on Wed Jan 18 11:03:52 2012Copyright （c） 1982, 2010, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing optionsSQL>RMAN的备份集增量备份启用Oracle 11g中的Apex相关资讯 Oracle基础教程

Oracle块编程返回结果集详解（11/10/2013 10:45:58）
Oracle基础教程之设置系统全局区（08/22/2013 14:24:00）
Oracle基础教程知识点总结（06/18/2013 07:43:32）

Oracle基础教程之tkprof程序详解（10/22/2013 11:49:50）
Oracle基础教程之sqlplus汉字乱码（07/18/2013 16:30:00）
Oracle 管理之 Linux 网络基础（02/16/2013 18:37:35）

本文评论查看全部评论（0）