I have made an additional section to the handbook chapter "Linux Binary Compatibility". begin 644 ora8i.sgml.gz M'XL("/TE:ST"`V]R83AI+G-G;6P`S5MM<]I($OYL5_D_S&6W;O$M2,'."W&` M6@RRS08#"R39W!?7(`U&L:31:B1C[Z^_[AF](VPGSE:=JQ*#9J:GWZ;[Z1Z9 MD+9@9M@DMM5YX=A>=,?<J,$#:CJL9;_H'NP3^%%S;&_%XP?PB$;AF@?7`8]\ M>+@7?\>/,+BR`Q%ZU&7=.0NNV7U;SYZH&2(*Y+</L(C=MO7DNQHUN1<&]K+; M5[^CD%ED>4_:>C*`.^K9ENU_-1KD1I+Z3?!5Z-"E%D2DT<CXU8L,JV=EN=JA M'3JL._1$2!U0QS692%60EMW6U=C!?CS5]BQV%[+`S?;P`]NEP7V7^KYCFS2T MN2?:>O(TG0:[<L_"1^W<S*[:"AC-/9,LQI,3IO,;Y^QSE&V@.)T&;$5-EC&> M<$D#VEVL;4$L;D8N\T)B,6&"6ID@X9H1/^`F$X+P%;$K-#$[)K66UM3>'I(5 M#TA"=X3>0\`^G%#B4G-M>XP$D>?AXK.`L=/Y@+S27C=FQLCHS0U0##*2-T4B MPD-2Y6R#O*I=#>_6#KB'LI3%+8I]26\8`5]CY)Y'9$UO&5GR<(T>ZS#I@/(0 M7"VI8(TW6A,=-QX@U+/0U4HS+78;<NZ(\FR?FC?T&C0:JY!9&NDY@DNN<5J! M%CBVZ]-0ES1U%IJZ&])EGIX;B9"P.UN$&OEL@RM'(;%#22W9(2`K:CM"2V3. M',X$]7O=?X-A73_4`L[#]Z0="1;8GA^%76+Z1&ZZ`D)+4LT,V"A;`?92-!,7 M3!3\!=3J,3BNX`86WW@.IQ9J+F$R-MCO@P^-)OA0BZR`IY13H!+!KC<D"IS. MBU7H:TL'](B$-#B[+[I;CX`I7-#54G=ZLM0A#<C=UU6??+5NFLW6U>UQX]JQ MEV;C"!@[UF!86_Y]5-)&)`)]ER:>N*]I5=!,>7@N=<<C#4$T(DD_DQ8SUYS( M_^PWK3>D6^)[:7LZ#<SU<_6Q=KE%?KW[AZA;/]Z"[HUE!\3A)G5^'"44^/FR M_@BF8A?2\D[YE=[2AR-`%L(?"M_]@$%FBX-WG%*>'+U/&20<%;I-ZJ4A19&I MR^=)[!$L))$/F0B$]%D`P99ENV@$PY2`&.I8!!A2$2J"O`H@!3_FF(LWD>F8 M7$>VQ:I"#8AZ7,10-RSPF-,((\Q_&93*J>*#G$$6<D8F^%X.6:2(0E$C83PW M>5P$`WNX6++6$VE*Q\C[L#Q;BI,8#)>X],YV(Y<(^V^&:$"L:0"S7.;RX%XC M9,")QT'/@BG8YMC`"76Z\XO+R]Z?;3WYKE2;@`!M]T1)!H")RP+FW(.1'3," M5F%/3'?`06GE]'R>VT4EZ!P?,#S\KY'-`)87:R`MO<AB*T`H58P7J,*:'O@8 M@`20@/L2TTGO6S(4'%Q'2!I;^E:^0L@98"1V1UW?82<YSP%+!?PZH*X#*1V, MVOV)S.]%R%SRJ:AGZ9M@>+H$Z^%REP%GL&G"3/(S_S+_!`*DWW\"3DPGLA#P M^#X/0@G7"K0KB"0:Z#3?'+=>`1%P`D)='GGAE@L`.XAP:J]N`/<1^[CUYG`7 MQ<Z+6DKZ/]/>N7&%IOFU>?@B.Q>[?A0/Q9T%NY;(5;IF;7D?,K%C[^&X<Y2C M!-;Y7DKC8:?Y\F6>)R]RE^@69;V`Y;W07MG5=KJXG!OG0.IQ\02!V)7@<?2: MO),PE_I8\HAO\Q#C40])"5=0,,IJR*D@69<7/SD-0K)=37`^ZKQIDAUZS:1$ M5=C6#I[F>1*5RQ]G9#*]!,F:U8Q@%E$5G60$"',?`Y13,HL+EH)30?Z*6/2- MIKF<GS]BFB)QS`.%$")30)IE9*B9,UDC");&+HSQ$50.$/1!GU[((#9;&,I0 M2I4D*C*<3.['C^0\U3=H4-/$<*&2WMY6WHL344_-RM?5<?:2&(&!ZI*<%1,D M7[$&HD+FJXU,WF8R]5Y%:!F*X^D:!GM2I@'91?C,M`$E<0]R3+BF82$!7MNW M*BN`CFA<KH@U<QS,!)9%=A5MB%>A;%SGB[:0)_V09`E64Y*:*)66$K%(!\51 M:>TL:^?%0AZ_@0>M4&<_`?WM^1LBNR04A&UXQ%K29^))I(C?D*!R$=*XEG0; M+B+-:AD>V?1)#IG#?(U*#%8)/3,8!1H/+(E6>6R)7T0%@I+^`^$[L3>:4G"7 MD=S^Y)8&-H8!J,\O`(.D>"S7(<`8I8.&%)+)$N#99-;#B92@2?&<HFM8%*IR M*ICR\S;L18/NJ#<^;^OJ,RZ)/&`F5)Y-;[EM838!+ER1WV!CA^MB*T$173(X M<#[4V\H#8UP-$UVDG?/"-4BK*]OJ&NR`(SDG/"$E+XS;987H!4+V1\;5:6]N M=)#6>X!-,O+E!@[VXR\7DTNC\W-N!-MFY14XZ6!_-+@:#4]GO=F7JVEO<9&N MPE'PN66ZJC0QW6L^''30!&7R\/Q@7Y+<\N"3XA.Q_0C+4'@:$_@9_Z^8H1;* M_]3'>-E).EHD@$_3:O*D(*F<&PN@Q(M<*F[(RZ,C^(AN0I3S;"65\HE[>K6W MU4A-#AFI+O#.L$N,_HUE73XH@U;,@H?*TZ>189A@<8M[3.;X#2<;>B].<F<= M#C&<.`LE*GJ@E!'R=K<(0N,TQ/W[I%)%/).=60N6R;8T1@#@;A/8H<SP+K-L MJE7YNEZYU=,8D*&D$'7P8(FDFB"EM8^&8],GC0"BK@43]($M;IIZ$'G#M(M8 M&$F*;.WA>+Q3R+9>K7W#EA45F`J+=&E>V>($4\H&N+)[%F+R'.8C2Q[P%!WW M^)5Y_.I@OTT6%S.C-YA?G8UZYQT/-(@)OM%H'.QWBV/7*-+.`T!4G$VWCC6# MH4HB.\WV[$+'%D1;,B5;7!:";V(:X)$@*TAQB,>>Y:9%1E^;KU'<WV?&U6C2 M[RV&DW%'TW3@\IKI?7`&.")04\1Q6A,;2_L:,%WV8?6F/H!\<H:.I1MW/D54 MJ`)1JJL"X0=:F"4N=^OS.\Y%R<3F,4H\GWR<]8U,5IAE168HM*\T2+F/)Q6< MNVKZZ_H;$_[],YILD\G'X9-I\L@&FF^1JO:RDNYWV*9;9*%"']_/S//L7ATJ MMFL1=8$%6"2D0;B5%`IY8YE=0?U)/MN>Q3?9_0B9Q4-4W7O)&"G/+H^35?I` MXM<Z@!X1,76#PQV';W`QZ-H%\4^V^*T.QTBH>/FB%:/OP[!717P,1.IB4`90 M$!2`:@`9&&"@ZZ^IL$570'UGJJLFV15&W0`R3(:W^%24)ZI*]M@=0%BYMX1\ M'\?#/U55H"`HWNXL::;)SVN8J"1D5AUUKFH9,[#],!<S0;%HJQGD)*U8*JD6 M868"3%MY`\35SRXMRV^2"\$<4`1:)CG7R&WL(77`";)G::XY%]AZAG+<#VSX M>$D]</Z`-'+YU`X![T/9CYDJ0@J8Y-DM[*+8E=6AZB9CM*=XOV<QQ4&.3`P; M+A:+*;`7W*(K315S9*+*\KJL`7_'+OLT"4>YDV&[B-NH5TH,4NI!O"'Z/I8& MG`,S4!"GXB-K)L4*OWA;"&K!"\-MO-+6J_:3MY>QWF#I>+(@"<VD%`$W]%;V M=:0Z)7"NP-.0BK;C,%?5;#)?-M#\A9(MN=3&431ND+A0_L(@K=RD)VQ=7M<5 ME*)FK/+-V@;8D8L5/@N@\':9ZB-#6-CICW59[\&1PY`EDSN-*_?8YTU9T97* M_V#+[S72`[2#;0A58F5Q)8:\/)&TCI_EC;4=IHI7MQM)#$K/.=[=2W+Q`,2\ M^.XDB8:YT[F,;\1S]&ZI$S'5U\:FNRHG<\5$6F'BIL5A*(K2T0W6N1`^\IZ< M][6M'OA;\RWFR/[%Y/.X\T*V`L#A-MZ+-,\E0TGYDXZ_,]])K&?,%_$PCH90 MP&:+X\'<0.N-V9*IOO?Y0T==.6YNTOGR84)*#K1:9JN5L9AQ6&*PQ!^P=U1_ M=VS*_W'Y^<R8JM6`.7U\,CH=QLO2^BVEJ68GC*@5W7C%5JK/+7_7,M]);N?& MH$0;RK<,/*3#Z4#S9=.$?ZE&"PHMZC-]7)'P=W5KJJO%)!T72\7J2E$>\/0= M#G5JF)4&N"!*SOA]=M.'I04&<#Q3D2=?6GKD]1L,`?8*#YQT94QK$-943Q#6 MVR%$WI5ZKZ.>7DN&,A?*TQL'?M@08K[`D"A?G-&.M[MRN=HZIY(_(MN\(47% MD+)FTN1])IN&&)\W:RX#E,<V6>]*GM8-E2W$?!KY"S?!&(3=GCR4JB<!,:8J M0N:+IZ*E[:PB[S$L"#7%)(94NP_7L-N@R;1(H;MA+<5[?(T%:K!0PQ8:?L"F MC?SR:.F:1U8>@2H^+!*(.U\J+IY4%/A5U8FUO$)UR-[1P;Y\=8T[5[)V)QU2 M0W"M8^;4<8)NADY3LY:K.MD>.,*!PZT#1D@14V]I\OMT*VX#]SHHOD50I#'_ M-+L\GW6+%N&>A[`'KQ3`#;YUN03S""^YNFO\MM5]J.(7!AGT%CUL!JJ.Z<'^ M:')^-AP9$$`G'Z>D26J_E'3K\&NI]%\.U?U?\[)^L*]F'U7./BK.!A34F_4O MAI\,V`IB?P]<<F',(*(N2'_4^C`9MF8'^\B6Y*-,4%U&*0X4R=<O+PF-0HZ7 M^G!:N??^&S7Q6^%8!-;2%3JU7,Q$L"U(H(F_G!])$T_U=]",+0;V&AGS::]O MR*`AR$Y=R>%857AW3(Y`5;V/BXGQY\(8#\AD_/X[63`NIQ/L^N:9`;/X<J22 M%QS-L]+\0:Q\G(/O").'(1D.C/%B>#8T!N3T"PEM+$T&QEGOXVBQK;2=(GPK M'^>SWA@\=S(>&_U%G<P,U34ABXEBZ_VSK1PL'[`Q#.;5^OK':'4V&8U.>_T/ M<"K/+T&KR,/+9HFI;Z7=&^$YWT%Z,AX-Q\;_`<DD**M`H[MQC?N<XP]'W7>B M)`#XD;]TK.\X_REGZ%:Z\N\?QY;%7/XX7SNZV$]+HQ("&(@4RD!$ST.'IX(% MA>-MQ*<=B1)?'NP#7'"6U+RY2E\'`=@@W>%'80')VIAO=L#DQ$A%"!GW-TIO M[JH?5#SB;]4`D`V3'7CI"3A$F?2)+@).\L>HZ"%S8P1AC`S&O4NC3@S\1<YF MDTL"X;(.T72Z.-C_?&',#'R@X??QI(._XL_O_TG7(7/;,YG"/0CNQRS<\."& M]`LME%[20E'O=A?>U2O+GS1?6-S"4_3@S$<`Z.^S-I7JFTKSJ5=#A'P[3=TJ ME8G6Y/6OO)!3]\XN-CNRED;!^>,]XT.8:W,<;O6&GW(F?H+]\'Y<H"L`;3Q/ M!_MHQKDV&,[`MI/D4K>V&,_E0!TBI?I],9DO\.,AOI^#))G'`D5B-)Q#2H%@ MVT$6:KW!`#+=_`H?PY.]Y$&G-IU-%I/^9-0)3?^PAA0[*S`[7G<?UB#E+CK- MUT?-P\/J1;9O'M8^&%\ZT_$4?AT>'NYA!3P?#N165PD;D@M22YY+%O#+P)CW M.WDEU<Y'D]/>Z&IPBH+)PJ*@6;DJ&]K;VRN,YN_.9>:%6C>W7GV4Z@H]@783 M2EU(K%-#;F;#J;PU``ZK!%[TIX]H::\6@XLK!`&=6G*W+@</'[PS2`_.[GB5 MW0@D]C[!/R:2/;"N([P`:BDU"?^42#TN.R%&N#3NK0,>7:^3LY0C5A&;?D,Y B,KK:HRZ_%2ZD^*42>:MUDOM+F?@/F.#S_P!O2/"!R#4````` ` end
If a patch form is preferred there is one: RCS file: /home/ncvs/doc/en_US.ISO8859-1/books/handbook/linuxemu/chapter.sgml,v diff -r1.76 chapter.sgml 927a928,1244 > <sect1 id="linuxemu-oracle8i"> > <sect1info> > <authorgroup> > <author> > <firstname>Sergey</firstname> > <surname>Khorev</surname> > <contrib>Contributed by </contrib> > </author> > <!-- khorev@softlab.ru --> > </authorgroup> > </sect1info> > <title>Installing Oracle 8i</title> > > <indexterm> > <primary>applications</primary> > <secondary><application>Oracle</application></secondary> > </indexterm> > > <sect2> > <title>Preface</title> > <para>This document describes the process of installing Oracle 8iR3 (8.1.7) for > Linux onto a machine running FreeBSD 4.5-RELEASE</para> > </sect2> > > <sect2> > <title>Installing the Linux Environment</title> > > <para>Make sure you have both <filename>linux_base-6.1</filename> and > <filename>linux_devtools-6.1</filename> packages installed. Also the file > <filename>/compat/linux/etc/mtab</filename> must exist. Without it the installer fails. > > <screen>&prompt.root; <userinput> cp /etc/fstab /compat/linux/etc/mtab </userinput></screen> > > <para>You need to download and install Linux JDK-1.1.8 from > <ulink url="ftp.blackdown.org">ftp.blackdown.org</ulink>.</para> > > <screen>&prompt.root; <userinput>tar xjfC jdk118_v3-glibc-2.1.3.tar.bz2 /compat/linux/usr/ </userinput></screen> > <screen>&prompt.root; <userinput>cd /compat/linux/usr/jdk118_v3/ </userinput></screen> > <screen>&prompt.root; <userinput>ln -s . linux </userinput></screen> > <screen>&prompt.root; <userinput>echo echo i686 > /compat/linux/bin/arch </userinput></screen> > <screen>&prompt.root; <userinput>chmod +x /compat/linux/bin/arch </userinput></screen> > <screen>&prompt.root; <userinput>cd /compat/linux/usr/ </userinput></screen> > <screen>&prompt.root; <userinput>mkdir local </userinput></screen> > <screen>&prompt.root; <userinput>mkdir local/bin </userinput></screen> > <screen>&prompt.root; <userinput>cd local </userinput></screen> > <screen>&prompt.root; <userinput>ln -s ../jdk118_v3/ java </userinput></screen> > > </sect2> > > <sect2> > <title>Creating the Oracle Environment</title> > > <para>Before you can install Oracle, you need to set up a proper > environment. You should read and understand the Oracle installation guide.</para> > > <sect3 id="linuxemu-kernel-tuning8i"> > <title>Kernel Tuning</title> > <indexterm><primary>kernel tuning</primary></indexterm> > > <para>As described in the Oracle installation guide, you need to set > the maximum size of shared memory. Do not use > <literal>SHMMAX</literal> under FreeBSD. <literal>SHMMAX</literal> > is merely calculated out of <literal>SHMMAXPGS</literal> and > <literal>PGSIZE</literal>. Therefore define > <literal>SHMMAXPGS</literal>. All other options can be used as > described in the guide. For example:</para> > > <programlisting># System V shared memory and tunable parameters > options SYSVSHM # include support for shared memory > options SHMMAXPGS=16384 # max amount of shared memory pages (4k on i386) > options SHMMAX="(SHMMAXPGS*PAGE_SIZE+1)" > # max shared memory segment size (bytes) > options SHMMIN=2 # min shared memory segment size (bytes) > options SHMMNI=100 # max number of shared memory identifiers > options SHMSEG=10 # max shared memory segments per process > > # System V semaphores and tunable parameters > options SYSVSEM # include support for semaphores > options SEMMNI=100 # number of semaphore identifiers in the system > options SEMMSL=61 # max number of semaphores per id > options SEMMNS=61 # number of semaphores in the system > options SEMOPM=101 # max number of operations per semop call > > # System V message queues and tunable parameters > options SYSVMSG # include support for message queues</programlisting> > > <para>Set these options to suit your intended use of Oracle.</para> > > </sect3> > > <sect3 id="linuxemu-oracle-account8i"> > > <title>Oracle Account</title> > > <para>Create an Oracle account just as you would create any other > account. The Oracle account is special only that you need to give > it a Linux shell. Add <filename>/compat/linux/bin/bash</filename> to > <filename>/etc/shells</filename> and set the shell for the Oracle > account to <filename>/compat/linux/bin/bash</filename>.</para> > <screen>&prompt.root; <userinput> pw groupadd -n dba </userinput></screen> > <screen>&prompt.root; <userinput> pw useradd oracle -g dba -m -s /compat/linux/bin/bash </userinput></screen> > </sect3> > > <sect3 id="linuxemu-environment-8i"> > <title>Environment</title> > > <para>According to Oracle's installation guide you are to > set some environment variables. Here Oracle is installed in /ora and > FORA is a name of the database. The <envar>LANG</envar> is unsetted to avoid problems > with the installer. The best place > to set them is <filename>/home/oracle/.profile</filename>: </para> > <programlisting>ORACLE_BASE=/ora; export ORACLE_BASE > ORACLE_HOME=$ORACLE_BASE/app; export ORACLE_HOME > LD_LIBRARY_PATH=$ORACLE_HOME/lib; export LD_LIBRARY_PATH > ORACLE_SID=FORA; export ORACLE_SID > PATH=/compat/linux/bin:/compat/linux/sbin:/compat/linux/usr/bin > PATH=$PATH:/compat/linux/usr/sbin:/bin:/sbin:/usr/bin:/usr/sbin > PATH=$PATH:/usr/local/bin:$ORACLE_HOME/bin > export PATH > umask 022 > unset LANG</programlisting> > </sect3> > </sect2> > > <sect2> > <title>Installing Oracle</title> > > <para>First of all you need to patch the installation. It can be done in two ways: > <orderedlist> > <listitem> > <para>Copying the entire Oracle distribution to writable media.</para> > </listitem> > <listitem> > <para>Copying some installation files:</para> > <screen>&prompt.root; <userinput> cp -r /cdrom/Disk1/runInstaller /cdrom/Disk1/install . </userinput></screen> > </listitem> > </orderedlist> > Either way a patch must be applied to <filename>runInstaller</filename>: > <programlisting>34c34 > < THREADS_FLAG=native > --- > > THREADS_FLAG=green</programlisting> > The <filename>install/oraparam.ini</filename> may be patched in two various fashions > <orderedlist> > <listitem> > <programlisting>5c5 > < JRE_LOCATION=../stage/Components/oracle.swd.jre/1.1.8/1/DataFiles/Expanded/l inux > --- > > JRE_LOCATION=/compat/linux/usr/jdk118_v3 > </programlisting> > </listitem> > <listitem> > <programlisting>3c3 > < SOURCE=../stage/products.jar > --- > > SOURCE=/cdrom/Disk1/stage/products.jar > 5,6c5,6 > < JRE_LOCATION=../stage/Components/oracle.swd.jre/1.1.8/1/DataFiles/Expanded/l inux > < OUI_LOCATION=../stage/Components/oracle.swd.oui/1.7.1.8.0/1/DataFiles/Expand ed > --- > > JRE_LOCATION=/compat/linux/usr/jdk118_v3 > > OUI_LOCATION=/cdrom/Disk1/stage/Components/oracle.swd.oui/1.7.1.8.0/1/DataFi les/Expanded > </programlisting> > </listitem> > </orderedlist> > </para> > > <para>To start the installation you need to be running X Windows. > Running as the <username>oracle</username> user, issue the following command: > </para> > <screen>&prompt.user; <userinput> ./runInstaller </userinput></screen> > <para> The second way to correct <emphasis>source file location</emphasis> </para> > <para> On the next screen set UNIX group name to dba. > When prompted, run the script <filename>orainstRoot.sh</filename> under <username>root</username> account > </para> > <para>When selecting products to install, do not choose Enterprise Manager - > it's rather unstable even under Linux. You may also deselect > Oracle HTTP server, Product Options, and Java Products. > <important> > <para>Deselection of too many products may cause the installer to fail.</para> > </important> > Also choose to NOT use the database configuration assistant. > </para> > > <sect3 id="linuxemu-patch-root-8i"> > <title>Patching root.sh</title> > > <para>When installing Oracle, some actions, which need to be performed > as <username>root</username>, are recorded in a shell script called > <filename>root.sh</filename>. Apply the > following patch to root.sh, to have it use the proper command locations of > commands. Before running the script be sure the proper values > of <envar>ORACLE_HOME</envar> and <envar>ORACLE_SID</envar> were set. > </para> > <programlisting>7c7 > < CHOWN="/bin/chown" > --- > > CHOWN="/usr/sbin/chown" > 9c9 > < TEST="/usr/bin/test" > --- > > TEST="/bin/test" > 86c86 > < AWK=/bin/awk > --- > > AWK=/usr/bin/awk > 88c88 > < CHOWN=/bin/chown > --- > > CHOWN=/usr/sbin/chown > 92,93c92,93 > < GREP=/bin/grep > < LBIN=/usr/local/bin > --- > > GREP=/usr/bin/grep > > LBIN=/compat/linux/usr/local/bin > 98c98 > < SED=/usr/local/bin/sed > --- > > SED=/usr/bin/sed > 101c101 > < TEST=/usr/bin/test > --- > > TEST=/bin/test</programlisting> > > </sect3> > > <sect2> > <title>Running Oracle</title> > > <para>When you have followed the instructions, you should be able to run > <application>Oracle</application> as if it were run on Linux > itself. Also, you can then patch Oracle to version 8.1.7.3.</para> > <sect3> > <title>Quick Running Oracle </title> > <para> For those who are new to Oracle and want to > quickly test installation, perform those steps as the <username>oracle</username> user</para> > <procedure> > <step> > <screen>&prompt.user; <userinput> cd $ORACLE_HOME/dbs; cp init.ora initFORA.ora </userinput></screen> > <para> Then edit initFORA.ora to set values:</para> > <programlisting>db_name=FORA > control_files = (/ora/data/FORA/ctl1.dbf, /ora/data/FORA/ctl2.dbf)</programlisting> > </step> > <step> > <screen>&prompt.user; <userinput> svrmgrl </userinput> > SVRMGR> <userinput> connect internal </userinput> > SVRMGR> <userinput> startup nomount </userinput> > SVRMGR> <userinput> CREATE DATABASE FORA > LOGFILE GROUP 1 ('/ora/data/FORA/log1.dbf') size 1M, > GROUP 2 ('/ora/data/FORA/log2.dbf') size 1M NOARCHIVELOG CHARACTER SET CL8KOI8R > DATAFILE '/ora/data/FORA/system1.dbf' size 50M autoextend on; </userinput> > SVRMGR> <userinput> @$ORACLE_HOME/rdbms/admin/catalog.sql </userinput> > SVRMGR> <userinput> @$ORACLE_HOME/rdbms/admin/catproc.sql </userinput> > SVRMGR> <userinput> CREATE TABLESPACE users DATAFILE '/ora/data/FORA/users1.dbf' SIZE 20M AUTOEXTEND ON; </userinput> > SVRMGR> <userinput> CREATE TEMPORARY TABLESPACE temp TEMPFILE '/ora/data/FORA/temp1.dbf' SIZE 10M AUTOEXTEND ON; </userinput> > SVRMGR> <userinput> CREATE USER scott IDENTIFIED BY tiger DEFAULT TABLESPACE users TEMPORARY TABLESPACE temp; </userinput> > SVRMGR> <userinput> GRANT CONNECT, RESOURCE TO scott; </userinput> > SVRMGR> <userinput> CREATE TABLESPACE rbs DATAFILE '/ora/data/FORA/rbs1.dbf' SIZE 5M AUTOEXTEND ON; </userinput> > SVRMGR> <userinput> CREATE ROLLBACK SEGMENT rbs01 TABLESPACE rbs; </userinput> > SVRMGR> <userinput> ALTER ROLLBACK SEGMENT rbs01 ONLINE; </userinput> > SVRMGR> <userinput> ALTER ROLLBACK SEGMENT rbs01 ONLINE; </userinput> > SVRMGR> <userinput> connect system/manager </userinput> > SVRMGR> <userinput> @$ORACLE_HOME/sqlplus/admin/pupbld.sql </userinput> > SVRMGR> <userinput> connect scott/tiger </userinput> > SVRMGR> <userinput> @$ORACLE_HOME/sqlplus/admin/demobld.sql </userinput> > </screen> > </step> > <step> > <para>Edit $ORACLE_HOME/dbs/initFORA.ora:</para> > <programlisting>compatible = 8.1.0 > rollback_segments = (rbs01)</programlisting> > </step> > <step> > <para>Now you should be able to connect to Oracle and select from > demonstration tables:</para> > <screen>&prompt.user; <userinput> sqlplus scott/tiger </userinput> > SQL> <userinput> SELECT DNAME, ENAME FROM EMP, DEPT > WHERE EMP.DEPTNO=DEPT.DEPTNO;</userinput> > </screen> > </step> > <step> > <para> Since starting Network Configuration Assistant fails, you need to > configure the network manually. You may start from these sample files > (place all of them in <filename>$ORACLE_HOME/network/admin/</filename>) > </para> > <programlisting># this is sqlnet.ora > NAMES.DIRECTORY_PATH=(TNSNAMES, ONAMES, HOSTNAME) > # listener.ora > LISTENER = > (ADDRESS_LIST= > (ADDRESS=(PROTOCOL=tcp)(HOST=freehome)(PORT=1521)) > (ADDRESS=(PROTOCOL=ipc)(KEY=PNPKEY))) > > SID_LIST_LISTENER= > (SID_LIST= > (SID_DESC= > (GLOBAL_DBNAME=FORA) > (SID_NAME=FORA) > (ORACLE_HOME=/ora/app) > ) > ) > # tnsnames.ora > FORA=(DESCRIPTION= > (ADDRESS=(PROTOCOL=TCP)(HOST=freehome)(PORT=1521)) > (CONNECT_DATA=(SID=FORA)) > )</programlisting> > <para> Now you should be able to start the listener: <command>lsnrctl start</command> > and connect through network: <command>sqlplus scott/tiger@FORA</command>. > </para> > </step> > </procedure> > </sect3> > > </sect2> > </sect1> >
In order to submit the right patch: Index: chapter.sgml =================================================================== RCS file: /home/ncvs/doc/en_US.ISO8859-1/books/handbook/linuxemu/chapter.sgml,v retrieving revision 1.76 diff -u -r1.76 chapter.sgml --- chapter.sgml Thu Aug 29 14:35:44 2002 +++ chapter.sgml Tue Sep 10 10:48:57 2002 @@ -925,6 +925,323 @@ </sect2> </sect1> + <sect1 id="linuxemu-oracle8i"> + <sect1info> + <authorgroup> + <author> + <firstname>Sergey</firstname> + <surname>Khorev</surname> + <contrib>Contributed by </contrib> + </author> + <!-- khorev@softlab.ru --> + </authorgroup> + </sect1info> + <title>Installing Oracle 8i</title> + + <indexterm> + <primary>applications</primary> + <secondary><application>Oracle</application></secondary> + </indexterm> + + <sect2> + <title>Preface</title> + <para>This document describes the process of installing Oracle 8iR3 (8.1.7) for + Linux onto a machine running FreeBSD 4.5-RELEASE</para> + </sect2> + + <sect2> + <title>Installing the Linux Environment</title> + + <para>Make sure you have both <filename>linux_base-6.1</filename> and + <filename>linux_devtools-6.1</filename> packages installed. Also the file + <filename>/compat/linux/etc/mtab</filename> must exist. Without it the installer fails. + + <screen>&prompt.root; <userinput> cp /etc/fstab /compat/linux/etc/mtab </userinput></screen> + + <para>You need to download and install Linux JDK-1.1.8 from + <ulink url="ftp.blackdown.org">ftp.blackdown.org</ulink>.</para> + + <screen>&prompt.root; <userinput>tar xjfC jdk118_v3-glibc-2.1.3.tar.bz2 /compat/linux/usr/ </userinput></screen> + <screen>&prompt.root; <userinput>cd /compat/linux/usr/jdk118_v3/ </userinput></screen> + <screen>&prompt.root; <userinput>ln -s . linux </userinput></screen> + <screen>&prompt.root; <userinput>echo echo i686 > /compat/linux/bin/arch </userinput></screen> + <screen>&prompt.root; <userinput>chmod +x /compat/linux/bin/arch </userinput></screen> + <screen>&prompt.root; <userinput>cd /compat/linux/usr/ </userinput></screen> + <screen>&prompt.root; <userinput>mkdir local </userinput></screen> + <screen>&prompt.root; <userinput>mkdir local/bin </userinput></screen> + <screen>&prompt.root; <userinput>cd local </userinput></screen> + <screen>&prompt.root; <userinput>ln -s ../jdk118_v3/ java </userinput></screen> + + </sect2> + + <sect2> + <title>Creating the Oracle Environment</title> + + <para>Before you can install Oracle, you need to set up a proper + environment. You should read and understand the Oracle installation guide.</para> + + <sect3 id="linuxemu-kernel-tuning8i"> + <title>Kernel Tuning</title> + <indexterm><primary>kernel tuning</primary></indexterm> + + <para>As described in the Oracle installation guide, you need to set + the maximum size of shared memory. Do not use + <literal>SHMMAX</literal> under FreeBSD. <literal>SHMMAX</literal> + is merely calculated out of <literal>SHMMAXPGS</literal> and + <literal>PGSIZE</literal>. Therefore define + <literal>SHMMAXPGS</literal>. All other options can be used as + described in the guide. For example:</para> + + <programlisting># System V shared memory and tunable parameters +options SYSVSHM # include support for shared memory +options SHMMAXPGS=16384 # max amount of shared memory pages (4k on i386) +options SHMMAX="(SHMMAXPGS*PAGE_SIZE+1)" + # max shared memory segment size (bytes) +options SHMMIN=2 # min shared memory segment size (bytes) +options SHMMNI=100 # max number of shared memory identifiers +options SHMSEG=10 # max shared memory segments per process + +# System V semaphores and tunable parameters +options SYSVSEM # include support for semaphores +options SEMMNI=100 # number of semaphore identifiers in the system +options SEMMSL=61 # max number of semaphores per id +options SEMMNS=61 # number of semaphores in the system +options SEMOPM=101 # max number of operations per semop call + +# System V message queues and tunable parameters +options SYSVMSG # include support for message queues</programlisting> + + <para>Set these options to suit your intended use of Oracle.</para> + + </sect3> + + <sect3 id="linuxemu-oracle-account8i"> + + <title>Oracle Account</title> + + <para>Create an Oracle account just as you would create any other + account. The Oracle account is special only that you need to give + it a Linux shell. Add <filename>/compat/linux/bin/bash</filename> to + <filename>/etc/shells</filename> and set the shell for the Oracle + account to <filename>/compat/linux/bin/bash</filename>.</para> + <screen>&prompt.root; <userinput> pw groupadd -n dba </userinput></screen> + <screen>&prompt.root; <userinput> pw useradd oracle -g dba -m -s /compat/linux/bin/bash </userinput></screen> + </sect3> + + <sect3 id="linuxemu-environment-8i"> + <title>Environment</title> + + <para>According to Oracle's installation guide you are to + set some environment variables. Here Oracle is installed in /ora and + FORA is a name of the database. The <envar>LANG</envar> is unsetted to avoid problems + with the installer. The best place + to set them is <filename>/home/oracle/.profile</filename>: </para> + <programlisting>ORACLE_BASE=/ora; export ORACLE_BASE +ORACLE_HOME=$ORACLE_BASE/app; export ORACLE_HOME +LD_LIBRARY_PATH=$ORACLE_HOME/lib; export LD_LIBRARY_PATH +ORACLE_SID=FORA; export ORACLE_SID +PATH=/compat/linux/bin:/compat/linux/sbin:/compat/linux/usr/bin +PATH=$PATH:/compat/linux/usr/sbin:/bin:/sbin:/usr/bin:/usr/sbin +PATH=$PATH:/usr/local/bin:$ORACLE_HOME/bin +export PATH +umask 022 +unset LANG</programlisting> + </sect3> + </sect2> + + <sect2> + <title>Installing Oracle</title> + + <para>First of all you need to patch the installation. It can be done in two ways: + <orderedlist> + <listitem> + <para>Copying the entire Oracle distribution to writable media.</para> + </listitem> + <listitem> + <para>Copying some installation files:</para> + <screen>&prompt.root; <userinput> cp -r /cdrom/Disk1/runInstaller /cdrom/Disk1/install . </userinput></screen> + </listitem> + </orderedlist> + Either way a patch must be applied to <filename>runInstaller</filename>: + <programlisting>34c34 +< THREADS_FLAG=native +--- +> THREADS_FLAG=green</programlisting> + The <filename>install/oraparam.ini</filename> may be patched in two various fashions + <orderedlist> + <listitem> + <programlisting>5c5 +< JRE_LOCATION=../stage/Components/oracle.swd.jre/1.1.8/1/DataFiles/Expanded/l inux +--- +> JRE_LOCATION=/compat/linux/usr/jdk118_v3 + </programlisting> + </listitem> + <listitem> + <programlisting>3c3 +< SOURCE=../stage/products.jar +--- +> SOURCE=/cdrom/Disk1/stage/products.jar +5,6c5,6 +< JRE_LOCATION=../stage/Components/oracle.swd.jre/1.1.8/1/DataFiles/Expanded/l inux +< OUI_LOCATION=../stage/Components/oracle.swd.oui/1.7.1.8.0/1/DataFiles/Expand ed +--- +> JRE_LOCATION=/compat/linux/usr/jdk118_v3 +> OUI_LOCATION=/cdrom/Disk1/stage/Components/oracle.swd.oui/1.7.1.8.0/1/DataFi les/Expanded + </programlisting> + </listitem> + </orderedlist> + </para> + + <para>To start the installation you need to be running X Windows. + Running as the <username>oracle</username> user, issue the following command: + </para> + <screen>&prompt.user; <userinput> ./runInstaller </userinput></screen> + <para> The second way to correct <emphasis>source file location</emphasis> </para> + <para> On the next screen set UNIX group name to dba. + When prompted, run the script <filename>orainstRoot.sh</filename> under <username>root</username> account + </para> + <para>When selecting products to install, do not choose Enterprise Manager - + it's rather unstable even under Linux. You may also deselect + Oracle HTTP server, Product Options, and Java Products. + <important> + <para>Deselection of too many products may cause the installer to fail.</para> + </important> + Also choose to NOT use the database configuration assistant. + </para> + + <sect3 id="linuxemu-patch-root-8i"> + <title>Patching root.sh</title> + + <para>When installing Oracle, some actions, which need to be performed + as <username>root</username>, are recorded in a shell script called + <filename>root.sh</filename>. Apply the + following patch to root.sh, to have it use the proper command locations of + commands. Before running the script be sure the proper values + of <envar>ORACLE_HOME</envar> and <envar>ORACLE_SID</envar> were set. + </para> + <programlisting>7c7 +< CHOWN="/bin/chown" +--- +> CHOWN="/usr/sbin/chown" +9c9 +< TEST="/usr/bin/test" +--- +> TEST="/bin/test" +86c86 +< AWK=/bin/awk +--- +> AWK=/usr/bin/awk +88c88 +< CHOWN=/bin/chown +--- +> CHOWN=/usr/sbin/chown +92,93c92,93 +< GREP=/bin/grep +< LBIN=/usr/local/bin +--- +> GREP=/usr/bin/grep +> LBIN=/compat/linux/usr/local/bin +98c98 +< SED=/usr/local/bin/sed +--- +> SED=/usr/bin/sed +101c101 +< TEST=/usr/bin/test +--- +> TEST=/bin/test</programlisting> + + </sect3> + + <sect2> + <title>Running Oracle</title> + + <para>When you have followed the instructions, you should be able to run + <application>Oracle</application> as if it were run on Linux + itself. Also, you can then patch Oracle to version 8.1.7.3.</para> + <sect3> + <title>Quick Running Oracle </title> + <para> For those who are new to Oracle and want to + quickly test installation, perform those steps as the <username>oracle</username> user</para> + <procedure> + <step> + <screen>&prompt.user; <userinput> cd $ORACLE_HOME/dbs; cp init.ora initFORA.ora </userinput></screen> + <para> Then edit initFORA.ora to set values:</para> + <programlisting>db_name=FORA +control_files = (/ora/data/FORA/ctl1.dbf, /ora/data/FORA/ctl2.dbf)</programlisting> + </step> + <step> + <screen>&prompt.user; <userinput> svrmgrl </userinput> + SVRMGR> <userinput> connect internal </userinput> + SVRMGR> <userinput> startup nomount </userinput> + SVRMGR> <userinput> CREATE DATABASE FORA +LOGFILE GROUP 1 ('/ora/data/FORA/log1.dbf') size 1M, +GROUP 2 ('/ora/data/FORA/log2.dbf') size 1M NOARCHIVELOG CHARACTER SET CL8KOI8R +DATAFILE '/ora/data/FORA/system1.dbf' size 50M autoextend on; </userinput> + SVRMGR> <userinput> @$ORACLE_HOME/rdbms/admin/catalog.sql </userinput> + SVRMGR> <userinput> @$ORACLE_HOME/rdbms/admin/catproc.sql </userinput> + SVRMGR> <userinput> CREATE TABLESPACE users DATAFILE '/ora/data/FORA/users1.dbf' +SIZE 20M AUTOEXTEND ON; </userinput> + SVRMGR> <userinput> CREATE TEMPORARY TABLESPACE temp TEMPFILE '/ora/data/FORA/temp1.dbf' +SIZE 10M AUTOEXTEND ON; </userinput> + SVRMGR> <userinput> CREATE USER scott IDENTIFIED BY tiger DEFAULT TABLESPACE users +TEMPORARY TABLESPACE temp; </userinput> + SVRMGR> <userinput> GRANT CONNECT, RESOURCE TO scott; </userinput> + SVRMGR> <userinput> CREATE TABLESPACE rbs DATAFILE '/ora/data/FORA/rbs1.dbf' +SIZE 5M AUTOEXTEND ON; </userinput> + SVRMGR> <userinput> CREATE ROLLBACK SEGMENT rbs01 TABLESPACE rbs; </userinput> + SVRMGR> <userinput> ALTER ROLLBACK SEGMENT rbs01 ONLINE; </userinput> + SVRMGR> <userinput> ALTER ROLLBACK SEGMENT rbs01 ONLINE; </userinput> + SVRMGR> <userinput> connect system/manager </userinput> + SVRMGR> <userinput> @$ORACLE_HOME/sqlplus/admin/pupbld.sql </userinput> + SVRMGR> <userinput> connect scott/tiger </userinput> + SVRMGR> <userinput> @$ORACLE_HOME/sqlplus/admin/demobld.sql </userinput> + </screen> + </step> + <step> + <para>Edit $ORACLE_HOME/dbs/initFORA.ora:</para> + <programlisting>compatible = 8.1.0 +rollback_segments = (rbs01)</programlisting> + </step> + <step> + <para>Now you should be able to connect to Oracle and select from + demonstration tables:</para> + <screen>&prompt.user; <userinput> sqlplus scott/tiger </userinput> + SQL> <userinput> SELECT DNAME, ENAME FROM EMP, DEPT +WHERE EMP.DEPTNO=DEPT.DEPTNO;</userinput> + </screen> + </step> + <step> + <para> Since starting Network Configuration Assistant fails, you need to + configure the network manually. You may start from these sample files + (place all of them in <filename>$ORACLE_HOME/network/admin/</filename>) + </para> + <programlisting># this is sqlnet.ora +NAMES.DIRECTORY_PATH=(TNSNAMES, ONAMES, HOSTNAME) +# listener.ora +LISTENER = + (ADDRESS_LIST= + (ADDRESS=(PROTOCOL=tcp)(HOST=freehome)(PORT=1521)) + (ADDRESS=(PROTOCOL=ipc)(KEY=PNPKEY))) + +SID_LIST_LISTENER= + (SID_LIST= + (SID_DESC= + (GLOBAL_DBNAME=FORA) + (SID_NAME=FORA) + (ORACLE_HOME=/ora/app) + ) + ) +# tnsnames.ora +FORA=(DESCRIPTION= + (ADDRESS=(PROTOCOL=TCP)(HOST=freehome)(PORT=1521)) + (CONNECT_DATA=(SID=FORA)) + )</programlisting> + <para> Now you should be able to start the listener: <command>lsnrctl start</command> + and connect through network: <command>sqlplus scott/tiger@FORA</command>. + </para> + </step> + </procedure> + </sect3> + + </sect2> + </sect1> + <sect1 id="sapr3"> <sect1info> <authorgroup>
State Changed From-To: open->analyzed Patch looks good.
Responsible Changed From-To: freebsd-doc->ceri I'll take this one.
Responsible Changed From-To: ceri->freebsd-doc Throw this back to the doc team.
Even though it's sad that this section has never been commited to the handbook, committing it now is probably too late, now that Oracle has come to versions 9i and 10g of its DBMS. The community would probably benifit if install guides for the most recent version of Oracle would become available, but this PR should be closed. RIP. http://www.freebsd.org/cgi/query-pr.cgi?pr=docs/42058
The 9i install happens to be really, really easy too. I'll write something if someone would care to open a new PR to remind me. Ceri
State Changed From-To: analyzed->closed I opened up another PR for the addittion of fresh documentation since this is outdated (sadly enough we did not commit it, i am very sorry for that). Eventhough we did not commit the documentation i would like to thank you for taking the time to document this. Keep up that good work. For now close the PR, docs/91174 has been opened for newer documentation.