HOME > > ADOP + ORA-12516: TNS:listener could not find available handler with matching protocol stack (DBD ERROR: OCIServerAttach)

ADOP + ORA-12516: TNS:listener could not find available handler with matching protocol stack (DBD ERROR: OCIServerAttach)

Anup - Saturday, December 26, 2015


ERROR in ADOP Log dile:-

[ERROR]     Cannot connect to database
[ERROR]     Error Message: ORA-12516: TNS:listener could not find available handler with matching protocol stack (DBD ERROR: OCIServerAttach)
[ERROR]     Error calling ad_zd_log. Refer to log file for details.
[ERROR]     Error calling ad_zd_log. Refer to log file for details.
[ERROR]     Error calling ad_zd_log. Refer to log file for details. 
[ERROR]     Cannot connect to database
[ERROR]     Error Message: ORA-12516: TNS:listener could not find available handler with matching protocol stack (DBD ERROR: OCIServerAttach) 

Solution:-
Step 1:- Ensure that your sqlnet_ifile.ora has the line:-

SQLNET.ALLOWED_LOGON_VERSION_SERVER = 8 (if the initialization parameter
SEC_CASE_SENSITIVE_LOGON is set to FALSE)
SQLNET.ALLOWED_LOGON_VERSION_SERVER = 10 (if SEC_CASE_SENSITIVE_LOGON is set to TRUE)

Step 2:- Restart faild working using adctrl utility.

Step 3:- Restart adop session 

adop phase=apply patchtop=$PER_TOP/patch/115 patches=driver:hrglobal.drv options=nocopyportion,nogenerateportion,forceapply workers=10 maxworkers=20 restart=yes
 


Anonymous said...

you made my day

Contact me

Get in Touch

Need to get touch with me? Please fill out the form with your enquiry.

Name
Anup Srivastav
Address
Lucknow - Utter Pradesh
Email
myindiandba@gmail.com
Message me