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.
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!!!
The Following Error was detected while doing Cloning of DB Tier.
The Actual Fact Was:
The server was heavily loaded, so the control file creation terminated unsuccessfully. So manually created the control file and opened the database.
After this, I began run adconfig.sh
$cd $ORACLE_HOME/appsutil/bin $ ./adconfig.sh [oracle@prod bin]$ ./adconfig.sh Enter the full path to the Context file: /oracle/PROD/db/tech_st/11.1.0/appsutil/UPGRDE_prod.xml Enter the APPS user password: The log file for this session is located at: /oracle/PROD/db/tech_st/11.1.0/appsutil/log/UPGRDE_prod/11081336/adconfig.log AutoConfig is configuring the Database environment... AutoConfig will consider the custom templates if present. Using ORACLE_HOME location : /oracle/PROD/db/tech_st/11.1.0 Classpath : :/oracle/PROD/db/tech_st/11.1.0/jdbc/lib/o jdbc5.jar:/oracle/PROD/db/tech_st/11.1.0/appsutil/java/xmlparserv2.jar:/oracle/PROD/db/tech_st/11.1.0/appsutil/java:/oracle/PROD/db/tech_st/11.1.0/jlib/netcfg.jar:/oracle/PROD/db/tech_st/11.1.0/jlib/ldapjclnt11.jar Using Context file : /oracle/PROD/db/tech_st/11.1.0/appsutil/UPGRDE_prod.xml Context Value Management will now update the Context file Updating Context file...COMPLETED Attempting upload of Context file and templates to database...ERROR: InD bCtxFile.uploadCtx() : Exception : Error executng BEGIN fnd_gsm_util.append_ctx_ fragment(:1,:2,:3); END;: 1; Oracle error -25153: ORA-25153: Temporary Tablespac e is Empty has been detected in FND_GSM_UTIL.APPEND_CTX_FRAGMENT. oracle.apps.ad.autoconfig.oam.InDbCtxFileException: Error executng BEGIN fnd_gsm _util.append_ctx_fragment(:1,:2,:3); END;: 1; Oracle error -25153: ORA-25153: Temporary Tablespace is Empty has been detected in FND_GSM_UTIL.APPEND_CTX_FRAGMENT. at oracle.apps.ad.autoconfig.oam.InDbCtxFile.uploadCtx(InDbCtxFile.java: 249) at oracle.apps.ad.autoconfig.oam.CtxSynchronizer.uploadToDb(CtxSynchroni zer.java:328) at oracle.apps.ad.tools.configuration.FileSysDBCtxMerge.updateDBCtx(File SysDBCtxMerge.java:678) at oracle.apps.ad.tools.configuration.FileSysDBCtxMerge.updateDBFiles(Fi leSysDBCtxMerge.java:222) at oracle.apps.ad.context.CtxValueMgt.processCtxFile(CtxValueMgt.java:16 88) at oracle.apps.ad.context.CtxValueMgt.main(CtxValueMgt.java:763) FAILED
So after creating the controlfile, i did not created a tempfile. So,
sqlplus "/as sysdba" SQL*Plus: Release 11.1.0.6.0 - Production on Mon Nov 8 13:45:51 2010 Copyright (c) 1982, 2007, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> select * from v$tempfile; no rows selected SQL> alter tablespace TEMP1 add tempfile '/oracle/PROD/db/apps_st/data/TEMP01.dbf' size 500M autoextend on; Tablespace altered. SQL> select * from v$tempfile; FILE# CREATION_CHANGE# CREATION_TIME TS# RFILE# STATUS ---------- ---------------- ------------------ ---------- ---------- ------- ENABLED BYTES BLOCKS CREATE_BYTES BLOCK_SIZE ---------- ---------- ---------- ------------ ---------- NAME -------------------------------------------------------------------------------- 1 5.9652E+12 08-NOV-10 284 1 ONLINE READ WRITE 524288000 64000 524288000 8192 /oracle/PROD/db/apps_st/data/TEMP01.dbf
After this, again run adconfig.sh on DB Tier :
[oracle@prod bin]$ ./adconfig.sh Enter the full path to the Context file: /oracle/PROD/db/tech_st/11.1.0/appsutil/UPGRDE_prod.xml Enter the APPS user password: The log file for this session is located at: /oracle/PROD/db/tech_st/11.1.0/appsutil/log/UPGRDE_prod/11081348/adconfig.log AutoConfig is configuring the Database environment... AutoConfig will consider the custom templates if present. Using ORACLE_HOME location : /oracle/PROD/db/tech_st/11.1.0 Classpath : :/oracle/PROD/db/tech_st/11.1.0/jdbc/lib/ojdbc5.jar:/oracle/PROD/db/tech_st/11.1.0/appsutil/java/xmlparserv2.jar:/oracle/PROD/db/tech_st/11.1.0/appsutil/java:/oracle/PROD/db/tech_st/11.1.0/jlib/netcfg.jar:/oracle/PROD/db/tech_st/11.1.0/jlib/ldapjclnt11.jar Using Context file : /oracle/PROD/db/tech_st/11.1.0/appsutil/UPGRDE_prod.xml Context Value Management will now update the Context file Updating Context file...COMPLETED Attempting upload of Context file and templates to database...COMPLETED Updating rdbms version in Context file to db111 Updating rdbms type in Context file to 32 bits Configuring templates from ORACLE_HOME ... AutoConfig completed successfully. [oracle@prod bin]$
Cheers… Hope this helps…
