+++++++++++++++=
Architecture :
++++++++++++++++
Apps : 12.0.6
DB : 10.2.0.5
Activity : CPU Patching for APPS & IAS and PSU patching for DB
+++++++++++++++++
While performing autoconfig on MT it failed.
Extracted the errors from the Terminal and log files are as follows :
$ tail -f $APPL_TOP/admin/KIRANG/log/adconfig/adconfig_120714233022.log
Using Context file : /KIRANG/inst/apps/KIRANG_ramuginni/appl/admin/KIRANG_ramuginni.xml
Context Value Management will now update the Context file
Updating Context file...COMPLETED
Attempting upload of Context file and templates to database...COMPLETED
Configuring templates from all of the product tops...
Configuring AD_TOP........COMPLETED
Configuring FND_TOP.......COMPLETED
Configuring ICX_TOP.......COMPLETED
Configuring IEO_TOP.......COMPLETED
....
.....
Configuring OZF_TOP.......COMPLETED
Configuring IES_TOP.......COMPLETED
Configuring CSD_TOP.......COMPLETED
Configuring IGC_TOP.......COMPLETED
AutoConfig completed with errors.
[CVM Error Report]
The following report lists errors encountered during CVM Phase
<filename> <return code where appropriate>
/KIRANG/applmgr/1206/ad/12.0.0/bin/adgentns.pl 2
No of scripts failed in CVM phase: 1
[AutoConfig Error Report]
The following report lists errors AutoConfig encountered during each
phase of its execution. Errors are grouped by directory and phase.
The report format is:
<filename> <phase> <return code where appropriate>
[SETUP PHASE]
AutoConfig could not successfully execute the following scripts:
Directory: /KIRANG/inst/apps/KIRANG_ramuginni/admin/install
adgendbc.sh INSTE8_SETUP 1
AutoConfig is exiting with status 1
Error Details :
++++++++++++++
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Params=fnd_jdbc_buffer_min=5
fnd_jdbc_buffer_max=20
fnd_jdbc_buffer_decay_interval=60
fnd_jdbc_buffer_decay_size=50
fnd_jdbc_usable_check=true
fnd_jdbc_context_check=true
fnd_jdbc_plsql_reset=false
Unique constraint error (00001) is OK if key already exists
java.sql.SQLException: Listener refused the connection with the following error:
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor
The Connection descriptor used by the client was:
(DESCRIPTION=(ADDRESS_LIST=(LOAD_BALANCE=YES)(FAILOVER=YES)(ADDRESS=(PROTOCOL=tcp)(HOST=kiranginni.kiraninsourcing.com)(PORT=10010)))(CONNECT_DATA=(SERVICE_NAME=KIRANG.kiraninsourcing.com)))
Database connection to jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(LOAD_BALANCE=YES)(FAILOVER=YES)(ADDRESS=(PROTOCOL=tcp)(HOST=kiranginni.kiraninsourcing.com)(PORT=10010)))(CONNECT_DATA=(SERVICE_NAME=KIRANG.kiraninsourcing.com))) failed
ADD call failed with exit code 1
Upon search in Metalink found below note : 422709.1 as close hit.
Followed and resolved the issue.
Solution :
To implement the solution, please execute the following steps::
1 - Modify the value of s_global_database_name in the database tier context file to match the
s_dbService value.
2 - Rerun Autoconfig in DB first and followed by MT where we are facing issue.
Configuring EAM_TOP.......COMPLETED
Configuring FTE_TOP.......COMPLETED
Configuring ONT_TOP.......COMPLETED
Configuring AR_TOP........COMPLETED
Configuring AHL_TOP.......COMPLETED
Configuring OZF_TOP.......COMPLETED
Configuring IES_TOP.......COMPLETED
Configuring CSD_TOP.......COMPLETED
Configuring IGC_TOP.......COMPLETED
AutoConfig completed successfully.
Happy Reading...
~kiran.
