Hi Readers,
7-8 months back I implemented R12.1.1 on Sun sparc-10 (64-bit) . End users start complaning that after giving username/password on login page and press login gives "unexpected error - please contact to your system administrator" . More interesting thing is that this issue comes intermittently .When end user tried again or refrehes the Internet explore and provide user credentials and clink on login , he/she logged in successfully into the applicaiton. I turned on FND_DIAGNOSTICS to Yes to see more details of the error.
Finally I got below error details and I raised a serv1 for this. After 4-5 months struggle finally oracle released the patch.
Oracle Support - February 9, 2011 1:27:33 PM GMT+05:30 [ODM Action Plan]
=== ODM Action Plan ===Patch 9908921 (9908921:R12.FWK.B Details) "FND, MESSAGE NAME: FND_NO_DATABASE_CONNECTION"has been released
To check more details of the error.
$LOG_HOME/ora/10.1.3/j2ee/oacore/oacore_default_group_1/application.log
javax.servlet.ServletException: Application: FND, Message Name: FND_NO_DATABASE_CONNECTION.
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.5.0) ].server.http.EvermindPageContext.handlePageThrowable(EvermindPageContext.java:899)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.5.0) ].server.http.EvermindPageContext.handlePageException(EvermindPageContext.java:816)
at _OALogout._jspService(_OALogout.java:243)
at com.orionserver[Oracle Containers for J2EE 10g (10.1.3.5.0) ].http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:390)
at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:594)
at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:518)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.5.0) ].server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:64)
at oracle.apps.jtf.base.session.ReleaseResFilter.doFilter(ReleaseResFilter.java:26)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.5.0) ].server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:15)
at oracle.apps.fnd.security.AppsServletFilter.doFilter(AppsServletFilter.java:318)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.5.0) ].server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:642)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.5.0) ].server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:391)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.5.0) ].server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:908)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.5.0) ].server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:458)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.5.0) ].server.http.AJPRequestHandler.run(AJPRequestHandler.java:313)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.5.0) ].server.http.AJPRequestHandler.run(AJPRequestHandler.java:199)
at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
at oracle.oc4j.network.ServerSocketAcceptHandler.procClientSocket(ServerSocketAcceptHandler.java:234)
at oracle.oc4j.network.ServerSocketAcceptHandler.access$700(ServerSocketAcceptHandler.java:29)
at oracle.oc4j.network.ServerSocketAcceptHandler$AcceptHandlerHorse.run(ServerSocketAcceptHandler.java:879)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.5.0) ].util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
at java.lang.Thread.run(Thread.java:619)
10/10/18 09:32:59.564 html: OABodyBean, localName='body': Could not find partial target: Employment.EmpHistoryTab
10/10/18 09:48:07.480 html: OABodyBean, localName='body': Could not find partial target: Employment.EmpHistoryTab
FYI,
When 9908921 Patch released (08-Feb-2011), it released in 2 versions. i.e. 9908921 for OA Framework 12.1.2 and 11832737 (FORWARD PORT OF 9908921 TO 12.1.3 - Released on 16-MAR-2011) for OA Framework 12.1.3 customers.This is documented in Doc Id # 1298103.1 (created as of 30-Mar-2011)
Hope this info is helpful.
Regards
Guru
Don't forget to leave your comments
Tuesday, March 1, 2011
install statspack for snap every 15 mins and snap for 2 hours between special window
Hi All,
Here is the requirement to configure statspack.
install statspackto take performance snapshots every 15 minutes on the 15 minutes except during our batch window of midnight until 7am, during which time we would like performance snapshots taken every 2 hours at the top of the hour (midnight, 2, 4 and 6).
To acheive the requirement we need to create function in which we will pass the data and time values. Same function will be used when we submit dbms_job.
1>Create a funciton.
CREATE OR REPLACE FUNCTION NEXTRUNRETURN DATE as NEXT_DATE DATE; CURRENT_DATE DATE;BEGIN CURRENT_DATE := SYSDATE; if (to_char(CURRENT_DATE,'HH24') > 7 and to_char(CURRENT_DATE,'HH24') <> 0 and to_char(CURRENT_DATE,'HH24') <> Use function NEXTRUN while submitting DBMS_JOB procedure.
variable JOB_NO number;variable INST_NO number;
DECLARE JOB_NO number(6);BEGINSELECT instance_number INTO :INST_NO FROM v$instance;
dbms_job.submit( :JOB_NO, 'statspack.snap;', to_date('03/MAR/11 00:00:00', 'dd/mon/yy HH24:MI:SS'), 'NEXTRUN', TRUE, :INST_NO);
dbms_job.submit( :JOB_NO, 'statspack.snap;', to_date('03/MAR/11 07:00:00', 'dd/mon/yy HH24:MI:SS'), 'NEXTRUN', TRUE, :INST_NO); COMMIT;END;
3>To verify the same next day.
Column Job# format a4Column What format a27Column Last_Date format a15Column Next_Date format a15select substr(to_char(job),1,3) Job#, substr(what,1,27) What, to_char(last_date, 'dd-MON-YY HH24:MI') Last_Date, to_char(Next_Date, 'dd-MON-YY HH24:MI') Next_Date, failures fail#, total_timefrom user_jobs;
Regards
Guru
Here is the requirement to configure statspack.
install statspackto take performance snapshots every 15 minutes on the 15 minutes except during our batch window of midnight until 7am, during which time we would like performance snapshots taken every 2 hours at the top of the hour (midnight, 2, 4 and 6).
To acheive the requirement we need to create function in which we will pass the data and time values. Same function will be used when we submit dbms_job.
1>Create a funciton.
CREATE OR REPLACE FUNCTION NEXTRUNRETURN DATE as NEXT_DATE DATE; CURRENT_DATE DATE;BEGIN CURRENT_DATE := SYSDATE; if (to_char(CURRENT_DATE,'HH24') > 7 and to_char(CURRENT_DATE,'HH24') <> 0 and to_char(CURRENT_DATE,'HH24') <> Use function NEXTRUN while submitting DBMS_JOB procedure.
variable JOB_NO number;variable INST_NO number;
DECLARE JOB_NO number(6);BEGINSELECT instance_number INTO :INST_NO FROM v$instance;
dbms_job.submit( :JOB_NO, 'statspack.snap;', to_date('03/MAR/11 00:00:00', 'dd/mon/yy HH24:MI:SS'), 'NEXTRUN', TRUE, :INST_NO);
dbms_job.submit( :JOB_NO, 'statspack.snap;', to_date('03/MAR/11 07:00:00', 'dd/mon/yy HH24:MI:SS'), 'NEXTRUN', TRUE, :INST_NO); COMMIT;END;
3>To verify the same next day.
Column Job# format a4Column What format a27Column Last_Date format a15Column Next_Date format a15select substr(to_char(job),1,3) Job#, substr(what,1,27) What, to_char(last_date, 'dd-MON-YY HH24:MI') Last_Date, to_char(Next_Date, 'dd-MON-YY HH24:MI') Next_Date, failures fail#, total_timefrom user_jobs;
Regards
Guru
Thursday, January 27, 2011
Delete Discoverer Workbook from backend
Hi,
I was facing couple of issues while deleting the Discoverere 10g workbook from front end.
I successfully deleted the same from backend.
Please find the scripts to delete particular workbook (select sql - to retrive and confim the workbook name ) and delete sql (pass the parameters as per the outcome/requirement of select statement.
eg:-
1)select * from eul5_documents where doc_id=121412 and DOC_EU_ID=100000;
2)select .DOC_NAME,d.DOC_DEVELOPER_KEY,p.notm,d.notm,d.DOC_DESCRIPTION,p.AP_ID,p.AP_TYPE,p.AP_EU_ID, p.GD_DOC_ID,d.doc_id from eul5_access_privs p, eul5_documents d where p.gd_doc_id=d.doc_id and d.doc_id=121412;
3)select * from eul5_access_privs where gd_doc_id=121412 and AP_UPDATED_BY='EUL_XX_US';
4)DELETE FROM eul5_access_privs where gd_doc_id=121412 and AP_UPDATED_BY='EUL_XX_US';
5)delete from eul5_documents where doc_id=121412 and DOC_EU_ID=100000;
6)commit;
Hope this helps.
Don't forget to give your feedback. :-)
Regards
Guru
I was facing couple of issues while deleting the Discoverere 10g workbook from front end.
I successfully deleted the same from backend.
Please find the scripts to delete particular workbook (select sql - to retrive and confim the workbook name ) and delete sql (pass the parameters as per the outcome/requirement of select statement.
eg:-
1)select * from eul5_documents where doc_id=121412 and DOC_EU_ID=100000;
2)select .DOC_NAME,d.DOC_DEVELOPER_KEY,p.notm,d.notm,d.DOC_DESCRIPTION,p.AP_ID,p.AP_TYPE,p.AP_EU_ID, p.GD_DOC_ID,d.doc_id from eul5_access_privs p, eul5_documents d where p.gd_doc_id=d.doc_id and d.doc_id=121412;
3)select * from eul5_access_privs where gd_doc_id=121412 and AP_UPDATED_BY='EUL_XX_US';
4)DELETE FROM eul5_access_privs where gd_doc_id=121412 and AP_UPDATED_BY='EUL_XX_US';
5)delete from eul5_documents where doc_id=121412 and DOC_EU_ID=100000;
6)commit;
Hope this helps.
Don't forget to give your feedback. :-)
Regards
Guru
Error connecting to database ORA--1
While viewing log and ouput files I am getting below error in log/output window.
Error connecting to database (**** DB NAME****): ORA--1
I did lot of troubleshooting to find the cause of this error. Finally came across that APPLSYSPUP is in EXPIRED (GRACE) status . you can check this under dba_users cloumn account_status.
I changed the status to open using
Alter user APPLSYSPUB identified by PUB;
This resolved my issue.
Regards
Guru
Error connecting to database (**** DB NAME****): ORA--1
I did lot of troubleshooting to find the cause of this error. Finally came across that APPLSYSPUP is in EXPIRED (GRACE) status . you can check this under dba_users cloumn account_status.
I changed the status to open using
Alter user APPLSYSPUB identified by PUB;
This resolved my issue.
Regards
Guru
Subscribe to:
Posts (Atom)