Oracle Apps DBA Info

Monday, June 29, 2015

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

Thursday, June 25, 2015

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/

Wednesday, June 24, 2015

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.

Thursday, July 17, 2014

NTP daemon slewing option check failed on some nodes

When I run the runcluvfy.sh got the below error. To fix the issue followed the below steps.

Checking NTP daemon command line for slewing option "-x"
Check: NTP daemon command line
  Node Name                             Slewing Option Set?
  ------------------------------------  ------------------------
  oel5-11g-rac2                         no
  oel5-11g-rac1                         no
Result:
NTP daemon slewing option check failed on some nodes
PRVF-5436 : The NTP daemon running on one or more nodes lacks the slewing option "-x"
Result: Clock synchronization check using Network Time Protocol(NTP) failed.

To perform the below steps need root access. Stop ntpd process

[root@oel5-11g-rac1 ~]# service ntpd stop
Shutting down ntpd:                                        [  OK  ]
[root@oel5-11g-rac1 ~]#

Edit the file /etc/sysconfig/ntpd the line OPTIONS="-u ntp:ntp -p /var/run/ntpd.pid" Add -x before -u in the above line.

[root@oel5-11g-rac1 ~]# cat /etc/sysconfig/ntpd
# Drop root to id 'ntp:ntp' by default.
OPTIONS="-u ntp:ntp -p /var/run/ntpd.pid"

# Set to 'yes' to sync hw clock after successful ntpdate
SYNC_HWCLOCK=no

# Additional options for ntpdate
NTPDATE_OPTIONS=""


[root@oel5-11g-rac1 ~]# cat /etc/sysconfig/ntpd
# Drop root to id 'ntp:ntp' by default.
OPTIONS="-x -u ntp:ntp -p /var/run/ntpd.pid"

# Set to 'yes' to sync hw clock after successful ntpdate
SYNC_HWCLOCK=no

# Additional options for ntpdate
NTPDATE_OPTIONS=""
[root@oel5-11g-rac1 ~]#

Start the ntpd service

[root@oel5-11g-rac1 ~]#  service ntpd start
ntpd: Synchronizing with time server:                      [  OK  ]
Starting ntpd:                                             [  OK  ]
[root@oel5-11g-rac1 ~]#

Now run the runcluvfy.sh to check the re-test the issue.
Result: Clock synchronization check using Network Time Protocol(NTP) passed

Wednesday, July 16, 2014

Recommended Browsers for Oracle E-Business Suite Release 12 (Doc ID 389422.1)

Certification Matrix for Internet Explorer (64-bit) Browsers

The table below outlines the certified combinations of 64-bit Internet Explorer Browser, Windows Desktop Client Operating System and JRE (64-bit) streams with minimum versions, where applicable. Please also review this document for further specific certification information and requirements:

Browser Version	Windows 8 (Desktop Mode) (64-bit)	Windows 7 (64-bit)
IE 10 (64-bit)	JRE 1.6.0_37 (64-bit) and higher JRE 1.7.0_10 (64-bit) and higher	JRE 1.6.0_32 (64-bit) and higher JRE 1.7.0_10 (64-bit) and higher
IE 9 (64-bit)	Not Certified	JRE 1.6.0_32 (64-bit) and higher JRE 1.7.0_10 (64-bit) and higher
IE 8 (64-bit)	Not Certified	JRE 1.6.0_32 (64-bit) and higher JRE 1.7.0_10 (64-bit) and higher

Certification Matrix for Internet Explorer (32-bit) Browsers

The table below outlines the certified combinations of 32-bit Internet Explorer Browser, Windows Desktop Client Operating System and JRE (32-bit) streams with minimum versions, where applicable. Please also review this document for further specific certification information and requirements:

Browser Version	Windows 8 (Desktop Mode) (32-bit & 64-bit)	Windows 7 (32-bit & 64-bit)	Windows Vista (32-bit)	Windows XP (32-bit)
IE 10	JRE 1.6.0_37 and higher JRE 1.7.0_10 and higher	JRE 1.6.0_03 and higher JRE 1.7.0_10 and higher	Not Certified	Not Certified
IE 9	Not Certified	JRE 1.6.0_03 and higher JRE 1.7.0_10 and higher	JRE 1.6.0_03 and higher JRE 1.7.0_10 and higher	Not Certified
IE 8	Not Certified	JRE 1.6.0_03 and higher JRE 1.7.0_10 and higher	JRE 1.6.0_03 and higher JRE 1.7.0_10 and higher	JRE 1.6.0_03 and higher JRE 1.7.0_10 and higher
IE 7	Not Certified	Not Certified	JRE 1.6.0_03 and higher JRE 1.7.0_10 and higher	JRE 1.6.0_03 and higher JRE 1.7.0_10 and higher
IE 6	Not Certified	Not Certified	Not Certified	JRE 1.6.0_03 and higher JRE 1.7.0_10 and higher