Sunday, November 29, 2015

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

at No comments:

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.
at No comments:
Labels: ,

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 




















at





No comments:
  


































          

        

          

        

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/















at





No comments:
  


















Labels:







Location:
Tulasi Nagar, Allwyn Colony










          

        

          

        

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]#

















at





No comments:
  


















Labels:


























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. 


























at





2 comments:
  


















Labels:

















          

        

          

        

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












at





No comments:
  


































        

      









Subscribe to:
Posts (Atom)









NLS boot file not found or invalid opmnctl ping – EBS 12.2 ADCFGCLONE FAIL



  Error:  adcfgclone.pl failed while performing clone of EBS 12.2 instance. This occurred while ohsT2PApply is in progress.     INST_TOP/adm...