ORAERP.COM - The Knowledge Center for Oracle ERP Professionals - Looking Beyond the Possibilities - Oracle Database Administration

FRM-47023:No such parameter named G_QUERY_FIND exists in form OEXOETEL

Wed, 12 Jun 2013 12:49:51 -0500

Hi,

I did fresh clone and after the clone when end user is trying to launch the form, he is encountering with error FRM-47023

FRM-47023:No such parameter named G_QUERY_FIND exists in form OEXOETEL

Please suggest. Error screenshots are attached in zip file.

Regards,
Sandy

error_form.zip (Size: 51.99 KB / Downloads: 1)

FRM-92050 error

Sat, 08 Jun 2013 02:37:42 -0500

Hi,

I have made the fresh clone with cold backup. Clone was successful, but it is showing error -
FRM-92050: Failed to connect to the server: .:
My source system is R12.1.3 with database version 11.1.0.7 on OS Version Linux 5.3 and the Target system is installed with OS Version Linux 5.9

Earlier, we have installed OS Version Linux 5.8 on the target but the yum installed updated it to the version Linux 5.9

Regards,
Sandy

PO not getting approved via mobile (blackberry) and e-mail

Mon, 27 May 2013 09:50:48 -0500

Hi,

PO/ PRF are not getting approve via mobile. When user clicks on approve button after receiving the emails, the same is not getting approved.

version for workflow e-mailer:
WF_VERSION - 2.6.0

I already went through the doc. How to Diagnose Problems with Purchasing Email Notifications [ID 369595.1]

Regards,
Sandy

Creating ODG for DB part of Oracle Apps R12.1.3

Tue, 21 May 2013 07:07:01 -0500

I am to create Oracle Data Guard for my current running Oracle Application version R12.1.3 with DB version 11gR2 (file system) to 2 Node RAC in Exadata Machine on ASM Disk Group.

Please provide the doc. id's or the steps to perform the same.

One thing more, do I need to take special precautions for my Application Tier? Do I need to apply some additional patches on Application Tier before creating the ODG for the DB part??

Regards,
Sandy

EBS R12 with RAC & ASM Installation on Solaris UNIX/RedHat Linux

Wed, 12 Sep 2012 06:43:20 -0500

Dear All,
We are going on a R12 New Installation on Solaris. Can someone
share Documents on the BEST Practices in industry.

Enable AutoConfig on Applications Database Tier

Mon, 23 Jan 2012 01:19:23 -0600

Enable AutoConfig on Applications Database Tier

Steps to Perform On All Oracle RAC Nodes

1> Execute $AD_TOP/bin/admkappsutil.pl on the applications tier to generate an
appsutil.zip file for the database tier.

2> Copy (e.g. via ftp) the appsutil.zip file to the database tier in the 11gR2_ORACLE_HOME

On linux1

On linux2

3> Unzip the appsutil.zip file to create the appsutil directory in the 11gR2_ORACLE_HOME

unzip appsutil (on linux1 and linux2)

4> Copy the jre directory from SOURCE_ORACLE_HOME>/appsutil to
11gR2_ORACLE_HOME>/appsutil.
On linux1

On linux2

5. Create a directory under <11gR2_ORACLE_HOME>/network/admin. Use
the new instance name while creating the context directory. For example, if your database name
is VISRAC, and you want to use "vis" as the instance prefix, create the
directory as vis1_.

7. Set the following environment variables:

ORACLE_HOME =<11gR2_ORACLE_HOME>
LD_LIBRARY_PATH = <11gR2_ORACLE_HOME>/lib,
<11gR2_ORACLE_HOME>/ctx/lib
ORACLE_SID =
PATH= $PATH:$ORACLE_HOME/bin;
TNS_ADMIN = $ORACLE_HOME/network/admin/

export ORACLE_HOME =
/d01/oracle/app/oracle/product/11.2.0/dbhome_1
export LD_LIBRARY_PATH = $ORACLE_HOME/lib:$ORACLE_HOME/ctx/lib
ORACLE_SID = RACDB1
export PATH= $PATH:$ORACLE_HOME/bin;
export TNS_ADMIN = $ORACLE_HOME/network/admin/racdb1_linux1

8> Copy the tnsnames.ora file from $ORACLE_HOME/network/admin to the $TNS_ADMIN
directory, and edit the aliases for SID=.

9. As the APPS user, run the following command on the primary node to de-register the
current configuration:

SQL>exec fnd_conc_clone.setup_clean;

PL/SQL procedure successfully completed.

10. From the 11gR2 ORACLE_HOME/appsutil/bin directory, create an instance-specific XML
context file by executing the command:

cd $ORACLE_HOME/appsutil/bin

perl adbldxml.pl appsuser=apps appspass=apps

nCopy tnsnames.ora and listener.ora from Source ORACLE Home

cd /d01/oracle/app/oracle/product/11.2.0/dbhome_1/network/admin/RACDB_linux1

modify listener.ora as follows

Perform the same on linux2

Convert 11gR2 non-RAC database to RAC database using rconfig

Mon, 23 Jan 2012 01:11:24 -0600

Convert 11gR2 non-RAC database to RAC database using rconfig

I’ve installed the new 11gR2 clustered ORACLE_HOME at /d01/oracle/app/oracle/product/11.2.0/dbhome_1 on both the nodes linux1 and linux2
New Oracle 11gR2 RAC Home - /d01/oracle/app/oracle/product/11.2.0/dbhome_1
SourceDBHome - /d01/oracle/RACDB/db/tech_st/11.2.0
ORACLE_SID – RACDB

1. As the oracle user, navigate to the directory $ORACLE_HOME/assistants/rconfig/sampleXMLs,
and open the sample file ConvertToRAC.xml using a text editor such as vi. This XML sample file
contains comment lines that provide instructions on how to edit the file to suit your site's specific
needs.
nConnect to new home
n. ./oracle.env
n[oracle@linux1 ~]$ cat oracle.env
export ORACLE_HOME=/d01/oracle/app/oracle/product/11.2.0/dbhome_1
export LD_LIBRARY_PATH=$ORACLE_HOME/lib,$ORACLE_HOME/ctx/lib
export ORACLE_SID=RACDB
export PATH=$PATH:$ORACLE_HOME/bin
export
TNS_ADMIN=/d01/oracle/app/oracle/product/11.2.0/dbhome_1/network/admin/RACDB
1_linux1
cd /d01/oracle/app/oracle/product/11.2.0/dbhome_1/assistants/rconfig/sampleXMLs
cp ConvertToRAC_AdminManaged.xml ConvertToRAC_AdminManaged.xml_org

2. Copy the sample ConvertToRAC_AdminManaged.xml, and modify the parameters as required for
your system. Make a note of the name of your copy of the XML file.

3. To test the settings specified, it is advisable to execute rconfig using convert verify="ONLY"
before carrying out the actual conversion. This will perform a test run to validate parameters and
flag any incorrect settings or issues that need to be resolved before the final conversion takes
place.

Note: Specify 'SourceDBHome' variable in ConvertToRAC_AdminManaged.xml as Non- RAC
oracle home (e.g. $OLD_ORACLE_HOME path). If you wish to specify as
NEW_ORACLE_HOME then start the database from new oracle home using:

I have started from NEW_ORACLE_HOME

4. Move the spfile to the shared location, in this case the Single Instance Database was hosted on file
system, in this process we will move the datafiles from file system storage to ASM.

-- From New Home

-- copy the initRACDB.ora from Source DB Home

Create the spfile from pfile using the command:
sqlplus “/as sysdba”

So create spfile in the shared disk location

create spfile='+DATA/spfile/spfileracdb.ora' from pfile;

You can check if the file is created through “asmcmd”
cat grid.env
export ORACLE_HOME=/d01/oracle/app/11.2.0/grid
export PATH=$PATH:$ORACLE_HOME/bin

. ./grid.env

. ./oracle.env

5.Take a backup of existing $ORACLE_HOME/dbs/init.ora and create a new
$ORACLE_HOME/dbs/init.ora with following parameter:

spfile='/spfile.ora'
spfile=’ +DATA/spfile/spfileracdb.ora’

6. Start up the instance from the NEW ORACLE_HOME

7. Now lets test if “rconfig” is ready for conversion, navigate to $ORACLE_HOME/
assistants/rconfig/sampleXMLs and issue the following command

cd /d01/oracle/app/oracle/product/11.2.0/dbhome_1/assistants/rconfig/sampleXMLs

rconfig ConvertToRAC_AdminManaged.xml

The above command validates( as we’ve set convert=”ONLY”) if rconfig is ready for conversion.
If the output throws any error, diagnose and troubleshoot to fix the issue. Refer to the following
output for successful validation:

Issues faced –

Rconfig

a> Default Listener is not configured in Grid Infrastructure Home.

Solution - on the grid infrastruture - run netca - create a default listener

b> /d02/oracle/RACDB/db/tech_st/11.2.0/dbs/arch LOG ARCHIVE DEST
Solution - mkdir /d02/oracle/RACDB/db/tech_st/11.2.0/dbs/arch

8. Now are we are ready for conversion, edit the xml file
“ConvertToRAC_AdminManaged.xml” and change:

Step By Step: Install and setup Oracle 11g R2 RAC on Oracle Enterprise Linux 5.5 (32

Sun, 22 Jan 2012 23:59:55 -0600

This Document shows the step by step of installing and setting up 3-Node 11gR2 RAC cluster. This setup uses IP Based iSCSI Openfiler SAN as a shared storage subsystem. This setup does not have IPMI and Grid Naming Service (GNS) configured. The SCAN is resolved through DNS.

Hardware Used in setting up 3-node 11g R2 RAC using iSCSI SAN (Openfiler):

Total Machines: 5 (3 for RAC nodes + 1 for NAS + 1 for DNS)
Network Switches: 3 (for Public, Private and Shared Storage)
Extra Network Adaptors: 7 (6 for RAC nodes (2 for each node) and one for Storage Server)
Network cables: 11 (9 for RAC nodes (3 for each node), one for Shared Storage and 1 for DNS server)
External USB HD: 1 (1 TB)

Machines Specifications:
DELL OPTIPLEX GX620
CPU: Intel 3800MHz
RAM: 4084MB
HD: 250GB
DVD, 10/100 NIC, 8 MB VRAM

Network Adaptor Specifications:
Linksys EG1032 Instant Gigabit Network Adapter
Network Switch Specifications:
D-Link 24-Port Rackmountable Gigabit Switch
Network Cables Specifications:
25-Foot Cat6 Snagless Patch Cable – (Blue, Black and Grey)

Software Used for the 3-node RAC Setup using NAS (Openfiler):

NAS Storage Solution: Openfiler 2.3 (2.6.26.8-1.0.11.smp.pae.gcc3.4.x86.i686)
Operating System: Oracle Enterprise Linux 5.5 (2.6.18-194.el5PAE)
Clusterware: Oracle 11g R2 Grid Infrastructure (11.2.0.1)
Oracle RAC: Oracle RDBMS 11g R2 (11.2.0.1)

3-Node RAC Setup

Operating System: Oracle Enterprise Linux 5.5 (2.6.18-194.el5PAE):
Server: All the RAC Nodes + DNS server

Grid Infrastructure Software (Clusterware + ASM 11.2.0.1):
Server: All the RAC Nodes
ORACLE_BASE: /u01/app/grid
ORACLE_HOME: /u01/app/grid11201
Owner: grid (Primary Group: oinstall, Secondary Group: asmadmin, asmdba)
Permissions: 755
OCR/Voting Disk Storage Type: ASM
Oracle Inventory Location: /u01/app/oraInventory

Oracle Database Software (RAC 11.2.0.1):

Server: All the RAC Nodes
ORACLE_BASE: /u01/app/oracle
ORACLE_HOME: /u01/app/oracle/db11201
Owner: oracle (Primary Group: oinstall, Secondary Group: asmdba, dba)
Permissions: 755
Oracle Inventory Location: /u01/app/oraInventory

Database Name: labdb
Listener: LAB_LISTENER (TCP:1525)

Openfiler 2.3:
Server: single dedicated server acting as NAS.
OS: Openfiler 2.3 (2.6.26.8-1.0.11.smp.pae.gcc3.4.x86.i686).

3-Node RAC Architecture:

Machine
Public Name
Private Name
VIP Name
RAC Node1
node1.hingu.net
node1-prv
node1-vip.hingu.net
RAC Node2
node2.hingu.net
node2-prv
node2-vip.hingu.net
RAC Node3
node3.hingu.net
node3-prv
node3-vip.hingu.net
Storage
nas-server
N/A
N/A
DNS server
lab-dns
N/A
N/A

SCAN IPs:
192.168.2.151
192.168.2.152
192.168.2.153

SCAN: lab-scan.hingu.net
Cluster Name: lab
Public Network: 192.168.2.0/eth2
Private network (cluster Interconnect): 192.168.0.0/eth0
Private network (Storage Network): 192.168.1.0/eth1

Machine
Public IP
Private IP
VIP
Storage IP
RAC Node1
192.168.2.1
192.168.0.1
192.168.2.51
192.168.1.1
RAC Node2
192.168.2.2
192.168.0.2
192.168.2.52
192.168.1.2
RAC Node3
192.168.2.3
192.168.0.3
192.168.2.53
192.168.1.3
Storage
N/A
N/A
N/A
192.168.1.101
DNS server
192.168.2.200
N/A
N/A
N/A

The Installation is divided into 3 main categories:

Pre-installation task:

Server Hardware Requirements:

Each node in the Cluster must meet the below requirement.
At least 1024 x 768 display resolution, so that OUI displays correctly.
1 GB of space in the /tmp directory
5.5 GB space for Oracle Grid Infrastructure Home.
At least 2.5 GB of RAM and equivalent swap space (for 32 bit installation as in my case).
· All the RAC nodes must share the same Instruction Set Architecture. For a testing RAC setup, it is possible to install RAC on servers with mixtures of Intel 32 and AMD 32 with differences in sizes of Memory/CPU speed.

Installation of OEL5.5 (On All the RAC Nodes and DNS Host):
The below selection was made during the installation of OEL5 on the Node 1 (node1.hingu.net). The same process was followed to install RHEL 5 on all the remaining RAC nodes and DNS Host (lab-dns).
The Hostname/IP information was appropriately chosen for respective nodes from the Architecture diagram.

Insert Installation Media #1:
Testing the CD Media: Skip
Language: English
Key Board: U.S. English
Partition Option: “Remove all Partitions on selected drives and create default layout”
Boot Loader: “ The GRUB boot loader will be installed on /dev/sda”

Network Devices:

Active on Boot
Devices
IPV4.Netmask
IPV6/Prefix

Yes
eth0
192.168.0.1/255.255.255.0
Auto
Yes
eth1
192.168.1.1/255.255.255.0
Auto
Yes
eth2
192.168.2.1/255.255.255.0
Auto

Hostname a Manually à node1.hingu.net
Ignore both the Warning Messages at this point
Region: America/New York
System Clock Uses UTC (checked)
Root Password à Enter the root password
Additional Tasks On top of Default Installation: “Checked all Software Development” and “Web Server”
Customize Now (Selected)
(Below is the extra selection on top of the default selected packages)
Applications à Authoring and Publishing (checked)
Development à Development Libraries à
libstdc++44-devel
Development a Java Development
Development à Legacy Software Development
Servers à Checked All the servers
Servers à Legacy Network Server à
bootparamd, rsh-server, rusers, rusers-server, telnet-server
Servers à Network Servers à
dhcp, dhcpv6, dnsmasq, ypserv
Servers à Servers Configuration Tools à
Checked All
Base System àAdministration Tools à
Checked All
Base System à Base à
device-mapper-multipath, iscsi-initiator-utils,
Base System à Legacy Software Support à
openmotif22
Base System à System Tools à
OpenIPMI-gui, lsscsi, oracle*, sysstat, tsclient

Post Installation Steps:
(1) Yes to License Agreement.
(2) Disable the firewall
(3) Disable SELinux
(4) Disable kdump
(5) Set the clock
(6) Finish

Installation of openfiler 2.3

Version: Openfiler V 2.3 (downloaded from Minimum Required RPMs for OEL 5.5 (All the 3 RAC Nodes):

binutils-2.17.50.0.6
compat-libstdc++-33-3.2.3
elfutils-libelf-0.125
elfutils-libelf-devel-0.125
elfutils-libelf-devel-static-0.125
gcc-4.1.2
gcc-c++-4.1.2
glibc-2.5-24
glibc-common-2.5
glibc-devel-2.5
glibc-headers-2.5
kernel-headers-2.6.18
ksh-20060214
libaio-0.3.106
libaio-devel-0.3.106
libgcc-4.1.2
libgomp-4.1.2
libstdc++-4.1.2
libstdc++-devel-4.1.2
make-3.81
numactl-devel-0.9.8.i386
sysstat-7.0.2
unixODBC-2.2.11
unixODBC-devel-2.2.11

Below command verifies whether the specified rpms are installed or not. Any missing rpms can be installed from the OEL Media Pack

rpm -q binutils compat-libstdc++-33 elfutils-libelf elfutils-libelf-devel elfutils-libelf-devel-static \
gcc gcc-c++ glibc glibc-common glibc-devel glibc-headers kernel-headers ksh libaio libaio-devel \
libgcc libgomp libstdc++ libstdc++-devel make numactl-devel sysstat unixODBC unixODBC-devel

I had to install below extra RPMs.

numactl-develà Located on the 3rd CD of OEL 5.5 Media pack.
oracleasmlibàAvailable Network Configuration for RAC Nodes/NAS Server/DNS Host:

Public, VIPs and SCAN VIPs are resolved by DNS. The private IPs for Cluster Interconnects are resolved through /etc/hosts. The hostname along with public/private and NAS network is configured at the time of OEL network installations. The final Network Configurations files are listed here.

(a) hostname:

For Node node1:
[root@node1 ~]# hostname node1.hingu.net

node1.hingu.net: /etc/sysconfig/network
NETWORKING=yes
NETWORKING_IPV6=yes
HOSTNAME=node1.hingu.net

For Node node2:
[root@node2 ~]# hostname node2.hingu.net

node2.hingu.net: /etc/sysconfig/network
NETWORKING=yes
NETWORKING_IPV6=yes
HOSTNAME=node2.hingu.net

For Node node3:
[root@node3 ~]# hostname node3.hingu.net

node3.hingu.net: /etc/sysconfig/network
NETWORKING=yes
NETWORKING_IPV6=yes
HOSTNAME=node3.hingu.net

For Node nas-server:
[root@nas-server ~]# hostname nas-server

nas-server: /etc/sysconfig/network
NETWORKING=yes
HOSTNAME=nas-server

For Node lab-dns:
[root@lab-dns ~]# hostname lab-dns

lab-dns.hingu.net: /etc/sysconfig/network
NETWORKING=yes
NETWORKING_IPV6=yes
HOSTNAME=nas-server

(b) Private Network for Cluster Interconnect:

node1.hingu.net: /etc/sysconfig/network-scripts/ifcfg-eth0
# Linksys Gigabit Network Adapter
DEVICE=eth0
BOOTPROTO=static
BROADCAST=192.168.0.255
HWADDR=00:22:6B:BF:4E:60
IPADDR=192.168.0.1
IPV6INIT=yes
IPV6_AUTOCONF=yes
NETMASK=255.255.255.0
NETWORK=192.168.0.0
ONBOOT=yes

node2.hingu.net: /etc/sysconfig/network-scripts/ifcfg-eth0
# Linksys Gigabit Network Adapter
DEVICE=eth0
BOOTPROTO=static
BROADCAST=192.168.0.255
HWADDR=00:22:6B:BF:4E:4B
IPADDR=192.168.0.2
IPV6INIT=yes
IPV6_AUTOCONF=yes
NETMASK=255.255.255.0
NETWORK=192.168.0.0
ONBOOT=yes

node3.hingu.net: /etc/sysconfig/network-scripts/ifcfg-eth0
# Linksys Gigabit Network Adapter
DEVICE=eth0
BOOTPROTO=static
BROADCAST=192.168.0.255
HWADDR=00:22:6B:BF:4E:49
IPADDR=192.168.0.3
IPV6INIT=yes
IPV6_AUTOCONF=yes
NETMASK=255.255.255.0
NETWORK=192.168.0.0
ONBOOT=yes

© Public Network:

node1.hingu.net: /etc/sysconfig/network-scripts/ifcfg-eth2
# Broadcom Corporation NetXtreme BCM5751 Gigabit Ethernet PCI Express
DEVICE=eth2
BOOTPROTO=static
BROADCAST=192.168.2.255
HWADDR=00:18:8B:04:6A:62
IPADDR=192.168.2.1
IPV6INIT=yes
IPV6_AUTOCONF=yes
NETMASK=255.255.255.0
NETWORK=192.168.2.0
ONBOOT=yes

node2.hingu.net: /etc/sysconfig/network-scripts/ifcfg-eth2
# Broadcom Corporation NetXtreme BCM5751 Gigabit Ethernet PCI Express
DEVICE=eth2
BOOTPROTO=static
BROADCAST=192.168.2.255
HWADDR=00:18:8B:24:F8:58
IPADDR=192.168.2.2
IPV6INIT=yes
IPV6_AUTOCONF=yes
NETMASK=255.255.255.0
NETWORK=192.168.2.0
ONBOOT=yes

node3.hingu.net: /etc/sysconfig/network-scripts/ifcfg-eth2
# Broadcom Corporation NetXtreme BCM5751 Gigabit Ethernet PCI Express
DEVICE=eth2
BOOTPROTO=static
BROADCAST=192.168.2.255
HWADDR=00:19:B9:0C:E6:EF
IPADDR=192.168.2.3
IPV6INIT=yes
IPV6_AUTOCONF=yes
NETMASK=255.255.255.0
NETWORK=192.168.2.0
ONBOOT=yes

lab-dns.hingu.net: /etc/sysconfig/network-scripts/ifcfg-eth0
# Broadcom Corporation NetXtreme BCM5751 Gigabit Ethernet PCI Express
DEVICE=eth0
BOOTPROTO=static
BROADCAST=192.168.2.255
HWADDR=00:13:72:A1:E9:1B
IPADDR=192.168.2.200
NETMASK=255.255.255.0
NETWORK=192.168.2.0
ONBOOT=yes

(d) Private Network for Shared Storage:

node1.hingu.net: /etc/sysconfig/network-scripts/ifcfg-eth1
# Linksys Gigabit Network Adapter
DEVICE=eth1
BOOTPROTO=static
BROADCAST=192.168.1.255
HWADDR=00:22:6B:BF:4E:60
IPADDR=192.168.1.1
IPV6INIT=yes
IPV6_AUTOCONF=yes
NETMASK=255.255.255.0
NETWORK=192.168.1.0
ONBOOT=yes

node2.hingu.net: /etc/sysconfig/network-scripts/ifcfg-eth1
# Linksys Gigabit Network Adapter
DEVICE=eth1
BOOTPROTO=static
BROADCAST=192.168.1.255
HWADDR=00:22:6B:BF:45:13
IPADDR=192.168.1.2
IPV6INIT=yes
IPV6_AUTOCONF=yes
NETMASK=255.255.255.0
NETWORK=192.168.1.0
ONBOOT=yes

node3.hingu.net: /etc/sysconfig/network-scripts/ifcfg-eth1
# Linksys Gigabit Network Adapter
DEVICE=eth1
BOOTPROTO=static
BROADCAST=192.168.1.255
HWADDR=00:22:6B:BF:4E:48
IPADDR=192.168.1.3
IPV6INIT=yes
IPV6_AUTOCONF=yes
NETMASK=255.255.255.0
NETWORK=192.168.1.0
ONBOOT=yes

nas-server.hingu.net: /etc/sysconfig/network-scripts/ifcfg-eth1
DEVICE=eth1
BOOTPROTO=static
BROADCAST=192.168.1.255
HWADDR=00:22:6B:BF:43D6
IPADDR=192.168.1.101
NETMASK=255.255.255.0
NETWORK=192.168.1.0
ONBOOT=yes
TYPE=Ethernet

(e) /etc/hosts files:

node1.hingu.net: /etc/hosts
# # Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1 node1.hingu.net node1 localhost.localdomain localhost
::1 localhost6.localdomain6 localhost6

##=======================================
# Private Network for Cluster Interconnect
##=======================================

192.168.0.1 node1-prv
192.168.0.2 node2-prv
192.168.0.3 node3-prv

##=======================================
##=======================================

node2.hingu.net: /etc/hosts
# # Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1 node2.hingu.net node2 localhost.localdomain localhost
::1 localhost6.localdomain6 localhost6

##=======================================
# Private Network for Cluster Interconnect
##=======================================

192.168.0.1 node1-prv
192.168.0.2 node2-prv
192.168.0.3 node3-prv

##=======================================
##=======================================

node3.hingu.net: /etc/hosts
# # Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1 node3.hingu.net node3 localhost.localdomain localhost
::1 localhost6.localdomain6 localhost6

##=======================================
# Private Network for Cluster Interconnect
##=======================================

192.168.0.1 node1-prv
192.168.0.2 node2-prv
192.168.0.3 node3-prv

##=======================================
##=======================================

lab-dns.hingu.net: /etc/hosts
## Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1 lab-dns.hingu.net lab-dns localhost.localdomain localhost
::1 localhost6.localdomain6 localhost6

Configure DNS server for SCAN VIPs, Node VIPs and Node IPs:

DNS Server: lab-dns.hingu.net

RPMs required in setting up DNS server:

ypbind-1.19-12.el5
bind-utils-9.3.6-4.P1.el5_4.2
bind-9.3.6-4.P1.el5_4.2
system-config-bind-4.0.3-4.0.1.el5
bind-libs-9.3.6-4.P1.el5_4.2
bind-chroot-9.3.6-4.P1.el5_4.2

Configurations files modified/created to set up DNS:

lab-dbs.hingu.net

/var/named/chroot/etc/named.conf (modified)
/var/named/chroot/var/named/hingu.net.zone (created)
/var/named/chroot/var/named/2.168.192.in-addr.arpa.zone (created)
/var/named/chroot/var/named/1.168.192.in-addr.arpa.zone (created)

On node1, node2 and node3

/etc/resolv.conf (modified)

/var/named/chroot/etc/named.conf

// Enterprise Linux BIND Configuration Tool
//
// Default initial "Caching Only" name server configuration
//

options {
directory "/var/named";
dump-file "/var/named/data/cache_dump.db";
statistics-file "/var/named/data/named_stats.txt";
};

// Zone for this RAC configuration is hingu.net

zone "hingu.net" in {
type master;
file "hingu.net.zone";
allow-update { none; };
};

// For reverse lookups

zone "2.168.192.in-addr.arpa" in {
type master;
file "2.168.192.in-addr.arpa.zone";
allow-update { none; };
};

zone "1.168.192.in-addr.arpa" in {
type master;
file "1.168.192.in-addr.arpa.zone";
allow-update { none; };
};

include "/etc/rndc.key";

/var/named/chroot/var/named/hingu.net.zone

$TTL 1d
hingu.net. IN SOA lab-dns.hingu.net. root.hingu.net. (
100 ; se = serial number
8h ; ref = refresh
5m ; ret = update retry
3w ; ex = expiry
3h ; min = minimum
)

IN NS lab-dns.hingu.net.

; DNS server

lab-dns IN A 192.168.2.200

; RAC Nodes Public name

node1 IN A 192.168.2.1
node2 IN A 192.168.2.2
node3 IN A 192.168.2.3

; RAC Nodes Public VIPs

node1-vip IN A 192.168.2.51
node2-vip IN A 192.168.2.52
node3-vip IN A 192.168.2.53

; 3 SCAN VIPs

lab-scan IN A 192.168.2.151
lab-scan IN A 192.168.2.152
lab-scan IN A 192.168.2.153

; Storage Network

nas-server IN A 192.168.1.101
node1-nas IN A 192.168.1.1
node2-nas IN A 192.168.1.2
node3-nas IN A 192.168.1.3

/var/named/chroot/var/named/2.168.192.in-addr.arpa.zone

$TTL 1d
@ IN SOA lab-dns.hingu.net. root.hingu.net. (
100 ; se = serial number
8h ; ref = refresh
5m ; ret = update retry
3w ; ex = expiry
3h ; min = minimum
)

IN NS lab-dns.hingu.net.

; DNS machine name in reverse
200 IN PTRlab-dns.hingu.net.

; RAC Nodes Public Name in Reverse

1 IN PTRnode1.hingu.net.
2 IN PTRnode2.hingu.net.
3 IN PTRnode3.hingu.net.

; RAC Nodes Public VIPs in Reverse

51 IN PTR node1-vip.hingu.net.
52 IN PTR node2-vip.hingu.net.
53 IN PTR node3-vip.hingu.net.

; RAC Nodes SCAN VIPs in Reverse

151 IN PTR lab-scan.hingu.net.
152 IN PTR lab-scan.hingu.net.
153 IN PTR lab-scan.hingu.net.

/var/named/chroot/var/named/1.168.192.in-addr.arpa.zone

$TTL 1d
@ IN SOA lab-dns.hingu.net. root.hingu.net. (
100 ; se = serial number
8h ; ref = refresh
5m ; ret = update retry
3w ; ex = expiry
3h ; min = minimum
)

IN NS lab-dns.hingu.net.

; Storage Network Reverse Lookup

101 IN PTR nas-server.hingu.net.
1 IN PTR node1-nas.hingu.net.
2 IN PTR node2-nas.hingu.net.
3 IN PTR node3-nas.hingu.net.

/etc/resolv.conf (on RAC nodes):

search hingu.net
nameserver 192.168.2.200

Start the DNS Service (named):

service named start
chkconfig --level 35 named on

Verify the DNS Setup:

NOTE: nslookup for lab-scan should return names in random order every time.

Enable Name Service Cache Daemon nscd: (On all the RAC Nodes)

chkconfig --level 35 nscd on
service ncsd start

Creating Oracle Users/Groups/Permissions and Installation Paths: (On all the RAC Nodes):

userdel oracle
groupdel oinstall
groupdel dba
groupadd -g 1000 oinstall
groupadd -g 1020 asmadmin
groupadd -g 1021 asmdba
groupadd -g 1031 dba
useradd -u 1100 -g oinstall -G asmadmin,asmdba grid
useradd -u 1101 -g oinstall -G dba,asmdba oracle
mkdir -p /u01/app/grid11201
mkdir -p /u01/app/grid
chown -R grid:oinstall /u01
mkdir -p /u01/app/oracle
chown oracle:oinstall /u01/app/oracle
chmod -R 775 /u01
passwd grid
passwd oracle

Install cvuqdisk Package: (On all the RAC Nodes):

This package is located in the rpm directory on Grid Infrastructure Media and needs to be installed after the group oinstall is created. In my case, as this was a fresh install of 11g R2 on new hardware, old versions of cvuqdisk was not present. If it is, then the older version needs to be removed first.

export CVUQDISK_GRP=oinstall
echo $CVUQDISK
rpm –ivh cvuqdisk-1.0.7-1.rpm

[root@node1 rpm]# pwd
/home/grid/11gR2_for_OEL5/grid11201/grid/rpm
[root@node1 rpm]# export CVUQDISK_GRP=oinstall
[root@node1 rpm]# echo $CVUQDISK_GRP
oinstall
[root@node1 rpm]# rpm -ivh cvuqdisk-1.0.7-1.rpm
Preparing... ########################################### [100%]
1:cvuqdisk ########################################### [100%]
[root@node1 rpm]# rpm -qa | grep cvuqdisk
cvuqdisk-1.0.7-1
[root@node1 rpm]#

Network Time Protocol Setting (On all the RAC Nodes):

In this installation, Oracle Time Synchronization Service is used over the Linux system provided ntpd. So, it needs to deactivated and deinstalled to avoid any possibility of it being conflicted with the Oracle’s Cluster Time Sync Service (ctss).

# /sbin/service ntpd stop
# chkconfig ntpd off
# mv /etc/ntp.conf /etc/ntp.conf.org

Also remove the following file:

/var/run/ntpd.pid

Configure Grid Infrastructure as well as Oracle RAC Owner’s User Environment (grid and oracle):

(a) Set the umask to 022 by putting below line into these users’ (grid and oracle) .bash_profile files:

umask 022

Then, executed the .bash_profile and verified that the correct value of umask is displayed.

[grid@node1 ~]$ . .bash_profile
[grid@node1 ~]$ umask

(b) Setting up X11 forwarding:

Created the file ~/.ssh/config to disable the X11Forwadding by placing below line in it.

Host *
ForwardX11 no

© Suppressed the Terminal output on STDOUT and STDERR to prevent Installation errors:
Modified the file ~/.bashrc (or .cshrc for C shell) with below entry.

Bourne, Bash, or Korn shell:

if [ -t 0 ]; then
stty intr ^C
fi

C shell:

test -t 0
if ($status == 0) then
stty intr ^C
endif

(d) Increased the Shell Limits:
Recommended:

Resource
Soft Limit
Hard Limit
Processes
2047
16384
Open File Descriptors
1024
65536
Stack
10240
10240 - 32768

Set:

Resource
Soft Limit
Hard Limit
Processes
131072
131072
Open File Descriptors
131072
131072
Stack
32768
32768

Added the following lines to the /etc/security/limits.conf file:

oracle soft nofile 131072
oracle hard nofile 131072
oracle soft nproc 131072
oracle hard nproc 131072
oracle soft core unlimited
oracle hard core unlimited
oracle soft memlock 3500000
oracle hard memlock 3500000
# Recommended stack hard limit 32MB for oracle installations
# oracle hard stack 32768

grid soft nofile 131072
grid hard nofile 131072
grid soft nproc 131072
grid hard nproc 131072
grid soft core unlimited
grid hard core unlimited
grid soft memlock 3500000
grid hard memlock 3500000
# Recommended stack hard limit 32MB for grid installations
# grid hard stack 32768

Added the following line in the /etc/pam.d/login file, if it does not already exist:

session required /lib/security/pam_limits.so

For the Bourne, Bash, or Korn shell, add the following lines to the /etc/profile:

if [ $USER = "oracle" ]; then
if [ $SHELL = "/bin/ksh" ]; then
ulimit -p 131072
ulimit -n 131072
else
ulimit -u 131072 -n 131072
fi
fi

if [ $USER = "grid" ]; then
if [ $SHELL = "/bin/ksh" ]; then
ulimit -p 131072
ulimit -n 131072
else
ulimit -u 131072 -n 131072
fi
fi

For the C shell (csh or tcsh), add the following lines to the /etc/csh.login.

if ( $USER == "oracle" ) then
limit maxproc 131072
limit descriptors 131072
endif

if ( $USER == "grid" ) then
limit maxproc 131072
limit descriptors 131072
endif

(e) Set the below Kernel Parameters with recommended range in /etc/sysctl.conf
This was already set with the installation of oracle-validated package.

/etc/sysctl.conf

# Kernel sysctl configuration file for Oracle Enterprise Linux
#
# For binary values, 0 is disabled, 1 is enabled. See sysctl(8) and
# sysctl.conf(5) for more details.

# Controls IP packet forwarding
net.ipv4.ip_forward = 0

# Controls source route verification
net.ipv4.conf.default.rp_filter = 1

# Do not accept source routing
net.ipv4.conf.default.accept_source_route = 0

# Controls the System Request debugging functionality of the kernel
kernel.sysrq = 1

# Controls whether core dumps will append the PID to the core filename
# Useful for debugging multi-threaded applications
kernel.core_uses_pid = 1

# Controls the use of TCP syncookies
net.ipv4.tcp_syncookies = 1

# Controls the maximum size of a message, in bytes
kernel.msgmnb = 65536

# Controls the default maxmimum size of a mesage queue
kernel.msgmax = 8192

# Controls the maximum shared segment size, in bytes
kernel.shmmax = 4294967295

# Controls the maximum number of shared memory segments, in pages
kernel.shmall = 1073741824
# For 11g, recommended value for file-max is 6815744
fs.file-max = 6815744
# For 10g, uncomment 'fs.file-max 327679', comment other entries for this parameter and re-run sysctl -p
# fs.file-max:327679
kernel.msgmni = 2878
kernel.sem = 250 32000 100 142
kernel.shmmni = 4096
net.core.rmem_default = 262144
# For 11g, recommended value for net.core.rmem_max is 4194304
net.core.rmem_max = 4194304
# For 10g, uncomment 'net.core.rmem_max 2097152', comment other entries for this parameter and re-run sysctl -p
# net.core.rmem_max=2097152
net.core.wmem_default = 262144
# For 11g, recommended value for wmem_max is 1048576
net.core.wmem_max = 1048576
# For 10g, uncomment 'net.core.wmem_max 262144', comment other entries for this parameter and re-run sysctl -p
# net.core.wmem_max:262144
fs.aio-max-nr = 3145728
# For 11g, recommended value for ip_local_port_range is 9000 65500
net.ipv4.ip_local_port_range = 9000 65500
# For 10g, uncomment 'net.ipv4.ip_local_port_range 1024 65000', comment other entries for this parameter and re-run sysctl -p
# net.ipv4.ip_local_port_range:1024 65000
# Added min_free_kbytes 50MB to avoid OOM killer on EL4/EL5
vm.min_free_kbytes = 51200

(f) Repeated this process for all the remaining nodes in the cluster.

SSH user Equivalency configuration (grid and oracle):

On All the Cluster Nodes:

su - oracle
mkdir ~/.ssh
chmod 700 ~/.ssh

Generate the RSA and DSA keys:

/usr/bin/ssh-keygen -t rsa
/usr/bin/ssh-keygen -t dsa

On node1:

touch ~/.ssh/authorized_keys
cd ~/.ssh

(a) Add these Keys to the Authorized_keys file.

cat id_rsa.pub >> authorized_keys
cat id_dsa.pub >> authorized_keys

(b) Send this file to node2.

scp authorized_keys node2:.ssh/

On node2:

(a) Add these Keys to the Authorized_keys file.

cd ~/.ssh
cat id_rsa.pub >> authorized_keys
cat id_dsa.pub >> authorized_keys

(b) Send this file to node3.

scp authorized_keys node3:.ssh/
On node3:

(a) Add these Keys to the Authorized_keys file.

cd ~/.ssh
cat id_rsa.pub >> authorized_keys
cat id_dsa.pub >> authorized_keys

(b) Send this file to node1 and node2.

scp authorized_keys node1:.ssh/
scp authorized_keys node2:.ssh/

On All the Nodes:

chmod 600 ~/.ssh/authorized_keys

ssh node1 date
ssh node2 date
ssh node3 date
ssh node1.hingu.net date
ssh node2.hingu.net date
ssh node3.hingu.net date
ssh node1-prv date
ssh node2-prv date
ssh node3-prv date

Entered 'yes' and continued when prompted

Repeat the Above process for user grid:

Configure the Shared Storage for 11g R2 Grid Infrastructure and RAC Database:

Volume Group: grid
Physical Volume: /dev/sda5 (1st extended partition on the last physical partition of local disk /dev/sda nas-server)
Logical Volumes: asmdisk01, asmdisk02, asmdisk03

a) Connect to the nas-server using: Configure the iSCSI disk Devises for Oracle ASM with ASMLib:

(a) Partition the Disk Devises (only from one node): Format these disks to contain a single primary partition to represent it at the time of creating ASM disk using oracleasm.

[root@node1 ~]# fdisk /dev/sdb

The number of cylinders for this disk is set to 24992.
There is nothing wrong with that, but this is larger than 1024,
and could in certain setups cause problems with:
1) software that runs at boot time (e.g., old versions of LILO)
2) booting and partitioning software from other OSs
(e.g., DOS FDISK, OS/2 FDISK)

Command (m for help): n
Command action
e extended
p primary partition (1-4)
p
Partition number (1-4): 1
First cylinder (1-24992, default 1):
Using default value 1
Last cylinder or +size or +sizeM or +sizeK (1-24992, default 24992):
Using default value 24992

Command (m for help): p

Disk /dev/sdb: 26.2 GB, 26206011392 bytes
64 heads, 32 sectors/track, 24992 cylinders
Units = cylinders of 2048 * 512 = 1048576 bytes

Device Boot Start End Blocks Id System
/dev/sdb1 1 24992 25591792 83 Linux

Command (m for help): w
The partition table has been altered!

Calling ioctl() to re-read partition table.
Syncing disks.
[root@node1 ~]# fdisk /dev/sdc

The number of cylinders for this disk is set to 25024.
There is nothing wrong with that, but this is larger than 1024,
and could in certain setups cause problems with:
1) software that runs at boot time (e.g., old versions of LILO)
2) booting and partitioning software from other OSs
(e.g., DOS FDISK, OS/2 FDISK)

Command (m for help): n
Command action
e extended
p primary partition (1-4)
p
Partition number (1-4): 1
First cylinder (1-25024, default 1):
Using default value 1
Last cylinder or +size or +sizeM or +sizeK (1-25024, default 25024):
Using default value 25024

Command (m for help): p

Disk /dev/sdc: 26.2 GB, 26239565824 bytes
64 heads, 32 sectors/track, 25024 cylinders
Units = cylinders of 2048 * 512 = 1048576 bytes

Device Boot Start End Blocks Id System
/dev/sdc1 1 25024 25624560 83 Linux

Command (m for help): w
The partition table has been altered!

Calling ioctl() to re-read partition table.
Syncing disks.
[root@node1 ~]# fdisk /dev/sdd

The number of cylinders for this disk is set to 25248.
There is nothing wrong with that, but this is larger than 1024,
and could in certain setups cause problems with:
1) software that runs at boot time (e.g., old versions of LILO)
2) booting and partitioning software from other OSs
(e.g., DOS FDISK, OS/2 FDISK)

Command (m for help): n
Command action
e extended
p primary partition (1-4)
p
Partition number (1-4): 1
First cylinder (1-25248, default 1):
Using default value 1
Last cylinder or +size or +sizeM or +sizeK (1-25248, default 25248):
Using default value 25248

Command (m for help): p

Disk /dev/sdd: 26.4 GB, 26474446848 bytes
64 heads, 32 sectors/track, 25248 cylinders
Units = cylinders of 2048 * 512 = 1048576 bytes

Device Boot Start End Blocks Id System
/dev/sdd1 1 25248 25853936 83 Linux

Command (m for help): w
The partition table has been altered!

Calling ioctl() to re-read partition table.
Syncing disks.
[root@node1 ~]#

(b) Refreshed the kernel on the remaining nodes with the latest partition table using partprobe.

[root@node1 ~]# partprobe

© Verified that the below RPMs are installed before configuring the ASM driver.

oracleasm-2.6.18-194.el5-2.0.5-1.el5
oracleasm-support-2.1.3-1.el5
oracleasm-2.6.18-194.el5xen-2.0.5-1.el5
oracleasm-2.6.18-194.el5PAE-2.0.5-1.el5
oracleasm-2.6.18-194.el5debug-2.0.5-1.el5
oracleasmlib-2.0.4-1.el5

(d) Configured the ASMLib (All the RAC nodes):

[root@node1 ~]# oracleasm configure –i

(e) Loaded the ASMLib Module (All the RAC nodes):

[root@node1 ~]# oracleasm init

(f) Created the ASM disks using oracleasm: (ONLY from one of the RAC nodes)

oracleasm createdisk DSK01 /dev/sdb1
oracleasm createdisk DSK02 /dev/sdc1
oracleasm createdisk DSK03 /dev/sdd1
oracleasm scandisks
oracleasm listdisks

(g) On the Remaining RAC nodes, simply scanned the ASM disks to instantiate these newly created disks

oracleasm scandisks
oracleasm listdisks

(h) Verified that these ASM disk can be discovered by ASM Libraries (oracleasmlib) on all the RAC Nodes during Installation of Grid Infrastructure.

/usr/sbin/oracleasm-discover 'ORCL:*'

[grid@node1 ~]$ /usr/sbin/oracleasm-discover 'ORCL:*'
Using ASMLib from /opt/oracle/extapi/32/asm/orcl/1/libasm.so
[ASM Library - Generic Linux, version 2.0.4 (KABI_V2)]
Discovered disk: ORCL:DSK01 [51183584 blocks (26205995008 bytes), maxio 512]
Discovered disk: ORCL:DSK02 [51249120 blocks (26239549440 bytes), maxio 512]
Discovered disk: ORCL:DSK03 [51707872 blocks (26474430464 bytes), maxio 512]
[grid@node1 ~]$

With this, the pre-Installation steps are completed successfully and are ready to install 11g R2 Grid Infrastructure software

Get ready with the RAC Architecture Diagram and RAC Setup Information about Cluster Name, SCAN Name, SCAN VIPs, Node Names, VIPs, and Inventory Location.

3-Node RAC Architecture:

Machine
Public Name
Private Name
VIP Name
RAC Node1
node1.hingu.net
node1-prv
node1-vip.hingu.net
RAC Node2
node2.hingu.net
node2-prv
node2-vip.hingu.net
RAC Node3
node3.hingu.net
node3-prv
node3-vip.hingu.net

SCAN: lab-scan.hingu.net
Cluster Name: lab
Public Network: 192.168.2.0/eth2
Private network: 192.168.0.0/eth0

Grid Infrastructure Software (Clusterware + ASM 11.2.0.1):
Server: All the RAC Nodes
ORACLE_BASE: /u01/app/grid
ORACLE_HOME: /u01/app/grid11201
Owner: grid (Primary Group: oinstall, Secondary Group: asmadmin, asmdba)
Permissions: 755
OCR/Voting Disk Storage Type: ASM
Oracle Inventory Location: /u01/app/oraInventory

Start the runInstaller from Grid Infrastructure Software Location:

[grid@node1 grid]$ /home/grid/11gR2_for_OEL5/grid11201/grid/runInstaller

Grid Infrastructure installation process:

Installation Option:
Install and Configure Grid Infrastructure for a Cluster
Installation Type:
Advanced Installation
Product Language:
English
Grid Plug and Play:
Cluster Name: lab
SCAN Name: lab-scan.hingu.net
SCAN Port: 1521
Configure GNS: Unchecked
Cluster Node Information:
Entered the Hostname and VIP names of the Cluster Nodes.
Checked the SSH connectivity
Network Interface Usage:
OUI picked up all the interfaces correctly. I did not have to make any changes here.
Storage Option:
Automatic Storage Management (ASM)
Create ASM Disk Group:
Disk Group Name: GIS_FILES
Redundancy: External
Candidate Disk: ORCL:DSK01
ASM Password:
Use Same Password for these accounts. (Ignored password warnings.)
Failure Isolation:
Do not use Intelligent Platform Management Interface (IPMI)
Operating System Groups:
ASM Database Administrator (OSDBA) Group: asmdba
ASM Instance Administrator Operator (OSOPER) Group: oinstall
ASM Instance Administrator (OSASM) Group: asmadmin
Installation Location:
Oracle Base: /u01/app/grid
Software Location: /u01/app/grid11201
Create Inventory:
Inventory Directory: /u01/app/oraInventory
Prerequisite Checks:
Ignored the failures of NTP check to use Oracle’s CTSS. All the 3 nodes’ clock was set to same time before the installation.
Summary Screen:
Verified the information here and pressed “Finish” to start installation.

At the End of the installation, the two scripts needs to be executed as root user.

/u01/app/oraInventory/orainstRoot.sh
/u01/app/grid11201/root.sh

After the successful completion of these scripts, the 11g R2 High Availability Service (CRS, CSS and EVMD) should all be up and running.
Verify the status of the installation using below set of commands.

crsctl check cluster –all
crs_stat –t –v
crsctl check ctss

The GSD and OC4J resources are by default disabled. Enable GSD them if 9i Database is managed by this cluster.

srvctl enable nodeapps –g
srvctl start nodeapps –n node1
srvctl start nodeapps –n node2
srvctl start nodeapps –n node3
srvctl enable oc4j
srvctl start oc4j

Install 11g R2 RAC Software

Start the runInstaller from 11g R2 Real Application Cluster (RAC) Software Location:

[oracle@node1 ~]$ /home/oracle/db11201/database/runInstaller

Real Application Cluster installation process:
Configure Security Updates:
Email: abdul.rehman@raqmiyat.com
Ignore the “Connection Failed” alert.
Installation Option:
Install database software only
Node Selection:
Select All the Nodes (node1,node2 and node3)
Product Language:
English
Database Edition:
Enterprise Edition
Installation Location:
Oracle Base: /u01/app/oracle
Software Location: /u01/app/oracle/db11201
Operating System Groups:
Database Administrator (OSDBA) Group: dba
Database Operator (OSOPER) Group: oinstall
Network Interface Usage:
OUI picked up all the interfaces correctly. I did not have to make any changes here.
Summary Screen:
Verified the information here and pressed “Finish” to start installation.

At the End of the installation, the two scripts needs to be executed on all the nodes as root user.

/u01/app/oracle/db11201/root.sh

Run the root.sh on all the RAC nodes.

At this point, the 11g R2 (11.2.0.1) Real Application cluster Installation is completed successfully. Now, it’s time to create new ASM disk groups and LISTENER for the new database.
Add Listener:
Listener name: LAB_LISTENER
END Point: TCP:1525

Invoke the netca utility under $ORACLE_HOME/bin to create a listener and provide the above information to the specific window. The screenshots of this process are as below.

Create ASM Disk Groups:

Disk Group Name: FRA, DATA
ASM DISKs: DSK02, DSK03 respectively.
Redundancy Level: External

Connect as grid user and Invoke the asmca utility under $GRID_HOME/bin to create these disk groups. The screenshots of this process are as below.

Create 11g R2 RAC database using dbca:

DB Name: labdb

Connect as oracle user and invoke the dbca utility under $ORACLE_HOME/bin to create a new database. After the successful creation of database, modify the LOCAL_LISTENER parameter to point to port 1525 for all the RAC nodes and test the connectivity to the database. The HOST and port value in the TNS ALIAS (connect string) should be set to lab-scan.hingu.net and 1521 respectively. This way, all client knows is the cluster host and port (lab-scan.hingu.net:1521). The DATABASE instances gets registered with the SCAN Listener (1521) running on virtual Host via REMOTE_LISTENER parameter and client connect request coming to SCAN listener gets redirected to the least loaded DATABASE instance based on the service name specified in connect string. So, the Database instance gets registered with the LOCAL_LISTENER (regular Database Listener) and REMOTE_LISTENER (scan).

The screenshots of this process are as below.

[grid@node1 ~]$ lsnrctl status listener_scan1

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 03-SEP-2011 22:30:53

Copyright © 1991, 2009, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1)))
STATUS of the LISTENER
------------------------
Alias LISTENER_SCAN1
Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date 03-SEP-2011 22:23:08
Uptime 0 days 0 hr. 7 min. 45 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/grid11201/network/admin/listener.ora
Listener Log File /u01/app/grid11201/log/diag/tnslsnr/node1/listener_scan1/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER_SCAN1)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.2.152)(PORT=1521)))
Services Summary...
Service "labdb.hingu.net" has 3 instance(s).
Instance "labdb1", status READY, has 1 handler(s) for this service...
Instance "labdb2", status READY, has 1 handler(s) for this service...
Instance "labdb3", status READY, has 1 handler(s) for this service...
Service "labdbXDB.hingu.net" has 3 instance(s).
Instance "labdb1", status READY, has 1 handler(s) for this service...
Instance "labdb2", status READY, has 1 handler(s) for this service...
Instance "labdb3", status READY, has 1 handler(s) for this service...
The command completed successfully
[grid@node1 ~]$

[oracle@node1 ~]$ lsnrctl status lab_listener

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 03-SEP-2011 22:36:55

Copyright © 1991, 2009, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LAB_LISTENER)))
STATUS of the LISTENER
------------------------
Alias LAB_LISTENER
Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date 03-SEP-2011 22:23:08
Uptime 0 days 0 hr. 13 min. 47 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/db11201/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/node1/lab_listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LAB_LISTENER)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1525)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.2.51)(PORT=1525)))
Services Summary...
Service "labdb.hingu.net" has 1 instance(s).
Instance "labdb1", status READY, has 1 handler(s) for this service...
Service "labdbXDB.hingu.net" has 1 instance(s).
Instance "labdb1", status READY, has 1 handler(s) for this service...
The command completed successfully
[oracle@node1 ~]$

With this, the Installation of 11g R2 RAC on Linux (OEL 5.5) is completed successfully. I hope you find this article helpful.

R12 Rapid clone mulit node to single node (12.1.1 on linux 5)

Sat, 04 Jun 2011 12:31:24 -0500

Oracle Application R12.1.1 on linux 5 with 11g Database. I have attached R12 Rapid clone doc. we have mulit node PROD and TEST is single node. DB node(Server) and Apps node(Sever) and without shared appl_top.

R12 Clone Process set up in Spearlog

Esitmate hours : 6 hours and 2 hours DBA task
Note : Please use the cold backup for R12 clone process
------------------------------------------------------------------------------------------------

1) login as oraprod

cd /u01/app/spearprod/dbtechst/11.1.0/appsutil/scripts/PROD_speardb
perl adpreclone.pl dbTier

log file : /u01/app/spearprod/dbtechst/11.1.0/appsutil/log/PROD_speardb/StageDBTier_05081242.log

2) login as applmgr

cd /u01/app/spearprod/inst/apps/PROD_spearapp/admin/scripts
perl adpreclone.pl appsTier

Log file located at /u01/app/spearprod/inst/apps/PROD_spearapp/admin/log/StageAppsTier_05081250.log

3) Shutdown apps node (Server --> )
--------------------------------------------------------
cd $INST_TOP/admin/scripts
./adstpall.sh apps/prod0310apps

4) Shutdown Database node
--------------------------------------------------------

a) cd $ORACLE_HOME or cd /u01/app/spearprod/dbtechst/11.1.0

b) [oraprod@speardb 11.1.0]$ ls *.env
PROD_speardb.env SPEARTST_speartest.env
c) . PROD_speardb.env

d) sqlplus "/as sysdba"

e) SQL> shutdown immediate;

f) exit

g) lsnrctl STOP PROD

Note : wait for 5 mintus

-----------------------------------------------------------------------------------------------------------------------
4.A
-----------------------------------------------------------------------------------------------------------------------
login as oreatest

Stop the Oracle Application and Database

Clear the file system in oratest
--------------------------------
STEP 1 cd /u01/app/speartst

rm -rf inst
rm -rf 10.1.3
rm -rf 10.1.2
rm -rf dbtechst
rm -rf appl
rm -rf comn

STEP 2 cd /d01/app/speartst
rm -rf oradata
mkdir oradata

5)login as oraprod

a) cd /u01/app/spearprod
scp -r dbtechst oratest@0.71:/u01/app/speartst > /tmp/dbtechst.log

b) cd /d01/app/spearprod/oradata
scp -r *.dbf oratest@0.71:/d01/app/speartst/oradata > /tmp/datafile.log

6)logins applmgr(root) ()
cd /u01/app/spearprod/appl

scr -r inst 10.1.3 10.1.2 appl comn oratest@0.71:/u01/app/speartst > /tmp/apps.log

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

7) cd /u01/app/speartst/dbtechst/11.1.0/appsutil/clone/bin
perl adcfgclone.pl dbTier (old password)

/u01/app/speartst/dbtechst/11.1.0/appsutil/log/SPEARTST_speartest/ApplyDBTier_05081706.log

8) /u01/app/speartst/comn/clone/bin
perl adcfgclone.pl appsTier (old password)

log file : /u01/app/speartst/inst/apps/SPEARTST_speartest/admin/log/ApplyAppsTier_05082041.log

9) Post clone actitives

Change pasword

a) FNDCPASS apps/prod0310apps 0 Y system/aprodsystemspl USER SYSADMIN sysadmin123
FNDCPASS apps/prod0310apps 0 Y system/prodsystemspl SYSTEM APPLSYS apps123

change sys and system password

b) Shutdown the Application services in Apps tier node and db tier node before changing the APPS password.
------------------------------------------------------------------------------------------------------
c) DB node:
----------------
$ cd /u01/app/speartst/dbtechst/11.1.0
adautocfg.sh apps/newPasword

d) APPS node After running the autoconfig(new password)
---------------------------
$ cd /u01/app/speartst/inst/apps/SPEARTST_speartest/admin/scripts
adautocfg.sh apps/newPasword

e) Startup the Application on DB node & apps node

DB/CA Part
-------------------
Login oraTag ? user id . and shutdown all services

cd /u01/app/speartst/inst/apps/SPEARTST_speartest/admin/scripts
./adstrtal.sh apps/

cd /u01/app/speartst/dbtechst/11.1.0

ls *.env

. SPEARTST_speartest.env

sqlplus "/as sysdba"
SQL > shutdown immediate
SQL > ! lsnrctl stop SPEARTST
SQL > startup
SQL > !lsnrctl start SPEARTST

APPS node
------------
cd /u01/app/speartst/inst/apps/SPEARTST_speartest/admin/scripts
./ adstrtal.sh apps/

---------------------------------------------------------------------------
(h) Login as sysadmin through Application
http://speartest.spearlog.com:8020/OA_HTML/AppsLogin
---------------------------------------------------------------------------

i) Finishing task
---------------------
Change the Profile Values as below,

Site Name(eg: Spearlog PROD Clone of PROD as of 08/05/2010
Remove the timeout from profile :ICX%Sess%
java color :
Apps node: (all Manager are status like actual and target should be more >0 , if not run the Below the script

cd /u01/app/speartst/inst/apps/SPEARTST_speartest/admin/scripts./adcmctl.sh start apps/app01

Sumbit Active User Request & verified the Log file

j) verify the workflows managers

After the backup restore (usage in TEST server)
----------------------------------------------
[oratest@speartest appl]$ df -h
Filesystem Size Used Avail Use% Mounted on
/dev/cciss/c0d0p6 20G 11G 8.3G 56% /
/dev/cciss/c0d0p5 29G 173M 27G 1% /r01
/dev/cciss/c0d0p3 97G 47G 45G 52% /u01
/dev/cciss/c0d0p2 243G 55G 176G 24% /d01
/dev/cciss/c0d0p1 99M 12M 83M 12% /boot
tmpfs 2.5G 0 2.5G 0% /dev/shm

Output Post Processor not coming up

Mon, 24 Jan 2011 03:48:41 -0600

Hi Friends,

We have a single node production instance (R12.1.1 with 11.1.0.7)

We cloned a test instance from this production instance. Now everything is fine except that the Output post Processor.

OPP is not coming up. Also, there are no FNDOPP* logs generated in $APPLCSF/log

I tried to resolve the issue by running:

exec fnd_conc_clone.setup_clean;

Ran autoconfig and $FND_TOP/patch/115/sql/afdcm037.sql

Even then OPP is not coming up.

Custom Top while upgrade

Sun, 02 Jan 2011 01:02:15 -0600

How to handle custom top and custom objects. while upgradation from 11i to R12.
what is the impact of upgradation on on custom top and Custom objects.

Expire Users Automatically after Inactivity

Thu, 16 Dec 2010 04:11:43 -0600

Is there any built-in functionality to automatically expire a user after they have been inactive in Oracle Financials? For example, if a user has not signed in for 90 days, we would like to have them automatically locked out requiring a sysadmin to reactivate them. Thank you.

How to check version after i apply pacth

Tue, 07 Dec 2010 23:07:33 -0600

I'm going to apply patch with the ID# 9355677 - R12.1.2 UNABLE TO SAVE THE TAX CLASSIFICATION FOR A SUPPLIER TYPE EMPLOYEE

my question is
in the readme file

there is a portion that i need to check the version of the following file
$JAVA_TOP/oracle/apps/zx/schema/server/PartyTaxProfileEOImpl.class 120.17.12010000.4
$ZX_TOP/patch/115/sql/zxcptytaxprfileb.pls 120.9.12010000.4
$ZX_TOP/patch/115/sql/zxcptytaxprfiles.pls 120.3.12010000.2

how do I know the version?
do i need to execute command so that i can able to check version?

VALIDATE DATABASE command

Tue, 07 Dec 2010 12:13:40 -0600

Can anyone tell what is the purpose of VALIDATE DATABASE command

RW-50015: Error at post installation

Thu, 28 Oct 2010 02:02:16 -0500

I'm getting this error after installing it on Linux 5, I've then applied Interim patch for Oracle base bug: 6078836 by copying libdb.so.2 at /usr/lib directory and then retry the installation with rapidwiz restart services but getting the same error. Kindly help me in resolving this issue