Autoconfig Fails While Running Scripts "afdbprf.sh" and "adcrobj.sh" with 12.1 database

Upgraded database 11.1.0 for 12.1 database having AutoConfig Error

While implement and run AutoConfig form my newly upgraded database 11.1.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/sonu/db/tech_st/11.1.0/appsutil/install/sonu_visr12
      afdbprf.sh              INSTE8_PRF         1


  [APPLY PHASE]
  AutoConfig could not successfully execute the following scripts:
    Directory: /u01/oracle/sonu/db/tech_st/11.1.0/appsutil/install/sonu_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 ...

[dba@sonu bin]$ cd $ORACLE_HOME/oracore/zoneinfo

[dba@sonu zoneinfo]$ ln -s timezone_18.dat timezone.dat
[dba@sonu zoneinfo]$ ln -s timezone_18.dat timezlrg.dat

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


[dba@sonu bin]$ perl adconfig.pl

Enter the full file path to the Context file: /u01/db/tech_st/12.1.0.2/appsutil/sonu.xml


Enter the APPS user password:

Using Context file          : /u01/db/tech_st/12.1.0.2/appsutil/sonu.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.

No comments:

ORA-00059: Maximum Number Of DB_FILES Exceeded in 19C database

When I am adding datafile to my 19C database facing the below error. SQL> alter tablespace DATA  add datafile '/u01/data/data15.dbf...