HP-UX 11i v2 11.23 Oracle10 g DB 11. Oracle10 g 2 2004/06 11 Oracle... 2 11.1... 6 11.2... 8 11.3... 10 11.4... 12 11.5 CD-ROM... 13 11.6... 15 11.7 Oracle... 17 11.8 CD-ROM... 30... 31 HP-UX DEVELOPER EDGE... 31
11 Oracle Oracle10g Database Oracle 2 sam 1M (GUI ) 2
Oracle Database 10g 1 10.1 for UNIX Systems Oracle Database 10g 1 10.1.0.2.0 for HP-UX Itanium RAM 512 Oracle 2.5GB TMP /tmp 400MB DBCA 1.2GB HP-UX HP-UX 11i v2 11.23 HP-UX Oracle Database 10g 1 10.1 for UNIX Systems HP-UX IT http://www.itrc.hp.com/ HP-UX Oracle # /bin/getconf KERNEL_BITS 64 Oracle # /bin/getconf KERNEL_BITS 64 3
KSI_ALLOC_MAX (NPROC * 8) MAX_THREAD_PROC 256 MAXDSIZ 1073741824 MAXDSIZ_64BIT 2147483648 MAXSSIZ 134217728 MAXSSIZ_64BIT 1073741824 MAXUPRC ((NPROC * 9) / 10) MSGMAP (MSGMNI + 2) MSGMNI 4096 MSGSEG 32767 MSGTQL 4096 NFILE (15 * NPROC + 2048) NFLOCKS 4096 NINODE (8 * NPROC + 2048) NKTHREAD (((NPROC * 7) / 4) + 16) NPROC 4096 SEMMNI 4096 SEMMNS (SEMMNI * 2) SEMMNU (NPROC - 4) SEMVMX 32767 SHMMAX SHMMNI 512 SHMSEG 120 VPS_CEILING 64 11-1 dbc_min_pct default = 5 dbc_max_pct default = 50 dbc_min_pct dbc_max_pct maxvgs default = 10 LVM 80 4
oracle ID 501 ID /home/oracle ( ID) ( ID oinstall 501 dba 502 ID ID /usr/bin/sh /u01 11-2 oracle 5
11.1 groupadd(1m) oinstall, dba # groupadd -g [ ID] oinstall # groupadd g [ ID] dba # groupadd g 501 oinstall # groupadd -g 502 dba # cat /etc/group oinstall::501: dba::502 ID 501,502 /etc/group groupadd(1m) groupadd g [ ID] [ ] -g [ ID] ID ID ID 0 99 ID groupadd(1m) # groupdel dba # groupdel oinstall 6
Solaris Solaris groupadd 7
11.2 useradd(1m) oracle # useradd -u 501 -g oinstall G dba -d /home/oracle -m -s /usr/bin/sh oracle # passwd oracle # useradd -u 501 -g oinstall G dba -d /home/oracle -m -s /usr/bin/sh oracle # cat /etc/passwd oracle:jfr0noptr7ccw:501:502:,,,:/home/oracle:/usr/bin/sh # passwd oracle oracle ID 501 oinstall /home/oracle /usr/bin/sh /etc/passwd useradd(1m) useradd u [ ID] g [ ] G [ ] d [ ] \ m s [ ] -u [ ID] ID -g [ ID ID] -G [ ID ID] -d [ ] -m -s [ ] useradd(1m) 8
usermod(1m) # userdel r oracle Solaris Solaris useradd 9
11.3 setprivgrp(1m) # setprivgrp f /etc/privgroup # vi /etc/privgroup /etc/privgroup dba MLOCK RTSCHED RTPRIO setprivgrp(1m) getprivgrp(1) # setprivgrp f /etc/privgroup # getprivgrp global privileges: CHOWN dba: RTPRIO MLOCK RTSCHED setprivgrp(1m) setprivgrp f [ ] -f [ ] /etc/privgroup setprivgrp(1m) 10
RTSCHED, RTPRIO Oracle hpux_sched_noage hpux_sched_noage 11
11.4 Oracle # mkdir p /u01/app/oracle /u01/app/oracle oracle oinstall 775 # mkdir p /u01/app/oracle # chown oracle:oinstall /u01/app/oracle # chmod 775 /u01/app/oracle # cd /u01/app # ls -la total 0 drwxrwxrwx 3 root sys 96 Mar 1 23:15. drwxrwxrwx 3 root sys 96 Mar 1 23:15.. drwxrwxr-x 2 oracle oinstall 96 Mar 1 23:15 oracle 12
11.5 CD-ROM Oracle CD-ROM mount(1m) # mount F cdfs /dev/dsk/c0t0d0 /SD_CDROM CD-ROM /SD_CDROM # mkdir /SD_CDROM # mount F cdfs /dev/dsk/c0t0d0 /SD_CDROM mount(1m) mount F [FStype] o rr [ ] [ ] rr CDFS -F [FStype] CD-ROM cdfs -o rr ISO-9660 Rock Ridge HP-UX 11i v2(11.23) DVD/CD-ROM mount(1m) mount_cdfs(1m) 13
DVD/CD-ROM # ioscan fnu C disk # ioscan -fnuc disk Class I H/W Path Driver S/W State H/W Type Description ======================================================================================= disk 0 0/0/2/0.0.0.0 sdisk CLAIMED DEVICE TEAC DV-28E-B /dev/dsk/c0t0d0 /dev/rdsk/c0t0d0 disk 1 0/1/1/0.0.0 sdisk CLAIMED DEVICE HP 73.4GST373453LC /dev/dsk/c2t0d0 /dev/rdsk/c2t0d0 /dev/dsk/c2t0d0s1 /dev/rdsk/c2t0d0s1 /dev/dsk/c2t0d0s2 /dev/rdsk/c2t0d0s2 /dev/dsk/c2t0d0s3 /dev/rdsk/c2t0d0s3 disk 2 0/1/1/0.1.0 sdisk CLAIMED DEVICE HP 73.4GST373453LC /dev/dsk/c2t1d0 /dev/rdsk/c2t1d0 /dev/dsk/c2t1d0s1 /dev/rdsk/c2t1d0s1 /dev/dsk/c2t1d0s2 /dev/rdsk/c2t1d0s2 /dev/dsk/c2t1d0s3 /dev/rdsk/c2t1d0s3 disk 3 0/4/1/0.8.0.255.0.0.0 sdisk CLAIMED DEVICE HP 36.4G ST336753FC disk 4 0/4/1/0.8.0.255.0.1.0 sdisk CLAIMED DEVICE HP 36.4G ST336753FC disk 5 0/4/1/0.8.0.255.0.2.0 sdisk CLAIMED DEVICE HP 36.4G ST336753FC disk 6 0/4/1/0.8.0.255.0.3.0 sdisk CLAIMED DEVICE HP 36.4G ST336753FC 14
11.6 Oracle oracle DISPLAY ORACLE_BASE ORACLE_HOME ORA_NLS10 ORACLE_SID NLS_LANG 172.16.41.9:0.0 X IP /u01/app/oracle $ORACLE_BASE/product/10.1.0/db_1 $ORACLE_HOME/nls/data orcl Japanese_Japan.JA16SJIS $ORACLE_HOME/bin:$PATH PATH LD_LIBRARY_PATH LANG TERM /usr/bin /etc /usr/bin/x11 /usr/local/bin ( ) /usr/lib:$oracle_home/lib ja_jp.sjis CDE dterm dterm TeraTerm vt100 11-3 Oracle Oracle Database 10g 1 10.1 for UNIX Systems Oracle Database 10g 1 10.1.0.2.0 for HP-UX Itanium oracle.profile # su - oracle $ vi.profile 15
# su oracle $ chmod u+w.profile $ vi.profile chmod(1).profile 444 ~/.profile # For Oracle10g DISPLAY=172.16.41.9:0.0 ORACLE_BASE=/u01/app/oracle ORACLE_HOME=$ORACLE_BASE/product/10.1.0/db_1 ORA_NLS33=$ORACLE_HOME/nls/data ORACLE_SID=orcl NLS_LANG=Japanese_Japan.JA16SJIS PATH=$ORACLE_HOME/bin:$PATH LD_LIBRARY_PATH=/usr/lib:$ORACLE_HOME/lib LANG=ja_JP.SJIS TERM=vt100 ; export DISPLAY ; export ORACLE_BASE ; export ORACLE_HOME ; export ORA_NLS33 ; export ORACLE_SID ; export NLS_LANG ; export PATH ; export LD_LIBRARY_PATH ; export LANG ; export TERM umask 022 chmod(1)..profile env $ chmod u-w.profile $..profile $ env LANG /tmp TMP CDE oracle.dtprofile.profile.dtprofile DTSOURCEPROFILE TRUE 16
11.7 Oracle 1. Oracle Universal Installer OUI runinstaller OUI 11-1 $ /SD_CDROM/runInstaller 11-1 17
2. Oracle orainventory 11-2 Oracle 11-2 11-2 18
3. orainstroot.sh orainstroot.sh 11-3 root orainstroot.sh 11-3 Oracle Universal Installer $ /bin/su - Password: # cd /u01/app/oracle/orainventory # sh orainstroot.sh Oracle (/var/opt/oracle/orainst.loc) : /u01/app/oracle/orainventory : oinstall. 19
4..profile ORACLE_HOME 11-4.profile 11-4 OUIHome1 20
5. 11-5 11-5 21
6. 11-6 OK 11-6 22
7. Enterprise Edition (2.19GB) 11-7 11-7 23
8. 11-8 11-8 24
9. Oracle 11-9 11-9 25
10. CD-ROM CD-ROM 11-10 11-10 # umount /SD_CDROM (Disk ) # mount -F cdfs -o rr /dev/dsk/c0t0d0 /SD_CDROM root CD-ROM CD-ROM CD-ROM OK 26
11. root.sh root.sh 11-11 root root.sh OK 11-11 27
# cd /u01/app/oracle/product/10.1.0/db_1/ # sh root.sh Running Oracle10 root.sh script... The following environment variables are set as: ORACLE_OWNER= oracle ORACLE_HOME= /u01/app/oracle/product/10.1.0/db_1 Enter the full pathname of the local bin directory: [/usr/local/bin]: Copying dbhome to /usr/local/bin... Copying oraenv to /usr/local/bin... Copying coraenv to /usr/local/bin... Creating /etc/oratab file... Adding entry to /etc/oratab file... Entries will be added to the /etc/oratab file as needed by Database Configuration Assistant when a database is created Finished running generic part of root.sh script. Now product-specific root actions will be performed. Successfully accumulated necessary OCR keys. Creating OCR keys for user 'root', privgrp 'sys'.. Operation successful. Oracle Cluster Registry for cluster has been initialized Adding to inittab Checking the status of Oracle init process... Expecting the CRS daemons to be up within 600 seconds. CSS is active on these nodes. hp01 CSS is active on all nodes. Oracle CSS service is installed and running under init(1m) 28
12. 11-12 11-12 <orainventory>/logs/installactions.log $ORACLE_HOME/install/make.log 29
11.8 CD-ROM Oracle CD-ROM umount(1m) # umount /SD_CDROM # umount /SD_CDROM umount(1m) umount [ ] 30
Oracle Database 10g 1 10.1 for UNIX Systems http://otn.oracle.co.jp/document/products/oracle10g/index.html Oracle Database 10g 1 10.1.0.2.0 for HP-UX Itanium http://otn.oracle.co.jp/document/products/oracle10g/index.html HP-UX DEVELOPER EDGE www.hp.com/jp/developer HP-UX Developer Edge HP-UX Web 2004 6 Copyright 2004 Hewlett-Packard Development Company, L.P. 140-8641 2-2-24 PDFHS04060-02 31