Oracle APPS DBA

ERROR ORA-29532: Java call terminated by uncaught Java exception: java.security.AccessControlException

ERROR   $ sqlplus / as sysdba rlwrap: error: Cannot execute sqlplus: No such file or directory   SOLUTION Add the following to the environment file: export PATH=$ORACLE_HOME/bin:$PATH export LD_LIBRARY_PATH=$ORACLE_HOME/lib …

ERROR   ERROR ORA-00020 maximum number of processes (%s) exceeded

Tkprof – Convert Trace .trc to Readable    tkprof <file.trc> <file.tkprof> explain=<apps_user>/<pswd> Where,  tkprof: is command <file.trc>: is file name of trace file with location (if currently not in same directory) <file.tkprof>: is …

ERROR   FRM-92050 failed to connect to Server /forms/servlet -1

ERROR Query has exceeded 200 rows. Potentially more rows exists, please restrict your query.  

ERROR Start uploading… Target file: SAF654_XML.rtf Creating a new record in XDO_LOBS: SAF645_XML.rtf java.io.IOException: ORA-01691: unable to extend lob segment XDO.SYS_LOB00001312564V00010$$ by 16 in tablespace APPS_TS_TX_DATA   

ERROR APP-FND-01542 : This Application Server is not authorized to access this system. Please contact your System Administrator. SOLUTION Step 1.  Backup context file . Step 2. Update the context …

How to Create a Read-Only APPS Schema?   We are going to create a schema similar to the APPS schema having only read-only privileges.   Step 1. Create the user for the …