Issue : Autoconfig failed due to mismatch in "s_global_database_name" & "s_dbService" values in Database $CONTEXT_FILE

+++++++++++++++=
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.