When it is a need to run autoconfig on the database tier, it ended up in the errors that
1. [AutoConfig Error Report]
The following report lists errors AutoConfig encountered during eachphase of its execution. Errors are grouped by directory and phase.
The report format is:
[APPLY PHASE]
AutoConfig could not successfully execute the following scripts: Directory: /oracle/Apps/visdb/9.2.0/appsutil/install/VIS_moonserver
adcrobj.sh INSTE8_APPLY 1
2. [AutoConfig Error Report]
The following report lists errors AutoConfig encountered during eachphase 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: /oracle/Apps/visdb/9.2.0/appsutil/install/VIS_moonserver
afdbprf.sh INSTE8_PRF 1
AutoConfig is exiting with status 1
But the original error is
-------------------ADX Database Utility Finished---------------
Verifying connection to the Database : Could not be stablished
No Restore Profile file created.
Working towards the fix for the issue:
Metalink Note: ID: 415335.1
SymptomsRunning Autoconfig on the RDBMS Oracle Home fails to run adcrobj.sh - the error message may vary by platform.
Here is the error message on HP-UX 64 bit :
adcrobj.sh exiting with status 1
ERRORCODE = 1 ERRORCODE_END
.end std out.
O/S Message: Not a typewriter
Manual running of the adcrobj.sh did not seem to show this error, but failed to connect as "/ as sysdba" via SQL*PLUS.
The cause of this problem is documented in unpublished
Bug 5449623 - 'AUTOCONFIG FAILS ON DB TIER DUE TO ERROR IN EXECUTING ADCROBJ.SH'
FIX:
1.) Please download and apply Patch 5495695 corresponding to your platform. This is a one-off Patch for 9.2.0.8
To apply this patch:
a. Take care to include the OPatch in the PATH
b. Shutdown the database and Listener
c. opatch apply
Before patch application
Back up the iSQL*Plus executable:
## % cp $ORACLE_HOME/bin/sqlplus $ORACLE_HOME/bin/sqlplus_pre5495695
After applying the patch
mv $ORACLE_HOME/sqlplus/lib/sqlplus $ORACLE_HOME/bin/sqlplus
Rerun the autoconfig.
It should be completed successfully.
No comments:
Post a Comment