o8i_816_LinuxTips_02_1015

Size: px

Start display at page:

Download "o8i_816_LinuxTips_02_1015"

ようじろうおまた
6 years ago
Views:

1 Oracl8i on Miracle Linux Page 1 1

2 Ajenda Miracle Linux Linux + Oracle Miracle Linux Miracle Linux Oracle8i for Linux Oracle8i for Linux Tips & Technique Miracle Linux Oracle8i for Linux Windows Oracle Oracle Page 2 2

3 Linux Linux Oracle NEC,OBC,, etc OS DBMS DB DB OS OS Page 3 3

4 Miracle Linux Oracle Oracle Linux Page 4 4

5 Miracle Linux Standard Edition Miracle Linux Standard Edition V1.0 ( ) 50,000 Oracle Oracle Oracle Oracle RAW I/O, 4GB Page 5 5

6 Oracle Oracle8i PHP Apache + PHP kernel glibc XFree Apache Samba PHP Oracle Page 6 6

7 Oracle Oracle 8i R8.1.5 Oracle 8i R8.1.6 Oracle8i R8.1.7 V1.0 Install Navigator for Oracle R /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 Page 7 7

8 Web Web Web C/S Page 8 8

9 Web Web Apache Linux PHP Browser HTML PHP Web Oracle HTTP Server R8.1.7 Browser Oracle HTTP Server Linux Java Servlet EJB Java Server Pages PL/SQL Server Pages Page 9 9

10 Web Browser Load Balancer ias Oracle8i Linux Solaris, HP-UX,AIX,etc Many Web Server Fat DB Server C/S VB,Developer ODBC Windows OLE-DB etc C/S Application Oracle8i Linux DB Server Page 10 10

11 Miracle Linux Miracle Linux Miracle Linux Page 11 11

12 FTP 1 Linux Oracle Miracle Linux + Oracle8i CPU Pentium 200MHz 128MB 256MB HDD 2GB 2 400MB CD-ROM Page 12 12

13 BIOS CRT CD-ROM OS DOS/Windows Linux Page 13 13

14 1 UNIX/Linux OS DOS/Windows DOS/Windows C D Linux/UNIX /tmp / swap Page 14 14

15 MBR MBR IDE MBR SCSI Page 15 15

16 OS Miracle Linux swap /boot Linux BIOS 15MB 32MB / swap OK Page 16 16

17 /home /usr OS /var /tmp MB GB MB MB - OK swap 400MB / - swap 400MB /boot 32MB / 2GB /u01 1GB Oracle /u02 Oracle Page 17 17

18 for Oracle swap /boot / /u MB 15 MB 2 GB X Window System Page 18 18

19 CD-ROM PC CD-ROM FD Page 19 19

20 for Oracle OFA Linux Normal X Page 20 20

21 RDBMS Oracle Apache Samba Apache RDBMS Oracle Apache Samba RDBMS Oracle Samba RDBMS X Window System Oracle8i GUI X Window System Linux Page 21 21

URL http://www.miraclelinux.com/tech/index2.

22 URL 16bpp(Bit Par Pixel) =65536 Page 22 22

23 X Miracle Linux Page 23 23

24 Miracle Linux inetd TCP Wrapper telnet, ssh, FTP RPM Miracle Tools HDE Linux Controller CD inetd TCP Wrapper inetd telnet ftp Page 24 24

25 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 TCP Wrapper tcpd Miracle Linux Deny ALL tcpd /etc/hosts.allow /etc/hosts.deny [ daemon_list ] : [ host_list ] (: [ command ]) Page 25 25

26 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: 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 : Page 26 26

27 ssh ssh telnet rsh OpenSSH telnet Windows ssh sshd # ps ax grep sshd /etc/hosts.allow ssh inetd $ Page 27 27

28 ssh Windows Tera Term Pro TTSSH Tera Term SSH ttssh.exe, ttxssh.dll, libeay32.dll Tera Term Tera Term ttssh.exe FTP /etc/inetd.conf # vi /etc/inetd.conf ftp stream tcp nowait root /usr/sbin/tcpd in.ftpd -l -a inetd /etc/hosts.allow in.ftpd : Page 28 28

29 RPM Red Hat Linux RPM rpm -ivh # rpm -ivh apache i386.rpm Intel # rpm -Uvh apache i386.rpm # rpm -e apache Miraclepkg Page 29 29

30 RPM # rpm -q apache # rpm -qi apache # rpm -qip apache i386.rpm # rpm -qi p apache i386.rpm Miracle Tools miraclenetcfg miracleprintcfg miraclepkg miracleservice miracleportcfg inetd Page 30 30

31 HDE Linux Controller HDE Linux Controller Miracle Linux Standard Edition V1.0 CD CD ATOK12 Adobe Acrobat Reader HDE Linux Controller Netscape Communicator TrueType 5 JRE Miraclepkg index.html Page 31 31

32 Linux Web CD-ROM Trouble Shooting # cat /proc/meminfo lilo FAQ CD-ROM CD BIOS Page 32 32

33 Oracle8i for Linux Oracle8i for Linux OFA Install Navigator for Oracle JRE Java Runtime Environment Oracle8i for Linux Page 33 33

34 OFA Optimal Flexible Architecture OFA Oracle Oracle8i Windows Oracle 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> Page 34 34

35 swap Linux Linux Oracle8i Linux Windows NT/ Windows Linux/UNIX Oracle Page 35 35

36 Miracle Linux Windows 1 swap for Oracle 400MB 2 3 Install Navigator for Oracle Oracle 4 6 root GNOME Page 36 36

37 Install Navigator oinstall, dba Oracle Oracle Universal Installer JRE Java Runtime Environment R8.1.5 JRE R8.1.6, R8.1.7 JRE # 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 Page 37 37

38 R8.1.5,R8.1.6 Install Navigator $ export LANG=C $ export LC_ALL=C $ cd /mnt/cdrom $./runinstaller & Oracle UNIX Oracle oinstall Page 38 38

39 Custom Product Languages Japanese Page 39 39

40 OSDBA,OSOPER OS SYSDBA SYSOPER UNIX Yes Yes CD-ROM DB TIPS Page 40 40

41 Oracle8i for Linux Oracle8i for Linux Oracle OS / / Oracle Page 41 41

42 Oracle OS Oracle SYSDBA # useradd -g dba -G oinstall o816 # passwd o816 Oracle # useradd foo # passwd foo 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 Page 42 42

43 $ export ORACLE_SID=orcl.bashrc.bash_profile Install Navigator for Oracle.bashrc xterm LD_LIBRARY_PATH $..bashrc Install Navigator Apache httpd.bootopt Oracle cgi PHP Oracle Page 43 43

44 Linux SQL*Plus sqlplus Server Manager svrmgrl Import imp Export exp SQL*Loader(sqlldr) Net8 Configuration Assistant netca Database Configuration Assistant dbasst / $ 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 Page 44 44

45 / Miracle Linux dbora 1./etc/oratab 2. dbstat,dbshut 3. /etc/rc.d/init.d/dbora 4.OS /etc/oratab /etc/oratab SID:ORACLE_HOME:[Y N] /etc/oratab orcl:/u01/app/oracle/product/8.1.6:y $ vi /etc/oratab Page 45 45

46 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) ; dbshut $ vi $ORACLE_HOME/dbshut shutdown Shutdown immediate Page 46 46

47 dbora ORA_HOME $ORACLE_HOME ORA_OWNER(oracle ) # vi /etc/rc.d/init.d/dbora ORA_HOME=/u01/app/oracle/product/8.1.6 ORA_OWNER=oracle if [! -f $ORA_HOME/bin/dbstart ] then echo "Oracle startup: cannot start" exit fi 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 Page 47 47

48 Oracle Linux/UNIX ps $ps ax grep ora ora_< >_<SID> SID orcl, SMON ora_smon_orcl $ export ORACLE_SID=orcl $ sqlplus system/manager Page 48 48

49 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 Oracle8i + Miracle Linux Tips & Technique Page 49 49

50 Oracle8i + Miracle Linux Tips & Technique kparam RAW I/O DB Enterprise Edition vs Workgroup Server Database Assistant DB kparam Linux/UNIX Oracle kparam Miracle Linux Page 50 50

51 kparam Miracle Linux (SHMMAX) Oracle semop 1 (SEMOPM) Oracle /proc kparam Linux SHMMAX SHMOPM Page 51 51

52 /proc/sys/kernel SEMOPM SHMMAX SHMMAX 256MB # echo > /proc/sys/kernel/shmmax SEMOPM 256 # echo 256 > /proc/sys/kernel/semopm # vi /etc/sysconfig/kparam /etc/sysconfig/kparam /proc/sys/kernel/semopm 100 /proc/sys/kernel/shmmax /etc/sysconfig/kparam /proc/sys/kernel/semopm /proc/sys/kernel/shmmax Page 52 52

53 RAW I/O RAW I/O I/O I/O RAW I/O Linux Oracle8i R8.1.6 raw OS Oracle8i for Linux Intel RAW / Page 53 53

54 RAW I/O raw /etc/rc.d/rc.sysinit RAW I/O 1 fdisk raw /dev/sda5, /dev/sda6 # raw /dev/raw/raw1 /dev/sda5 # raw /dev/raw/raw2 /dev/sda6 Page 54 54

55 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 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; Page 55 55

56 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 CPU top vmstat sysstat(sar, mpstat, iostat) Miracle Linux SE V1.1 Page 56 56

57 DB Windows NT/2000 Oracle Linux Oracle Net8 Export Windows Export( ), FTP, Linux Import Windows Export, FTP, Linux Import ( ), SQL*Loader DB Link Net8 DB Windows Linux Export Export export Windows Linux Import export Page 57 57

58 Enterprise Edition Workgroup Server Enterprise Edition Option etc Enterprise, Workgroup DB Assistant R8.1.6 Database Assistant $ ps ax grep jre $ kill 9 pid Page 58 58

59 DB Assistant 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 dbassist $ vi $ORACLE_HOME/bin/dbassist JAVA_HOME=$ORACLE_HOME/JRE JAVA_HOME=/usr/local/bin R8.1.6 OUI R8.1.5, R8.1.6 OUI Oracle NLS Oracle Java Page 59 59

60 Oracle NLS Oracle 1 NLS:National Language Support NLS_LANG NLS_LANG OS Windows NLS_LANG _ Japanese_Japan.JA16EUC EUC Japanese_Japan.JA16SJIS JIS American_America.US7ASCII American_America.JA16EUC EUC Page 60 60

61 Java NLS Oracle Universal Installer Oracle Enterprise Manager Assistant NLS_LANG NLS_LANG LANG LC_ALL DB Oracle8i JVM JServer Oracle8i JVM DB Assistant Oracle8i JVM DB CD-ROM R8.1.5 Page 61 61

62 DB Oracle8i NLS_LANG Database Assistant CD-ROM CD-ROM DB Dababase Configuration Assistant ALTER DATABASE NLS_LANG NLS_LANG Windows NLS_LANG NLS_LANG Linux/UNIX Database Configuration Assistant NLS_LANG Page 62 62

63 Web & Miracle Linux Users #guide Web & Oracle Technology Network Japan Linux & Windows Linux Oracle Technology Network Page 63 63

64 Page 64 64

D2印刷用.PDF

D2印刷用.PDF [ D-2 ] Oracle8i on Linux Agenda Oracle for Linux Miracle Linux Miracle Linux Miracle Linux Oracle8i for Linux Oracle8i for Linux Tips & Technique Oracle for Linux 1999/03 O8 WGS for Linux R8.0.5 1999/12