RMAN-10003: unable to connect to target database
ORA-12520: TNS:listener could not find available handler for requested type of s
erver

找oracle dba去

晕,现在只有我一个人,

。。。。。。。。。。。。。

ORA-12520: TNS:listener could not find available handler for requested type of server

路过.......

怎么解决嘛.大家帮帮忙嘛.
$ lsnrctl

LSNRCTL for IBM/AIX RISC System/6000: Version 10.2.0.1.0 - Production on 30-MAY-
2007 14:16:35

Copyright (c) 1991, 2005, 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_CGSJK2
Version                   TNSLSNR for IBM/AIX RISC System/6000: Version 10.2.0.1
.0 - Production
Start Date                30-MAY-2007 09:25:46
Uptime                    0 days 4 hr. 50 min. 55 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      ON
Listener Parameter File   /oracle/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File         /oracle/product/10.2.0/db_1/network/log/listener_cgsjk
2.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.192.208.10)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.192.208.5)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "cdcgk" has 2 instance(s).
  Instance "cdcgk1", status READY, has 1 handler(s) for this service...
  Instance "cdcgk2", status READY, has 1 handler(s) for this service...
Service "cdcgkXDB" has 2 instance(s).
  Instance "cdcgk1", status READY, has 1 handler(s) for this service...
  Instance "cdcgk2", status READY, has 1 handler(s) for this service...
Service "cdcgk_XPT" has 2 instance(s).
  Instance "cdcgk1", status READY, has 1 handler(s) for this service...
  Instance "cdcgk2", status READY, has 1 handler(s) for this service...
The command completed successfully
LSNRCTL>





-------------------------------------------------------------------------------------------------------------------------------------
# lsdev -Cc tape
rmt0 Available 03-08-00-0,0 LVD SCSI 4mm Tape Drive
rmt1 Defined   05-08-02     IBM 3580 Ultrium Tape Drive (FCP)
rmt2 Defined   05-08-02     IBM 3580 Ultrium Tape Drive (FCP)
smc0 Defined   05-08-02     IBM 3576 Library Medium Changer (FCP)




---------------------------------------------------------------------------------------------------------------------------------
$ tnsping cgsjk1

TNS Ping Utility for IBM/AIX RISC System/6000: Version 10.2.0.1.0 - Production o
n 30-MAY-2007 14:48:55

Copyright (c) 1997, 2005, Oracle.  All rights reserved.

Used parameter files:

Used HOSTNAME adapter to resolve the alias
Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=cgsjk1.))(ADDRESS
=(PROTOCOL=TCP)(HOST=10.192.208.4)(PORT=1521)))
OK (120 msec)
$

# cat /oracle/product/10.2.0/db_1/network/admin/listener.ora
# listener.ora.cgsjk1 Network Configuration File: /oracle/product/10.2.0/db_1/ne
twork/admin/listener.ora.cgsjk1
# Generated by Oracle configuration tools.

SID_LIST_LISTENER_CGSJK1 =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /oracle/product/10.2.0/db_1)
      (PROGRAM = extproc)
    )
  )

LISTENER_CGSJK1 =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.192.208.9)(PORT = 1521)(IP = FIRST))
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.192.208.4)(PORT = 1521)(IP = FIRST))
    )
  )

#




=============================================================================



# cat listener.ora
# listener.ora.cgsjk2 Network Configuration File: /oracle/product/10.2.0/db_1/ne
twork/admin/listener.ora.cgsjk2
# Generated by Oracle configuration tools.

SID_LIST_LISTENER_CGSJK2 =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /oracle/product/10.2.0/db_1)
      (PROGRAM = extproc)
    )
  )

LISTENER_CGSJK2 =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = cgsjk2_vip)(PORT = 1521)(IP = FIRST))
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.192.208.5)(PORT = 1521)(IP = FIRST))
    )
  )

#

[ 本帖最后由 zzjlzx 于 2007-5-30 14:53 编辑 ]

手动rman 一个备份到硬盘上试一试。看看结果

TNS-12520 TNS:listener could not find available handler for requested type of server

Cause: None of the known and available service handlers for requested type of server (dedicated or shared) are appropriate for the client connection.

Action: Run "lsnrctl services" to ensure that the instance(s) have registered with the listener and that the appropriate handlers are accepting connections.