Oracle Apps DBA Info

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

Monday, July 7, 2014

VirtualBox-4.2 installation on OEL 5

1. Download Virtaulbox software by running the below command.

wget http://download.virtualbox.org/virtualbox/4.2.16/VirtualBox-4.2-4.2.16_86992_el5-1.x86_64.rpm

[root@appsR12 ~]# wget http://download.virtualbox.org/virtualbox/4.2.16/VirtualBox-4.2-4.2.16_86992_el5-1.x86_64.rpm
--2014-07-07 09:22:24--  http://download.virtualbox.org/virtualbox/4.2.16/VirtualBox-4.2-4.2.16_86992_el5-1.x86_64.rpm
Resolving download.virtualbox.org... 137.254.120.26
Connecting to download.virtualbox.org|137.254.120.26|:80... connected.
HTTP request sent, awaiting response... 302 Moved Temporarily
Location: http://dlc.sun.com.edgesuite.net/virtualbox/4.2.16/VirtualBox-4.2-4.2.16_86992_el5-1.x86_64.rpm [following]
--2014-07-07 09:22:25--  http://dlc.sun.com.edgesuite.net/virtualbox/4.2.16/VirtualBox-4.2-4.2.16_86992_el5-1.x86_64.rpm
Resolving dlc.sun.com.edgesuite.net... 122.165.249.8, 122.165.249.40
Connecting to dlc.sun.com.edgesuite.net|122.165.249.8|:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: 87237668 (83M) [application/x-redhat-package-manager]
Saving to: `VirtualBox-4.2-4.2.16_86992_el5-1.x86_64.rpm.1'

 100% [                                                                                                                 ] 756,155      151K/s  eta 9m 18s  
[root@appsR12 ~]#

2. Now install it.

[root@appsR12 ~]# rpm -iUvH VirtualBox-4.2-4.2.16_86992_el5-1.x86_64.rpm
warning: VirtualBox-4.2-4.2.16_86992_el5-1.x86_64.rpm: Header V4 DSA signature: NOKEY, key ID 98ab5139
Preparing packages for installation...
VirtualBox-4.2-4.2.16_86992_el5-1

Creating group 'vboxusers'. VM users must be member of that group!

No precompiled module for this kernel found -- trying to build one. Messages
emitted during module compilation will be logged to /var/log/vbox-install.log.

Stopping VirtualBox kernel modules [  OK  ]
Recompiling VirtualBox kernel modules [  OK  ]
Starting VirtualBox kernel modules [  OK  ]

Saturday, July 5, 2014

ERROR: ORA-12162: TNS:net service name is incorrectly specified

I just installed oracle software and trying to connect sqlplus
When I say sqlplus, it was giving an error.

-bash-3.00$ sqlplus '/as sysdba'

SQL*Plus: Release 10.2.0.1.0 - Production on Sun Jul 6 00:54:32 2014

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

ERROR:
ORA-12162: TNS:net service name is incorrectly specified


Enter user-name:
ERROR:
ORA-12162: TNS:net service name is incorrectly specified


Enter user-name:
ERROR:
ORA-12162: TNS:net service name is incorrectly specified


SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus

I forgot to export ORACLE_SID
I exported the ORACLE_SID and tried again, it was successful


-bash-3.00$ export ORACLE_SID=prod


-bash-3.00$ sqlplus '/as sysdba'

SQL*Plus: Release 10.2.0.1.0 - Production on Sun Jul 6 01:04:52 2014

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> exit
Disconnected

It was just a thought to share, to those who forgets like me !

Error 6 initializing SQL*Plus

When I tried to connect sqlplus was giving an error.

-bash-3.00$ sqlplus '/as sysdba'
Error 6 initializing SQL*Plus
Message file sp1.msb not found
SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory

Log out from the user and login again. Don't source any environment variables yet.
Check the location of your correct oracle home by going into the directory. Export the oracle home

-bash-3.00$ export ORACLE_HOME=/u01/oracle/product/10.2.0/db_1
-bash-3.00$ export PATH=$ORACLE_HOME/bin:$PATH:.

Now try log in again


-bash-3.00$ sqlplus '/as sysdba'

SQL*Plus: Release 10.2.0.1.0 - Production on Sun Jul 6 01:04:52 2014

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> exit