We faced one clone issue in EBS R12. The login screen was blank and oacore log has the below error message
“javax.servlet.ServletException: java.lang.RuntimeException: Guest user/pwd does not exist or match: GUEST/ORACLE”
GUEST user validation was also failing.
Leave a CommentBelow are some of the simple but frequently used database tablespace related queries used by DBAs:
Check Temporary tablespace temp files size
set lines 132 col FILE_NAME format a60 select TABLESPACE_NAME,FILE_NAME,BYTES/1024/1024,AUTOEXTENSIBLE,MAXBYTES/1024/1024 from dba_temp_files;Leave a Comment
One of our EBS R12 was inaccessible and was throwing generic http-404 erorr for the login page. On the application side adopmnctl was showing status ACTIVE for all the required procesees.
Simple HTML file like http://<server_name>:<port>/OA_HTML/test.html was also not opening means it was Apache issue or Oacore issue since definition of OA_HTML in html link is given by OACORE.
Error message in the Browser was like below:
Not Found
The requested URL /OA_HTML/test.html was not found on this server.
In one of the Apache server log we were able to see that it is trying to find the file under portal directory which is not the correct place
</EXEC_CONTEXT_ID> </CORRELATION_DATA> <PAYLOAD> <MSG_TEXT>File does not exist: /fs01/<SID>/inst/apps/<CONTEXT_NAME>/portal/OA_HTML/test.html</MSG_TEXT> </PAYLOAD> </MESSAGE>1 Comment
If you need to add any new classpath to the $CLASSPATH variable in Oracle Apps 11i please see below example:
VERIFY:
$ echo $CLASSPATH /fh02/DBNAME/oraapps/common/util/java/1.6/jdk1.6.0_45/jre/lib/rt.jar:/fh02/DBNAME/oraapps/common/util/ java/1.6/jdk1.6.0_45/lib/dt.jar:/fh02/DBNAME/oraapps/common/util/java/1.6/jdk1.6.0_45/lib/tools.jar: /fh02/DBNAME/oraapps/common/util/java/1.6/jdk1.6.0_45/jre/lib/charsets.jar:/fh02/DBNAME/oraapps/common/ java/appsborg2.zip:/fh02/DBNAME/oraapps/8.0.6/forms60/java:/fh02/DBNAME/oraapps/common/java $ echo $CONTEXT_FILE /fh02/DBNAME/oraapps/11iApp/admin/DBNAME_SERVER.xmlLeave a Comment
We have observed many requests of couple of concurrent prorgams in our R12 instance go into error with below kind of message:
Enter Password:
MSG-01001: Entering AfterPForm
MSG-01001: Starting to retrive former request parameter by request ID
MSG-01001: Exiting AfterPForm
MSG-01010: :S_BATCH_COUNT = 0
REP-0069: Internal error
REP-57054: In-process job terminated:Executed successfully but there were some errors when distribute the output
REP-50159: Executed successfully but there were some errors when distribute the output
REP-54002: file : Cache item is no longer valid
Solaris is one of the flavor of UNIX and is currently controlled by Oracle corporation.
Below are some of the useful Soalris command from DBA perspectives.
Leave a CommentR12: Login was Failing Intermittently With Error “oracle.apps.fnd.framework.OAException: Application: FND, Message Name: FND_NO_DATABASE_CONNECTION”
Or getting below error when trying to access EB R12 login page.
If webadi look and feel seems distorted in 11i/R12 then you can check below profile option
Sometimes it is required to flush the BAD SQL_PLAN from shared_pool so that new (or old) better execution plan can be picked by SQL_ID
1) FIND ADDRESS AND HASH_VALUE OF SQL_ID
SQL> select ADDRESS, HASH_VALUE from V$SQLAREA where SQL_ID like '7yc%'; ADDRESS HASH_VALUE ---------------- ---------- 000000085FD77CF0 808321886
5 Comments
