歯815설치1.PDF

Transcription

1 1 Memory Swap Space Disk Drives 128 MB (JAVA VM 256MB ) RAM 3 (1GB ) GB 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 for Linux 1-1

2 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 ( ) (*) : Net8 Oracle for Linux 1-2

3 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 response file non-interactive(silent), X-windows X-terminal emulator Oracle for Linux 1-3

4 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 for Linux 1-4

5 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 for Linux 1-5

6 2 RedHat 60 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 for Linux 1-6

7 SHMMAX (, 4GB ) SHMMIN 1 ( ) SHMMNI 100 SHMSEG 10 SEMMNS 200 SEMMNI 100 SEMMNI SEMMSL PROCESSES+10 initsidora PROCESSES PROCESSES 50 SEMOPM 100 semop call SEMVMX 32767, Linux 8i, SHMMAX 4GB RedHat 16MB 8i Oracle for Linux 1-7

8 Oracle 8i 4 3 /u01, /u02, /u03, /u04, 3 Oracle for Linux 1-8

9 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 for Linux 1-9

10 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 for Linux 1-10

11 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 for Linux 1-11

12 3 OUI(Oracle Universal Installer) OUI JRE116 v5 CD-ROM OUI JRE 116 v5 /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 for Linux 1-12

13 OUI GUI (silent mode) response file Command line Oracle for Linux 1-13

14 OUI [ 1-1 ] Java-base OUI(Oracle Universal Installer) Next Deinstall Products, Installed Products Oracle for Linux 1-14

15 File Location [ 1-2 ] ORACLE_HOME Next ORACLE_BASE Path: ORACLE_BASE ( :/home/ora815) Oracle for Linux 1-15

16 UNIX Group Name [ 1-3 ] Oracle8i OS Group Name Oracle dba Oracle for Linux 1-16

17 orainstrootsh Alert [ 1-4 orainstrootsh ] Command line root /tmp/orainstall/orainstrootsh Retry Oracle for Linux 1-17

18 orainstrootsh [ 1-5 oraistrootsh ] root Oracle Inventory group dba [ 1-6 /etc/orainstloc ] Oracle for Linux 1-18

19 Available Products [ 1-7 ] Oracle8i Client/Server Client OUI Oracle8i Client Pro*C Oracle Programmer 815 Oracle for Linux 1-19

20 Installation Types [ 1-8 ] Custom Oracle for Linux 1-20

21 Available Product Components [ 1-9 ] 4 Product Languages Oracle for Linux 1-21

22 Language Selection [ 1-10 ] Korean OK Oracle for Linux 1-22

23 Component Location [ 1-11 ] Oracle for Linux 1-23

24 Create Database [ 1-12 ] Yes Typical/Minimal Yes Seed Database Database Configuration Assistant(DBCA) Oracle for Linux 1-24

25 Database Identification [ 1-13 ] Global Database Name, Net8 ORACLE_SID Oracle for Linux 1-25

26 Database File Location [ 1-14 ] oradata Oracle for Linux 1-26

27 Oracle Protocol support [ 1-15 ] TCP/IP Next Oracle for Linux 1-27

28 Summary [ 1-16 ] Previous Oracle for Linux 1-28

29 Caution [ 1-17 ] Command Line df k Yes Oracle for Linux 1-29

30 Caution [ 1-18 ] Command Line df k Yes Oracle for Linux 1-30

31 Install [ 1-19 ] Summary Oracle for Linux 1-31

32 Setup Privileges [ 1-20 ] root ORACLE_HOME/rootsh Oracle for Linux 1-32

33 rootsh [ 1-21 rootsh ] root ORACLE_HOME/rootsh local bin Oracle for Linux 1-33

34 Configuration Tools [ 1-22 ] Net8 DBCA Next DBCA Oracle for Linux 1-34

35 Configuration Tools [ 1-23 DBCA ] DBCA Oracle for Linux 1-35

36 Oracle Database Configuration Assistant(DBCA- Database Type) [ 1-24 DBCA- ] Typical Custom Custom (N) Oracle for Linux 1-36

37 Oracle Database Configuration Assistant(DBCA-Database Environment ) [ 1-25 ] Oracle for Linux 1-37

38 Oracle Database Configuration Assistant(DBCA-Number of Database Users ) [ 1-26 ] Oracle for Linux 1-38

39 Oracle Database Configuration Assistant(DBCA-Connection Mode) [ 1-27 Connection Mode ] Shared Service Mode, Multi-Threaded Server Dedicated Server Mode Oracle for Linux 1-39

40 Oracle Database Configuration Assistant(DBCA-Database Options) [ 1-28 ] Oracle for Linux 1-40

41 Oracle Database Configuration Assistant(DBCA-Database Information) [ 1-29 ] Change Character Set National Character Set KO16KSC5601FIXED NCHAR NVARCHAR2 NCLOB data type Oracle for Linux 1-41

42 Oracle Database Configuration Assistant(DBCA-Control File Parameter) [ 1-30 ],, Oracle for Linux 1-42

43 Oracle Database Configuration Assistant(DBCA-Tablespace Information) [ 1-31 ] Oracle for Linux 1-43

44 Oracle Database Configuration Assistant(DBCA-Redo Log) [ 1-32 ] Oracle for Linux 1-44

45 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 for Linux 1-45

46 Oracle Database Configuration Assistant(DBCA-Trace) [ 1-34 Trace ] Trace Oracle for Linux 1-46

47 Oracle Database Configuration Assistant(DBCA-Running Method) [ 1-35 ] Database, Oracle for Linux 1-47

48 Oracle Database Configuration Assistant(DBCA-Alert) [ 1-36 ] Yes Oracle for Linux 1-48

49 Oracle Database Configuration Assistant(DBCA-Progress) [ 1-37 ] Oracle for Linux 1-49

50 Oracle Database Configuration Assistant(DBCA-Progress) [ 1-38 ] Jserver, Oracle for Linux 1-50

51 Oracle Database Configuration Assistant(DBCA-Completion Alert) [ 1-39 ] OK Oracle for Linux 1-51

52 , oracle svrmgrl ( $ ) $ svrmgrl Oracle Server Manager Release Production (c) Copyright 1997, Oracle Corporation All Rights Reserved Oracle8 Release Production With the Java option PL/SQL Release 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 $ bytes bytes bytes bytes bytes Oracle for Linux 1-52

53 oracle $ svrmgrl Oracle Server Manager Release Production (c) Copyright 1997, Oracle Corporation All Rights Reserved Oracle8 Release Production With the Java option PL/SQL Release Production SVRMGR> connect internal; Connected SVRMGR> shutdown; Database closed Database dismounted ORACLE instance shut down SVRMGR> quit Server Manager complete $ Oracle for Linux 1-53

54 Oracle 8i SCOTT, svrmgrl $ svrmgrl Oracle Server Manager Release Production (c) Copyright 1997, Oracle Corporation All Rights Reserved Oracle8 Release Production With the Java option PL/SQL Release 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 Production on Tue Oct 7 15:20: (c) Copyright 1999 Oracle Corporation All rights reserved Connected to: Oracle8 Release Production With the Java option PL/SQL Release Production SQL>@?/sqlplus/demo/demobld Oracle for Linux 1-54

55 SQL> select table_name from tabs; TABLE_NAME BONUS DEPT DUMMY EMP EXECUTABLES SALES SALGRADE SQL> Oracle for Linux 1-55

56 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 ACCOUNTING NEW YORK 20 RESEARCH DALLAS 30 SALES CHICAGO 40 OPERATIONS BOSTON dept 4 row Oracle for Linux 1-56

57 Oracle for Linux 1-57