Shulou(Shulou.com)06/01 Report--

The system that the company launched two years ago, when it was going to use the new feature of 12c, was put into production. The initial oracle version is 12.1, and this version is constantly bug in practical use, which is a headache. Recently, more than 20 new application servers have been developed and put into production. When they are put into production, when the internal link of the database is at 910, an error will be reported, but our session number is very large, which is far from reaching the critical value. The specific error report is as follows.

TNS-12518: TNS:listener could not hand off client connection

TNS-12536: TNS:operation would block

TNS-12560: TNS:protocol adapter error

TNS-00506: Operation would block

Linux Error: 11: Resource temporarily unavailable

Query via MOS account; Ora-12518 on Oracle 12c Multitenant Architecture (document ID 2252001.1)

Ora-12518 on Oracle 12c Multitenant Architecture (document ID 2252001.1)

SYMPTOMS

When attempting to connect to PDB via listener

The following error occurs.

ERROR

ORA-12518: TNS:listener could not hand off client connection

Listener log:

=

03-APR-2017 08:57:31 (CONNECT_DATA= (SID=wd1) (CID= (PROGRAM=d:\ orasfw\ prd1\ bin\ sqlplus.exe) (HOST=Host name) (USER=ismeirb) (ADDRESS= (PROTOCOL=tcp) (HOST=XX.XX.XX.XX) (PORT=63994)) establish wd1 * 12518

TNS-12518: TNS:listener could not hand off client connection

TNS-12560: TNS:protocol adapter error

TNS-00530: Protocol adapter error

64-bit Windows Error: 203: Unknown error

CAUSE

PDB SiD name was not properly configured in the listener.ora file

SID_LIST_LSNRPD =

(SID_LIST =

(SID_DESC =

(GLOBAL_DBNAME = ct1)

(ORACLE_HOME = d:\ orasfw\ prd1)

(SID_NAME = ct1)

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.