This is a premium alert message you can set from Layout! Get Now!

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

Anup
1


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
 


Post a Comment

1 Comments

Please Select Embedded Mode To show the Comment System.*

Join the conversation(1)
To Top