D2印刷用.PDF

Size: px

Start display at page:

Download "D2印刷用.PDF"

ほのかのじま
5 years ago
Views:

1 [ D-2 ] Oracle8i on Linux

2 Agenda Oracle for Linux Miracle Linux Miracle Linux Miracle Linux Oracle8i for Linux Oracle8i for Linux Tips & Technique

3 Oracle for Linux 1999/03 O8 WGS for Linux R /12 O8i WGS for Linux R /6 2000/8 O8i EE for Linux R /9 O8i WGS for Linux R /9 Miracle Linux SE v1.0

4 Oracle for Linux 2000/9 Oracle8i Application Server /2 O8i EE for Linux R /2 Oracle9i Application Server R /3-4 O8i WGS for Linux R /?? Oracle Parallel Server for Linux R /?? Oracle 9i for Linux

5 Oracle on Linux EC /

6 Oracle8i for Linux Miracle Linux Standard Edition V1.0 TurboLinux Server 6.0/6.1 TurboLinux DataServer 6 for Oracle8i Red Hat Linux 6.0 ( ) 2001/2 Red Hat Linux 6.1/6.1J/6.1J /6.2/6.2J ( / ) Red Hat Linux Enterprise Edition Optimised for Oracle8i

7 Linux Linux Oracle NEC,OBC,, etc

8 Miracle Linux Oracle Linux Miracle Linux Standard Edition 50,000 Miracle Linux for PostgreSQL 20,000 Miracle Linux for Samba 20,000

9 Miracle Linux SE Oracle Oracle Oracle Oracle RAW I/O, 4GB

10 Miracle Linux SE Oracle Oracle8i PHP Apache + PHP

11 Oracle Oracle 8i R8.1.5 Oracle 8i R8.1.6 Oracle8i R8.1.7 V1.0 Install Navigator for Oracle R8.1.7

12 2000/9 Miracle Linux SE V /1H Miracle Linux SE V /2H Miracle Linux SE V2.0 kernel 2.4 IA64 Large File System, Logical Volume Manager, Journal File System, etc

13 Miracle Linux

14 Miracle Linux Miracle Linux

15 FTP 1 RAID SCSI Web Linux Oracle

16 Miracle Linux + Oracle8i CPU Pentium 200MHz 128MB 256MB HDD 2GB 2 400MB CD-ROM

17 BIOS CRT CD-ROM

18 OS DOS/Windows Linux

19 1 UNIX/Linux

20 OS DOS/Windows DOS/Windows C D Linux/UNIX /tmp / swap

21 MBR MBR

22 IDE MBR SCSI

23 OS Miracle Linux

24 swap /boot Linux BIOS 15MB 32MB / swap OK

25 /home /usr OS /var /tmp 128MB 1GB 64MB 128MB

26 - OK swap 400MB / - swap 400MB /boot 32MB / 2GB /u01 1GB Oracle /u02 Oracle

27 for Oracle swap 400MB /boot 15MB / 2GB /u01

28 X Window System

29 CD-ROM PC CD-ROM FD

31 for Oracle OFA Linux Normal

32 X

33 RDBMS Oracle Apache Samba Apache RDBMS Oracle Apache Samba RDBMS Oracle Samba

34 RDBMS X Window System Oracle8i GUI X Window System Linux

35 URL

36 X

37 Miracle Linux

38 Miracle Linux inetd TCP Wrapper telnet, ssh, FTP RPM Miracle Tools HDE Linux Controller CD

39 inetd TCP Wrapper tcpd inetd telnet ftp

40 inetd /etc/inetd.conf ftp stream tcp nowait root /usr/sbin/tcpd in.ftpd -l -a #telnet stream tcp nowait root /usr/sbin/tcpd in.telnetd -h # vi /etc/inetd.conf inetd # killall -HUP inetd

41 TCP Wrapper tcpd Miracle Linux Deny ALL tcpd /etc/hosts.allow /etc/hosts.deny [ daemon_list ] : [ host_list ] (: [ command ])

42 TCP Wrapper Miracle Linux /etc/hosts.deny ALL # less /etc/hosts.deny ALL: ALL telnet ftp /etc/hosts.allow # less /etc/hosts.allow in.ftpd : in.telnetd : ml10.miraclelinux.com ALL:

43 telnet /etc/inetd.conf # vi /etc/inetd.conf telnet stream tcp nowait root /usr/sbin/tcpd in.telnetd -h inetd /etc/hosts.allow in.telnetd : FTP

44 ssh ssh telnet rsh OpenSSH telnet Windows

45 ssh sshd # ps ax grep sshd /etc/hosts.allow ssh inetd $

46 ssh Windows Tera Term Pro TTSSH Tera Term SSH ttssh.exe, ttxssh.dll, libeay32.dll Tera Term Tera Term ttssh.exe

47 RPM Red Hat Linux

48 RPM rpm -ivh # rpm -ivh apache i386.rpm # rpm -Uvh apache i386.rpm # rpm -e apache Intel Miraclepkg

49 RPM # rpm -q apache # rpm -qi apache # rpm -qa # rpm -qip apache i386.rpm # rpm -qi p apache i386.rpm

50 Miracle Tools miraclenetcfg miracleprintcfg miraclepkg miracleservice miracleportcfg inetd

51 CD CD ATOK12 FEP Adobe Acrobat Reader HDE Linux Controller Netscape Communicator TrueType 5 JRE Miraclepkg index.html

52 Linux Web CD-ROM

53 Oracle8i for Linux

54 Oracle8i for Linux OFA Install Navigator for Oracle JRE Java Runtime Environment Oracle8i for Linux

55 OFA Optimal Flexible Architecture OFA Oracle Oracle8i Windows Oracle

56 OFA /u01 /app/oracle/ ORACLE_BASE /app/oracle/product/8.1.6 ORACLE_HOME /app/oracle/admin/<sid> init.ora,etc /u02/oradata/<sid> /u03/oradata/<sid> /u04/oradata/<sid>

57 1. swap Linux 5. Linux Oracle8i

58 Miracle Linux for Oracle 1 3 Oracle Install Navigator for Oracle Windows root GNOME R8.1.7 Web

59 Install Navigator oinstall, dba 3. Oracle Oracle Universal Installer

60 JRE Java Runtime Environment R8.1.5 JRE Miracle Linux CD # rpm -Uvh jre-1.1.6v5-2.i386.rpm Web # tar zxvf jre_1.1.6-v5-glibc-x86.tar.gz # ln -s /usr/jre116 /usr/local/jre R8.1.6, R8.1.7 Oracle JRE

61 JDK Java Development Kit Oracle8i JVM JServer R8.1.6,R8.1.7 R8.1.7 Oracle HTTP Server Powered by Apache JDK mod_jserv Oracle IBM JDK JDK # rpm -Uvh IBMJava118-SDK i386.rpm # ls -s /usr/jdk118 /usr/local/java

62 Install Navigator $ export LANG=C $ export LC_ALL=C $ cd /mnt/cdrom $./runinstaller &

63 Oracle UNIX Oracle oinstall

64 Custom

65 Product Languages Japanese

66 OSDBA,OSOPER OS SYSDBA SYSOPER UNIX

67 Yes Yes CD-ROM DB TIPS

68 JDK Oracle HTTP Server JDK1.1.8 JDK

69 Trouble Shooting Apache Oracle HTTP Server Oracle HTTP Server Apache Apache Apache Oracle HTTP Server Web

70 Oracle8i for Linux

71 Oracle8i for Linux Oracle OS / / Oracle

72 Oracle OS Oracle SYSDBA # useradd -g dba -G oinstall o816 # passwd o816 Oracle # useradd foo # passwd foo

73 ORACLE_BASE /u01/app/oracle ORACLE_HOME /u01/app/oracle/product/8.1.6 ORA_NLS33 ) $ORACLE_HOME/ocommon/nls/admin/data LD_LIBRARY_PATH $ORACLE_HOME/lib PATH $PATH:$ORACLE_HOME/bin NLS_LANG Japanese_Japan.JA16EUC ORACLE_SID orcl ORACLE_DOC $ORACLE_HOME/doc CLASSPATH $ORACLE_HOME/JRE, $ORACLE_HOME/product/jlib, etc

74 $ export ORACLE_SID=orcl.bashrc.bash_profile Install Navigator for Oracle.bashrc xterm LD_LIBRARY_PATH $..bashrc

75 Apache Oracle Install Navigator Apache /etc/httpd/conf/httpd.bootopt Oracle cgi PHP Oracle

76 Linux SQL*Plus sqlplus Server Manager svrmgrl Import imp Export exp SQL*Loader(sqlldr) Net8 Configuration Assistant netca Database Configuration Assistant dbasst

77 / $ sqlplus /nolog SQL> connect / as sysdba SQL> startup SQL> exit $ sqlplus /nolog SQL> connect / as sysdba SQL> shutdown [immediate] SQL> exit Server Manager internal R8.1.7

78 / Miracle Linux dbora 1./etc/oratab 2. dbstat,dbshut 3. /etc/rc.d/init.d/dbora 4.OS

79 /etc/oratab /etc/oratab SID:ORACLE_HOME:[Y N] /etc/oratab $ vi /etc/oratab orcl:/u01/app/oracle/product/8.1.6:y

80 dbstart R8.1.6 $ vi $ORACLE_HOME/dbstart 64 /PL /SQL (Release Version)/ {substr($3,1,3) ; /(PL /SQL JServer) (Release Version)/ {substr($3,1,3) ;

81 dbshut $ vi $ORACLE_HOME/dbshut shutdown Shutdown immediate

82 dbora ORA_HOME $ORACLE_HOME ORA_OWNER(oracle ) # vi /etc/rc.d/init.d/dbora ORA_HOME=/u01/app/oracle/product/8.1.7 ORA_OWNER=oracle if [! -f $ORA_HOME/bin/dbstart ] then echo "Oracle startup: cannot start" exit fi

83 OS # chkconfig --list dbora dbora 0:off 1:off 2:off 3:off 4:off 5:off 6:off # chkconfig dbora on # chkconfig --list dbora dbora 0:off 1:off 2:off 3:on 4:on 5:on 6:off

84 Oracle Linux/UNIX ps $ps ax grep ora ora_< >_<SID> SID orcl, SMON ora_smon_orcl

85 oerr oerr ora,exp $ oerr ora , 00000, "no data found" // *Cause: An application made reference to unknown or inaccessible data. // *Action: Handle this condition within the application or make appropriate // modifications to the application code. // NOTE: If the application uses Oracle-mode SQL instead of // ANSI-mode SQL, ORA will be generated instead of ORA R8.1.6 $ cd $ORACLE_HOME/rdbms/mesg $ ln -s oraus.msg oraja.msg

86 Oracle8i + Miracle Linux Tips & Technique

87 Oracle8i + Miracle Linux Tips & Technique kparam RAW I/O OS DB Database Assistant DB

88 kparam Linux/UNIX Oracle kparam Miracle Linux

89 kparam Miracle Linux (SHMMAX) Oracle semop 1 (SEMOPM) Oracle /proc

90 kparam Linux SHMMAX SHMOPM

91 /proc/sys/kernel SEMOPM SHMMAX SHMMAX 256MB # echo > /proc/sys/kernel/shmmax SEMOPM 256 # echo 256 > /proc/sys/kernel/semopm

92 # vi /etc/sysconfig/kparam /etc/sysconfig/kparam /proc/sys/kernel/semopm 100 /proc/sys/kernel/shmmax /etc/sysconfig/kparam /proc/sys/kernel/semopm 256 /proc/sys/kernel/shmmax

93 RAW I/O RAW I/O I/O I/O

94 RAW I/O Linux Oracle8i R8.1.6 OS OS 2GB Linux RAW I/O Oracle8i for Linux Intel RAW

95 RAW I/O raw 5. /etc/rc.d/rc.sysinit

96 RAW I/O 1 fdisk raw /dev/sda5, /dev/sda6 # raw /dev/raw/raw1 /dev/sda5 # raw /dev/raw/raw2 /dev/sda6

97 RAW I/O 2 # raw -qa -qa /dev/raw/raw1: bound to major 8, 8, minor minor 5 5 /dev/raw/raw1: bound to major 8, 8, minor minor 6 6 /dev/raw/rawn oracle # chown oracle /dev/raw/raw1 # chgrp oinstall /dev/raw/raw1

98 RAW I/O 3 raw REDO raw 2 $ sqlplus CREATE system/manager TABLESPACE ts1 DATAFILE /dev/raw/raw1 SIZE 100M SQL> CREATE TABLESPACE ts1 2> DATAFILE /dev/raw/raw1 SIZE 100M;

99 RAW I/O 4 OS /etc/rc.d/rc.sysinit raw /dev/raw/raw1 /dev/sda5 raw /dev/raw/raw2 /dev/sda6 Oracle alert.log

100 CPU top vmstat sysstat(sar, mpstat, iostat) Web Miracle Linux V1.1

101 Oracle8i Oracle8i Oracle8i JVM SGA db_block_buffers * db_block_size + shared_pool_size + large_pool_size + java_pool_size + log_buffer 1 init.ora

102 Oracle8i Oracle Oracle8i JVM java_pool_size shared_pool_size Oracle8i JVM java_pool_size 0 R MB 10MB OK shared_pool_size

103 Oracle Oracle Linux Oracle Net8 Export,Local Import Windows Export( ), FTP, Linux Import Windows Export, FTP, Linux Import ( ), SQL*Loader

104 Export/Import Export Oracle Export Export Export

105 1. DB Export Windows Linux Export export export 2. Export Windows Linux Import export

106 1. Net8 DB Windows Linux Export 2. Export export Windows Linux Import export Oracle7 Export Oracle8/8i Oracle8/8i catexp7.sql

107 DB Assistant R8.1.6 Database Assistant $ ps ax grep jre 3. $ kill 9 pid

108 DB Assistant 1. JRE116v5 # rpm -Uvh jre-1.1.6v5-2.i386.rpm Web # tar zxvf jre_1.1.6-v5-glibc-x86.tar.gz # ln -s /usr/jre116 /usr/local/jre 2. dbassist $ vi $ORACLE_HOME/bin/dbassist JAVA_HOME=$ORACLE_HOME/JRE JAVA_HOME=/usr/local/bin

109 R8.1.6,R8.1.7 OUI Oracle NLS Oracle Java

110 Oracle NLS Oracle 1 NLS:National Language Support NLS_LANG NLS_LANG OS Windows

111 NLS_LANG _ Japanese_Japan.JA16EUC EUC Japanese_Japan.JA16SJIS JIS American_America.US7ASCII American_America.JA16EUC EUC

112 Java NLS Oracle Universal Installer Oracle Enterprise Manager Assistant NLS_LANG NLS_LANG LANG LC_ALL

113 DB Oracle8i JVM JServer Oracle8i JVM Oracle8i JVM DB CD-ROM R8.1.5

114 DB 1. Oracle8i 2. NLS_LANG 3. Database Assistant CD-ROM CD-ROM DB

115 Dababase Configuration Assistant ALTER DATABASE NLS_LANG Windows NLS_LANG NLS_LANG Linux/UNIX Database Configuration Assistant NLS_LANG

116 Oracle8i for Linux R8.1.7

117 Oracle8i R8.1.7 for Linux Java Oracle8i JVM accelerator Oracle Servlet Engine Oracle JavaServer Pages XML Oracle HTTP Server(Powered by Apache) Oracle Enterprise Manager Linux

118 Oracle Enterprise Manager Oracle8i R8.1.7 Linux Oracle Enterprise Manager

119 Oracle Parallel Server for Linux H/W

120 Intel 64bit(IA64)CPU 4GB OLAP U.S. OTN (8.1.6) 9i

121 Web & Miracle Linux Users #guide

122 Web & Oracle Technology Network Japan Linux & Windows Linux Oracle Technology Network

123

o8i_816_LinuxTips_02_1015

o8i_816_LinuxTips_02_1015 Oracl8i on Miracle Linux Page 1 1 Ajenda Miracle Linux Linux + Oracle Miracle Linux Miracle Linux Oracle8i for Linux Oracle8i for Linux Tips & Technique Miracle Linux Oracle8i for Linux Windows Oracle