Oracle HTML DB Oracle Database 10g
... 4... 4 1... 4... 4 2... 5 2.1 Oracle HTTP Server... 6... 6... 7 2.2 root... 9 UNIX... 9 UNIX... 10 2.3 Oracle... 10... 11 (Bash )... 12 2.4 Oracle HTML DB... 13 2.5... 13 3 Oracle HTML DB... 15 3.1... 15... 15 Oracle Universal Installer... 16... 16... 20... 21... 23 HTML DB... 23... 25... 26 Configuration Assistant... 27... 29 4 Oracle HTML DB... 30 Configuration Assistant... 30 Oracle HTML DB 2
Configuration Assistant Oracle HTTP Server... 31 Configuration Assistant HTML DB Configuration Assistant... 31 Configuration Assistant Oracle HTTP Server... 32... 33 5 Oracle HTML DB... 33... 33 Oracle HTML DB... 34 Oracle HTTP Server... 34 6... 34... 35 Oracle HTML DB 3
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
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
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 9.0.4 ( ) 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
/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 2.1 3 (x86) make binutils (Red Hat Enterprise Linux AS 2.1 (32bit) ) RHSA-2003:195-06 http://www.jp.redhat.com/support/errata/rhsa/rhsa-2003-195j.html RHSA-2003:022-09 glibc https://rhn.redhat.com/errata/rhsa-2003-022.html Oracle HTML DB 7
# 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:195-06 # uname r 2.4.9-e.35smp 2.4.9 e.35 smp SMP 12 RHSA-2003:022-09 # rpm -q glibc glibc-2.2.4-32.11 2.2.4-31 glibc Oracle HTML DB 8
Red Hat Enterprise Linux 2.1 (x86) gcc 2.96 openmotif-2.1.30-11 Red Hat Enterprise Linux 3 gcc-3.2.3-20 compat-db-4.0.14.5 compat-gcc-7.3-2.96.122 compat-gcc-c++-7.3-2.96.122 compat-libstdc++-7.3-2.96.122 compat-libstdc++-devel-7.3-2.96.122 openmotif-2.2.2-16 setarch-1.3-1 gnome-libs-1.4.1.2.90-34.1 Linux Oracle Database 10g Red Hat Enterprise Linux 3 gnome-libs-1.4.1.2.90-34.1 2.2 root Oracle Oracle UNIX UNIX UNIX UNIX oinstall Oracle UNIX oinstall orainventory oinstall Oracle HTML DB 9
# /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
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
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
$../.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 9.2.0.3 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
2 Oracle Net Listener $ $ORACLE_HOME/bin/lsnrctl status 3 Oracle HTML DB 14
$ $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 2 3.1 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
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 5. 3. 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
6 root Oracle root runinstaller Installer Oracle Database 10g Oracle HTML DB 17
7 Oracle HTML DB 18
Oracle $ORACLE_BASE/oraInventory /etc/orainst.loc oinstall root orainstroot.sh Oracle HTML DB 19
Oracle product.jar Oracle Oracle Oracle Oracle Oracle HTML DB 20
8 Oracle Companion CD Oracle HTTP Server Oracle Oracle HTML DB Oracle HTTP Server 2 Oracle Database 10g Companion Products 10.1.0.2.0 Oracle HTML DB 21
9 OS ( ) OK Oracle HTML DB 22
10 Apache Standalone 9.0.4.0 HTML DB 10.1.0.2.0 11 HTML DB Oracle HTML DB Oracle HTML DB 23
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
12 HTML DB SYSAUX Oracle Database 10g SYSTEM SYSAUX Oracle SYSTEM SYSAUX SYSTEM Oracle HTML DB 25
13 Oracle Universal Installer 10 Oracle HTML DB 26
14 Configuration Assistant Configuration Assistant 10 20 ( ) Oracle HTML DB 27
15 Configuration Assistant root root.sh 16 root.sh root.sh OK 17 root.sh Oracle HTML DB 28
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
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
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 /nolog @$ORACLE_HOME/htmldb_temp_inst.sql 21 Oracle HTML DB $ORACLE_HOME/marvel/coreins.sql HTML DB marvel Oracle HTML DB HTML DB Oracle HTML DB 31
HTMLDB_PUBLIC_USER mod_plsql FLOWS_010500 HTML DB 1000 FLOWS_FILES 22 Oracle HTML DB $ORACLE_HOME/bin/sqlplus /nolog @$ORACLE_HOME/htmldb_temp_lang.sql 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
$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
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
Oracle Universal Installer 1. Oracle $ su - oracle 2. Oracle Universal Installer ${ }/runinstaller 3. 6 4. 7 Oracle 5. 6. 7. 29 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
2. Oracle HTML DB SQL> select username from dba_users where username like 'HTMLDB%' or username like 'FLOWS%'; USERNAME ------------------------------ FLOWS_010500 HTMLDB_PUBLIC_USER FLOWS_FILES 3. DROP SQL> drop user HTMLDB_PUBLIC_USER cascade; SQL> drop user FLOWS_010500 cascade; SQL> drop user FLOWS_FILES cascade; 30 Oracle HTML DB Oracle HTML DB 36
Copyright 2004 Oracle Corporation Japan. All Rights Reserved. Oracle Oracle Corporation Oracle Corporation Oracle HTML DB 37