Share the content if you found it is useful (You can share using 300 community websites) click "share" at the end of the post.

You are encouraged to leave a comment.








Tuesday, March 10, 2009

After upgrading the database to 9.2.0.8, Autoconfig fails on adcrobj.sh / afdbprf.sh on dbTier

Today, I held up with one issue in the upgraded Database, (ie) from 9.2.0.6 to 9.2.0.8.

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:

Related Posts Plugin for WordPress, Blogger...

Let us be Friends...

Share |

Popular Posts

Recent Comments