Steps to Start and Shutdown Standby :

If the automatic recovery mode is enabled use,

STARTUP :
========

SQL>startup mount

SQL> alter database mount standby database;

SQL> alter database recover managed standby database disconnect from session;

SHUTDOWN :
=========
SQL> alter database recover managed standby database cancel;

SQL> shutdown immediate;

EBS R12 Login Page Is Not Coming Up -

 java.lang.RuntimeException: Guest user/pwd does not exist or match: GUEST/ORACLE 

E-Business Suite (EBS) Production Instance Login page is not coming up, Instead a blank page is being displayed.

CAUSE :

The root cause of the issue is with GUEST User and Password not in sync.

Running the below query, confirmed that GUEST user and password was not in sync

select fnd_web_sec.validate_password('GUEST','ORACLE') from dual;

FND_WEB_SEC.VALIDATE_PASSWORD('GUEST','ORACLE')
--------------------------------------------------------------------------------
N

Also, confirmed with the below error on the oacore log

javax.servlet.ServletException: java.lang.RuntimeException: Guest user/pwd does not exist or match: GUEST/ORACLE

SOLUTION :

Please perform the below steps

1. Shutdown the EBS services.

2. The only supported way to change the Guest user password is to update the context variable s_guest_pass and run AutoConfig, which runs the AdminAppServer utility internally.

3. Run autoconfig on DB Node and then application node.

4. Execute the below sql again:

select fnd_web_sec.validate_password('GUEST','ORACLE') from dual;

Check whether query output is showing Y.

If no,  Please check whether the below error is seen on autoconfig log:

Unable to update GUEST_USER_PWD in database to GUEST/ORACLE - Password was not changed, this point to the DB parameter JAVA_JIT_ENABLED which is set as TRUE.

5. On 11g DB you need to have the below settings for EBS specifically, run the below sql

alter system set JAVA_JIT_ENABLED= FALSE scope = both;

6. Follow the steps 2 and 3 again.

7. Run the below command:

perl $FND_TOP/patch/115/bin/ojspCompile.pl --compile --flush -p 2

7. Check whether the compile completed successfully.

8. Restart the application services.

9. Retest the issue.

EBS R12 Login Page Is Not Coming Up - java.lang.RuntimeException: Guest user/pwd does not exist or match: GUEST/ORACLE (Doc ID 1673030.1)

SMTP Mail Check to identify its triggering Mail or not :

There are 2 methods we can check SMTP.

1.Run the below procedure from SQL Prompt 

DECLARE

  v_From      VARCHAR2(80) := 'test@abc.com';

  v_Recipient VARCHAR2(80) := 'user@abc.com';

  v_Subject   VARCHAR2(80) := 'test subject';

  v_Mail_Host VARCHAR2(30) := '**.**.**.**';  --(SMTP MAIL SERVER IP)

  v_Mail_Conn utl_smtp.Connection;

  crlf        VARCHAR2(2)  := chr(13)||chr(10);

BEGIN

v_Mail_Conn := utl_smtp.Open_Connection(v_Mail_Host, 25);

utl_smtp.Helo(v_Mail_Conn, v_Mail_Host);

utl_smtp.Mail(v_Mail_Conn, v_From);

utl_smtp.Rcpt(v_Mail_Conn, v_Recipient);

utl_smtp.Data(v_Mail_Conn,

   'Date: '   || to_char(sysdate, 'Dy, DD Mon YYYY hh24:mi:ss') || crlf ||

   'From: '   || v_From || crlf ||

   'Subject: '|| v_Subject || crlf ||

   'To: '     || v_Recipient || crlf ||

   crlf ||

   'some message text'|| crlf ||      -- Message body

   'more message text'|| crlf

);

utl_smtp.Quit(v_mail_conn);

EXCEPTION

WHEN utl_smtp.Transient_Error OR utl_smtp.Permanent_Error then

   raise_application_error(-20000, 'Unable to send mail: '||sqlerrm);

END;

2. Below method using telnet

telnet **.**.**.***  **                               -- ( telnet IP port)

EHLO ***.**.7.16                    ( Server IP)

MAIL FROM: test@abc.com

RCPT TO: user@abc.com

DATA

Test mail.

Find The Maximum run time of a concurrent request in a 

particular day using FND History Table :

select DESCRIPTION, request_id, request_date, phase_code, status_code, requested_start_date, 
actual_start_date, actual_completion_date,ROUND(((nvl(actual_completion_date,sysdate) -actual_start_date) * 1440)/60,2)   "Runtime (in hours)"  ,
argument_text from apps.fnd_conc_req_history 
where 
DESCRIPTION in ('&program_name')
and actual_start_date between to_date('21-04-2015 00:00:00','DD-MM-YYYY HH24:MI:SS')
and to_date('22-04-2015 23:59:59','DD-MM-YYYY HH24:MI:SS')
order by request_date desc


Note : Change the Actual start date and to_date based on your requirement

                                  Dbconsole - Orainventory Error Manual Fix 

 

$ emca -repos create

STARTED EMCA at Apr 6, 2016 6:10:46 PM

EM Configuration Assistant, Version 11.2.0.3.0 Production

Copyright (c) 2003, 2011, Oracle.  All rights reserved.

Enter the following information:

Database SID: TEST

Listener port number: 1523

Password for SYS user:

Password for SYSMAN user:

Do you wish to continue? [yes(Y)/no(N)]: Y

Apr 6, 2016 6:11:30 PM oracle.sysman.emcp.EMConfig perform

INFO: This operation is being logged at /testdb/oracle/TEST/db/tech_st/11.2.0.3/cfgtoollogs/emca/TEST/emca_2016_04_06_18_10_46.log.

Apr 6, 2016 6:11:30 PM oracle.sysman.emcp.ParamsManager checkListenerStatusForDBControl

WARNING: ORA-01031: insufficient privileges

Apr 6, 2016 6:11:30 PM oracle.sysman.emcp.EMConfig perform

SEVERE:

Database connection through listener failed. Fix the error and run EM Configuration Assistant again.

Some of the possible reasons may be:

1) Listener port 1523 provided is incorrect. Provide the correct port.

2) Listener is not up. Start the Listener.

3) Database service TEST is not registered with listener. Register the database service.

4) Listener is up on physical host and ORACLE_HOSTNAME environment variable is set to virtual host. Unset ORACLE_HOSTNAME environment variable.

5) Listener is up on virtual host. Set environment variable ORACLE_HOSTNAME=<virtual host>.

6) /etc/hosts does not have correct entry for hostname.

Refer to the log file at /testdb/oracle/TEST/db/tech_st/11.2.0.3/cfgtoollogs/emca/TEST/emca_2016_04_06_18_10_46.log for more details.

Could not complete the configuration. Refer to the log file at /testdb/oracle/TEST/db/tech_st/11.2.0.3/cfgtoollogs/emca/TEST/emca_2016_04_06_18_10_46.log for more details

ERROR in logfile :

=============

Apr 6, 2016 6:10:46 PM oracle.sysman.emcp.util.OUIInventoryUtil getOUILoc

CONFIG: Error accessing inventory.

oracle.sysman.oii.oiii.OiiiInventoryDoesNotExistException: The inventory pointed at location /app04/oracle/DEVA/apps/tech_st/10.1.2/oraInventory is not valid

        at oracle.sysman.oii.oiii.OiiiInstallAreaControl.initAreaControl(OiiiInstallAreaControl.java:1910)

        at oracle.sysman.oii.oiic.OiicStandardInventorySession.initSession(OiicStandardInventorySession.java:301)

        at oracle.sysman.oii.oiic.OiicStandardInventorySession.initSession(OiicStandardInventorySession.java:240)

        at oracle.sysman.oii.oiic.OiicStandardInventorySession.initSession(OiicStandardInventorySession.java:189)

        at oracle.sysman.emcp.util.OUIInventoryUtil.getOUILoc(OUIInventoryUtil.java:135)

        at oracle.sysman.emcp.util.ClusterUtil.isHASInstalled(ClusterUtil.java:279)

        at oracle.sysman.emcp.EMConfig.<clinit>(EMConfig.java:159)

        at java.lang.J9VMInternals.initializeImpl(Native Method)

        at java.lang.J9VMInternals.initialize(J9VMInternals.java:196)

        at oracle.sysman.emcp.EMConfigAssistant.<clinit>(EMConfigAssistant.java:211)

        at java.lang.J9VMInternals.initializeImpl(Native Method)

        at java.lang.J9VMInternals.initialize(J9VMInternals.java:196)

Apr 6, 2016 6:10:46 PM oracle.sysman.emcp.util.ClusterUtil isHASInstalled

CONFIG: Inventory not found

SOLUTION :

 ==========

Enter the inventory path in /etc/oraInst.loc as below

change the oraInst.loc permission to 644

# cat oraInst.loc

inventory_loc=/testdb/oracle/TEST/db/tech_st/11.2.0.3/oraInventory

inst_group=dba