Some commands related to the installation of Oracle on HP-UX
1. For 10g RAC on HP-UX, 512 MB of physical RAM is required. To check the RAM size, use:
# /usr/sbin/dmesg | grep "Physical:"
2. 1GB or 2ce the size of RAM is needed as swap space. To check swap information, use:
# /usr/sbin/swapinfo -a
3. At least 400M of tmp space is needed. To check tmp space, use:
# bdf /tmp
4. To check the disk free space, use:
# bdf
5. To determine whether the system architecture can run the software, enter the command:
# /bin/getconf KERNEL_BITS
The expected output is the value 64.
6. To check the version of HP-UX, use:
# uname -a
7. To determine if a package is installed, use:
# /usr/sbin/swlist -l level | more
where level is the package name.
8. To determine whether an Oracle software owner exists, use:
# id oracle
In all nodes, user name and ID for Oracle software must be the same.
9. To create the oracle user, enter a command similar to the following:
# /usr/sbin/useradd -u 200 -g oinstall -G dba[,oper] oracle
where
-g specifies primary group
-G specifies secondary group
-u specifies the user ID
10. Create group, use:
# /usr/sbin/groupadd -g 200 oinstall
where -g specifies the group id, to change a group , use "groupmod"
11. To define user equivalence for each node, on all the nodes, modify the file named /etc/hosts.equiv
add in following entries:
node1-public oracle
node1-public.domain oracle
node2-public oracle
node2-public.domain oracle
where:
noden_public is the host name associated with the primary public network interface
domain is the domain name of the system, for example mydomain.com
12. To test user equivalence on all nodes. use:
# su oracle
$ remsh nodename1 date
$ remsh nodename2 date
.
.
.
$ exit
For each "remsh nodename1 date" command, if it prompts for a password or displays any other information, it means the user equivalence is not setup correctly.
File named .rhosts in ~oracle can also achieve this.
13. Grant privileges to group.
a. edit /etc/privgroup, add
dba MLOCK RTPRIO RTSCHED
b. to grant privilege to OSDBA group, use:
# /usr/sbin/setprivgrp -f /etc/privgroup
c. to verify the privilege granted, use:
# /usr/sbin/getprivgrp dba
14. To identify existing Oracle hoem, use:
# more /etc/oratab
15. To check whether an ASM home is already installed, use:
# more /etc/oratab
There must be "+ASM:oracle_home_path:N" if there's an existing ASM home
16. Get information of each disk attached to the system
# /usr/sbin/ioscan -fun -C disk
If this command does not display device name information, enter the following command to install the special device files:
# /usr/sbin/insf -e
For each disk that you want to add to a disk group, enter the following command to verify that it is not already part of an LVM volume group:
# /sbin/pvdisplay /dev/dsk/cxtydz
Network requirement of RAC on HP-UX
1. 2 NICs for each node, one for public ip and the other for private interconnection.
2. The interface name of each NIC for each network must be the same. eg, public network nic must has the same name for all nodes.
3. Each NIC for public network must support TCP/IP
4. an ip address and an associated host name registered in DNS for each public NIC.
5. One unused virtual IP address and virtual host name register in DNS that'll be used for publich nic.
6. Virtual public IP address must be in the same sub-network as the public network.
To identify the interface name and associated IP address, use:
# /usr/bin/netstat -in