Forgot your password?    
+ Reply to Thread
Results 1 to 8 of 8

Thread: Error while logging to home page of EBS with sysadmin usernm/pwd.

  1. #1
    Oracle DBA
    Join Date
    Oct 2011
    Posts
    21

    Error while logging to home page of EBS with sysadmin usernm/pwd.

    Hi,

    I am getting this error when trying to login to EBS. This started after I changed my database from non-archive to archive mode.

    Help.
    Vipul
    Attached Images Attached Images

  2. #2
    Expert Oracle Administrator
    Join Date
    Oct 2011
    Location
    New Delhi, India
    Posts
    427
    Vipul ,

    Please can you put in the error message here .. am not able to read the content in the screenshot.

    Thanks

  3. #3
    Oracle DBA
    Join Date
    Oct 2011
    Posts
    21
    The error message which is shown is:

    Exception Details.

    oracle.apps.fnd.framework.OAException: Application: FND, Message Name: SQL_PLSQL_ERROR. Tokens: ROUTINE = WebAppsContext.createSession(userId=6,sessionMode= '115P','B96EBE1C641079A6E040007F010024041629584272 6901925179840963781143'); REASON = java.sql.SQLException: ORA-20001: Oracle error -376: ORA-00376: file 398 cannot be read at this time ORA-01110: data file 398: '/u02/oraprod/proddata/a_archive01.dbf' has been detected in FND_SIGNON.NEW_ICX_SESSION. ORA-06512: at "APPS.APP_EXCEPTION", line 70 ORA-06512: at "APPS.FND_SIGNON", line 18 ORA-06512: at "APPS.FND_SIGNON", line 744 ORA-06512: at "APPS.FND_SESSION_MANAGEMENT", line 323 ORA-06512: at "APPS.FND_SESSION_MANAGEMENT", line 466 ORA-06512: at line 1 ; ERRNO = 20001; (Could not lookup message because there is no database connection) at oracle.apps.fnd.framework.OACommonUtils.processAOL JErrorStack(OACommonUtils.java:870) at oracle.apps.fnd.framework.webui.OAPageBean.validat eUser(OAPageBean.java:4170) at oracle.apps.fnd.framework.webui.OAPageBean.prepare Page(OAPageBean.java:597) at oracle.apps.fnd.framework.webui.OAPageBean.prepare Page(OAPageBean.java:462) at oracle.apps.fnd.framework.webui.OAPageBean.prepare Page(OAPageBean.java:383) at _oa__html._OA._jspService(_OA.java:88) at oracle.jsp.runtime.HttpJsp.service(HttpJsp.java:11 9) at oracle.jsp.app.JspApplication.dispatchRequest(JspA pplication.java:417) at oracle.jsp.JspServlet.doDispatch(JspServlet.java:2 67) at oracle.jsp.JspServlet.internalService(JspServlet.j ava:186) at oracle.jsp.JspServlet.service(JspServlet.java:156) at javax.servlet.http.HttpServlet.service(HttpServlet .java:588) at org.apache.jserv.JServConnection.processRequest(JS ervConnection.java:456) at org.apache.jserv.JServConnection.run(JServConnecti on.java:294) at java.lang.Thread.run(Thread.java:534) ## Detail 0 ## oracle.apps.fnd.framework.OAException: Application: FND, Message Name: FND_GENERIC_MESSAGE. Tokens: MESSAGE = java.sql.SQLException: ORA-20001: Oracle error -376: ORA-00376: file 398 cannot be read at this time ORA-01110: data file 398: '/u02/oraprod/proddata/a_archive01.dbf' has been detected in FND_SIGNON.NEW_ICX_SESSION. ORA-06512: at "APPS.APP_EXCEPTION", line 70 ORA-06512: at "APPS.FND_SIGNON", line 18 ORA-06512: at "APPS.FND_SIGNON", line 744 ORA-06512: at "APPS.FND_SESSION_MANAGEMENT", line 323 ORA-06512: at "APPS.FND_SESSION_MANAGEMENT", line 466 ORA-06512: at line 1 ; (Could not lookup message because there is no database connection) at oracle.apps.fnd.framework.OAException.wrapperExcep tion(OAException.java:888) at oracle.apps.fnd.framework.OAException.wrapperExcep tion(OAException.java:862) at oracle.apps.fnd.framework.OACommonUtils.processAOL JErrorStack(OACommonUtils.java:876) at oracle.apps.fnd.framework.webui.OAPageBean.validat eUser(OAPageBean.java:4170) at oracle.apps.fnd.framework.webui.OAPageBean.prepare Page(OAPageBean.java:597) at oracle.apps.fnd.framework.webui.OAPageBean.prepare Page(OAPageBean.java:462) at oracle.apps.fnd.framework.webui.OAPageBean.prepare Page(OAPageBean.java:383) at _oa__html._OA._jspService(_OA.java:88) at oracle.jsp.runtime.HttpJsp.service(HttpJsp.java:11 9) at oracle.jsp.app.JspApplication.dispatchRequest(JspA pplication.java:417) at oracle.jsp.JspServlet.doDispatch(JspServlet.java:2 67) at oracle.jsp.JspServlet.internalService(JspServlet.j ava:186) at oracle.jsp.JspServlet.service(JspServlet.java:156) at javax.servlet.http.HttpServlet.service(HttpServlet .java:588) at org.apache.jserv.JServConnection.processRequest(JS ervConnection.java:456) at org.apache.jserv.JServConnection.run(JServConnecti on.java:294) at java.lang.Thread.run(Thread.java:534) ## Detail 0 ## java.sql.SQLException: ORA-20001: Oracle error -376: ORA-00376: file 398 cannot be read at this time ORA-01110: data file 398: '/u02/oraprod/proddata/a_archive01.dbf' has been detected in FND_SIGNON.NEW_ICX_SESSION. ORA-06512: at "APPS.APP_EXCEPTION", line 70 ORA-06512: at "APPS.FND_SIGNON", line 18 ORA-06512: at "APPS.FND_SIGNON", line 744 ORA-06512: at "APPS.FND_SESSION_MANAGEMENT", line 323 ORA-06512: at "APPS.FND_SESSION_MANAGEMENT", line 466 ORA-06512: at line 1 at oracle.jdbc.dbaccess.DBError.throwSqlException(DBE rror.java:134) at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:2 89) at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:583) at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol .java:1986) at oracle.jdbc.ttc7.TTC7Protocol.executeFetch(TTC7Pro tocol.java:1005) at oracle.jdbc.driver.OracleStatement.executeNonQuery (OracleStatement.java:2190) at oracle.jdbc.driver.OracleStatement.doExecuteOther( OracleStatement.java:2050) at oracle.jdbc.driver.OracleStatement.doExecuteWithTi meout(OracleStatement.java:2931) at oracle.jdbc.driver.OraclePreparedStatement.execute Update(OraclePreparedStatement.java:662) at oracle.jdbc.driver.OraclePreparedStatement.execute (OraclePreparedStatement.java:738) at oracle.apps.fnd.common.WebAppsContext.createSessio n(WebAppsContext.java:1813) at oracle.apps.fnd.common.WebAppsContext.createSessio n(WebAppsContext.java:1907) at oracle.apps.fnd.common.WebAppsContext.createAnonym ousSession(WebAppsContext.java:3739) at oracle.apps.fnd.common.WebRequestUtil.setGuestSess ion(WebRequestUtil.java:1081) at oracle.apps.fnd.framework.webui.OAPageBean.validat eUser(OAPageBean.java:4168) at oracle.apps.fnd.framework.webui.OAPageBean.prepare Page(OAPageBean.java:597) at oracle.apps.fnd.framework.webui.OAPageBean.prepare Page(OAPageBean.java:462) at oracle.apps.fnd.framework.webui.OAPageBean.prepare Page(OAPageBean.java:383) at _oa__html._OA._jspService(_OA.java:88) at oracle.jsp.runtime.HttpJsp.service(HttpJsp.java:11 9) at oracle.jsp.app.JspApplication.dispatchRequest(JspA pplication.java:417) at oracle.jsp.JspServlet.doDispatch(JspServlet.java:2 67) at oracle.jsp.JspServlet.internalService(JspServlet.j ava:186) at oracle.jsp.JspServlet.service(JspServlet.java:156) at javax.servlet.http.HttpServlet.service(HttpServlet .java:588) at org.apache.jserv.JServConnection.processRequest(JS ervConnection.java:456) at org.apache.jserv.JServConnection.run(JServConnecti on.java:294) at java.lang.Thread.run(Thread.java:534) oracle.apps.fnd.framework.OAException: Application: FND, Message Name: FND_GENERIC_MESSAGE. Tokens: MESSAGE = java.sql.SQLException: ORA-20001: Oracle error -376: ORA-00376: file 398 cannot be read at this time ORA-01110: data file 398: '/u02/oraprod/proddata/a_archive01.dbf' has been detected in FND_SIGNON.NEW_ICX_SESSION. ORA-06512: at "APPS.APP_EXCEPTION", line 70 ORA-06512: at "APPS.FND_SIGNON", line 18 ORA-06512: at "APPS.FND_SIGNON", line 744 ORA-06512: at "APPS.FND_SESSION_MANAGEMENT", line 323 ORA-06512: at "APPS.FND_SESSION_MANAGEMENT", line 466 ORA-06512: at line 1 ; (Could not lookup message because there is no database connection) at oracle.apps.fnd.framework.OAException.wrapperExcep tion(OAException.java:888) at oracle.apps.fnd.framework.OAException.wrapperExcep tion(OAException.java:862) at oracle.apps.fnd.framework.OACommonUtils.processAOL JErrorStack(OACommonUtils.java:876) at oracle.apps.fnd.framework.webui.OAPageBean.validat eUser(OAPageBean.java:4170) at oracle.apps.fnd.framework.webui.OAPageBean.prepare Page(OAPageBean.java:597) at oracle.apps.fnd.framework.webui.OAPageBean.prepare Page(OAPageBean.java:462) at oracle.apps.fnd.framework.webui.OAPageBean.prepare Page(OAPageBean.java:383) at _oa__html._OA._jspService(_OA.java:88) at oracle.jsp.runtime.HttpJsp.service(HttpJsp.java:11 9) at oracle.jsp.app.JspApplication.dispatchRequest(JspA pplication.java:417) at oracle.jsp.JspServlet.doDispatch(JspServlet.java:2 67) at oracle.jsp.JspServlet.internalService(JspServlet.j ava:186) at oracle.jsp.JspServlet.service(JspServlet.java:156) at javax.servlet.http.HttpServlet.service(HttpServlet .java:588) at org.apache.jserv.JServConnection.processRequest(JS ervConnection.java:456) at org.apache.jserv.JServConnection.run(JServConnecti on.java:294) at java.lang.Thread.run(Thread.java:534) ## Detail 0 ## java.sql.SQLException: ORA-20001: Oracle error -376: ORA-00376: file 398 cannot be read at this time ORA-01110: data file 398: '/u02/oraprod/proddata/a_archive01.dbf' has been detected in FND_SIGNON.NEW_ICX_SESSION. ORA-06512: at "APPS.APP_EXCEPTION", line 70 ORA-06512: at "APPS.FND_SIGNON", line 18 ORA-06512: at "APPS.FND_SIGNON", line 744 ORA-06512: at "APPS.FND_SESSION_MANAGEMENT", line 323 ORA-06512: at "APPS.FND_SESSION_MANAGEMENT", line 466 ORA-06512: at line 1 at oracle.jdbc.dbaccess.DBError.throwSqlException(DBE rror.java:134) at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:2 89) at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:583) at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol .java:1986) at oracle.jdbc.ttc7.TTC7Protocol.executeFetch(TTC7Pro tocol.java:1005) at oracle.jdbc.driver.OracleStatement.executeNonQuery (OracleStatement.java:2190) at oracle.jdbc.driver.OracleStatement.doExecuteOther( OracleStatement.java:2050) at oracle.jdbc.driver.OracleStatement.doExecuteWithTi meout(OracleStatement.java:2931) at oracle.jdbc.driver.OraclePreparedStatement.execute Update(OraclePreparedStatement.java:662) at oracle.jdbc.driver.OraclePreparedStatement.execute (OraclePreparedStatement.java:738) at oracle.apps.fnd.common.WebAppsContext.createSessio n(WebAppsContext.java:1813) at oracle.apps.fnd.common.WebAppsContext.createSessio n(WebAppsContext.java:1907) at oracle.apps.fnd.common.WebAppsContext.createAnonym ousSession(WebAppsContext.java:3739) at oracle.apps.fnd.common.WebRequestUtil.setGuestSess ion(WebRequestUtil.java:1081) at oracle.apps.fnd.framework.webui.OAPageBean.validat eUser(OAPageBean.java:4168) at oracle.apps.fnd.framework.webui.OAPageBean.prepare Page(OAPageBean.java:597) at oracle.apps.fnd.framework.webui.OAPageBean.prepare Page(OAPageBean.java:462) at oracle.apps.fnd.framework.webui.OAPageBean.prepare Page(OAPageBean.java:383) at _oa__html._OA._jspService(_OA.java:88) at oracle.jsp.runtime.HttpJsp.service(HttpJsp.java:11 9) at oracle.jsp.app.JspApplication.dispatchRequest(JspA pplication.java:417) at oracle.jsp.JspServlet.doDispatch(JspServlet.java:2 67) at oracle.jsp.JspServlet.internalService(JspServlet.j ava:186) at oracle.jsp.JspServlet.service(JspServlet.java:156) at javax.servlet.http.HttpServlet.service(HttpServlet .java:588) at org.apache.jserv.JServConnection.processRequest(JS ervConnection.java:456) at org.apache.jserv.JServConnection.run(JServConnecti on.java:294) at java.lang.Thread.run(Thread.java:534)






    err1.jpgerr2.jpg

  4. #4
    Oracle DBA
    Join Date
    Oct 2011
    Posts
    21
    Any suggestions/help..................?

  5. #5
    Expert Oracle Administrator
    Join Date
    Oct 2011
    Location
    New Delhi, India
    Posts
    427
    The major problem is in the error message :

    Oracle error -376: ORA-00376: file 398 cannot be read at this time ORA-01110: data file 398: '/u02/oraprod/proddata/a_archive01.dbf' has been detected

    Is this file offline / missing / corrupted...
    - Please see the alertlog for the database
    - Ensure this datafile is a part of the database
    - do a dbv on the datafile.

    Let me know on the results.

  6. #6
    Oracle DBA
    Join Date
    Oct 2011
    Posts
    21
    hi sir,

    i have checked the datafile 398. looks like is corrupt (plz see the scrnshot 1) as filesize shown when doing a ls -l gives 0bytes. any method by which i can recover. Normal method of recover datafile 398 gave error (plz see scrnshot 2). dbverify also gives an error (plz see scrnshot 3)

    scn1.jpgscn2.jpgscn3.jpg

    vipul

  7. #7
    Oracle Administrator
    Join Date
    Oct 2011
    Posts
    43
    Hi vipul
    just try to resize this datafile you can increase or decrease the file. Then try DBV or you can also try RMAN to check for corruptions. Its a problem on OS level.

  8. #8
    Expert Oracle Administrator
    Join Date
    Oct 2011
    Location
    New Delhi, India
    Posts
    427
    Resizing a corrupt datafile is not going to help.
    If its 0 bytes in size , you need to restore and recover the datafile applying all the archives.

    Not recommended (but as I see you are offlining the tablespace) ==> If you are ready to drop the tablespace , losing all the tablespace data , then :
    use offline immediate to offline the tablespace , and then drop the tablespace.

+ Reply to Thread

Similar Threads

  1. Jinitiator 11i - security settings prohibit running ActiveX controls on this page
    By Hemant in forum Concepts,Service Management,Apache,OC4J,OPMN,JServ,Forms, Issues,Troubleshooting,
    Replies: 1
    Last Post: 03-20-2012, 10:55 AM
  2. Validate SYSADMIN Pasword
    By Amit in forum Concepts,Service Management,Apache,OC4J,OPMN,JServ,Forms, Issues,Troubleshooting,
    Replies: 0
    Last Post: 11-01-2011, 03:24 PM
  3. Enable Logging on HTTP Web Server/Apache
    By Amit in forum Concepts,Service Management,Apache,OC4J,OPMN,JServ,Forms, Issues,Troubleshooting,
    Replies: 0
    Last Post: 11-01-2011, 11:24 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

DBA Lounge (P) Ltd. deals in Oracle Technologies on Consulting, Resourcing, Corporate Training


Online and corporate training available on Oracle Database 11g, Oracle 11g Real Application Cluster (RAC), Oracle Applications 11i/R12, Oracle Fusion Middleware 11g, Oracle Identity Management-OIM, Oracle Internet Directory 11g-OID, Oracle Business Intelligence Enterprise Edition-OBIEE, Oracle Golden Gate, Oracle Access Management-OAM, Oracle Internet Directory-ODS, Oracle Identity Analytics Architecture-OIA Statistics