1 Memory Swap Space Disk Drives 128 MB (JAVA VM 256MB ) RAM 3 (1GB ) 2 22 2GB 1 4 Oracle Software, 3 DB CD-ROM Drive LINUX CD-ROM Oracle8i Enterprise Edition Oracle8i Client Programmer/2000 Minimal 693MB N/A N/A Typical 765 MB 216 MB 177 MB Custom Minimal : Oracle 81500 for Linux 1-1
OS OS Patches System Libraries Windows Manager Linux kernel 22 GNU C Tools egcs-112 (GLIBC package v21) windows manager, : fvmw (Motif v12 ) : Release 815 Character Mode Installation Netscape Navigator 40 MS Internet Explorer 40 Oracle Software Packager 1607 JDK 116 PRO*C/C++ Oracle Intelligent Agent Oracle JDBC drivers egcs-112 TCL 75 (ftp://ftpscripticscom ) JDK 116 v5 (http://wwwblackdownorg ) (*) : Net8 Oracle 81500 for Linux 1-2
init<sid>ora PROCESSES NFS(UDP ) ext2, 2GB ORACLE_HOME Java Runtime Environment (JRE) Character Mode Optimal Flexible Architecture (OFA) Oracle8i Release 815 ORACLE_HOME ORACLE_HOME JRE 116 v5 http://wwwblackdownorg, response file non-interactive(silent), X-windows X-terminal emulator Oracle 81500 for Linux 1-3
Oracle Partitioning JAVA Runtime Environment 11 Oracle Database Configuration Assistant Oracle JServer and Oracle JServer Enterprise Edition Oracle Universal Installer Oracle InterMedia Oracle InterMedia Locator Service Oracle JDBC Drivers Oracle SQLJ JRE 116 v5 JAVA JAVA VM, JAVA Core files, Jserver JVM, CORBA ORB, JDBC EJB JAVA Application,,,,, (spatial) JAVA Oracle7,Oracle8 Oracle8i JAVA SQL Net8 Oracle Spatial Oracle Time Series Oracle Visual Information Retrieval Oracle Programmer Oracle Net8 Assistant, Oracle Net8 Client, Oracle Net8 Server Spatial Cartridge Time Series Cartridge Object data type timestamped data Visual Information Retrieval Cartridge Image data,, Programmer2000 Precompilers, networking services, Client Software Oracle 81500 for Linux 1-4
Oracle intermedia Audio Oracle intermedia Image Oracle intermedia Text Oracle intermedia Video Oracle Audio Cartridge Digital audio data Oracle Image Cartridge Image data,, Oracle Context Cartridge Text data, Oarcle Video Cartridge Video data, Oracle 81500 for Linux 1-5
2 RedHat 60 http://technetoraclecokr root Linux 8i SGA(System Global Area) Linux IPC(Interprocess Commuication) SGA 1 ipcs, 2 /usr/src/linux/include/asm/ shmparamh /usr/src/linux/include/linux/ semh (SHMMAX) (SHMMIN) (SHMMNI) (SHMSEG) (SHMMSL) (SHMMNS) semop call (SEMOPM) (SEMVMX) SHMMAX * SHMSEG initsidora initsidora Oracle 81500 for Linux 1-6
SHMMAX 4294967295 (, 4GB ) SHMMIN 1 ( ) SHMMNI 100 SHMSEG 10 SEMMNS 200 SEMMNI 100 SEMMNI SEMMSL PROCESSES+10 initsidora PROCESSES+10 815 PROCESSES 50 SEMOPM 100 semop call SEMVMX 32767, Linux 8i, SHMMAX 4GB RedHat 16MB 8i Oracle 81500 for Linux 1-7
Oracle 8i 4 3 /u01, /u02, /u03, /u04, 3 Oracle 81500 for Linux 1-8
Database Administrator LINUX LINUX groupadd dba, [root /]# groupadd -g 5000 dba /etc/group dba LINUX useradd oracle ID oracle DBA ORACLE_HOME /bin/bash, /bin/sh, /bin/csh, /bin/ksh bash LINUX oracle, /home1/oracle, bash oracle root oracle Oracle 81500 for Linux 1-9
oracle (Permission) umask OUI(Oracle Universal Installer), profile login, bash_profile oracle 022 umask 022 DISPLAY IP X DISPLAY IP, X 0, Failed to connect to server Connection refused by server, Can t open display $ DISPLAY=workstation_name:0,0 $EXPORT DISPLAY $ xhost +server_machine_name oracle profile cshrc bash_profile ORACLE_BASE bash OFA(Optimal Flexible Architecture) /software_mount_point/app/oracle OFA ORACLE_HOME OFA $ORACLE_BASE/product/release LD_LIBRARY_PATH Shared Library LD_LIBARARY_PATH $ORACLE_HOME/lib ORACLE_SID Oracle System Identifier(SID) Oracle 81500 for Linux 1-10
PATH $ORACLE_HOME/bin, /bin, /usr/bin NLS_LANG Oracle ORA_NLS33 Oracle (US7ASCII) OUI DB $ORACLE_HOME/ocommon/nls/admin/data bash_profile ## Environment variables for Oracle export ORACLE_HOME=/home1/ora815 export NLS_LANG=AMERICAN_AMERICAKO16KSC5601; export PATH=$PATH:$ORACLE_HOME/bin export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib export ORACLE_SID=ORCL JDBC CLASSPATH JDK 11 export CLASSPATH=$CLASSPATH:$ORACLE_HOME/jdbc/lib/classes111zip export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/jdbc/lib JDK 10 export CLASSPATH=$CLASSPATH:$ORACLE_HOME/jdbc/lib/classes102zip export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/jdbc/lib Oracle 81500 for Linux 1-11
3 OUI(Oracle Universal Installer) OUI JRE116 v5 CD-ROM OUI JRE 116 v5 http://wwwblackdownorg, /usr/local/jre installed_path_of_jre/jre_116_v5 (symbolic link) CD-ROM Oracle CD-ROM RockRidge CD-ROM CD-ROM root, /cdrom ( ) ) $ su root # mount t iso9660 /dev/cdrom /cdrom # (mkdir /cdrom) # mount t iso9660 /dev/cdrom /cdrom # exit $ OUI OUI oracle CD-ROM runinstaller logout login ) $ cd /cdrom $ /runinstaller : root Oracle 81500 for Linux 1-12
OUI GUI (silent mode) response file Command line Oracle 81500 for Linux 1-13
OUI [ 1-1 ] Java-base OUI(Oracle Universal Installer) Next Deinstall Products, Installed Products Oracle 81500 for Linux 1-14
File Location [ 1-2 ] ORACLE_HOME Next ORACLE_BASE Path: ORACLE_BASE ( :/home/ora815) Oracle 81500 for Linux 1-15
UNIX Group Name [ 1-3 ] Oracle8i OS Group Name Oracle dba Oracle 81500 for Linux 1-16
orainstrootsh Alert [ 1-4 orainstrootsh ] Command line root /tmp/orainstall/orainstrootsh Retry Oracle 81500 for Linux 1-17
orainstrootsh [ 1-5 oraistrootsh ] root Oracle Inventory group dba [ 1-6 /etc/orainstloc ] Oracle 81500 for Linux 1-18
Available Products [ 1-7 ] Oracle8i 81500 Client/Server Client OUI Oracle8i Client Pro*C Oracle Programmer 815 Oracle 81500 for Linux 1-19
Installation Types [ 1-8 ] Custom Oracle 81500 for Linux 1-20
Available Product Components [ 1-9 ] 4 Product Languages Oracle 81500 for Linux 1-21
Language Selection [ 1-10 ] Korean OK Oracle 81500 for Linux 1-22
Component Location [ 1-11 ] Oracle 81500 for Linux 1-23
Create Database [ 1-12 ] Yes Typical/Minimal Yes Seed Database Database Configuration Assistant(DBCA) Oracle 81500 for Linux 1-24
Database Identification [ 1-13 ] Global Database Name, Net8 ORACLE_SID Oracle 81500 for Linux 1-25
Database File Location [ 1-14 ] oradata Oracle 81500 for Linux 1-26
Oracle Protocol support [ 1-15 ] TCP/IP Next Oracle 81500 for Linux 1-27
Summary [ 1-16 ] Previous Oracle 81500 for Linux 1-28
Caution [ 1-17 ] Command Line df k Yes Oracle 81500 for Linux 1-29
Caution [ 1-18 ] Command Line df k Yes Oracle 81500 for Linux 1-30
Install [ 1-19 ] Summary Oracle 81500 for Linux 1-31
Setup Privileges [ 1-20 ] root ORACLE_HOME/rootsh Oracle 81500 for Linux 1-32
rootsh [ 1-21 rootsh ] root ORACLE_HOME/rootsh local bin Oracle 81500 for Linux 1-33
Configuration Tools [ 1-22 ] Net8 DBCA Next DBCA Oracle 81500 for Linux 1-34
Configuration Tools [ 1-23 DBCA ] DBCA Oracle 81500 for Linux 1-35
Oracle Database Configuration Assistant(DBCA- Database Type) [ 1-24 DBCA- ] Typical Custom Custom (N) Oracle 81500 for Linux 1-36
Oracle Database Configuration Assistant(DBCA-Database Environment ) [ 1-25 ] Oracle 81500 for Linux 1-37
Oracle Database Configuration Assistant(DBCA-Number of Database Users ) [ 1-26 ] Oracle 81500 for Linux 1-38
Oracle Database Configuration Assistant(DBCA-Connection Mode) [ 1-27 Connection Mode ] Shared Service Mode, Multi-Threaded Server Dedicated Server Mode Oracle 81500 for Linux 1-39
Oracle Database Configuration Assistant(DBCA-Database Options) [ 1-28 ] Oracle 81500 for Linux 1-40
Oracle Database Configuration Assistant(DBCA-Database Information) [ 1-29 ] Change Character Set National Character Set KO16KSC5601FIXED NCHAR NVARCHAR2 NCLOB data type Oracle 81500 for Linux 1-41
Oracle Database Configuration Assistant(DBCA-Control File Parameter) [ 1-30 ],, Oracle 81500 for Linux 1-42
Oracle Database Configuration Assistant(DBCA-Tablespace Information) [ 1-31 ] Oracle 81500 for Linux 1-43
Oracle Database Configuration Assistant(DBCA-Redo Log) [ 1-32 ] Oracle 81500 for Linux 1-44
Oracle Database Configuration Assistant(DBCA-SGA Parameter) [ 1-33 SGA ] SGA SGA 1/2 Size Log Buffer Size OLTP Block Size (2048), DSS 32K Hybrid Oracle 81500 for Linux 1-45
Oracle Database Configuration Assistant(DBCA-Trace) [ 1-34 Trace ] Trace Oracle 81500 for Linux 1-46
Oracle Database Configuration Assistant(DBCA-Running Method) [ 1-35 ] Database, Oracle 81500 for Linux 1-47
Oracle Database Configuration Assistant(DBCA-Alert) [ 1-36 ] Yes Oracle 81500 for Linux 1-48
Oracle Database Configuration Assistant(DBCA-Progress) [ 1-37 ] Oracle 81500 for Linux 1-49
Oracle Database Configuration Assistant(DBCA-Progress) [ 1-38 ] Jserver, Oracle 81500 for Linux 1-50
Oracle Database Configuration Assistant(DBCA-Completion Alert) [ 1-39 ] OK Oracle 81500 for Linux 1-51
, oracle svrmgrl ( $ ) $ svrmgrl Oracle Server Manager Release 31500 Production (c) Copyright 1997, Oracle Corporation All Rights Reserved Oracle8 Release 81500 Production With the Java option PL/SQL Release 81500 Production SVRMGR> connect internal; Connected SVRMGR> startup; ORACLE instance started Total System Global Area Fixed Size Variable Size Database Buffers Redo Buffers Database mounted Database opened SVRMGR> quit Server Manager complete $ 71998864 bytes 64912 bytes 54974804 bytes 16777216 bytes 172032 bytes Oracle 81500 for Linux 1-52
oracle $ svrmgrl Oracle Server Manager Release 31500 Production (c) Copyright 1997, Oracle Corporation All Rights Reserved Oracle8 Release 81500 Production With the Java option PL/SQL Release 81500 Production SVRMGR> connect internal; Connected SVRMGR> shutdown; Database closed Database dismounted ORACLE instance shut down SVRMGR> quit Server Manager complete $ Oracle 81500 for Linux 1-53
Oracle 8i SCOTT, svrmgrl $ svrmgrl Oracle Server Manager Release 31500 Production (c) Copyright 1997, Oracle Corporation All Rights Reserved Oracle8 Release 81500 Production With the Java option PL/SQL Release 81500 Production SVRMGR> connect internal; Connected SVRMGR> create user scott identified by tiger default tablespace users temporary tablespace temp quota unlimited on users; Created SVRMGR> grant connect to scott; Processed SVRMGR> exit; sqlplus $ sqlplus scott/tiger SQL*Plus: Release 81500 - Production on Tue Oct 7 15:20:08 1999 (c) Copyright 1999 Oracle Corporation All rights reserved Connected to: Oracle8 Release 81500 Production With the Java option PL/SQL Release 81500 Production SQL>@?/sqlplus/demo/demobld Oracle 81500 for Linux 1-54
SQL> select table_name from tabs; TABLE_NAME ------------------------------ BONUS DEPT DUMMY EMP EXECUTABLES SALES SALGRADE SQL> Oracle 81500 for Linux 1-55
SCOTT 7, desc SQL> desc dept; Name Null? Type ------------------------------- -------- ---- DEPTNO DNAME LOC NUMBER(2) VARCHAR2(14) VARCHAR2(13) dept, dept Select SQL> select * from dept; DEPTNO DNAME LOC ---------- -------------- ------------- 10 ACCOUNTING NEW YORK 20 RESEARCH DALLAS 30 SALES CHICAGO 40 OPERATIONS BOSTON dept 4 row Oracle 81500 for Linux 1-56
Oracle 81500 for Linux 1-57