oracle 经常出现12518,频繁出现 ORA-12518 请教大家如何解决

最初由 rollingpig 发布

[B]参考我的签名……

贴出lsnrctl service ,客户端的tnsnames.ora 等信息…… [/B]

信息如下，谢谢！

client 信息

sqlnet.ora里面没有可用信息，都注释掉了的。

ORA03 =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.10.202 )(PORT = 1521))

)

(CONNECT_DATA =

(SERVICE_NAME = ora03)

)

)

server 信息

oracle@ora03:~$ lsnrctl service

LSNRCTL for HPUX: Version 9.2.0.7.0 - Production on 15-OCT-2006 13:54:18

Copyright (c) 1991, 2002, Oracle Corporation.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ora03)(PORT=1521)))

Services Summary...

Service "PLSExtProc" has 1 instance(s).

Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...

Handler(s):

"DEDICATED" established:0 refused:0

LOCAL SERVER

Service "ora03" has 1 instance(s).

Instance "ora03", status READY, has 6 handler(s) for this service...

Handler(s):

"DEDICATED" established:69 refused:0 state:ready

LOCAL SERVER

"D004" established:2077 refused:235 current:362 max:2000 state:ready

DISPATCHER

(ADDRESS=(PROTOCOL=tcp)(HOST=ora03)(PORT=59824))

"D003" established:5201 refused:344 current:362 max:2000 state:ready

DISPATCHER

(ADDRESS=(PROTOCOL=tcp)(HOST=ora03)(PORT=59823))

"D002" established:1194 refused:22714 current:288 max:2000 state:ready

DISPATCHER

(ADDRESS=(PROTOCOL=tcp)(HOST=ora03)(PORT=59822))

"D001" established:4138 refused:4923 current:362 max:2000 state:ready

DISPATCHER

(ADDRESS=(PROTOCOL=tcp)(HOST=ora03)(PORT=59821))

"D000" established:4252 refused:2586 current:362 max:2000 state:ready

DISPATCHER

(ADDRESS=(PROTOCOL=tcp)(HOST=ora03)(PORT=59819))

The command completed successfully

oracle@ora03:~$ lsnrctl status

LSNRCTL for HPUX: Version 9.2.0.7.0 - Production on 15-OCT-2006 13:57:41

Copyright (c) 1991, 2002, Oracle Corporation.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ora03)(PORT=1521)))

STATUS of the LISTENER

------------------------

Alias                     LISTENER

Version                   TNSLSNR for HPUX: Version 9.2.0.7.0 - Production

Start Date                13-OCT-2006 17:06:46

Uptime                    1 days 20 hr. 50 min. 55 sec

Trace Level               admin

Security                  OFF

SNMP                      OFF

Listener Parameter File   /software/oracle/app/9.2.0/network/admin/listener.ora

Listener Log File         /software/oracle/app/9.2.0/network/log/listener.log

Listener Trace File       /software/oracle/app/9.2.0/network/trace/listener.trc

Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ora03)(PORT=1521)))

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

Services Summary...

Service "PLSExtProc" has 1 instance(s).

Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...

Service "ora03" has 1 instance(s).

Instance "ora03", status READY, has 6 handler(s) for this service...

The command completed successfully

连接数不多

SQL> select count(*) from v$session;

COUNT(*)

----------

1198