DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Tuesday, November 27, 2012

FRM-92101: There was a failure in the Forms Server during startup. This could happen due to invalid configuration.

Scenario:

After cloning, While launching the forms we get the following error

Error :

FRM-92101: There was a failure in the Forms Server during startup. This could happen due to invalid configuration.
Please look into the web-server log file for details.




Cause:

This is due to ldflags pointing to wrongly to PROD server which should points to (TEST/DEV) respective server.

Solution:

Source the Apps environment

Bring down the application

Cd $ORACLE_HOME/lib32

ls –lrt ldflags  -Would be pointing to production location

unlink  ldflags

ln -s   /u01/test/apps/tech_st/10.1.2/lib/ldflags ldflags (link to the right path)

cd $ORACLE_HOME/forms/lib32/

make -f ins_forms.mk install

Now restart the application and check for the same.

Error while loading shared libraries: libdb.so.2: cannot open shared object file

Scenario:

While starting Apache after clone we faced the following error.

[applmgr@trinity scripts]$ sh adapcctl.sh start
You are running adapcctl.sh version 120.7.12010000.2
Starting OPMN managed Oracle HTTP Server (OHS) instance ...
adapcctl.sh: exiting with status 204
adapcctl.sh: check the

 Check the following log file :
/db/VIS/inst/apps/VIS_doyen/logs/ora/10.1.3/opmn/HTTP_Server~1.log

Error :

/db/VIS/inst/apps/VIS_doyen/ora/10.1.3/Apache/Apache/bin/apachectl startssl: execing httpd
/db/VIS/apps/tech_st/10.1.3/Apache/Apache/bin/httpd: error while loading shared libraries: libdb.so.2: cannot open shared object file: No such file or directory


Cause:

http web server unable to start due to missing library.

Solution:

Create link for library file as below

ln -s /usr/lib/libgdbm.so.2.0.0 /usr/lib/libdb.so.2

Now start Apache and check the same.

[applmgr@DOYEN scripts]$ sh adapcctl.sh start
You are running adapcctl.sh version 120.7.12010000.2
Starting OPMN managed Oracle HTTP Server (OHS) instance ...
adapcctl.sh: exiting with status 0

Now you should be able to access the application.

Monday, November 26, 2012

Apps login shows blank page

Problem :

R12 AppsLocalLogin shows blank page

Check for the following log file
cd $LOG_HOME/ora/10.1.3/j2ee/oacore/oacore_default_group_1

vi application.log

Go to the end of the file and found the following error

Error :

12/11/26 11:12:19.657 html: chain failed
javax.servlet.ServletException: java.lang.RuntimeException: Guest user/pwd does not exist or match: GUEST/ORACLE at com.evermind[Oracle Containers for J2EE 10g  (10.1.3.4.0) ].server.http.EvermindPageContext.handlePageThrowable(EvermindPageContext.java:899)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].server.http.EvermindPageContext.handlePageException(EvermindPageContext.java:816)
at _AppsLocalLogin._jspService(_AppsLocalLogin.java:303)
at com.orionserver[Oracle Containers for J2EE 10g (10.1.3.4.0) ].http.OrionHttpJspPage.service(OrionHttpJspPage.java:59) at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:462)
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.4.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.4.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.4.0) ].server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:621)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:370)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:871)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:453)
at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].server.http.AJPRequestHandler.run(AJPRequestHandler.java:313) at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].server.http.AJPRequestHandler.run(AJPRequestHandler.java:199)
at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260) at com.evermind[Oracle Containers for J2EE 10g (10.1.3.4.0) ].util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)

Now we came to know that there is some problem with Guest user. So validate the Guest user

SQL> select FND_WEB_SEC.VALIDATE_LOGIN('GUEST','ORACLE') from dual;
FND_WEB_SEC.VALIDATE_LOGIN('GUEST','ORACLE')
--------------------------------------------------------------------------------
N
The above Query should show Y but it shows N. So we need to check for the reason
SQL> select fnd_message.get from dual;

GET
--------------------------------------------------------------------------------
Oracle error -449: ORA-00449: background process 'MMON' unexpectedly terminated
with error 448 has been detected in FND_WEB_SEC.VALIDATE_LOGIN(u,p).
So the above error states that there was Abnormal termination happened by MMON.

Solution:

Restart DB and Listener and apps and check for the Validation of Guest user

SQL> select FND_WEB_SEC.VALIDATE_LOGIN('GUEST','ORACLE') from dual;

FND_WEB_SEC.VALIDATE_LOGIN('GUEST','ORACLE')
--------------------------------------------------------------------------------
Y

Tuesday, November 6, 2012

ORA-00600: internal error code, arguments: [krr_init_lbufs_1], [74]

Error :

=====

ORA-00600: internal error code, arguments: [krr_init_lbufs_1], [74]

Scenario:
=======
When we are applying the archives for recovering the database in the middle of a recovery we face this error after applying some of the archvies.

ORA-00279: change 568074198 generated at 03/13/2009 10:47:27 needed for thread 1

ORA-00289: suggestion :

/u02test/archivelogs/archivelog_test_1_2684_655528279.log

ORA-00280: change 556095143 for thread 1 is in sequence #2834

ORA-00278: log file '/u02test/archivelogs/

archivelog_test_1_2684_655528279.log'

no longer needed for this recovery

ORA-00283: recovery session canceled due to errors
ORA-00600: internal error code, arguments: [krr_init_lbufs_1], [74],[66],[43], [], [], [], [], [], [], [], []
ORA-01112: media recovery not started
Only 1 hit in metalink but fortunately a documented bypass ( from bug 7373196 evidently ).

Solution :
========

Bug in 64 bit 11.1.0.7 ...
Shut down the instance
Add the following parameter in pfile
_max_io_size=4194304

Now mount the same and start the recovery.