Tuesday 8 March 2016

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

2 comments:

Was this Post Helpful?

Feel free to suggest your opinions in the comments section!