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

Anup December 25, 2015

0 Comments

Reader Mode

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]
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 Views: 65

Categories: EBS 11i/R12.1/R12.2

Type of RMAN Backup Tutorial

Reader Mode Full Backups A full backup reads the entire file and copies all blocks into the backup set, only skipping datafile blocks that have…

Anup June 13, 2009

0 Comments

Simple Steps to Find Password for an Application User in Oracle Applications

Reader Mode To achieve this you need to create a small package and run a query which I wrote below: Step 1: Create Package Specification…

Anup October 5, 2023

0 Comments

How to Move OCR and Voting Disk to ASM Diskgroup in 11gR2

Reader Mode We can use the following steps to migrate OCR and Vote Disk from RAW to ASM Disk. Step 1:- Check the current OCR…

Anup October 5, 2023

0 Comments

Generate Create Tablespace Script

Reader Modeset serveroutput on size 1000000 DECLARE CURSOR get_ts IS SELECT * FROM dba_tablespaces WHERE tablespace_name != ‘SYSTEM’; CURSOR get_df (p_ts VARCHAR2) IS…

Anup October 5, 2023

0 Comments

Apply Patch Set 4 (10.2.0.5) in RAC Environment

Reader Mode Source Environment Details: ORACLE_HOME=/home/oracle/oracle/product/10.2.0/db CRS_HOME=/home/oracle/oracle/product/10.2.0/crs Oracle Database Version SQL> select * from v$version; BANNER —————————————————————- Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 –…

Anup October 5, 2023

0 Comments

Responses

Anonymous January 19, 2019

you made my day

Reply

Related Articles

Responses