Oracle
9.2.0.1 on HP-UX 11.0 (64 bit) comes with 4 CDs.
Patches
Following patches need to be installed
Note: Please take a backup of the system before
installing patch and these patches may damage your system.
Refer Oracle Document and Metalink for
additional patches.
Where to download the patch?
You
can download the patch from ftp site of HP
#ftp us-ffs.external.hp.com
Go to
hp-ux_patces/s700_800/11.X and download the required patch .
Unshare the patch with sh <patch name> and go through the patch.text for installation instructions. Make sure to take the backup of the system before installing patch.
JAVA 1.3 is required. Check /opt/java1.3 directory on your system .
If you do not find it, you can install it from http://www.hp.com/products1/unix/java
( download SDK and RTE 1.3). After completion of installation, add /opt/java1.3/bin
to your path.
Link the libraries due to know HP bug (KBRC00003627)
cd /usr/lib
ln -s /usr/lib/libX11.3 libX11.sl
ln -s /usr/lib/libXIE.2 libXIE.sl
ln -s /usr/lib/libXext.3 libXext.sl
ln -s /usr/lib/libXhp11.3 libXhp11.sl
ln -s /usr/lib/libXi.3 libXi.sl
ln -s /usr/lib/libXm.4 libXm.sl
ln -s /usr/lib/libXp.2 libXp.sl
ln -s /usr/lib/libXt.3 libXt.sl
ln -s /usr/lib/libXtst.2 libXtst.sl
KERNEL
The
following KERNEL configuration is
required for 9.2.0
|
Kernel Parameter |
Setting |
Purpose |
|
KSI_ALLOC_MAX
|
(NPROC
* 8) |
Defines
the systemwide limit of queued signals that can be allocated. |
|
MAX_THREAD_PROC
|
256
|
Defines
the maximum number of kernel threads allowed per process. You may need to
increase the value if required by your application. Setting it to a default
or low value may lead to an out of memory error for certain applications. |
|
MAXDSIZ
|
1073741824
bytes |
Refers
to the maximum data segment size in bytes for 32-bit systems. Setting this
value too low may cause the processes to run out of memory. |
|
MAXDSIZ_64
|
2147483648
bytes |
Refers
to the maximum data segment size in bytes for 64-bit systems. Setting this
value too low may cause the processes to run out of memory. |
|
MAXSSIZ
|
134217728
bytes |
Defines
the maximum stack segment size in bytes for 32-bit systems. |
|
MAXSSIZ_64BIT
|
1073741824
|
Defines
the maximum stack segment size in bytes for 64-bit systems. |
|
MAXSWAPCHUNKS
|
16384
|
Defines
the maximum number of swap chunks where SWCHUNK is the swap chunk size (1 KB
blocks). SWCHUNK is 2048 by default. It specifies the maximum amount of
configurable swap space on the system. |
|
MAXUPRC
|
((NPROC*9)/10)
|
Defines
the maximum number of user processes. |
|
MSGMAP
|
(MSGTQL
+ 2) |
Defines
the maximum number of message map entries. |
|
MSGMNI
|
NPROC
|
Defines
the number of message queue identifiers. |
|
MSGSEG
|
32767
|
Defines
the number of segments available for messages. |
|
MSGTQL
|
NPROC
|
Defines
the number of message headers. |
|
NCALLOUT
|
(NPROC
+ 16) |
Defines
the maximum number of pending timeouts. |
|
NCSIZE
|
((8
* NPROC + 2048) + |
Defines
the Directory Name Lookup Cache (DNLC) space needed for inodes. VX_NCSIZE is by
default 1024. |
|
NFILE
|
(15
* NPROC + 2048) |
Defines
the maximum number of open files. |
|
NFLOCKS
|
4096
|
Defines
the maximum number of file locks available on the system. |
|
NINODE
|
(8
* NPROC + 2048) |
Defines
the maximum number of open inodes. |
|
NKTHREAD
|
(((NPROC
* 7) / 4) + 16) |
Defines
the maximum number of kernel threads supported by the system. |
|
NPROC
|
4096
|
Defines
the maximum number of processes. |
|
SEMMAP
|
(SEMMNI
+ 2) |
Defines
the maximum number of semaphore map entries. |
|
SEMMNI
|
4096
|
Defines
the maximum number of semaphore sets in the entire system. |
|
SEMMNS
|
(SEMMNI
* 2) |
Defines
the maximum number of semaphores in the system. The default value of SEMMNS
is 128, which is, in most cases, too low for Oracle9i software. |
|
SEMMNU
|
(NPROC
- 4) |
Defines
the number of semaphore undo structures. |
|
SEMVMX
|
32768
|
Defines
the maximum value of a semaphore. |
|
SHMMAX
|
Available
physical memory |
Defines
the maximum allowable size of one shared memory segment. The SHMMAX setting
should be large enough to hold the entire SGA in one shared memory segment. A
low setting can cause creation of multiple shared memory segments which may
lead to performance degradation. |
|
SHMMNI
|
512
|
Defines
the maximum number of shared memory segments in the entire system. |
|
SHMSEG
|
32
|
Defines
the maximum number of shared memory segments one process can attach. |
|
VPS_CEILING
|
64
|
Defines
the maximum System-Selected Page Size in kilobytes |
Oracle User
And Group
You have to create
group named dba and user
oracle either through SAM or command line. Your home directory of
oracle may not necessary to your
software mount point.
Mount Points
I would recommend minimum
three mount points , one for software
which is approximately 3.5GB for 9.2.0.1
and it you want to install 9.2.0.2 patch it should be approximately 5 GB and
other for database. (Read the OFA and create the mount points according to your
requirement)
After creating the mount point change the
ownership of oracle mounts as
# chown oracle:dba
/u01
create a directory /var/opt/oracle. Oracle user must
have a write permission to this directory. For simplicity I mostly do chmod 777
/var/opt/oracle
login as Oracle user and add the following environment variable in
your profile.
Here is sample for .profile as I am using KSH
umask 022
ORACLE_SID=HPOR92
export ORACLE_SID
ORACLE_HOME=/u01/app/oracle/product/9.2.0
export ORACLE_HOME
ORACLE_BASE=/u01/app/oracle
export ORACLE_BASE
PATH=$ORACLE_HOME/bin:/usr/ccs/bin:/usr/openwin/bin:/usr/bin:/etc:/usr/l
ical/bin:/opt/java1.3/bin
export PATH
DISPLAY=172.20.12.15:0.0
export DISPLAY
Save the
profile setting , logback and login and
do echo $ORACEL_HOME, if you do
not see the results , check DTSOUREPROFILE=TRUE in .dtprofile. It should be uncommented.
Also check your display is working properly or not
by $ /usr/bin/X11/xclock should display you a clock. If you are not seeing the
clock , refer to metalink doc 153960.1 for troubleshooting.
Ready for Install.
Step 1.
Check again all the Prerequisites
again.
Check the /tmp space, mount file system space,
required patches, Java version, memory, swap , required oracle account and
privileges.
Step 2 .
(a) Find the device
#ioscan –funC
disk
The output of the above command will tell you the
cdrom device.
(b) Now issue mount command
Login as root
#mkdir
/SD_CDROM
#nohup
/usr/sbin/pfs_mountd &
#nohup /usr/sbin/pfsd &
#pfs_mount –o xlat=unix /dev/rdsk/cXtXd0 /SD_CDROM
/dev/rdsk/cXtXd0 is the cdrom device found in (a) above.
Verify mounted CDROM as
# bdf
Filesystem kbytes used
avail %used Mounted on
/dev/vg00/lvol3 143360
22691 113172 17% /
/dev/vg00/lvol1 295024
33984 231536 13% /stand
<output
deleted here>
/dev/vg00/lvol5 20480
1264 18070 7% /home
nghpux01:/SD_CDROM 0
0 0 0% /SD_CDROM
Step 3. Run Installer
Login as an oracle account and invoke the installer
as
$cd /tmp
$/SD_CDROM/runInstaller
Oracle installer will invoke with in 40-50 sec.
Follow the screen instructions to install oracle.
Approximation 17% completion , installer
ask you for the second CD.
To eject and put 2nd CD, Open another session , connect as root and
un-mount the CD as
Open New Terminal Session
$su
Password
#cd /
#/usr/sbin/pfs_umount /SD_CDROM
Eject the 1st
CD from the CDROM and put the 2nd
CD . Mount the 2nd CD as
#pfs_mount
–o xlat=unix
/dev/rdsk/cXtXd0 /SD_CDROM
Click OK on the installer to run it.
Note :- Installer will ask JDK 1.3.1 path , as it is
recommended to install Java in /opt. Give the path /opt/java1.3 ( Do not give the
path /opt/java1.3/bin. This is the common mistake which mostly people do)
You will also prompted to run “root.sh” with the
instrunctions.
Complete the installation with all the four CDs
After installation, you will see similar screen as
follows
/u01/app/oracle/product/9.2.0/Apache/Apache/setupinfo.txt
-----------------------------------------
The HTTP Server can be
accessed using the following URLs:
Non SSL Mode (executed at
install time):
http://nghpux01:7777
SSL mode:
http://nghpux01:7778
Keep the above information
, It will be required for later use. Eject the 4th CD now , your
installation has completed.
Configure listener and database in /etc/rc scripts to
automatic database and listener startup after reboot of the server.
Do not forget to refer, Oracle
Documentation for further updates.
HP-UX: Quick Start Guide - 9.2.0 RDBMS Installation
Oracle Documentation
Hope the above information will help …
--
Author
Sameer
Wadhwa
Copyright©
Oracle Techniques www.SamOraTech.com
Disclaimer:
The author does not guarantee that this
information is error-free.
If any
errors are found, please report them to author at Wadhwa_s@hotmail.com or SamOracle@Yahoo.com
Ask and Solve
Database Problems at OraTechSupportGroup
What do you think
about Oracle Techniques?