Case:
While doing adcfgclone.pl in appsTier, the session hang and no further output.
Even after the restart of server, there is no further progress with adcfgclone phase.
It’s hanging trying to connect as APPS.
Details:
$ tail -f /u01/applmgr/fs1/EBSapps/comn/clone/bin/CloneContext_0725094527.log
getConnection() –>
sDbHost : prod01
sDbDomain : example.com
sDbPort : 1521
sDbSid : DEV
sDbUser : APPS
Trying to connect using SID…
getConnectionUsingSID() –>
JDBC URL: jdbc:oracle:thin:@prod01.example.com:1521:DEV
From db server:
$ sqlplus / as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Thu Jan 01 22:01:18 2018
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 – 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Advanced Analytics and Real Application Testing options
SQL> connect apps/<prod apps pwd>
…has been hanging for 60 seconds plus>>>
Solution:
After issuing the following command, and bounce the DB, the issue was resolved.
alter system set event =”28401 TRACE NAME CONTEXT FOREVER, LEVEL 1″ scope=spfile;
