Upgrade Latest version of JRE Native on Server and Disable Java-auto update on Client Machine

High Level Steps
***************

1. Download the latest Java patch on Windows platform(Clients platform) from (Doc ID 1439822.1) and unzip the patch. Which consist of jre-7u67-windows-i586.exe file

19295660

Oracle JRE 7 Update 67 with Auto Update Off

05-AUG-2014

                     2. Rename the downloaded JRE Native Plugin file to j2se<version>.exe

For example:

jre-7u67-windows-i586.exe or jre-7u67-windows-x64.exe would be renamed j2se17067.exe

           3. Move the j2se170xx.exe file to the web application tier and place it in the following directory:

$[COMMON_TOP]/webapps/oacore/util/jinitiator

                    4. If not applied previously, apply the JRE Plug-in interoperability Patch 4377566 through AutoPatch by following its readme.

                    5. Run the $FND_TOP/bin/txkSetPlugin.sh script against the web node of the application tier.

# su - applmgr
$ cd $FND_TOP/bin
$ sh txkSetPlugin.sh 17067



Now you have upgraded JRE Native version to latest....So whenever client access the application form's function, it will prompt for latest version java download...


References
**********

Deploying JRE (Native Plug-in) for Windows Clients in Oracle E-Business Suite Release 12 (Doc ID 393931.1)
All Java SE Downloads on MOS (Doc ID 1439822.1)

How to find table DML locks and remove those locks

SQL> set linesize 1500
SQL> set pagesize 500
SQL> select * from dba_dml_locks;

SESSION_ID OWNER                          NAME                           MODE_HELD     MODE_REQUESTE LAST_CONVERT BLOCKING_OTHERS
---------- ------------------------------ ------------------------------ ------------- ------------- ------------ ----------------------------------------
        40 APPLSYS                        FND_CONCURRENT_REQUESTS        Row-X (SX)    None                    45 Not Blocking
       558 AP                             AP_INVOICES_ALL                Row-X (SX)    None                    29 Not Blocking
       676 APPS                           XXICAR_EMP_QUAL_STG            Row-X (SX)    None                   712 Not Blocking
       989 APPLSYS                        AQ$_WF_JAVA_DEFERRED_T         Row-X (SX)    None                   186 Not Blocking
       989 APPLSYS                        AQ$_WF_JAVA_DEFERRED_H         Row-X (SX)    None                   186 Not Blocking
       989 APPLSYS                        AQ$_WF_JAVA_DEFERRED_I         Row-X (SX)    None                   186 Not Blocking
       989 APPLSYS                        WF_JAVA_DEFERRED               Row-X (SX)    None                   186 Not Blocking
      1211 APPLSYS                        FND_CONCURRENT_QUEUES          Row-X (SX)    None                    18 Not Blocking

8 rows selected.

SQL> SELECT SID,SERIAL# FROM V$SESSION WHERE SID IN (SELECT SESSION_ID FROM DBA_DML_LOCKS);

       SID    SERIAL#

---------- ----------

       558      64621

       676       5315

       989       8413

      1211      30149

SQL> alter system kill session '558,64621';

System altered.

SQL> SELECT SID,SERIAL# FROM V$SESSION WHERE SID IN (SELECT SESSION_ID FROM DBA_DML_LOCKS);

       SID    SERIAL#

---------- ----------

        40         55

       676       5315

       989       8413

      1211      30149

SQL>  alter system kill session '40,55' immediate;

System altered.

SQL> SELECT SID,SERIAL# FROM V$SESSION WHERE SID IN (SELECT SESSION_ID FROM DBA_DML_LOCKS);

       SID    SERIAL#

---------- ----------

       319      63245

       676       5315

       989       8413

      1211      30149

SQL> alter system kill session '319,63245';

System altered.

SQL> SELECT SID,SERIAL# FROM V$SESSION WHERE SID IN (SELECT SESSION_ID FROM DBA_DML_LOCKS);

       SID    SERIAL#

---------- ----------

       676       5315

       989       8413

      1211      30149

SQL> alter system kill session '676,5315' immediate;

System altered.

SQL> SELECT SID,SERIAL# FROM V$SESSION WHERE SID IN (SELECT SESSION_ID FROM DBA_DML_LOCKS);

       SID    SERIAL#

---------- ----------

       989       8413

      1211      30149

SQL> alter system kill session '989,8413' immediate;

System altered.

SQL> SELECT SID,SERIAL# FROM V$SESSION WHERE SID IN (SELECT SESSION_ID FROM DBA_DML_LOCKS);

       SID    SERIAL#

---------- ----------

      1211      30149

SQL> alter system kill session '1211,30149' immediate;

System altered.

SQL> SELECT SID,SERIAL# FROM V$SESSION WHERE SID IN (SELECT SESSION_ID FROM DBA_DML_LOCKS);

       SID    SERIAL#

---------- ----------

        40         63

SQL> alter system kill session '40,63';

System altered.

SQL> SELECT SID,SERIAL# FROM V$SESSION WHERE SID IN (SELECT SESSION_ID FROM DBA_DML_LOCKS);

       SID    SERIAL#

---------- ----------

       554      17471

SQL> alter system kill session '554,17471' immediate;

System altered.

SQL> SELECT SID,SERIAL# FROM V$SESSION WHERE SID IN (SELECT SESSION_ID FROM DBA_DML_LOCKS);

no rows selected

Finally we have removed all those DML locks successfully... :)

How to check SMTP Server is working or not in Linux/Unix

bash-3.2# telnet mail.iasri.res.in 25
Trying...
Connected to mail.iasri.res.in.
Escape character is '^]'.
220 mail.iasri.res.in ESMTP Smtpd; Mon, 13 Oct 2014 15:40:47 +0530
EHLO  mail.iasri.res.in
250-mail.iasri.res.in Hello [192.168.101.25], pleased to meet you
250-ENHANCEDSTATUSCODES
250-PIPELINING
250-8BITMIME
250-SIZE 10485760
250-DSN
250-AUTH LOGIN PLAIN DIGEST-MD5 CRAM-MD5
250-STARTTLS
250-DELIVERBY
250 HELP
MAIL FROM:fmsprod@iasri.res.in
250 2.1.0 fmsprod@iasri.res.in... Sender ok
RCPT TO:gunasekarappsdba@gmail.com
250 2.1.5 gunasekarappsdba@gmail.com... Recipient ok
DATA
354 Enter mail, end with "." on a line by itself
Subject: test message sent from manual telnet session

Hello ,

This is a test message sent from a manual telnet session.

Yours truly,
SMTP administrator

.
250 2.0.0 s9DAAldq022476-s9DAAldr022476 Message accepted for delivery
QUIT
221 2.0.0 mail.iasri.res.in closing connection
Connection closed.
bash-3.2#