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 Oracle Page 2 2
Linux Linux Oracle NEC,OBC,, etc OS DBMS DB DB OS OS Page 3 3
Miracle Linux Oracle Oracle Linux Page 4 4
Miracle Linux Standard Edition Miracle Linux Standard Edition V1.0 ( ) 50,000 Oracle Oracle Oracle Oracle RAW I/O, 4GB Page 5 5
Oracle Oracle8i PHP Apache + PHP kernel 2.2.16 glibc 2.1.3 XFree86 3.3.6 Apache 1.3.12 Samba 2.0.7 PHP 3.0.15 Oracle Page 6 6
Oracle Oracle 8i R8.1.5 Oracle 8i R8.1.6 Oracle8i R8.1.7 V1.0 Install Navigator for Oracle R8.1.7 2000/9 Miracle Linux SE V1.0 2001/1H Miracle Linux SE V1.1 2001/2H Miracle Linux SE V2.0 kernel 2.4 IA64 Large File System, Logical Volume Manager, Journal File System, etc Page 7 7
Web Web Web C/S Page 8 8
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
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
Miracle Linux Miracle Linux Miracle Linux Page 11 11
http://www.miraclelinux.com/support/hardware.html FTP 1 Linux Oracle Miracle Linux + Oracle8i CPU Pentium 200MHz 128MB 256MB HDD 2GB 2 400MB CD-ROM Page 12 12
BIOS CRT CD-ROM OS DOS/Windows Linux Page 13 13
1 UNIX/Linux OS DOS/Windows DOS/Windows C D Linux/UNIX /tmp / swap Page 14 14
MBR MBR IDE MBR SCSI Page 15 15
OS Miracle Linux swap /boot Linux BIOS 15MB 32MB / swap OK Page 16 16
/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
for Oracle swap /boot / /u01 400 MB 15 MB 2 GB X Window System Page 18 18
CD-ROM PC CD-ROM FD Page 19 19
for Oracle OFA Linux Normal X Page 20 20
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.html 16bpp(Bit Par Pixel) =65536 Page 22 22
X Miracle Linux Page 23 23
Miracle Linux inetd TCP Wrapper telnet, ssh, FTP RPM Miracle Tools HDE Linux Controller CD inetd TCP Wrapper inetd telnet ftp Page 24 24
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
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 : 192.168.0.1 192.168.0.2 in.telnetd : ml10.miraclelinux.com ALL: 192.168.0. 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 : 192.168.0.1 Page 26 26
ssh ssh telnet rsh OpenSSH telnet Windows ssh sshd # ps ax grep sshd /etc/hosts.allow ssh inetd $ ssh @ Page 27 27
ssh Windows Tera Term Pro http://hp.vector.co.jp/authors/va002416/ TTSSH Tera Term SSH http://www.zip.com.au/~roca/ttssh.html 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 : 192.168.0.1 Page 28 28
RPM Red Hat Linux RPM rpm -ivh # rpm -ivh apache-1.3.12-6.i386.rpm Intel # rpm -Uvh apache-1.3.12-6.i386.rpm # rpm -e apache Miraclepkg Page 29 29
RPM # rpm -q apache # rpm -qi apache # rpm -qip apache-1.3.12-6.i386.rpm # rpm -qi p apache-1.3.12-6.i386.rpm Miracle Tools miraclenetcfg miracleprintcfg miraclepkg miracleservice miracleportcfg inetd Page 30 30
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
Linux Web CD-ROM http://www.miraclelinux.com/support/index.html Trouble Shooting # cat /proc/meminfo lilo FAQ CD-ROM CD BIOS Page 32 32
Oracle8i for Linux Oracle8i for Linux OFA Install Navigator for Oracle JRE Java Runtime Environment Oracle8i for Linux Page 33 33
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
swap Linux Linux Oracle8i Linux Windows NT/2000 2 6 Windows Linux/UNIX Oracle Page 35 35
Miracle Linux Windows 1 swap for Oracle 400MB 2 3 Install Navigator for Oracle Oracle 4 6 root GNOME Page 36 36
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 http://www.blackdown.org # tar zxvf jre_1.1.6-v5-glibc-x86.tar.gz # ln -s /usr/jre116 /usr/local/jre Page 37 37
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
Custom Product Languages Japanese Page 39 39
OSDBA,OSOPER OS SYSDBA SYSOPER UNIX Yes Yes CD-ROM DB TIPS Page 40 40
Oracle8i for Linux Oracle8i for Linux Oracle OS / / Oracle Page 41 41
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
$ 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
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
/ 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
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
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
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
oerr oerr ora,exp $ oerr ora 100 00100, 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-01403 will be generated instead of ORA-00100. R8.1.6 $ cd $ORACLE_HOME/rdbms/mesg $ ln -s oraus.msg oraja.msg Oracle8i + Miracle Linux Tips & Technique Page 49 49
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
kparam Miracle Linux (SHMMAX) Oracle semop 1 (SEMOPM) Oracle /proc kparam Linux SHMMAX SHMOPM Page 51 51
/proc/sys/kernel SEMOPM SHMMAX SHMMAX 256MB # echo 268435456 > /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 134217728 /etc/sysconfig/kparam /proc/sys/kernel/semopm 256 256 /proc/sys/kernel/shmmax 268435456 Page 52 52
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
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
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
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) http://perso.wanadoo.fr/sebastien.godard/ Miracle Linux SE V1.1 Page 56 56
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
Enterprise Edition Workgroup Server Enterprise Edition Option etc Enterprise, Workgroup http://www.oracle.co.jp/o8i/matrix/index.html DB Assistant R8.1.6 Database Assistant $ ps ax grep jre $ kill 9 pid Page 58 58
DB Assistant JRE116v5 # rpm -Uvh jre-1.1.6v5-2.i386.rpm Web http://www.blackdown.org # 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
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
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
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
Web & http://www.oracle.co.jp/linux/ http://www.miraclelinux.com Miracle Linux Users miracle-users-ctl@miraclelinux.com #guide Web & Oracle Technology Network Japan http://technet.oracle.co.jp Linux & Windows Linux Oracle Technology Network http://technet.oracle.com Page 63 63
Page 64 64