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

Wednesday, November 7, 2012

Query to find the session that is generating more Archives

This Query is to find the session that is generating more Archives.

col program for a10
col username for a10
select to_char(sysdate,'hh24:mi'), username, program , a.sid, a.serial#, b.name, c.value
from v$session a, v$statname b, v$sesstat c
where b.STATISTIC# =c.STATISTIC#
and c.sid=a.sid and b.name like 'redo%'
order by value;

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.