The below error is encountered when I was trying to drop schema from 12C database :
SQL> drop user BKP CASCADE; drop user BKP CASCADE * ERROR at line 1: ORA-28014: cannot drop administrative users Solution :
SQL> alter session set "_oracle_script"=true; Session altered. SQL> drop user BKP CASCADE; User dropped.
Customer Recommended Datapump Export (expdp) Raises Warnings Like “DBMS_AW_EXP: SYS.AW$EXPRESS: OLAP not enabled” (Doc ID 1638799.1)
APPLIES TO :
Oracle Database – Enterprise Edition – Version 11.2.0.4 and later
Oracle Database Cloud Schema Service – Version N/A and later
Oracle Database Exadata Express Cloud Service – Version N/A and later
Oracle Database Exadata Cloud Machine – Version N/A and later
Oracle Cloud Infrastructure – Database Service – Version N/A and later
Information in this document applies to any platform.
SYMPTOMS :
Expdp on Oracle Standard Edition / Standard Edition 1 produces below warnings
DBMS_AW_EXP: SYS.AW$EXPRESS: OLAP not enabled
DBMS_AW_EXP: SYS.AW$AWMD: OLAP not enabled
DBMS_AW_EXP: SYS.AW$AWCREATE: OLAP not enabled
DBMS_AW_EXP: SYS.AW$AWCREATE10G: OLAP not enabled
DBMS_AW_EXP: SYS.AW$AWXML: OLAP not enabled
DBMS_AW_EXP: SYS.AW$AWREPORT: OLAP not enabled
CAUSE :
The issue was explained in
Bug 17718899 – EXPDP ON STANDARD EDITION ONE SHOWS MESSAGES “OLAP NOT ENABLED”
closed with status ‘Not a Bug’ with below comment:
OLAP is not available in Standard Edition One (SE1) or Standard Edition (SE) as per the Database Licensing Information document,
it is only available in Enterprise Edition (EE).
This message is intentionally output for DATAPUMP and coded as such in 11.2.0.4 and higher Standard Edition One (SE1) or Standard Edition (SE).
From the Datapump perspective these are warnings and it is safe to ignore them.
NOTE :
The same symptoms can be encountered with the Oracle Enterprise Edition when OLAP is not installed.
SOLUTION :
The OLAP related warnings can be safely ignored for DataPump usage.
REFERENCES :
BUG:17718899 – EXPDP ON STANDARD EDITION ONE SHOWS MESSAGES “OLAP NOT ENABLED”
This issue is caused due to missing class files in the OA_HTML directory.
We can see the below error in oacore application.log file
javax.servlet.ServletException:
oracle.classloader.util.AnnotatedClassNotFoundException:
Missing class: _AppsLocalLogin
Please perform the below steps :
1. Shutdown the application services
2. Compile the jsp’s manually using the below command
perl $FND_TOP/patch/115/bin/ojspCompile.pl –compile –flush -p 2
logfile set: /d01/oracle/VIS/inst/apps/VIS_vision04/logs/appl/rgf/ojsp/ojspc_error.log
starting...(compiling all)
using 10i internal ojsp ver: 10
synchronizing dependency file:
loading deplist...8096
enumerating jsps...8096
updating dependency...0
initializing compilation:
eliminating children...6025 (-2071)
translating and compiling:
translating jsps...6025/6025 in 3m33s
compiling jsps...6025/6025 in 6m45s
Finished!
3. Check whether all the jsp’s are getting compiled successfully
4. Restart the application services
5. Clear the browser cache
6. Try to open the R12 Login page
After clone, while running adautocfg.sh getting the following error.
Context Value Management will now update the Context file Updating Context file...COMPLETED Attempting upload of Context file and templates to database...Exception in thread "main" java.lang.AbstractMethodError: oracle.sql.LnxLibThin.lnxnuc([BILjava/lang/String;) at oracle.sql.NUMBER.toInt(NUMBER.java:413) at oracle.jdbc.dbaccess.DBConversion.NumberBytesToInt(DBConversion.java: 2959) at oracle.jdbc.driver.OracleStatement.getIntValue(OracleStatement.java:4583) at oracle.jdbc.driver.OracleCallableStatement.getInt(OracleCallableStatement.java:635) at oracle.apps.ad.autoconfig.oam.InDbCtxFile.uploadCtx(InDbCtxFile.java: 216) at oracle.apps.ad.autoconfig.oam.CtxSynchronizer.uploadToDb(CtxSynchronizer.java:328) at oracle.apps.ad.tools.configuration.FileSysDBCtxMerge.updateDBCtx(FileSysDBCtxMerge.java:678) at oracle.apps.ad.tools.configuration.FileSysDBCtxMerge.updateDBFiles(FileSysDBCtxMerge.java:222) at oracle.apps.ad.context.CtxValueMgt.processCtxFile(CtxValueMgt.java:1586) at oracle.apps.ad.context.CtxValueMgt.main(CtxValueMgt.java:665) Error returned from java. Context Value Management was aborted ERROR: Context Value Management Failed. Terminate. The logfile for this session is located at: %APPL_TOP%\admin\%CONTEXT_NAME%\log\\adconfig.log
The reason for this error is that JAVA_TOP/oracle/sql contain the following two files
LnxLibThin.class,
LdxLibThin.class
Need to remove and re-run autoconfig again.
As part of the 11.5.10 Maintenance Pack, these files should have been removed by adpatch
After successfully removed these two files, need to re-run the autoconfig from Applmgr user
Cheers!!!
