Tuesday 3 August 2010

Upgraded database 11.2.0 for R12 having AutoConfig Error

While implement and run AutoConfig form my newly upgraded database 11.2.0, getting the following errors

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


  [PROFILE PHASE]
  AutoConfig could not successfully execute the following scripts:
    Directory: /u01/oracle/AJI/db/tech_st/11.2.0/appsutil/install/AJI_visr12
      afdbprf.sh              INSTE8_PRF         1


  [APPLY PHASE]
  AutoConfig could not successfully execute the following scripts:
    Directory: /u01/oracle/AJI/db/tech_st/11.2.0/appsutil/install/AJI_visr12
      adcrobj.sh              INSTE8_APPLY       1




AutoConfig is exiting with status 2

After checking privileges on $ORACLE_HOME/oracore/zoneinfo, timezone.dat and timezlrg.dat are not present ...

Cause
The multiple timezlrg.* and timezone.* are present so a choice of timezone versions are available.

Solution
To resolve the problem, create links to one of the timezone_nn.dat files. Unless you have a requirement for a specific version, choose the latest ...

$ cd $ORACLE_HOME/oracore/zoneinfo
$ ln -s timezone_11.dat timezone.dat
$ ln -s timezlrg_11.dat timezlrg.dat

After the above steps, again initiated the script, and completed successfully.

[oracle@visr12 bin]$ perl adconfig.sh contextfile=$ORACLE_HOME/appsutil/AJI_visr12.xml appspass=PASS

Using Context file          : /u01/oracle/AJI/db/tech_st/11.2.0/appsutil/AJI_visr12.xml


Context Value Management will now update the Context file


        Updating Context file...COMPLETED


        Attempting upload of Context file and templates to database...COMPLETED


Updating rdbms version in Context file to db112
Updating rdbms type in Context file to 32 bits
Configuring templates from ORACLE_HOME ...

AutoConfig completed successfully.


Cheers!!!

SocialTwist Tell-a-Friend

Related Posts by Categories



No comments: