R12 : ORA-38856: cannot mark instance (redo thread ) as enabled -----Resolution as given in metalin
After upgrading to R12.1.3 from 11.5.10.2, we encountered the issue as explained in metalink note - 1457541.1 .
Issue :
REP-1401: 'beforereport': Fatal PL/SQL error occurred.
ORA-38856: cannot mark instance (redo thread ) as enabled
-----------------------------------------------------
As a resolution for the issue, metalink note provides solution as ---
1. Connect to server and navigate to $GL_TOP/patch/115/sql path
cd $GL_TOP/patch/115/sql
2. Connect to database using sqlplus as APPS user
3. Execute below commands one by one at sql command prompt
@gluplifs.pls
@gluplifb.pls
4. Compile the report GLXXTB.rdf using adadmin
5. Retest the issue
----------------------------------------------------------------
The scripts mentioned above are header and body for the package GL_INFO pkg which is already in VALID status in R12 environment.