Oracle HTML DB 導入ガイド

Size: px

Start display at page:

Download "Oracle HTML DB 導入ガイド"

まいえひめい
6 years ago
Views:

1 Oracle HTML DB Oracle Database 10g

2 Oracle HTTP Server root... 9 UNIX... 9 UNIX Oracle (Bash ) Oracle HTML DB Oracle HTML DB Oracle Universal Installer HTML DB Configuration Assistant Oracle HTML DB Configuration Assistant Oracle HTML DB 2

3 Configuration Assistant Oracle HTTP Server Configuration Assistant HTML DB Configuration Assistant Configuration Assistant Oracle HTTP Server Oracle HTML DB Oracle HTML DB Oracle HTTP Server Oracle HTML DB 3

4 Oracle HTML DB Oracle Database 10g Oracle HTML DB Web Oracle HTML DB Oracle HTML DB Oracle HTTP Server Oracle HTML DB Red Hat Enterprise Linux ES 3 OS OS Oracle HTML DB Oracle Oracle HTML DB Oracle Oracle HTML DB 1 Oracle HTML DB Oracle HTML DB Oracle Database 10g Release 1 CD Pack Oracle HTML DB 4

5 Oracle Database 10g Oracle Database Oracle HTTP Server Oracle HTML DB EE SE Oracle Database 10g Companion CD Oracle HTTP Server Oracle HTML DB Oracle Database 10g Oracle Database 10g Companion CD Oracle HTTP Server Oracle Oracle Database Oracle HTTP Server Oracle HTML DB Oracle HTTP Server Oracle 2 Oracle HTML DB Oracle Universal Installer Oracle ( ) Oracle Oracle HTML DB Oracle HTTP Server Oracle HTML DB Oracle HTML DB 5

6 2.1 Oracle HTTP Server Oracle HTML DB Oracle Oracle HTTP Server Oracle Database 10g Oracle HTTP Server CD-ROM Oracle Oracle Database 10g Oracle Database 10g CD-ROM Companion CD CD-ROM Oracle HTML DB Oracle HTTP Server Oracle HTML DB Oracle HTTP Server Oracle Oracle Database 10g Companion CD Oracle HTTP Server ( ) Oracle Application Server 10g (9.0.4) Oracle Enterprise Manager 10g(Grid Control) Oracle HTTP Server 256MB RAM 512MB Oracle HTML DB /tmp 40MB Oracle HTML DB 6

7 /tmp 40MB /tmp /tmp TMPDIR TMP /tmp Oracle HTTP Server + Oracle HTML DB 700MB Oracle HTTP Server 400MB Oracle HTTP Server Linux Red Hat Enterprise Linux AS/ES (x86) make binutils (Red Hat Enterprise Linux AS 2.1 (32bit) ) RHSA-2003: RHSA-2003: glibc Oracle HTML DB 7

8 # cat /etc/issue Red Hat Linux Advanced Server release 2.1AS/ m (Pensacola) # cat /etc/issue Red Hat Enterprise Linux ES release 3 (Taroon) Kernel r on an m (Red Hat Enterprise Linux AS 2.1 (32bit) ) RHSA-2003: # uname r e.35smp e.35 smp SMP 12 RHSA-2003: # rpm -q glibc glibc glibc Oracle HTML DB 8

9 Red Hat Enterprise Linux 2.1 (x86) gcc 2.96 openmotif Red Hat Enterprise Linux 3 gcc compat-db compat-gcc compat-gcc-c compat-libstdc compat-libstdc++-devel openmotif setarch gnome-libs Linux Oracle Database 10g Red Hat Enterprise Linux 3 gnome-libs root Oracle Oracle UNIX UNIX UNIX UNIX oinstall Oracle UNIX oinstall orainventory oinstall Oracle HTML DB 9

10 # /usr/sbin/groupadd oinstall Oracle Oracle HTTP Server Oracle HTML DB UNIX # more /etc/orainst.loc inventory_loc=/u01/app/oracle/orainventory inst_group=oinstall orainventory Oracle Universal Installer *1 Oracle inst_group Oracle UNIX *1 Oracle Universal Installer Oracle GUI Oracle Oracle Universal Installer UNIX Oracle UNIX oracle oinstall oracle # /usr/sbin/useradd g oinstall [ G dba] oracle oracle # passwd oracle < > dba Oracle HTML DB 2.3 Oracle Oracle HTML DB 10

11 Oracle Oracle Oracle Oracle Oracle (orainventory) {Oracle }/orainventory Oracle Oracle Universal Installer Oracle Oracle Oracle Oracle Oracle Oracle Oracle Universal Installer Oracle ORACLE_HOME oracle ORACLE_BASE Oracle ORACLE_HOME Oracle ORA_NLS33 Oracle HTML DB 11

12 NLS_LANG _.Oracle ( ) LANG Oracle Universal Installer GUI OS LANG PATH $ORACLE_HOME/bin LD_LIBRARY_PATH $ORACLE_HOME/lib (Bash ) Oracle HTTP Server Oracle HTML DB.profile $ vi.profile # ORACLE SETTINGS export ORACLE_BASE=$HOME/app/oracle export ORACLE_HOME=$ORACLE_BASE/ohs/9.0.4 export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data export NLS_LANG=Japanese_Japan.JA16EUC # PATH export PATH=$ORACLE_HOME/Apache/Apache/bin:$ORACLE_HOME/bin:$PATH # LD_PATH export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH 1 Oracle HTML DB 12

13 $../.profile $ LANG=ja_JP.eucJP; export LANG LANG 2.4 Oracle HTML DB ( ) Oracle HTML DB Oracle ( ) Oracle HTML DB Oracle HTML DB Oracle Database 10g Oracle9i Database release Oracle HTML DB Oracle Companion CD Oracle HTTP Server Oracle 2.5 Oracle HTML DB 3 SQL*Plus SYS $ $ORACLE_HOME/bin/sqlplus /nolog SQL> connect sys/[ ] as sysdba SQL*Plus SYS SQL> select * from v$instance; Oracle HTML DB 13

14 2 Oracle Net Listener $ $ORACLE_HOME/bin/lsnrctl status 3 Oracle HTML DB 14

15 $ $ORACLE_HOME/bin/lsnrctl start 3 Oracle HTML DB Oracle HTTP Server Oracle HTML DB CD-ROM Oracle Database 10g CD Pack Oracle Database 10g Companion CD CD-ROM1 HP-UX Companion CD Oracle Database 10g Companion CD for Linux Red Hat Enterprise Linux 3 Oracle Universal Installer HTML DB Configuration Assistant Oracle Database 10g Companion CD CD-ROM CD-ROM Oracle HTML DB 15

16 CD-ROM CD-ROM 1. Companion CD CD-ROM CD-ROM 2. CD-ROM root $ su - root 3. Companion CD CD-ROM # ls /mnt/cdrom 4. # mount t iso9660 /dev/cdrom /mnt/cdrom Companion CD CD-ROM 4 CD-ROM /mnt/cdrom Red Hat Companion CD CD-ROM Oracle Universal Installer Oracle Universal Installer Oracle 1. Oracle # su - oracle 2. Oracle Universal Installer $ { }/runinstaller 5 OUI Oracle Universal Installer Oracle HTML DB 16

17 6 root Oracle root runinstaller Installer Oracle Database 10g Oracle HTML DB 17

18 7 Oracle HTML DB 18

19 Oracle $ORACLE_BASE/oraInventory /etc/orainst.loc oinstall root orainstroot.sh Oracle HTML DB 19

20 Oracle product.jar Oracle Oracle Oracle Oracle Oracle HTML DB 20

21 8 Oracle Companion CD Oracle HTTP Server Oracle Oracle HTML DB Oracle HTTP Server 2 Oracle Database 10g Companion Products Oracle HTML DB 21

22 9 OS ( ) OK Oracle HTML DB 22

10 Apache Standalone 9.0.4.0 HTML DB 10.1.0.2.

23 10 Apache Standalone HTML DB HTML DB Oracle HTML DB Oracle HTML DB 23

24 Oracle Net Listener TCP/IP ( 1521) Oracle HTML DB SYS SYS HTML DB Oracle HTML DB HTML DB ( ) HTML DB HTMLDB_PUBLIC_USER HTMLDB_PUBLIC_USER mod_plsql HTML DB Oracle HTML DB ADMIN ( ) HTML DB HTML DB SYSAUX Oracle HTML DB 100MB Oracle HTML DB 24

25 12 HTML DB SYSAUX Oracle Database 10g SYSTEM SYSAUX Oracle SYSTEM SYSAUX SYSTEM Oracle HTML DB 25

26 13 Oracle Universal Installer 10 Oracle HTML DB 26

27 14 Configuration Assistant Configuration Assistant ( ) Oracle HTML DB 27

28 15 Configuration Assistant root root.sh 16 root.sh root.sh OK 17 root.sh Oracle HTML DB 28

29 Configuration root.sh Oracle root Oracle Universal Installer Oracle root.sh Oracle Oracle HTML DB Oracle HTTP Server Oracle Universal Installer 18 Oracle HTML DB 29

30 URL Oracle HTTP Server ORACLE_HOME/Apache/Apache/setupinfo.txt Companion CD CD-ROM CD-ROM 4 Oracle HTML DB Oracle HTTP Server Oracle HTML DB Oracle Universal Installer Configuration Assistant Oracle Oracle HTTP Server Oracle HTML DB $ cd $ORACLE_HOME $ ls sqlnet.log ldap/ owm/ sqlplus/ jdbc/ jdk/ cfgtoollogs/ marvel/ plsql/ srvm/ jlib/ lib/ dcm/ network/ precomp/ Apache/ oui/ inventory/ orainst.loc ocommon/ rdbms/ bin/ perl/ root.sh* otrace/ opmn/ relnotes/ diagnostics/ xdk/ root.sh.old* assistants/ oracore/ slax/ install/ jre/ JRE@ 19 Oracle HTML DB 30

31 Configuration Assistant Oracle HTTP Server Configuration Assistant Oracle HTTP Server OPMN $ORCLE_HOME/opmn/bin/opmnctl startall 20 Oracle HTTP Server Configuration Assistant HTML DB Configuration Assistant Configuration Assistant HTML DB $ORACLE_HOME/marvel/10ins.sql $ORACLE_HOME/bin/sqlplus 21 Oracle HTML DB $ORACLE_HOME/marvel/coreins.sql HTML DB marvel Oracle HTML DB HTML DB Oracle HTML DB 31

32 HTMLDB_PUBLIC_USER mod_plsql FLOWS_ HTML DB 1000 FLOWS_FILES 22 Oracle HTML DB $ORACLE_HOME/bin/sqlplus 23 Oracle HTML DB htmldb_temp_lang.sql ( $ORACLE_HOME/builder/ja/load_ja.sql ) Oracle HTML DB Oracle HTML DB Oracle HTML DB Application Builder Oracle HTML DB Configuration Assistant Oracle HTTP Server Oracle HTTP Server Oracle HTML DB 32

33 $ORCLE_HOME/opmn/bin/opmnctl stopall $ORCLE_HOME/opmn/bin/opmnctl startall 24 OPMN htmldb_temp_ins.sql htmldb_temp_lang.sql root.sh Oracle Universal Installer 5 Oracle HTML DB Oracle Oracle Universal Installer Oracle HTML DB Oracle Universal Installer installactions[yyyy-mm-dd_hh-mi-ss-am(pm)].log orainventory $ORACLE_BASE/oraInventory/logs/installActions[YYYY-MM-DD_HH-MI-SS-AM (PM)].log 25 Oracle Universal Installer Oracle HTML DB 33

34 Oracle HTML DB Oracle HTML DB $ORACLE_HOME/marvel/install.lst 26 Oracle HTML DB Oracle HTTP Server Oracle HTTP Server Oracle Process Manager and Notification Server(OPMN) ( ) OPMN Oracle HTTP Server Oracle HTTP Server $ORACLE_HOME/opmn/bin/opmnctl restartproc ias-component=http_server 27 Oracle HTTP Server Oracle HTTP Server $ORACLE_HOME/opmn/logs/HTTP_Server~1 28 Oracle HTTP Server 6 Oracle HTML DB 34

35 Oracle Universal Installer 1. Oracle $ su - oracle 2. Oracle Universal Installer ${ }/runinstaller Oracle Oracle Oracle Universal Installer Oracle HTML DB Oracle Oracle HTML DB ( 22 Oracle HTML DB ) 1. SQL*Plus SYS $ $ORACLE_HOME/bin/sqlplus /nolog SQL> connect sys/[ ] as sysdba Oracle HTML DB 35

36 2. Oracle HTML DB SQL> select username from dba_users where username like 'HTMLDB%' or username like 'FLOWS%'; USERNAME FLOWS_ HTMLDB_PUBLIC_USER FLOWS_FILES 3. DROP SQL> drop user HTMLDB_PUBLIC_USER cascade; SQL> drop user FLOWS_ cascade; SQL> drop user FLOWS_FILES cascade; 30 Oracle HTML DB Oracle HTML DB 36

<Documents Title Here>

<Documents Title Here> Oracle9i Database R9.2.0 for Windows Creation Date: Mar 06, 2003 Last Update: Mar 24, 2003 CD 1 A99346-01 Oracle9i Database Release 2 (9.2.0.1.0) for Microsoft Windows NT/2000/XP CD 1 of 3 2 A99347-01