R12.2 Apps DBA. Powered by Blogger.

Adop Prepare Phase Fails With Error: Bad Stylesheet (Doc ID 2183746.1)

No comments :
SYMPTOMS
On : 12.2.4 version, Applications Installation
adop phase=prepare fails with "bad stylesheet" error
1. We are in a middle of installing AD/TXK delta 7 as per the Note:1617461.1 - Applying the Latest AD and TXK Release Update Packs to Oracle E-Business Suite Release 12.2
2. The ETCC patches on the database have been successfully applied.
3. Running the following command produces and error:
$ adop phase=prepare
ERROR
-----------------------
Validating system setup.
  Node registry is valid.
  Remote execution is operational.
  [ERROR] META:16:20:36.632: bad stylesheet: kurole
  Encountered the above errors when performing database validations.
 Resolve the above errors and restart adop.
adop exiting with status = 1 (Fail)
CHANGES
Applying latest RUPs to R12.2
CAUSE
After applying RDBMS patches the adgrants.sql script was not executed.
Since the the adgrants.sql script was not executed, The "META:16:20:36.632: bad stylesheet" error is thrown.
SOLUTION
1. To find the current version of the adgrants.sql script on the instance, do the following:
  a. Source the database environment.
  b. Then go $ORACLE_HOME/appsutil/admin and provide the version of adgrants.sql file by executing:
  $ head -n 4 adgrants.sql
2. Copy this version (or higher) over to the database environment.
(In this case it was: adgrants.sql 120.67.12020000.37)
3. Execute it:
$ sqlplus /nolog
SQL> @$ORACLE_HOME/appsutil/admin/adgrants.sql
4. Run the ADOP Prepare phase again.

No comments :

Post a Comment

Note: only a member of this blog may post a comment.