Oracle version : 9.2.0
Platform : HP-UX

===========================================================================================
1. O/S Information
===========================================================================================

O/S version
# uname -a
//11.0, 11.11(11i) (32bit/64bit)
11.0 (64bit), 11.11 (64bit), 11.22 (IA64 - Itanium)

CPU
# psrinfo -v

Kernel Bits
# getconf KERNEL_BITS

Memory : 512Mb 이상
# dmesg | grep -i mem

Swap : 메모리와 같거나 1Gb 이상
# swapinfo -q

/tmp : 400Mb 이상
# bdf

Disk Space : full option일 경우 oracle s/w가 설치될 디렉토리에 4.5G 필요
# bdf

※ /usr/dt/bin/rpc.ttdbserver

O/S Patches
HP OS 64bit로 Install 시에 default로 했다면 Bug가 있음
(Doc ID: KBRC00003627) X library symbolic links가 제대로 생성되지 않음

Oracle S/W link 시에 make.log 파일에 다음과 같은 에러메시지가 발생하는 경우가 있다.

" /usr/ccs/bin/ld : Can't find library for -lXm *** Error exit code 1 "
" /usr/ccs/bin/ld : Can't find library for -lXt *** Error exit code 1 "
" /usr/ccs/bin/ld : Can't find library for -lX11 *** Error exit code 1 "

/usr/lib 디렉토리로 가서 위의 Xm, Xt, X11 같은 argument를 가지고 있는 파일을 찾는다.
ex) ls -al *Xm* ....
해당 파일 중에서 가장 높은 번호의 확장자를 가지는 file을 .sl 파일로 link 시켜주면 된다.

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

# /usr/sbin/swlist -l fileset | grep -i
11.0(64 bit) patches:
PHCO_23792 s/b PHCO_26960
PHCO_24148 s/b PHCO_25707 s/b PHCO_27608
PHKL_24268 s/b PHKL_27178
PHKL_24729
PHKL_25475 s/b PHKL_27510
PHKL_25525 s/b PHKL_27364
PHNE_24715 s/b PHNE_26771
PHSS_23670 s/b PHSS_26138
PHSS_24301 s/b PHSS_26273
PHSS_24303 s/b PHSS_26559
PHSS_24627
PHSS_22868
-----------------------------------------
11i(64 bit) patches:
PHNE_27114
PHNE_26388
PHNE_23502
PHKL_25506
PHSS_26263
PHSS_24638
PHSS_26674
PHSS_23441
PHSS_26946
PHSS_26560
PHCO_27740
PHCO_24402
PHCO_23094
PHCO_23772
-----------------------------------------
11.22(IA64) patches:
PHSS_27284
PHSS_27285
PHSS_27286
PHSS_27287
PHSS_27288
PHSS_27289
PHSS_27290
PHSS_27291
PHSS_27292
PHSS_27293
PHKL_28465

Kernel Parameter
# SAM or /etc/sysdef or /usr/sbin/kmtune
KSI_ALLOC_MAX (NPROC*8)
MAX_THREAD_PROC 256
MAXDSIZ 1073741824 bytes
MAXDSIZ_64BIT 2147483648 bytes
MAXSSIZ 134217728 bytes
MAXSSIZ_64BIT 1073741824
MAXSWAPCHUNKS 16384
MAXUPRC ((NPROC*9)/10)
MSGMAP (MSGTQL+2)
MSGMNI NPROC
MSGSEG 32767
MSGTQL NPROC
NCALLOUT (NKTHREAD+16)
NCSIZE ((8*NPROC+2048)+VX_NCSIZE)
NFILE (15*NPROC+2048)
NFLOCKS 4096
NINODE (8*NPROC+2048)
NKTHREAD (((NPROC*7)/4)+16)
NPROC 4096
SEMMAP (SEMMNI+2)
SEMMNI 4096
SEMMNS (SEMMNI*2)
SEMMNU (NPROC - 4)
SEMVMX 32768
SHMMAX AvailMem
SHMMIN 1
SHMMNI 512
SHMSEG 32
VPS_CEILING 64

# vi /stand/system

===========================================================================================
. User, Directory Creation
===========================================================================================

O/S 그룹 및 유저 생성
# vi /etc/group
groupname::gid:username1, username2, ...
ex) dba::300:oracle 추가
# vi /etc/passwd
username:x:uid:gid:description:directory:shell
ex) oracle:x:500:300:Oracle Admin:/u01/app/oracle/product/9.2.0:/bin/ksh 추가
(csh일 경우 /bin/csh)

디렉토리 생성
# mkdir -p /u01/app/oracle/product/9.2.0
# chown -R oracle:dba u01

===========================================================================================
. Mount
===========================================================================================

# ioscan -fun -C disk

disk 1 0/0/1/1.15.0 sdisk CLAIMED DEVICE SEAGATE ST39204LC
/dev/dsk/c1t15d0 /dev/rdsk/c1t15d0
disk 1 0/0/2/1.2.0 sdisk CLAIMED DEVICE HP DVD-
ROM 305
/dev/dsk/c3t2d0 /dev/rdsk/c3t2d0
# mkdir /cdrom
# chmod 777 /cdrom
# ps -ef | grep rpc로 확인후 없으면
/usr/sbin/rpc.lockd ------------|
/usr/sbin/rpc.statd |==> 이 세개는 있는지 확인만 할것!
/usr/sbin/nfsd & ------------|

# nohup /usr/sbin/pfs_mountd &
# nohup /usr/sbin/pfsd &
한후에 다시 ps -ef|grep rpc로 프로세스가 정상적으로 떠있는지 확인한다.

# ps -ef | grep rpc

/usr/sbin/rpcbind
/opt/dce/sbin/rpcd
/usr/sbin/rpc.statd
/usr/sbin/rpc.lockd
/usr/sbin/rpc.mountd ==> 없어도 됨.
pfsd.rpc
pfs_mountd.rpc

# pfs_mount -o xlat=unix /dev/rdsk/c3t2d0 /cdrom
# pfs_umount /cdrom


% 9204 패치 - cpio -idcmv < 파일명

===========================================================================================
. JDK & JRE
===========================================================================================

JDK 1.3.1.02 => Apache에서 사용, Apache를 사용하지 않는다해도 꼭 설치가 되있어야 함
JRE 1.1.8.06
/usr 디렉토리 아래 java1.x 확인

===========================================================================================
. Xwindow
===========================================================================================

# xhost +
access control disabled, clients can connect from any host
$ xclock
GUI프로그램이 잘 작동하는지 확인 (.profile에 /usr/openwin/bin 추가해줘야 함)

===========================================================================================
. .profile or .cshrc
===========================================================================================

ksh일 경우

$ vi .profile
umask 022
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/9.2.0
export ORACLE_SID=SSAMMAI
export NLS_LANG=American_America.KO16KSC5601
export TNS_ADMIN=$ORACLE_HOME/network/admin
export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data
export PATH=/bin:/usr/bin:/usr/sbin:/etc:/opt/bin:/usr/ccs/bin:/usr/local/bin:$ORACLE_HOME/bin
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib:$ORACLE_HOME/rdbms/lib
export SHLIB_PATH=$ORACLE_HOME/lib32:$ORACLE_HOME/rdbms/lib32
CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib
export CLASSPATH=$CLASSPATH:$ORACLE_HOME/network/jlib
export ORACLE_TERM=vt100
export EDITOR=vi
export DISPLAY=172.22.13.208:0.0
stty erase ^H
PS1=`hostname`:'$PWD] '


$ . ./.profile or 재로그인

csh일 경우

$ vi .cshrc
umask 022
stty erase ^H
set path=(/bin /usr/bin /usr/sbin /usr/ucb /usr/ccs/bin /etc .)
#
#------------------ General Setup ------------------------------------------------
#
setenv LANG ko
set path=(/opt/SUNWspro/bin /bin /usr/bin /usr/ucb /usr/contrib/bin)
set path=($path /usr/local/bin /sbin /usr/sbin /usr/ccs/bin)
set path=($path /etc /usr/etc /opt/bin .)
setenv LD_LIBRARY_PATH /usr/ucb:/usr/ucblib
setenv LD_INCLUDE_PATH /usr/include
setenv MANPATH /usr/man
#
#------------------ Oracle Setup -------------------------------------------------
#
setenv TMPDIR /tmp
setenv ORACLE_HOME /u01/app/oracle/product/9.2.0
setenv ORACLE_SID SSAMMAI
setenv ORACLE_TERM vt100
setenv NLS_LANG American_America.KO16KSC5601
setenv TNS_ADMIN $ORACLE_HOME/network/admin
setenv ORA_CLIENT_LIB shared
setenv EPC_DISABLED TRUE
setenv ORA_NLS33 $ORACLE_HOME/ocommon/nls/admin/data
set path=($ORACLE_HOME/bin $path .)
setenv LD_LIBRARY_PATH $ORACLE_HOME/lib:$ORACLE_HOME/network/lib:$LD_LIBRARY_PATH
setenv SHLIB_PATH $ORACLE_HOME/lib32:$ORACLE_HOME/rdbms/lib32
setenv DISPLAY DBSE:0.0

$ source .cshrc

===========================================================================================
. runInstaller
===========================================================================================

$ /cdrom/runInstaller &
......
$ su root
# sh oraInstRoot.sh
/etc/oraInst.loc 확인
......
# sh root.sh
/etc/oratab 확인

===========================================================================================
. SQL*Net
===========================================================================================

listener.ora 내용 확인

LISTENER =
(DESCRIPTION_LIST =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.22.13.202)(PORT = 1521))
)
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = SSAMMAI)
(ORACLE_HOME = /u01/app/oracle/product/9.2.0)
(SID_NAME = SSAMMAI)
)
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /u01/app/oracle/product/9.2.0)
(PROGRAM = extproc)
)
)


tnsnames.ora 내용 확인

FASTEST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST =172.22.13.202)(PORT = 1521))
(CONNECT_DATA =
(SERVICE_NAME = SSAMMAI)
)
)

===========================================================================================
. Database
===========================================================================================

shell script로 저장하여 실행하거나 dbca 상태에서 생성

===========================================================================================
. User Creation
===========================================================================================

$ sqlplus '/as sysdba'

SQL> create user scott identified by tiger
2 default tablespace users
3 temporary tablespace temp;

SQL> grant connect, resource to scott;
SQL> exit

$ splplus scott/tiger@fastest 접속 확인

SQL> @ ?/sqlplus/demo/demobld.sql

===========================================================================================
. Pro*C test
===========================================================================================

C compiler 설치 확인 후 (HP ANSI C compiler Release A.11.01.20 이상, HP aC++ A03.25.필요)
$ORACLE_HOME/precomp/demo/proc로 이동 후
$ make -f demo_proc.mk sample1
$ ./sample

===========================================================================================
. JDK 설치 방법
===========================================================================================

sdkXXX.depot 다운로드 ( 파일크기 : 33M )

installation instructions

If you download the software from the website, you need approximately 60MB of disk space
to download the .depot file. To install the software from the .depot file,
you need an additional 100MB disk space.
After installing the software, you can remove the .depot file.
The HP-UX SDK, for the Java 2 Platform installs under /opt/java1.3.
As root user, use the SD-UX swinstall command to install the software:

/usr/sbin/swinstall

It will lead you through the installation.
Change Source Depot Type to "Local Directory" and Source Depot Path to /tmp/<filename>.
(If you used a directory other than /tmp in the previous step,
replace /tmp with that directory name.)
We recommend you select the "Reinstall filesets" and unselect the "Mount filesystems" option
from the options menu.

WARNING: Do not unarchive rt.jar, il8n.jar, jpda.jar, and tools.jar.
These files are needed by the SDK tools and the runtime environment.

Add the directory /opt/java1.3/bin to your PATH.

For information on setting important system parameters required for correct execution
of Java programs go to the programmer's guide which can be found at

http://www.hp.com/go/JAVA, by selecting this product and then selecting information library.

file structure

The diagram below displays an abbreviated form of the file structure:

java1.3
|
___|_____________________________________________________
| | | | | |
bin lib jre src.jar demo include
| | |
java tools.jar |
javac dt.jar |
javadoc ir.idl |
javah orb.idl |
javap |
jdb |
|_____________
| |
bin lib
| |
__________________|_____________|_____________________________________
| | | | | | | | |
java PA_RISC PA_RISC2 IA64 rt.jar security PA_RISC PA_RISC2.0 IA64
___|___ ___|_______|__ il8n.jar _____|__ __|_____ ___|_____
| | | | | | | | |
native native native classic HS* classic HS* classic HS*
threads threads threads
| | |
java java java

H* = hotspot

The tools install under opt/java1.3/bin and the libraries install under opt/java1.3/lib.
The tools.jar file contains the classes for supporting the tools and utilities.
The file dt.jar contains the DesignTime archive of BeanInfo files.
The jre directory includes the runtime environment.
The file rt.jar contains the runtime classes for the core API.
The file il8n.jar contains the internationalization and localization classes and files.
The security directory contains security management files.
The PA_RISC and PA_RISC2 directories contain the shared libraries used by the HP-UX platform.
The file src.jar contains an archive of source files for the core API for informational
purposes. To view the files, enter the command

$ jar xvf src.jar.
The include directory contains the header files for supporting JNI and JVMDI.

Bookmark Fixed font Go to End

Doc ID: Note:109621.1
Subject: HP-UX: LD_LIBRARY_PATH and SHLIB_PATH
Type: BULLETIN
Status: PUBLISHED
Content Type: TEXT/PLAIN
Creation Date: 22-MAY-2000
Last Revision Date: 24-FEB-2003