ORA-12504 While running Autoconfig on Database Server

After Oracle Database upgrade from 11.2.0.3 to 11.2.0.4, Autoconfig errored on Database server with the below error


[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>


  [PROFILE PHASE]
  AutoConfig could not successfully execute the following scripts:
    Directory: /test1/oracle/product/11204/appsutil/install/test1_host1
      afdbprf.sh              INSTE8_PRF         1


  [APPLY PHASE]
  AutoConfig could not successfully execute the following scripts:
    Directory: /test1/oracle/product/11204/appsutil/install/test1_host1
      adcrobj.sh              INSTE8_APPLY       1




AutoConfig is exiting with status 2


====Running the failed script has given the ORA-12504 error



$ afdbprf.sh


afdbprf.sh started at Thu Mar  3 03:20:47 JST 2016




The environment settings are as follows …


       ORACLE_HOME : /test1/oracle/product/11204
        ORACLE_SID : TEST1
              PATH : /test1/oracle/product/11204/perl/bin:/test1/oracle/product/11204/perl/bin:/test1/oracle/product/11204/bin:/test1/oracle/product/11204/OPatch:/usr/bin:/usr/sbin:/test1/oracle/product/11204/jdk/bin:/usr/ccs/bin:/bin:/usr/bin/X11:/usr/local/bin::.
      Library Path : /test1/oracle/product/11204/lib:/usr/X11R6/lib:/usr/openwin/lib:/test1/oracle/product/11204/lib:/usr/dt/lib:/test1/oracle/product/11204/ctx/lib


Executable : /test1/oracle/product/11204/bin/sqlplus




Enter the APPS username: APPS


Enter the APPS password:


SQL*Plus: Release 11.2.0.4.0 Production on Thu Mar 3 03:20:55 2016


Copyright (c) 1982, 2013, Oracle.  All rights reserved.


Enter value for 1: Enter value for 2: Enter value for 3: ERROR:
ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA




ERRORCODE = 1 ERRORCODE_END
$






Solution
=========


s_instLocalListener is not correct in database server context file


1. Take Backup of Context file


2. Modify the value of s_instLocalListener from test1 to test1_LOCAL


3. Run Autoconfig

3 thoughts on “ORA-12504 While running Autoconfig on Database Server”

Leave a Reply

Your email address will not be published. Required fields are marked *