JRE Version in R12

To find the JRE/Java version used by Client Machine,

-bash-4.1$ cat $FORMS_WEB_CONFIG_FILE|grep sun_plugin_version
sun_plugin_version=1.6.0_45

(or)

-bash-4.1$ grep plugin $CONTEXT_FILE

                        1.6.0_45</sun_plugin_ver>
                        jdk
-bash-4.1$
 

(or)

cd $COMMON_TOP/webapps/oacore/util/jinitiator

-bash-4.1$ ls -ltr
-rwxrwxr-x 1 applmgr applmgr 17090992 Aug 10  2013 j2se16045.exe

-bash-4.1$


j2se16045.exe means client machine uses jre1.6.0_45.

The name  j2se16045.exe as when we do jre upgrade, will move as follows

 mv jre-6u45-windows-i586.exe $COMMON_TOP/webapps/oacore/util/jinitiator/j2se16045.exe

Install Oracle EBS rpms

1. Download and copy the appropriate yum configuration file in place, by running the following commands as root:

   Oracle Linux 7

   # cd /etc/yum.repos.d
# wget http://public-yum.oracle.com/public-yum-ol7.repo

   Oracle Linux 6

   # cd /etc/yum.repos.d
# wget http://public-yum.oracle.com/public-yum-ol6.repo

   Oracle Linux 5

   # cd /etc/yum.repos.d
# wget http://public-yum.oracle.com/public-yum-el5.repo

   Oracle Linux 4, Update 6 or Newer

   # cd /etc/yum.repos.d
# mv Oracle-Base.repo Oracle-Base.repo.disabled
# wget http://public-yum.oracle.com/public-yum-el4.repo

   Oracle OpenStack for Oracle Linux 2.0

   # cd /etc/yum.repos.d
# wget http://public-yum.oracle.com/public-yum-ol7.repo
# yum install yum-plugin-priorities
   Note: Make sure to enable ol7_optional_latest repository before installing yum-plugin-priorities on your system

   Oracle OpenStack for Oracle Linux 1.0

   # cd /etc/yum.repos.d
# wget http://public-yum.oracle.com/public-yum-openstack-ol6.repo

   Oracle VM 2

   # cd /etc/yum.repos.d
# wget http://public-yum.oracle.com/public-yum-ovm2.repo
2. By default, the latest repository is enabled. If you want to change the default, you can enable an alternative repository by editing the yum configuration file.
• Open the yum configuration file in a text editor
• Locate the section in the file for the repository want to enable, e.g. [el4_u6_base]
• Change enabled=0 to enabled=1

[root@r122prod ~]# cd /etc/yum.repos.d/
[root@r122prod yum.repos.d]# wget http://public-yum.oracle.com/public-yum-el5.repo
--2015-11-29 23:49:20--  http://public-yum.oracle.com/public-yum-el5.repo
Resolving public-yum.oracle.com... 123.176.32.146, 123.176.32.178
Connecting to public-yum.oracle.com|123.176.32.146|:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: 5274 (5.2K) [text/plain]
Saving to: `public-yum-el5.repo'

100%[===========================================================================================================================>] 5,274       --.-K/s   in 0s


2015-11-29 23:49:20 (195 MB/s) - `public-yum-el5.repo' saved [5274/5274]

Edit the public-yum-ol6.repo file to enable the ol5_addons channel.

Find the ol6_addons section and change enabled=0 to enabled=1.

[ol6_addons]
name=Oracle Linux $releasever Add ons ($basearch)
baseurl=http://public-yum.oracle.com/repo/OracleLinux/OL5/addons/$basearch/
gpgkey=http://public-yum.oracle.com/RPM-GPG-KEY-oracle-ol5
gpgcheck=1
enabled=1

Save the file.

[root@r122prod yum.repos.d]# yum install oracle-ebs-server-R12-preinstall -y
Loaded plugins: rhnplugin, security
This system is not registered with ULN.
ULN support will be disabled.
el5_addons                                                                                                                                    | 1.2 kB     00:00
el5_addons/primary                                                                                                                            | 108 kB     00:01
el5_addons                                                                                                                                                   418/418
el5_latest                                                                                                                                    | 1.4 kB     00:00
el5_oracle_addons                                                                                                                             |  951 B     00:00
el5_oracle_addons/primary                                                                                                                     | 1.7 kB     00:00
el5_oracle_addons                                                                                                                                                7/7
ol5_UEK_latest                                                                                                                                | 1.2 kB     00:00
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package oracle-ebs-server-R12-preinstall.x86_64 0:1.0.0-6.el5 set to be updated
el5_addons/filelists                                                                                                                          | 686 kB     00:05
el5_latest/filelists                                                                                                                          |  41 MB     06:16

fnd_concurrent_queues table control_code column meaning

Concurrent Manger queues Status code meaning

SQL> select lookup_code,meaning from apps.fnd_lookups where lookup_type = 'CP_CONTROL_CODE' order by lookup_code;

LOOKUP_CODE                    MEANING
------------------------------ -------------------------------------------------
A                              Activating
B                              Activated
D                              Deactivating
E                              Deactivated
N                              Target node/queue unavailable
O                              Suspending concurrent manager
P                              Suspended
Q                              Resuming concurrent manager
R                              Restarting
T                              Terminating
U                              Updating environment information

LOOKUP_CODE                    MEANING
------------------------------ -------------------------------------------------
V                              Verifying
X                              Terminated

13 rows selected.

Bounce Concurrent Manager from backend or using SQL

I have a requirement to bounce Receiving Transaction Manager everyday. So, I was trying to automate this activity. I found below way to bounce it from backend using a script. I had put all the below statements in a script and scheduled in cron.

Find out the short name of the concurrent manager to be bounced, in my case it is Receiving Transaction Manager

SQL> select CONCURRENT_QUEUE_NAME from  apps.fnd_concurrent_queues_tl where USER_CONCURRENT_QUEUE_NAME='Receiving Transaction Manager';
CONCURRENT_QUEUE_NAME
---------------------
RCVOLTM

Check the status of the concurrent manager before bouncing it.

SQL>select control_code,running_processes,MAX_PROCESSES from fnd_concurrent_queues where concurrent_queue_name='RCVOLTM';

Deactivating the concurrent manager:When you deactivate a manager all requests (concurrent programs) currently running are allowed to complete before the manager(s) shut down.

SQL>update fnd_concurrent_queues set control_code='D' where concurrent_queue_name='RCVOLTM';

Set max and target processes to 0

SQL>update fnd_concurrent_queues set running_processes=0,MAX_PROCESSES=0 where concurrent_queue_name='RCVOLTM';
commit;

see the status of the Manager

SQL>select control_code,running_processes,MAX_PROCESSES from fnd_concurrent_queues where concurrent_queue_name='RCVOLTM';

Activating the concurrent manager:

SQL>update fnd_concurrent_queues set control_code='R' where concurrent_queue_name='RCVOLTM';
commit;

See the status of the Manager

SQL>select control_code,running_processes,MAX_PROCESSES from fnd_concurrent_queues where concurrent_queue_name='RCVOLTM';

Click here for status code meaning 

View Contents of .zip file without Extracting

View Contents of .zip file without Extracting:
To see the contents of zips is to use the familiar ‘unzip’ command with a simple -l flag. The reported information is not as detailed as ‘zipinfo’ but it still includes meaningful details including individual file size, file modification date and time, total file count, and file names.

$ unzip -l archive_name.zip

Sample output of the command is shown below:

[root@R12PRODDB R122_Stage]# unzip -l V29764-01.zip
Archive:  V29764-01.zip
  Length      Date    Time    Name
---------  ---------- -----   ----
    20863  12-20-2011 03:14   readme.htm
        0  12-19-2011 13:39   Disk1/
        0  12-19-2011 13:41   Disk1/install/
        0  12-19-2011 13:39   Disk1/install/linux64/
      686  07-19-2011 05:26   Disk1/install/linux64/oraparam.ini
        0  12-19-2011 13:39   Disk1/install/linux64/resource/
    14341  12-01-2010 16:37   Disk1/install/linux64/resource/cons_pt_BR.nls
    14601  12-01-2010 16:36   Disk1/install/linux64/resource/cons_es.nls
    15518  12-01-2010 16:36   Disk1/install/linux64/resource/cons_ko.nls
    15228  12-01-2010 16:36   Disk1/install/linux64/resource/cons_de.nls
    16440  12-01-2010 16:36   Disk1/install/linux64/resource/cons_ja.nls
    15557  12-01-2010 16:36   Disk1/install/linux64/resource/cons_fr.nls
    14691  12-01-2010 16:36   Disk1/install/linux64/resource/cons_it.nls
    13366  12-01-2010 16:36   Disk1/install/linux64/resource/cons.nls
    12110  12-01-2010 16:37   Disk1/install/linux64/resource/cons_zh_CN.nls
    12175  12-01-2010 16:37   Disk1/install/linux64/resource/cons_zh_TW.nls
   145976  12-01-2010 16:37   Disk1/install/linux64/unzip
   161745  12-01-2010 16:37   Disk1/install/linux64/runInstaller
        0  12-19-2011 13:39   Disk1/plugins/
        0  12-19-2011 13:39   Disk1/plugins/sjsws/

MD5 Checksums for R12.2 Rapid Install Media

MD5 Checksums for R12.2 Rapid Install Media

After staging the Rapid Install software with the buildStage.sh script the md5 checksums for the staged directory structure can be used to validate the software integrity. Do this by running the md5sum program against the stage area using the Oracle-created checksum file.

MD5 Checksums for R12.2 Rapid Install Media (Doc ID 1505510.1).

Which checksums need to run.

In my case, I need to run  Based on startCD 48.

Download the md5sum txt to Stage area and run it.

[root@R12PRODDB ~]# cd R122_Stage/
[root@R12PRODDB R122_Stage]# vi R12.2_Linux_64.txt
[root@R12PRODDB R122_Stage]#  md5sum --check R12.2_Linux_64.txt  > md5sum_result.txt
md5sum: WARNING: 1 of 12868 computed checksums did NOT match

Search for any errors in md5sum

[root@R12PRODDB R122_Stage]# grep -v OK md5sum_result.txt
EBSInstallMedia/AppDB/VISION/Disk7/data/stage/06nrdhe4_1_1: FAILED
[root@R12PRODDB R122_Stage]#

Or

[root@R12PRODDB R122_Stage]# grep FAILED md5sum_result.txt
EBSInstallMedia/AppDB/VISION/Disk7/data/stage/06nrdhe4_1_1: FAILED
[root@R12PRODDB R122_Stage]#

R12.2 Installation Fails with the error "Database pre-install checks failed"

Issue: 

R12.2 Installation Fails with the error "Database pre-install checks failed"

Cause: 

 I have created R12 Stage directory under root $HOME where as I am performing a single node installation with oracle user. Oracle user could not write to /root directory and the error message is populating continuously. The permissions issue was not reported anywhere in the logs.

Solution:

Moved the Stage directory from /root to /u01 and given ownership to oracle user then the installation moved further.

[root@R12PRODDB ~]# pwd

/root

[root@R12PRODDB ~]# cd R122_Stage

[root@R12PRODDB R122_Stage]# pwd

/root/R122_Stage

[root@R12PRODDB /]# mv /root/R122_Stage/ /u01

[root@R12PRODDB /]# cd /u01

[root@R12PRODDB u01]# ls

app  R122_Stage

[root@R12PRODDB u01]# ls -ltr

total 8

drwxr-xr-x. 3 root   root     4096 Jun  6 10:01 app

drwxrwxrwx. 6 oracle oinstall 4096 Jun 25 17:01 R122_Stage






If this error encounters, check for the permissions on stage area. Oracle & applmgr user should be able to read/write to the stage directory. cd to stage area with oracle & application users.