11 Oracle Oracle10g Database Oracle 2 sam 1M (GUI ) 2

Size: px

Start display at page:

Download "11 Oracle Oracle10g Database Oracle 2 sam 1M (GUI ) 2"

うのすけおうじ
9 years ago
Views:

1 HP-UX 11i v Oracle10 g DB 11. Oracle10 g /06 11 Oracle CD-ROM Oracle CD-ROM HP-UX DEVELOPER EDGE... 31

3... 10 11.4... 12 11.5 CD-ROM... 13 11.6... 15 11.

2 11 Oracle Oracle10g Database Oracle 2 sam 1M (GUI ) 2

3 Oracle Database 10g for UNIX Systems Oracle Database 10g for HP-UX Itanium RAM 512 Oracle 2.5GB TMP /tmp 400MB DBCA 1.2GB HP-UX HP-UX 11i v HP-UX Oracle Database 10g for UNIX Systems HP-UX IT HP-UX Oracle # /bin/getconf KERNEL_BITS 64 Oracle # /bin/getconf KERNEL_BITS 64 3

2GB HP-UX HP-UX 11i v2 11.23 HP-UX Oracle Database 10g 1 10.

4 KSI_ALLOC_MAX (NPROC * 8) MAX_THREAD_PROC 256 MAXDSIZ MAXDSIZ_64BIT MAXSSIZ MAXSSIZ_64BIT MAXUPRC ((NPROC * 9) / 10) MSGMAP (MSGMNI + 2) MSGMNI 4096 MSGSEG MSGTQL 4096 NFILE (15 * NPROC ) NFLOCKS 4096 NINODE (8 * NPROC ) NKTHREAD (((NPROC * 7) / 4) + 16) NPROC 4096 SEMMNI 4096 SEMMNS (SEMMNI * 2) SEMMNU (NPROC - 4) SEMVMX SHMMAX SHMMNI 512 SHMSEG 120 VPS_CEILING dbc_min_pct default = 5 dbc_max_pct default = 50 dbc_min_pct dbc_max_pct maxvgs default = 10 LVM 80 4

NPROC + 2048) NKTHREAD (((NPROC * 7) / 4) + 16) NPROC 4096 SEMMNI 4096 SEMMNS (SEMMNI * 2) SEMMNU (NPROC - 4) SEMVMX 32767 SHMMAX

5 oracle ID 501 ID /home/oracle ( ID) ( ID oinstall 501 dba 502 ID ID /usr/bin/sh /u oracle 5

6 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

oinstall::501: dba::502 ID 501,502 /etc/group groupadd(1m) groupadd g [ ID]

7 Solaris Solaris groupadd 7

8 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

$/usr/bin/sh /etc/passwd useradd(1m) useradd u [ ID] g [ ] G [ ] d [ ] \ m s [ ] -u [ ID] ID -g [ ID ID] -G [ ID ID]$

9 usermod(1m) # userdel r oracle Solaris Solaris useradd 9

10 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

setprivgrp f /etc/privgroup # getprivgrp global privileges: CHOWN dba:

11 RTSCHED, RTPRIO Oracle hpux_sched_noage hpux_sched_noage 11

12 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

/u01/app/oracle # cd /u01/app # ls -la total 0 drwxrwxrwx 3 root sys 96 Mar 1

13 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

mount(1m) mount F [FStype] o rr [ ] [ ] rr CDFS -F [FStype] CD-ROM cdfs -o rr

14 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/ 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/ sdisk CLAIMED DEVICE HP 36.4G ST336753FC disk 4 0/4/1/ sdisk CLAIMED DEVICE HP 36.4G ST336753FC disk 5 0/4/1/ sdisk CLAIMED DEVICE HP 36.4G ST336753FC disk 6 0/4/1/ sdisk CLAIMED DEVICE HP 36.4G ST336753FC 14

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.

15 11.6 Oracle oracle DISPLAY ORACLE_BASE ORACLE_HOME ORA_NLS10 ORACLE_SID NLS_LANG :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 vt Oracle Oracle Database 10g for UNIX Systems Oracle Database 10g for HP-UX Itanium oracle.profile # su - oracle $ vi.profile 15

JA16SJIS $ORACLE_HOME/bin:$PATH PATH LD_LIBRARY_PATH LANG TERM /usr/bin /etc /usr/bin/x11 /usr/local/bin ( )

16 # su oracle $ chmod u+w.profile $ vi.profile chmod(1).profile 444 ~/.profile # For Oracle10g DISPLAY= :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

JA16SJIS PATH=$ORACLE_HOME/bin:$PATH LD_LIBRARY_PATH=/usr/lib:$ORACLE_HOME/lib LANG=ja_JP.

17 11.7 Oracle 1. Oracle Universal Installer OUI runinstaller OUI 11-1 $ /SD_CDROM/runInstaller

18 2. Oracle orainventory 11-2 Oracle

19 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

/u01/app/oracle/orainventory # sh orainstroot.

20 4..profile ORACLE_HOME 11-4.profile 11-4 OUIHome1 20

22 OK

23 7. Enterprise Edition (2.19GB)

25 9. Oracle

26 10. CD-ROM CD-ROM # umount /SD_CDROM (Disk ) # mount -F cdfs -o rr /dev/dsk/c0t0d0 /SD_CDROM root CD-ROM CD-ROM CD-ROM OK 26

27 11. root.sh root.sh root root.sh OK

28 # 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

29 <orainventory>/logs/installactions.log $ORACLE_HOME/install/make.log 29

30 11.8 CD-ROM Oracle CD-ROM umount(1m) # umount /SD_CDROM # umount /SD_CDROM umount(1m) umount [ ] 30

Oracle DB 10g R2構築手順

Oracle DB 10g R2構築手順 HP Integrity サーバ + HP-UX 11i v2(11.23) Oracle DB 10g R2 構築手順 1. Oracle インストール初版 2006/06 目次 1 Oracle インストール... 2 1.1 シンボリックリンクの作成... 6 1.2 グループの作成... 7 1.3 ユーザアカウントの作成... 9 1.4 グループ属性の設定... 11 1.5 インストールディレクトリの作成