Sophie: howto-text-ja-2006-5mdv2010.0 noarch

howto-text-ja-2006-5mdv2010.0.noarch.rpm

  Oracle for Linux CXg[ HOWTO
  Stephen Darlington, <stephen@zx81.org.uk>
  $Id: Oracle-8-HOWTO.sgml,v 1.1 2000/07/13 14:36:27 nakano
  Exp $
  ðä põ <sake@istar.ca>
  v1.12j May 22, 2000

  í¸©Î©èÌK^Æ±Ì HOWTO ÉæÁÄAOracle8i Enterprise Edition
  for Linux ðCXg[µAf[^x[Xðì¬µA[g}V©ç»
  êÉÚ±Å«éæ¤ÉÈéÍ¸Å·BÅßÌ¼ÌfBXgr[VÉÎ
  µÄà¨¨æ»ÏXÈµÅKpÅ«éÍ¸Å·ªA±ÌKChÌåÈÅ_Í
  RedHat Linux 6.0 ÉÄçêÄ¢Ü·B (óF{HOWTO ÅÍ Release
  8.1.5 ÉÂ¢Äæèµ¢Ü·BÈ¨ R8.1.5 Ì Enterprise Edition Íú{Å
  Ìo×ª©çêA@\ðí¸µ½ Workgroup Server ¾¯ªo×³êÄ¢Ü
  ·B½¾µCXg[èÍå· èÜ¹ñ)
  ______________________________________________________________________

  Ú

  1. Í¶ßÉ
     1.1 ±Ì HOWTO Ìàe
     1.2 ±Ì HOWTO ÍNÌ½ßÌàÌH
     1.3 ±ÌhLgÌVµ¢o[W
     1.4 ÆÓ
     1.5 Ó«
     1.6 CZX(Licence)

  2. Í¶ßÌêà
     2.1 TÏ
     2.2 Oñð
     2.3 Linux ÌÝè
        2.3.1 fBXgr[VÌÝè
        2.3.2 J[lÌp[^
        2.3.3 [UÆO[v
     2.4 Í¶ßÌêà p`
        2.4.1 {É 128MB Ì RAM ªKvÅ·©H
        2.4.2 RedHat 6.1 Å®«Ü·©H
        2.4.3 Debian/SuSE/Mandrake/»Ì¼ÌfBXgr[VÅ®«Ü·©H
        2.4.4 JnJ[lãÅ®«Ü·©H

  3. CXg[
     3.1 Ç¤âÁÄH
     3.2 CXg[vOÌ¿âÉÇ¤¦é©H
     3.3 pb`ÌCXg[
     3.4 Â«Ýè
     3.5 CXg[ p`
        3.5.1 CXg[vOª 'CreateOUIProcess()' Æ¾ÁÄI¹µÄµÜ¢Ü·B
        3.5.2 CXg[ªXN[ãÅ½¾_ÅµÄA»ÌãÁ¦ÄµÜ¢Ü·B
        3.5.3 Cg[vOðN®µ½Æ«AïÈ Java ÌG[ª¶µÜ·B
        3.5.4 CXg[vOÅ 'Segmentation Fault'Æ¾íêÜ·B
        3.5.5 ¤LCuð[h·éÆ«ÌâèB
        3.5.6 Pro*C ª®«Ü¹ñ
        3.5.7 pb`ðÄ½àÌÌAÜ·Ü·Ôª«»µÜµ½I

  4. f[^x[XÌì¬
     4.1 TÏ
     4.2 XebvoCXebvKCh
     4.3 p`
        4.3.1 {É»ñÈÉÈPÈñÅ·©H
        4.3.2 {É·×ÄÌt@CðÊXÌfBXNÉüêéKvª èÜ·©H
        4.3.3 dbassist ðN®Å«Ü¹ñ
        4.3.4 "ORA-01034: ORACLE not available" Æ¾íêÜ·
        4.3.5 "ORA-01012: Not logged in" Æ¾íêÜ·

  5. RtBM[V
     5.1 TÏ
     5.2 Ê[UÆµÄÚ±·é
     5.3 ÊÌ}V©çÚ±·é
     5.4 ÊÌ}VÖÚ±·é
     5.5 p`
        5.5.1 netasst ªN®Å«Ü¹ñB

  6. ÑÌ¾t
     6.1 ðÉ§Â\tgEFA
     6.2 ðÉ§Â{
     6.3 C^[lbgãÌðÉ§Â\[X

  ______________________________________________________________________

  1.  Í¶ßÉ

  1.1.  ±Ì HOWTO Ìàe

  Linux ÍïðÅAêÊÉ[UÉÆÁÄÍßñèª½¢±ÆÅLmçêÄ¢
  Ü·B¿åÁÆµ½ Unix t@ÌÆµÄÍA±Ì±ÆÉ¯ÓÅ«é©Ç¤
  ©í©èÜ¹ñªB Oracle à¯¶æ¤ÈàÌ¾Æv¢Ü·BÍ¶ßÍÆÁÂ
  «É¢àÌÌAµêÄµÜ¦ÎA¼Ì RDBMS ÈñÄgÁÄ¢çêÈÈè
  Ü·B±ÌQÂªêÉÈéí¯ÅAOracle8i ÍÜ¾æ 2 [X¾Æ¢¤
  ±Æðv¢o¹ÎA½Æ¦±Ì¼ûÉÚµÄàAêØêÅÍ¢©È¢¾ë¤
  ÆCÃÅµå¤B©gA±Ì¼ûÉÚµ¢ÂàèÅ·ªA»êÉà©©í
  ç¸AâèÍN«Üµ½B©gÌð©³âv¢ãªè©ç¶¶½âèà½
  ©Á½ÌÅ·ªA®Sðú·½ßA·×Ä«L·±ÆÉµÜµ½B

  1.2.  ±Ì HOWTO ÍNÌ½ßÌàÌH

  ±ÌhLgÍ Linux ãÌ Oracle8i o[W 8.1.5 ðCXg[
  µ½¢l½¿Ì½ßÌàÌÅ·B(óFOracle Technet
  <http://technet.oracle.com> Éüï·éÆPÂÌJCZXÂ« CD ð
  ³¿ÅÁÄêÜ·BÂÜèPlÌJÒªgpÂ\¾ªA©RÉzzÅ«
  È¢Æ¢¤àÌÅ·) ±êæèOÌo[WÉÂ¢ÄÍ¢Á³¢æèµÁÄ
  ¢Ü¹ñBàµ 8.0 ðCXg[µ½¢ÈçA Linux Journals guide
  <http://www2.linuxjournal.com/lj-issues/issue67/3572.html>ÉgC·é
  ±Æð¨©ßµÜ·B±êÈOÌo[WðCXg[µ½¢Æ«ÉÍA
  SCO ÅðgíÈÄÍÈçÈ¢Åµå¤B»ÌÆ«ÍAPaul Haigh Ì Oracle
  Database HOWTO <http://www.linuxdoc.org/HOWTO/Oracle-HOWTO.html> Ìw
  ¦É]¤±ÆB

  u³µ¢vo[WðCXg[µæ¤ÆµÄ¢él½¿ÉAÌobN
  Ohðµà¾µÜ·BàµÇÒÌobNOhª½àÌÅ éÈ
  çA «ç©É½¿Íg·ªÒÁ½è ¤±ÆÉÈèÜ·ËB

  o  Í Unix o±ÒÅ·BÆ¢¤æèA¨»çÍ Unix ÌuêåÆvÆ
     ¢¦éÅµå¤BåwÅASunOS/Solaris Ìàðo¦Üµ½B»ê©
     çASunOS/Solaris ðg¢±¯AHP-UX (ñPN) Æ Linux (TNBÅà±
     êÍïÐÆ¢¤æè©ªÌÔÅ) ªm¯Ét¯ÁíèÜµ½B

     Windows © NT ÌobNOh©çÄ¢éÈçAOracle ð Linux É
     CXg[·éÌÍA©Èèïµ¢©àµêÜ¹ñBoOÌOÅ¨èã
     °óÔÉÈéÜ¦ÉAÜ¸½³ñÌTOâêåpêðwÎÈÄÍÈç
     È¢ÌÅ·B

  o  Í Oracle o±ÒÅ·BDBA(f[^x[XÇÒ) ÆµÄAversion 7.1
     Æ 7.3 ðCXg[µ½±Æª éµA8.0 ãÅVXeJµ½±Æ
     à èÜ·B (±êçÍÝÈ Solaris ã) K¢È±ÆÉAOracle ÌC
     Xg[èÍÈPÉÈÁÄ«Ä¢Ü·B ¢ÉA¢ÜÌÆ±ë»êÍ
      ÜèÀèµÄ¢Ü¹ñBÈÆà Linux ÌãÅÍ»¤Å·B

     v·éÉAàµ Oracle ðOÉgÁ½±ÆªÈ¢ÌÈçA±êÍènßÆ
     µÄÍæ¢»iÅÍÈ¢©àµêÈ¢Æ¢¤±ÆÅ·BæÙÇÔÆªC
     ÅàÈ¢©¬èB

     ÇÒª±ÌªìÅêèÊÌm¯ðÁÄ¢é±ÆðOñÉµÄ¢Ü·B
     Oracle ðCXg[·é±Æ³¦³³¢ÈÛèÅÍÈ¢ÌÅAuÅÍ±
     ÌL[ðµÜµå¤vÆ¢¤èÌKChubNðÂàèÍ èÜ¹
     ñBàµ±ÌèÌuTÅàí©éKChubNvªÙµ¢ÈçA±Ì
     HOWTO à Oracle à½ÔñÓ³íµÈ¢Åµå¤ËB

  1.3.  ±ÌhLgÌVµ¢o[W

  Linux Æ Oracle Ì¢EÅÍA¨ÍßÜ®éµÚèÏíèÜ·B±Ìh
  Lgà·®ãxêÉÈÁÄµÜ¤Æ¢¤±ÆÅ·Bàµ±ÌhL
  gª 1EQÈãÃ©Á½çAüùÅðÌEFuTCg
  <http://www.zx81.org.uk/computing/oracle/oracle-howto/> Å©ÄÝé±Æ
  ð¨©ßµÜ·B
  1.4.  ÆÓ

  ¢àÌÉÍ¢àÌÈèÌAÀ¢àÌÉÍÀ¢àÌÈèÌ±ÆÍ èÜ·B
  ÍAÃÙIÅ ê½Å êA¢©ÈéíÞÌÛØàñµÜ¹ñBÅ«é©
  ¬èÌÍÉµÝÜ¹ñªA@IÉÍÇÒ©gÅÓCðÆÁÄ¾³¢B

  1.5.  Ó«

  ±Ì HOWTO Í Stephen Darlington ÉæÁÄLq³êÜµ½B Oracle
  Technet j[XO[vÆ Usenet j[XO[vÅÌArØêé±ÆÌ
  È¢¿âÆ¦ÌXªÈ©Á½çA±Ì HOWTO Íìèo¹È©Á½±ÆÅ
  µå¤BeµÂÃ¯ÄêÄ¢él½¿É´ÓµÜ·B·×ÄÌl½¿ðÂ
  ÊÉL·±ÆªÅ«ÈÄ·ÝÜ¹ñB

  ±ÌhLgÖÌv£ÉÎµÄAÌl½¿É´Óðq×Ü·(s¯)
  |Ton Haver, Guy Cole, Iain Frerichs, Albert Braun, Steve Morando »µ
  Ä Krill Kokoshka.

  ±Ì HOWTO Æ Linux Ü½Í Oracle ÉÖ·éêÊÉÖµÄAÝIÈ²
  Ó©ð¨Ò¿µÄ¢Ü·Bstephen@zx81.org.uk
  <mailto:stephen@zx81.org.uk>.  É[µÄ¾³¢B

  1.6.  CZX(Licence)

  This document is copyright 2000 Stephen Darlington. You may use,
  disseminate and reproduce it freely, provided you:

  o  Do not omit or alter this copyright notice.

  o  Do not omit or alter the version number and date.

  o  Do not omit or alter the document's pointer to the current WWW
     version.

  o  Clearly mark any condensed, altered or versions as such.

  These restrictions are intended to protect potential readers from
  stale or mangled versions. If you think you have a good case for an
  exception, ask me.

  (This copyright notice has been lifted from Eric Raymond's
  Distribution HOWTO.)

  (óFÇÒÌÖXÌ½ßú{êóðµÜ·ªA´¶Ìì \¦ªDæµÜ
  ·)

  ±ÌhLgÌì Í Stephen Darlington ªLµÜ·BÈºÌð
  ð½·©¬èA©RÉgpAzzAÄ¶YµÄ\¢Ü¹ñB

  o  ±Ìì \¦ðÈªÜ½ÍüÏµÈ¢±ÆB

  o  o[WÔ¨æÑútðÈªÜ½ÍüÏµÈ¢±ÆB

  o  »ÝÌ WWW ÅÖÌhLgÌ|C^ðÈªÜ½ÍüÏµÈ¢±
     ÆB

  o   çäéÈªÅEüÏÅð»êÆµÄ¾mÉwµ¦·±ÆB

  ±ñÈKèðà¤¯Ä éÌÍA«ÌÇÒðÅâü«Å©ççé½ßÅ
  ·BÃÈRª éÌÅáOðFßÄÙµ¢AÆ¢¤ûÍ²A¾³¢B

  (±Ìì \¦Í Eric Raymond Ì Distribution HOWTO ©çqØµÜµ½)

  2.  Í¶ßÌêà

  2.1.  TÏ

  ±ÌßÅÍAçêÄ«½ CD ©ç Oracle8i ðæèoµÄAn[hfBXN
  ÉCXg[·éÆ±ëÜÅ½ÇèÂ¯éæ¤É Linux ðÝèµÜ·B

  Oracle ÌCXg[ð·éOÉAÜ¸ PC ðgÝ§ÄALinux ðCXg
  [µAeíÝèðsÁÄAlbg[NÉÚ±µÄ¨©ËÎÈèÜ¹ñB

  2.2.  Oñð

  v¤ÉAÅàdvÈOñðÍAOñð»ê©ÌðyµÈ¢±ÆA»µ
  ÄA\tgEFAÉÖ·é©¬èAKvªÈ¯êÎAá¤Ó¤ÉâçÈ¢±Æ
  Å·B

  Ìßµ¢¨bÍÈºÌÊè|

  o  ÅÌ»µÄÅåÌß¿ÍAOracle ª 128MB Ì RAM ªKv¾Æ¾Á½Æ
     «A»êðçk¾ÆvÁ½±ÆÅ·B»êç¢ÌðÏñ¾ Sun T
     [oÉQx Oracle ðCXg[µ½±ÆÍ éàÌÌAÇ¤µÄ CISC
     }VÉ»êÈãÌªKvÈñ¾ë¤HÌ¨ÅÍÈAOracle ð
     M¶é±ÆÅ·B32MB Ì RAM ÌÌ}VÆi¬·é±Æ 30 ª«ç
     ¸A]ÝªÈ¢±ÆÉCÃ«Üµ½B

  o  Oracle ª Java Runtime Environment version 1.1.6 ªKv¾Æ¾Á½
     çAÜ³É»ÌÊèÌ±ÆðÓ¡µÜ·BuVµ¢o[WÌÙ¤ªo
     OªÈ¢¾ë¤vÆÍl¦È¢±ÆÅ·BCXg[Í¨»ç¤Ü
     ®©È¢©çÅ·BÜÆß|hLgÌw¦ÊèABlackdown Ì
     JRE 1.1.6v5 ðCXg[µÜµå¤B¢¸êÉµëAÅãÍ»¤·é
     ÍßÉÈèÜ·B

     Oracle Í RedHat Linux ÌãÅåªÌJðsÁ½æ¤Å·B½¸ÈC
     Xg[Ì½ßÉÍA¯¶ðµÜµå¤B¼ÌfBXgr[V
     ÉCXg[µæ¤Æµ½Æ«Ì¼ÁÆ·ébð¢Â©¨Éµ½±
     Æª èÜ·B

  ² èÓê½ RH6 ÌÝèðgÁ½Æ±ëAÙÆñÇâèÍN«Ü¹ñÅµ
  ½BÍAJRE version 1.1.6v5 ð_E[hECXg[
  µA1999N8ÜÅÌ·×ÄÌpb`ðÄÜµ½B³çÉJ[lÌo[
  Wð 2.2.13 Éã°½ÌÅ·ªA±êÍÌlbg[NJ[hðg¦é
  æ¤É·é½ßÅµ½B Oracle Í RedHat t®Ì 2.2.5 J[lÅà«Á
  Æ®Í¸Å·B

  ÓBOracle ÌCXg[Í JRE ÌÀst@Cª
  /usr/local/jre/bin/jre É éÆ¢¤OñÅÀ³êÄ¢éæ¤Å·B¾©
  çÆ¾ÁÄ»±É JRE ðCXg[µÈ¯êÎÈçÈ¢Æ¢¤±ÆÅÍ 
  èÜ¹ñª (ºLQÆ) JDK Åãp·éí¯ÉÍ¢«Ü¹ñB±êÍdvÈ|
  CgÈÌÅAà¤¢¿Ç¾¢Ü·B|K¸ JRE ðg¤±ÆÅ·BOracle Ì
  CXg[Í JDK ÆÍêÉ®«Ü¹ñI (óFJRE Ì_E[hª
  KvÈÌÍ R8.1.5 ¾¯Å·B Linux ÅÅà R8.1.6 ÅÍ CD ÌÉCX
  g[pÌ JRE ªÜÜêÄ¢Ü·µAR8.0.5 ÍCXg[ª Java ðg¢
  Ü¹ñBR8.1.6 ÌpÅÍ Oracle Technet Å_E[hÂ\Å·)

  JRE ÌìÆÅðæ¾·é½ßÉAÌèðÀsµÜµ½B

  1. Blackdown ÌEFuTCg <http://www.blackdown.org> ©ç Java
     Runtime Environment ð_E[h·éB

  2. JRE ðCXg[µ½¢êÉÚ®·é -

     cd /usr/local

  3. A[JCuðð·é -

     bzip2 -d -c jre-1.1.6-v5-glibc-x86.tar.bz2 | tar xvf -

  4. Oracle ªzè·éêÆÀÛÌêÌÔÉV{bNNð£é -

     ln -s jre116_v5 jre

  n[hEFAÉÖµÄ¢¤ÆAêèÌuî{vðz¦Ä³¦¢êÎA
  Linux Ì®½¢Ä¢Ìn[hEFAÌãÅ Oracle Í®Í¸Å·BQlÜ
  ÅÉAÌVXeÍ Intel Celeron 446 MHz É 128 MB ÌA 8 GB
  Ìn[hfBXNA»µÄ DM9102 lbg[NJ[hÅ·B±êÍAd¢f
  [^x[XAvP[VpÌ}VÅÍÈ¢àÌÌA¿åÁÆµ½eXg
  âJVXepÉÍ\ª·¬éÙÇÅ·B

  2.3.  Linux ÌÝè

  2.3.1.  fBXgr[VÌÝè

  OßÅwEµ½ÊèAOracle Í RedHat 6.0 ðgÁÄJðsÁÄ¢éÌ
  ÅA¸ÖÈCXg[Ì½ßÉÍAÇÒà¨»ç±êðgÁ½Ù¤ª¢¢
  Åµå¤B

  Æ±ëÅAOracle ð®©·½ßÉÍAÇñÈIvVðg¢AcåÈÌ
  pbP[WÌÅÇêÆÇêðCXg[µ½ç¢¢ÌÅµå¤©H

  Ü¸AXbvóÔÌ2E3{ÌªKvÅ·B(½¾CXg[ð®©
  ·¾¯ÅàAñ 200MB ÌÀÜ½¼zªKvÉÈéÅµå¤I) ÊàÆ
  Í  ÉALinux ÌXbvp[eBVÍA128MB æèå«·é±Æª
  Å«Ü·B

  ¼Ìp[eBVÌRtBM[VàÜ½dvÈ±Æª èÜ·B
  K¸ Oracle Ì\tgEFAÍ OS ÆÍÊÌp[eBVÉüêAOracle
  Ìf[^t@CÍ³çÉÊÌp[eBVÉüêéæ¤ÉµÄ¾³¢B
  ±êÍAf[^t@CªtOg»µÈ¢æ¤É·é½ßÅ·B (ÀÛ
  ÌÂ«ÅÍAOracle Í¢ÂàÌfBXNÌãÉUçÎÁÄ¶Ý·éÂ\«
  ª¢àÌÅ·B±Ì±ÆÉÖµÄ³çÉîñð¾é½ßÉÍAæ¢{ª¢
  Âà èÜ·)

  \tgEFAÉÖµÄÍAÍAÀ¼ÈIvVðIÑA½¾ÙÆñÇ·×
  ÄðCXg[µÜµ½BKvÈÌÍAmÀÉ·×ÄÌ 'base' pbP[
  WAX Windows (CXg[E[eBÍ Java GUI)A»µÄR[fB
  O·éÂàèÌ éÈµÉ©©íç¸Jpc[Å·BOracle Æf[^x
  [XÌå«³Éä×½çALinux fBXgr[VÍ÷X½éàÌÅA
  ½Ôñ 1GB àÈ¢Åµå¤By·é½ßÉA·×ÄðCXg[·é¿l
  Í èÜ·I

  2.3.2.  J[lÌp[^

  Oracle ÌhLgÍAæè½Ì¤Lð¾é½ßÉA Linux J[
  lÉèðÁ¦é±Æð§µÄ¢Ü·B±êÍALinux ÅÍñíÉïµ¢
  (½¢Ä¢Ì¤p Unix Æ¿ªÁÄAJ[lðÄRpCµÈ¯êÎÈç
  È¢) ÌÅAÌæÁ½Av[`ÍAÆÉ©CXg[ðµÄµÜ¤±
  ÆÅµ½BRedHat Linux ftHgÌÝèÍ¤Ü¢«Üµ½BåKÍÈJ
  âdpÌVXeÌ½ßÉÍÝèðÏXµÈ¯êÎÈçÈ¢©àµêÜ¹
  ñªB

  »à»à Oracle ð®©·½ßÉJ[lðÄRpCµÈ¯êÎÈçÈ¢
  l½¿à¢½±ÆÉÓµÄ¾³¢B¯¶}VãÅç¹Ä¢é¼Ì\t
  gEFAÉË¶µÄ¢éªª éÆv¢Ü·B

  Vµ¢J[lð\z·éÉÍAOracle ÌhLg (CXg[ CD
  ãÌ HTML t@C) Æ Linux Kernel HOWTO
  <http://www.linuxdoc.org/HOWTO/Kernel-HOWTO.html> Ìw¦É]ÁÄ¾³
  ¢B

  2.3.3.  [UÆO[v

  LinuxConf( é¢Í¨DÝÌCÓÌû@) ðgÁÄA"dba" O[vÆ
  "oracle" [UðÇÁ·éKvª èÜ·B"oracle" [UÍAVµìç
  ê½ "dba" O[vÉ®³¹½Ù¤ª¢¢Åµå¤B

  "dba" O[vÉüêé±ÆÅAÇñÈ[Uà DBA É·é±ÆªÅ«Ü
  ·B¡Ì DBA ª¢éÌÈçAÄ¸Ì½ßÉð§Â©àµêÜ¹ñB

  2.4.  Í¶ßÌêà p`

  2.4.1.  {É 128MB Ì RAM ªKvÅ·©H

  128MB ÈãÌðg¤±Æ©ßÜ·B»êÈºÅÍAÇñÈÜÆàÈ
  dð³¹éÌàïµ¢Åµå¤B

  µ©µÈªçAàµ Java IvVðOµÄA·×ÄÌ¤LÝèðä
  rI¬³¢àÌÉ·êÎA®©È¢RÍ èÜ¹ñB64MB Å¤Ü¢Á½
  Æ¢¤bð·¢½±Æª èÜ·B½Ôñ 32MB ÅÍ³Åµå¤¯ÇB

  SÉ¯ßÄ¨×«±Æª èÜ·BOracle ª§·éÆ±ëÌ¼ª¾¯
  ÅA\tgEFAðç¹é±ÆÍÅ«é©àµêÜ¹ñªACXg[·
  éÆ«ÉÍA»ÌÍÓ¡ðÁÄ«Ü·BCXg[ª 150MB ðgÁ
  Ä¢éÆ¢¤ñð¨Éµ½±Æª èÜ·µAÌêÍADÉ 120MB ð
  ´¦Ä¢éÌð©Üµ½Bàµ 64MB ÈºÌµ©È¢ÈçAXbvó
  ÔÆªCðYêÈ¢æ¤ÉµÄ¾³¢B

  Ìû@Åà¤Ü¢Í¸Å·B(·@ïÍÜ¾È¢ÌÅ·ª) - Oracle
  ð¼Ìæèå«È}VÉCXg[µÄA$ORACLE_HOME fBNgÉ
  Rs[µÜ·Bàµ[UÆO[vª·×Ä¯¶ÈçA®©È¢Í¸ÍÈ¢
  Æv¢Ü·B

  (óF dba O[v¾¯ìÁÄ êÎãLÌû@Åâè èÜ¹ñBBêÌ
  âèÆµÄACXg[ðgÁÄv_NgÌÇÁð·éÆ«ÍÇ¤·é
  ©HÀÍuOÉ½ðCXg[µ½©vðCXg[ªLqµ½eLXg
  t@Cª éÌÅA»êàÜÆßÄRs[·êÎæ¢Í¸Å·Bµ©µÈª
  çAÈÆàú{INÅÍãLÌû@ÉæéCXg[ðT|[gµ
  Ä¢Ü¹ñ)

  2.4.2.  RedHat 6.1 Å®«Ü·©H

  ©gÜ¾ 6.0 ðç¹Ä¢éÌÅA¾¦é±ÆÍ±ÌRtBM[
  VÅ½Ìl½¿ª¬÷µ½Æå£µÄ¢é±Æ¾¯Å·B

  ±êð¢Ä¢é_ÅÍAOracle8i Í RedHat 6.0 ãÅ®ìÛØ³êÄ¢
  ÄAu¼ÌfBXgr[VÉ¨¯é®ìÛØÍ»ÝisvÆÌ±Æ
  Å·B (Oracle8i Patch FAQ)

  2.4.3.  Debian/SuSE/Mandrake/»Ì¼ÌfBXgr[VÅ®«Ü·
  ©H

  Oracle ÌèßédlÍ Linux kernel version 2.2 ÈãÅAGLIBC version
  2.1 »µÄCÓÌEBhE}lWÆÈÁÄ¢Ü·B_ãÍA±êçÌv
  dlð½·CÓÌfBXgr[VÅ¤Ü¢Í¸Å·B

  ÀÛÉÍAOracle Í»êðT|[gµÈ¢©àµêÜ¹ñµACXg[
  ð®¹³¹æ¤Æ·éÆ«Éæè½ÌâèÉÔÂ©é©àµêÜ¹ñB¼Ì
  ±Æð·é½¢Öñæ¢RÅàÈ¢©¬èAÄçêé¾¯Ìpb`ðÄ
  ½ RedHat 6.0 ÉÅ··é±Æð©ßÜ·B (óFR8.1.5 ÉÖµÄAú{
  INÅÍ RedHat 6.0 pêÅÆ TurboLinux Server 6.0 (ú{êÅ)ÌÝ
  ðT|[gÎÛÆµÄ¢Ü·)

  2.4.4.  JnJ[lãÅ®«Ü·©H

  ®©È¢Æ¢¤ÍÁ«èµ½RÍ èÜ¹ñ - ÌÀènJ[lªA
  Ìlbg[NJ[hðT|[gµÄ¢È¢êûA2.3.19 ÍT|[gµÄ
  ¢½ÌÅA»êð·±µÌÔg¢Üµ½ - µ©µ·µÁ½KvªÈ¢©¬
  èAßñçÈ¢Ìª¢¿ÎñÀSÈÌÍm©Å·BhCoªÀènV[Y
  É·èÜêéæ¤ÉÈéâ¢ÈâAÍJ[lðàÆÉßµÜµ½B

  3.  CXg[

  3.1.  Ç¤âÁÄH

  êÊIÉAOracle ÌhLgÉ]¤Ìª¢¢Åµå¤B«È¢oÅ
  ·µA»êÉ]ÁÄ¨¯ÎA¸ÁÆÜµÈT|[gð Oracle ©çó¯é±Æ
  ªÅ«Ü·B (Oracle Applications ÌhLgÉ]ÁÄ - »¤Èéñ
  ¶áÈ¢©Æí©ÁÄ¢½àÌÌ - ¨ðÔ¿óµÄIíÁ½±Æª èÜ
  µ½B»êªÜÆàÈT|[gðó¯éBêÌû@¾Á½ÌÅ·)

  ÌhLgÅÍTªðà¾µÜ·ªAOracle ÌhLgàËRè
  ³É¨Kvª èÜ·B

  3.2.  CXg[vOÌ¿âÉÇ¤¦é©H

  CXg[ìÆÌêÆµÄAOracle Í½Ì¿âð½¸ËÄ«Ü·B
  êÊÉA»ñÈÉïµ¢àÌÅÍ èÜ¹ñªAÌüÍÆ»ÌRð©ÄÝ
  Üµå¤B

  1. CXg[vO(runInstaller)ð 'oracle' [UÆµÄç¹
     Ü·B

  2. ^CgXN[ªoÄéÍ¸Å·B'Next'ðNbNB

  3. CXg[pÌt@C('jar't@C) Ì\[XfBNgÆ
     Oracle CXg[pfBNgðüÍ·éæ¤Éw¦³êÜ·BOÒ
     ÍÁÉwèµÈÄàåävÅµå¤BãÒÌ Oracle z[fBNg
      (ORACLE_HOME)ÆÍA\tgEFAðCXg[·éêÌ±ÆÅ
     ·BCXg[ìÆhLgÉæêÎA»êÍ /u01 ÌºÌÇ±©
     Æ¢¤±ÆÅ·ªAÍ»êð³µÄ /home/oracle ÉÝèµÜµ½B
     {Í Oracle ÌAhoCXÉ]ÁÄAÙÈÁ½f[^x[Xt@CÍ
     ÙÈÁ½fBXNÉªUµÄu¢½Ù¤ª¢¢ÌÅ·ªBÚ×ÚðüÍ
     µ½ç 'Next' ðNbNµÜ·B

  4. »ê©ç DBA O[vÉÂ¢Ä½¸ËÄ«Ü·B±êÍAOßÅì¬µ½
     Unix O[vÅA¨»ç 'dba' Å·BÚ×ðüÍµÄA'Next' ðN
     bNµÜ·B

  5. ¡xÍ 'root' ÆµÄOCµA/tmp/OraInstall/orainstRoot.sh ð
     ç¹éKvª èÜ·Bw¦ÌÊèÉâèÜµå¤B(pdksh â bash ð
     gÁÄ¬÷ É±ÌXNvgðI¹³¹éÉÍAuB VFÝ·[
     hvÅç¹éKvª é©àµêÜ¹ñ) IíÁ½ç 'Retry' ðNb
     NµÜ·B

  6. É½ðCXg[·é©IÔ±ÆªÅ«Ü·BÙÆñÇ·×ÄðÜñ
     Å¢é 'Oracle Enterprise Edition' ðIÔÌªxXgÅ·B (Oracle
     ÌhLgÌ\ 3.1 ©çA½ðCXg[·éÌ©í©èÜ·) E
     ÌWI{^ðIðµÄ¢é±ÆðmFµÄA'Next' ðNbNµÜ
     ·B

  7. ±±ÅÍA¸ÁÆ×©½ðCXg[·é©I×Ü·BfBXNeÊ
     Ì§ÀªÁÉ«Â¢Æ©AKvÈàÌªÍÁ«èí©ÁÄ¢éÆ©ÅÈ¯
     êÎA»ÌÜÜÉµÄA'Next'ðNbNµ½Ù¤ª¢¢Åµå
     ¤BUniversal Installer Íð©ÈIððµÜ¹ñÌÅA½©Ì`Fb
     NðOµÄà ÜèSz·éKvÍ èÜ¹ñB¢ÂÅà³ÉßÁÄÇÁ
     ·é±ÆªÅ«Ü·B

  8. CXg[·éæ¤Éw¦µ½CÓÌ»iÉÂ¢ÄAÇ±Éüêé©Ï
     X·é±ÆªÅ«Ü·B±±ÅàAÏX·éÌÍAµÁ©èµ½RÌ 
     éÆ«¾¯ÉµÄ¾³¢BIíÁ½ç 'Next'ðNbNB

  9. EBhEªÁ¦ÄAw¦µ½·×ÄÌ\tgEFAªCXg[³ê
     Ü·B±êÉÍA½ÔñµÎçÔª©©èAv¤æè¸ÁÆð
     Áï·éÅµå¤B

  10.
     f[^x[Xðì¬·é©·¢Ä«Ü·BæÙÇâªCªÈ¢©¬
     èA±±ÅÍ 'No'ðIñÅ¨«Üµå¤BÆ¢¤ÌÍA±êªAÊÌ
     Java o[`}VÆ X Window ðN®·éæ¤ÈÌÅ·B ¢É
     A2ÂÌ JVM vX Oracle obNGh (óFOracle CX^X
     Ì±ÆÆvíêé) Æ¢¤ÌÍAÆÄà 128MB ÉÍûÜèÜ¹ñBàµ±
     ÌûjðÑO·éÌÈçA¢Á½ñßÉiÝAIíÁ½ç±±ÉßÁÄ
     «Ä¾³¢B (½Ìl½¿ª±Ì_Åf[^x[XðìéÆÀÛÉ
     Í¤Ü¢©È¢ÆRgµÄ¢Ü·)

  11.
     Oracle ÉT|[g³¹½¢lbg[NvgRð·¢Ä«Ü·BÌ
     êAüÍtB[hÍSóÅµ½B½ðLü·×«©í©èÜ¹ñ
     ªA 'Next'ðNbNµÄ·×Ä¤Ü¢«Üµ½B (óFTCP pÌ
     lbg[NA_v^ªftHgÅCXg[³êéÌÅA»ÌæÊ
     ªóÅàâèÍ èÜ¹ñ)

  12.
     ±êÅåÏÈÆ±ëÍIíèÅ·Bw¦µ½»iÍ·×ÄCXg[ª
     IíèAõ®¹Å·B¨ßÅÆ¤B

  3.3.  pb`ÌCXg[

   ¢ÉAOracle ©ççêÄ«½ CD Í½Ôño[W 8.1.5.0.0 Å
  µå¤B¼Ì\tgEFAÌÅÌ[Xª½¢Ä¢»¤Å éæ¤ÉA±
  Ìo[WÉàâèª èA(âèÍót@CªçÝÈÌÅA©Èè[
  Å·) o[W 8.1.5.0.2 Öo[Wðã°é½ßÌpb`ªsÂÅ
  ·B±Ì HOWTO ÌuRtBM[VvÌßÉiÞÉÍAmÀÉKv
  ÉÈÁÄ«Ü·B±±ÉLq³ê½pb`ÍAÝÏpb`Å·BÂÜ
  èA8.1.5.0.0 ©ç 8.1.5.0.2 ÖÚs·éÌÉKvÈt@Cð·×ÄÜñ
  Å¢éÆ¢¤±ÆÅ·B

  KvÈt@CÍ Oracle ÌEFuTCg
  <http://technet.oracle.com/support/tech/linux/files/linux_815patches.gz>É
   èACXg[·éÌÍärIÈPÅ·B (óFú{Åo×³êÄ¢é
  R8.1.5ÉÍ R8.1.5.0.1 Ìpb`ªt®µÄ¢Ü·)

  1. ±êðènßÆµÄ½³ñÌpb`ðÄé±ÆÉÈéÅµå¤©çA
     Ç±©ÖÈÆ±ëÉ "patches" Æ¢¤fBNgðìÁÄ¨«Üµå
     ¤ (Ìê $ORACLE_HOME)B

  2. pb`t@Cð_E[hµÄ»±Éu«Ü·B

  3. êt@CÌ½ßÌêðmÛµÜ·B

     mkdir /tmp/orapatch
     cd /tmp/orapatch

  4. pb`t@CððµÜ·B

     tar zvxf $ORACLE_HOME/patches/linux815patches.gz

  5. JgfBNgÉÅ«½VFXNvgðÀsµÜ·B

     ./linux_815patches.sh

  ê®êàAJgfBNgãÅApb`t@CððµÈ¢æ¤É
  µÄ¾³¢Bpb`ÌCXg[Í¶Ý·ét@CÌª³µ¢©mF
  µAàµ»¤ÅÈ¢Æ¸sµÜ·BRApb`ÌA[JCut@Cð©Â
  ¯o·ÆAt@CÌª½·¬é±ÆÉÈÁÄµÜ¢Ü·I

  3.4.  Â«Ýè

  ".profile"(Ü½ÍÓ¾ñg¤VFÅ»êÉ·éàÌ) ÉÌsðÁ¦
  Ä¾³¢B

  . oraenv
  export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib

  Èº Oracle ÌCXg[ª±êðâçÈ¢Ì©ÍäÅ·B

  ÉOC·éÆ«ÉA"[: integer expression expected before -lt" Æ
  ¢¤bZ[Wð©½çA»êÍ 'oraenv' Í ULIMITÌÉftHgÌ
  'unlimited' ÅÍÈ®ðßÄ¢½©çÅ·B±ÌG[ð³µÄà«
  e¿Í èÜ¹ñªACÓÌLÀð ULIMIT ÉÝè·é±ÆÅAoÈ¢æ¤
  É·é±ÆªÅ«Ü·B

  3.5.  CXg[ p`

  3.5.1.  CXg[vOª 'CreateOUIProcess()' Æ¾ÁÄI¹µÄ
  µÜ¢Ü·B

  Ü¸³µ¢o[WÌ JVM ðç¹Ä¢é©mFµÄ¾³¢B Oracle
  ªÞçÌ\tgEFAÉÎµÄ½ðµÄ¢éÌ©Íí©èÜ¹ñªAgp·é
  o[WÉ[Ë¶µÄ¢Ü·B

  ÉACD Ì[gfBNg©ç runInstaller ðç¹éãíèÉA
  install/linux ÉÚ®µÄ VFXNvg runInst.sh ðç¹éÆ¤Ü
  ¢©àµêÜ¹ñB

  ±ÌâèÍARedHat 6.0 æè 6.1 Åæ éæ¤ÅAVµ¢ C Cu
  ÉÖWµÄ¢éÌ©àµêÜ¹ñB

  Ü½AGnome ÌÊíÌEBhE}lW Enlightenment Åo[Wªá
  ¤Æ±Ìâèª¶·éÂ\«ª éÆ·¢½±Æª èÜ·Bo[Wð
  ã°é©A KDE â Fvwm2 Æ¢Á½¼ÌÂ«ÉØèÖ¦ÄÝÄ¾³¢B (ó
  F±êÍ RedHat 6.0 ÉÖ·éâèÅ·BÎµ½pb`ª RedHat ©ç_
  E[hÂ\ÉÈÁÄ¢Ü·)

  3.5.2.  CXg[ªXN[ãÅ½¾_ÅµÄA»ÌãÁ¦ÄµÜ¢Ü
  ·B

  ±êÍ¿µ¢±ÆÅÍ èÜ¹ñBÊíA±êÍÃ¢o[WÌ
  Enlightenment ðç¹Ä¢éÆ¢¤±ÆðÓ¡µÄ¢Ü·Bo[Wðã
  °½è¼ÌÂ«ÉØèÖ¦½è·é±ÆÅA±Ìâèðð·é±ÆªÅ«é
  Í¸Å·B

  ±êÆ½æ¤ÈâèÅ·ªAàÁÆæÌiKÅCXg[vOªÁ
  ¦ÄµÜ¤±Æà èÜ·BCXg[ªWª½I¹µ½ ½èÅN±é
  ±ÆÌ½¢»ÛÅ·BÇ¤âçªs«µÄ¢éçµ¢Æ¢¤ÌªåûÌ
  ©ûÅ·B}VÌXbvÌÊðâµÄÝéÆ¢¢Åµå¤B200MB æè
  ½¯êÎ\ªÈÍ¸Å·B

  3.5.3.  Cg[vOðN®µ½Æ«AïÈ Java ÌG[ª¶
  µÜ·B

  ÇÌo[WÌ Java o[`}VðgÁÄ¢Ü·©H½Ìl½¿ª
  ¼Ìo[WÅÌ¬÷ðå£µÄ¢éàÌÌAÌêAåªÌâèªð
  µ½ÌÍAOracle ªhLgÅ§µÄ¢é JRE 1.1.6v5 Éo[W
  ðº°½Æ«Åµ½B

  wE·é¿lÌ é±Æð ÆQÂ - K¸ JDK ÅÍÈ JRE ðg¤±ÆA
  à¤PÂÍA"green" Xbhðg¤×«¾Æ¢¤±ÆÅ·B THREADS_FLAG
  ð 'native' ÆÝèµÈ¢©¬èÍAÙÚmÀÉÝèÍ³µ¢Í¸Å·B

  3.5.4.  CXg[vOÅ 'Segmentation Fault'Æ¾íêÜ·B

  ¿áñÆ GLIBC 2.1 ðgÁÄÜ·æËH

  3.5.5.  ¤LCuð[h·éÆ«ÌâèB

  âèÌG[bZ[WÍ±ñÈ´¶Å· -

  error in loading shared libraries: libclntsh.so.8.0: cannot open
  shared object file: No such file or directory

  ±êÍANT ª DLL ð©Â¯çêÈ¢Æ¶åð¾ÁÄ¢éÌÆ¯¶Å·B¼·
  ÌÍÆÄàÈPÅ·Bàµ B VFÌVFðgÁÄ¢éÈçA
  ".profile" ÌÅãÉsðPÉÇÁµÜ·B (½Ì±Æ©í©çÈ¯ê
  ÎAgßÌÚµ¢lÉ¿âµÄÝÄ¾³¢)

  export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib

  Ü½AC VFÌVFÅÍsðg¢Ü·B

  setenv LD_LIBRARY_PATH "$LD_LIBRARY_PATH$ORACLE_HOME/lib"

  Í C VFðgíÈ¢ÌÅAÀÛÉ±ÌR}hðmFµÄ¢½¾¯éÆ
   èª½¢Å·B

  3.5.6.  Pro*C ª®«Ü¹ñ

  ¦É½ÇèÜÅµÎçâèðÇÕµÄÝéKvª èÜµ½BàÁÆ
  àê¶½³ª¹Î Oracle ÌEFuTCg©ÌÉ¦Í éÌÅ·ªB

  ftHgÌRtBM[VÅÍAPro*C ÍÇ±É·×ÄÌCu
  ª éÌ©mçÈ¢ÌÅA³¦Ä °éKvª èÜ·BCXg[µ½
  ã $ORACLE_HOME/precomp/admin/pcscfg.cfg ÍóÅ·ªAÌÚðLü·
  éKvª èÜ·B

  sys_include=(/home/oracle/precomp/public, /usr/include,
  /usr/lib/gcc-lib/i386-redhat-linux/egcs-2.91.66/include/,
  /usr/include, /usr/lib/gcc-lib/i386-redhat-linux/egcs-2.91.66/include,
  /usr/include)
  include=(/home/oracle/precomp/public)
  include=(/home/oracle/rdbms/demo)
  include=(/home/oracle/network/public)
  include=(/home/oracle/plsql/public)
  ltype=short

  (sys_include ©ç include) ÜÅÌÅÌSsÍt@CÌÅ·×Ä¯¶
  sÉu±Æ)

  Oracle ÌhLgÍGêÄ¢È¢ÌÅ·ªA
  $ORACLE_HOME/precomp/lib/env_precomp.mk àC³ÌKvª èÜ
  ·BCCPSYSINCLUDE ðè`µÄ¢ésÅAÌæ¤ÉµÜ·B

  CCPSYSINCLUDE=sys_include='($(ORACLE_HOME)/precomp/public,
  /usr/lib/gcc-lib/i386-redhat-linux/egcs-2.91.66/include,
  /usr/include/g++-2, /usr/include)'

  RedHat 6.0 Èç±êÅ¢¢ÌÅ·ªA¼ÌfBXgr[Vâ RedHat
  ÌVµ¢o[WÅÍ·±µÐËèªKv©àµêÜ¹ñB

  3.5.7.  pb`ðÄ½àÌÌAÜ·Ü·Ôª«»µÜµ½I

  ±êÍAOracle ÌhLgÉÙÆñÇ©êÄ¢È¢àÌÌA·×ÄÌ
  »iâCXg[vOÉ¤Ê·éâÁ©¢ÈâèÅ·B±ÌÉÖµ
  ÄÍA¢¢©°ñ Oracle ÉèðÅÁÄàçíÈ¢ÆI

  æN±éÌÍÌæ¤È±ÆÅ· - Oracle Enterprise Edition ðCX
  g[µÜ·B»µÄAOracle Ì¾¤ÊèA»ÌÜÜ±ñÇÍè³É é
  pb`ðCXg[µÜ·B»ê©çAvRpCªKv¾Æfµ
  ÄA¯¶ CD ©ç Oracle Programmer ðCXg[µÜ·B

  Pro*C ðCXg[·éOÍf[^x[XÍ®¢Ä¢½ÌÉA¢ÜÍà¤®
  «Ü¹ñB

  âèÍACXg[µ½o[WÌvRpCÉÍpb`ª½ÁÄ
  ¨ç¸AOracle T[oÌR[hÌêÍ»ÌC³ªÉË¶µÄ¢éAÆ¢
  ¤_É èÜ· - Oracle ÌCXg[Íð©Éà¯¶R[hÌVµ¢o[
  Wðã«µÄµÜ¤ÌÅ·B

  ð@ÍÏÁÆµÜ¹ñBCD ©çêÂêÂÌt@Cð²«o·±ÆªÅ«
  È¢ÌÅASÌðCXg[µÈ¨·Kvª èÜ·B¡xÍApb`ÌO
  É Oracle Programmer ðÇÁ·éæ¤ÉµÜ·B

  4.  f[^x[XÌì¬

  4.1.  TÏ

  Ü¾f[^x[Xðì¬µÈ¢æ¤ÉÆ¢¤OßÌAhoCXÉ]ÁÄ¢½¾
  ¯½Åµå¤©H

  ½ÌlXÉÆÁÄAf[^x[XÌì¬ÍÌ¾tÉvñÅ«é©àµêÜ
  ¹ñ - u'dbassist'ðÀs¹æv Oracle ðç¹éÌªßÄÅÈ¯ê
  ÎA'dbassist' ª·¢Äé¿âÉÍïÈ¦çêéÍ¸Å·B

  ®Sðú·½ßÉAÌâÁ½±ÆðhLgÉcµÜ·ªAÜ¸ÍÌ
  ÚwµÄ¢½àÌðq×éÌªxXg¾Æv¢Ü·Bvñ - ±êÍdpÌ
  VXeÅàu{iIÈv(¡[UÌAÜ½ÍAígpÌ) Jp{b
  NXÅàÈ¢ÌÅ·Bª 8i ðCXg[µ½ÌÍA8 ÈOÌo[W
  Éä×ÄÇ±ªVµ¢Ì©A é¢ÍÇ±ªáÁÄ¢éÌ©AÀÛÉ¢¶è
  ÜíµÈªç²×é½ßÈÌÅ·B

  »¤¢¤í¯ÅAÈé× 'dbassist' ÌÀÕÈIvVðIÑÜµ½BÊ
  ÌfBXNAÜ½Í¹ßÄÊÌp[eBVðgp·é±Æð§³êÜµ
  ½ªA»¤µÜ¹ñÅµ½BÌ $ORACLE_HOME Í /home/oracle Å·B·×
  ÄÌf[^t@CÆ\tgEFAÍÜÆÜÁÄ»±É èA1 ÂÌp[eB
  VÌãÉÚÁÄ¢Ü·B

  4.2.  XebvoCXebvKCh

  1. R}hvvgÅºÌæ¤É^CvµÜ·B

     dbassist

  2. Ì}VÍ "JNLS Exception: oracle.ntpg.jnls.JNLSException.
     Unable to find any National Character Sets." Æ¾ÁÄ«Ü·B
     Oracle8i pb`}jAÉæéÆA±êÍùmÌâè (884001) ÈÌÅ
     ³µÄåävÅ·B

  3. "Create a database" WI{^ðIðµA"Next" ðµÜ·B

  4. ±±Å2ÂÌIvVª èÜ·BÊí(Typical)ÆJX^(Custom)Å
     ·B dbassist Ììª«¿ñÆí©é®ç¢ÈçA±ñÈÆ±ëðÇñ
     ÅÍ¢È¢Åµå¤µAJX^ðIñÅàyÅµå¤B»êÍ±±Å
     Íæèµ¢Ü¹ñBãíèÉA"Typical" ðIðµ "Next" ðµ½àÌ
     ÆµÜ·B (ó: ú{êbZ[WðCXg[·éêÍ Custom
     ðIð·éKvª èÜ·B»iIðæÊÌÆ±ëÅEãÌ Language {
     ^ðNbNµAJapanese ðÇÁµÄ¾³¢)

  5. É CD ©çf[^x[XðRs[·é©f[^t@Cðì¬·é©·
     ¢Ä«Ü·BªAÅÌIvVðµ½Æ«ÍA Oracle Í CD v
     [ð©Â¯é±ÆÉíÉ¸sµÄ¢Üµ½B (½Á½¡»±©çC
     Xg[µ½Î©èÈÌÉI) Å·ÌÅA 2ÔÚÌIvVð¨©ßµ
     Ü·BÊÉïµ¢í¯ÅÍÈAµ]vÉÔª©©é¾¯Åµå¤

  6. f[^x[Xðç¹éÂ«ð·©ê½Æ«A'Hybrid' ðIð·éÌª¨
     »ç³ïÅµå¤B

  7. ¡xÍí½lÌ[Uªf[^x[Xðp·é©·¢Ä«Ü·BÍ
     5 ÆüêÜµ½B

  8. ÉVµ¢f[^x[XÉÇÌ»iðüêé©·¢Ä«Ü·B±±ÅàA
     ©ªª½ðüê½¢Ì©ÈñÄæèÇÒÌF³ñÌÙ¤ªæí©ÁÄ
     ¢Ü·æËI
  9. ±±ÅAOracle Í uO[of[^x[X¼v Æ "SID" ðKvÆµ
     Ü·B±Ìf[^x[X¼ÍAthC¼Ìæ¤ÈàÌÅ·B (µ©
     µÊ¨Å·) Oracle ÌBlÈç½ðüêé×«©í©éÅµå¤ªA»¤
     ÅÈ¢êAÇÒÌïÐÉÍÈñç©Ì½¼K¥ª é©àµêÜ¹ñB
     ÌêÍA'dev1' ÆµÜµ½B(SID Æf[^x[X¼Ì¼ûÉÎµÄ)

  10.
     ³ÄAf[^x[Xð¢Ü±±Åì¬µÜ·©H»êÆàKvÈîñ
     ðVFXNvgÉÛ¶³¹½Ù¤ª¢¢Åµå¤©H128MB Ì RAM Å
     ÍAOÒÌIvVÍêÉ¾Æ¢¤±Æªí©èÜµ½BÍVFX
     Nvgðì¬µAX ÈÇðåÊÉÁï·éàÌð·×ÄI¹³¹
     ÄA»ÌXNvgðç¹Üµ½B»Á¿ÌÙ¤ª¸ÁÆèÛª¢¢Å
     ·B

  11.
     hLgÌÇ±Éà©Â©çÈ©Á½ÌÅ·ªA±êÈµÉÍf[^
     x[XÍÜÆàÉ®«Ü¹ñI 'dbassist' ªì¬·éf[^x[X©Ì
     Í¢¢ÌÅ·ªAftHgÅ[U[obNZOgªItC
     ÉÈÁÄ¢Ü·B(ß - ñVXe[UÍgUNVðKv
     Æ·éìðÀsÅ«Ü¹ñ) ÈºÌæ¤É^CvµÜ·B

     cd $ORACLE_HOME/dbs

  ±±ÅA"init<SID>.ora" Æ¢¤¼OÌt@CðÒW·éKvª èÜ·B
  (Ìê "initdev1.ora" Åµ½)

  t@CÌ^ñ ½èÅA±ñÈ´¶ÌsªRgAEg³êÄ¢Ü·B

  # rollback_segments = (r01, r02, r03, r04)

  ±ÌsÌRgðOµÄ(V[vLðæè) t@CðÛ¶·êÎ
  IíèÅ·B

  12.
     ±êÍ^XebvÆÅàÄÔ×«àÌÅ·Bf[^x[Xª ÁÄN®
     Å«éÍ¸¾ÆµÄàA¨»çpX[hVXeÉÂ¢ÄÍ½àmè
     Ü¹ñæËImÁÄ¨×«±Æª2Â èÜ·B1ÂÍ SYSTEM ÌpX
     [hÅ·BftHgÍ 'MANAGER' ÉÈÁÄ¢Ü·B (Oracle ÌpX
     [hÍå¶É·éÌªKíµÌæ¤Å·BÀÛÉÍAå¶¬¶Ìá
     ¢ÍF¯³êÜ¹ñ) SQL*Plus ÌvvgÅ password Æ^CvµÄA
     ·®ÉpX[hðÏX·é±Æð¨©ßµÜ·B (ALTER USER R}h
     ¶áÈ¢©Æv¤là¢éÅµå¤ªA±êÍ 8i t®o[WÌ
     SQL*Plus ÌVR}hÅ·) ¼ÉméKvª éÌÍA SYS ÌpX[
     hÅ·B±ÌftHgÍ 'CHANGE_ON_INSTALL' ÅA»Ì¼ÌÊèCX
     g[µ½ç·®ÉÏXµÜµå¤I

  13.
     ÅãÌXebvÅ·B±êÍASQL*Plus ÖÌOCÌ¤ÁÆ¤µ¢
     'no profile' xðæè«Ü·B'system' [UÆµÄOCµÄ
     ¾³¢B(sqlplus system/<password>) »ê©çÌæ¤É^CvµÜ
     ·B

     @?/sqlplus/admin/pupbld.sql

  ^âÍ $ORACLE_HOME fBNgÌGCAXÅ·B

  ±êÅIíèÅ·B±êÅASQL*Plus ðgÁÄOCÅ«ÄA·®Ég¦
  éf[^x[XªÅ«Ä¢éÍ¸Å·B

  4.3.  p`

  4.3.1.  {É»ñÈÉÈPÈñÅ·©H

  ¦ÍCGXÅ èm[Åà èÜ·B½¾Vñ¾èA8i ÌVµ¢Á¥ðw
  Ô½ßA©ª©gpÉf[^x[Xð\z·éÈçA¦ÍCGXÅ·BãÌ
  w¦É]ÁÄÅ«éf[^x[XÍ®SÅA¤Ü®ìµÜ·B

  µ©µAOracle ÉÂ¢Äm¯ª éÈçAftHgÌRtBM[
  VÍ «êéÙÇÐÇ¢àÌ¾Æ·®ÉCÃÅµå¤Bàµ{iIÈd
  pÌVXeðìÁÄ¢éÈçA"Custom" IvVðgÁ½Ù¤ª¢¢
  Åµå¤B

  Ì¨VÑÌVXeÉÎµÄ³¦A¢ç©ÐËèðüêÜµ½BåªÌ
  e[uXy[XÌTCYðâµA©Â»êª©®IÉ¦È¢æ¤ÉµÜ
  µ½B (ûÔé\tgEFAÍ¢Å·)

  4.3.2.  {É·×ÄÌt@CðÊXÌfBXNÉüêéKvª èÜ·
  ©H

  KvÍ èÜ¹ñB»¤µÈÄà®ìµÜ·Bµ©µA»¤¾ÆµÄàA·
  ×ÄÌt@Cð¯¶fBXNÉüêéÌÍ©ßÜ¹ñB

  t@Cð¢Â©ÌfBXNÉªUµÄuÆA½Æ¦f[^t@CÆ
  [obNZOgðÊXÉ·é¾¯ÅàAµ¢ptH[}XãÌ_
  ª èÜ·BÚµÍAOracle DBA book ðÇñÅ¾³¢B

  4.3.3.  dbassist ðN®Å«Ü¹ñ

  ÅÉCXg[µ½É¢Â© é·³ 0 Ìt@Cª´öÅ·B
  pb`ðÄéÆâèÍðµÜ·B

  4.3.4.  "ORA-01034: ORACLE not available" Æ¾íêÜ·

  ÈPÉ¾¤ÆA¨»çA$ORACLE_SID ª³µÝè³êÄ¢È¢©A é¢
  ÍÜÁ½Ýè³êÄ¢È¢©AÅ·B'dbassist' Å^¦½àÌÆ¯¶lÉ
  Ýè³êÄ¢ÄA©ÂGNX|[g³êÄ¢é±ÆðmFµÄ¾³¢B (Â
  Üè B VFÝ·VFÅÍAexport ORACLE_SID)

  4.3.5.  "ORA-01012: Not logged in" Æ¾íêÜ·

  ±êÍÆÄà èÓê½G[ÅA¢ë¢ëÈ´öª èÜ·B

  Ü¸A¤LT[o\¬ (MTS ÆÄÎêé±Æà é) ÅÍÈ¢±ÆðmFµÄ
  Ý½Ù¤ª¢¢Åµå¤BêpT[o\¬ðgÁÄf[^x[Xðì¬µAã
  Å»êðÏ·µÜ·B (óF¤LT[o\¬ÅÍAÍêÂÌT[o[vZ
  Xª¡Ì[U[ZbVÌðó¯ÂÌÉÎµAêpT[o[\¬
  ÅÍA[U[ÌZbVPÂÉÎµÄ Oracle ÌT[o[vZXªêÂ
  ¶¬³êÜ·)

  ±êª´öÅÈ¯êÎANLS_LANG Â«Ïð`FbNµÜ·BêÔÈPÈÌ
  ÍA»êð unset ·é±ÆÅ·Bàµ{Ég¢½¢ÈçAK¸®àøÉ³µ
  ÝèµÜ·B 1 (¢¿) Æ l (G) ðæèá¦È¢æ¤ÉCðÂ¯Ä¾
  ³¢I (óFEUC gpÌú{êÂ«ÅÍ japanese_japan.ja16euc ðg¢Ü
  ·B½¾µÂ«Ï ORA_NLS33 à³µÝèµÈ¢Æú{êbZ[WÍg
  ¦Ü¹ñ)

  5.  RtBM[V

  5.1.  TÏ

  ¨ßÅÆ¤BÇÒÌ Linux }VÉ Oracle ªéæ¤ÉÈèÜµ½Bf[
  ^x[XàÅ«Ä¢Ü·µASQL*Plus ðgp·êÎAf[^x[XÉÚ±Å
  «Ü·B

  à¿ëñA±êÅIíèÆ¢¤í¯ÅÍ èÜ¹ñBzð¾¦ÎAÊÌ
  Unix [UâÜÁ½ÙÈÁ½}V©çf[^x[XÉÚ±Å«éÆ¢¢
  Å·ËB±ÌßÅÍ»êÉÖµÄq×Ü·B

  5.2.  Ê[UÆµÄÚ±·é

  ±êÍªÂlIÉgÁÄ¢éRtBM[VÅÍÈ¢ÌÅA±Ìß
  ÌÚ×ÉÂ¢ÄÍ¢ç©¨¨´ÁÏÈLqà èÜ·Bµ©µAÌèÌ
  ¤¿ÌêÂðÀs·é±ÆÅ¤Ü¢Í¸Å·B

  o  B VFÌVF (Bash â pdksh) ðç¹Ä¢éÈç

     . oraenv

  o  C VFªD«Èç

     source coraenv

  ÌÂ«ÅÍA"oraenv" ðç¹Ä¢éÆ«ALinux ÌftHgÌVF
  Å é 'bash' ðg¤ÆG[ªoÜ·B½àâèÍø«N±µÄ¢È¢æ¤
  ÈÌÅASz³pÅ·BàµÇ¤µÄàsÀÈçA'pdksh' ðg¦Î¢¢Å
  µå¤B

  5.3.  ÊÌ}V©çÚ±·é

  úÌo[WÌ Oracle ÅÍñíÉ¡G¾Á½ÆL¯µÄ¢éàÌÌA±
  ±ÅÍ¤Ü®¢Ä¢éæ¤É©¦Üµ½Bm©ÈÌÍA±êÍAª½©Ü
  ¿ªÁ½±Æðµ½©AâÁ½±ÆðYêÄµÜÁ½©A é¢ÍåÈZ
  LeBz[ª é©AÆ¢¤±ÆÅ·B

  ªâÁ½ÆL¯µÄ¢éÌÍ -

  1. Linux Ì 'oracle' [UÆµÄOC

  2. "oraenv" ªÀsÏÝÅ é±ÆðmF·é (ÂÜèA$ORACLE_HOME ª³
     µÝè³êÄ¢éÆ¢¤±Æ)

  3. Ìæ¤É^Cv -

     lsnrctl start

  NCAg}VÅ·éKvª éÌÍA}VÆf[^x[XCX^
  Xð³µwè·é±Æ¾¯Å·B

  vZXðàÁÆ×©§äµ½¢êÉÍANet8 Configuration Assistant
  ('netec') ªð§ÂÍ¸Å·B

  5.4.  ÊÌ}VÖÚ±·é

  ½ÌúÌo[WÌ Oracle ÅÍA±êÍñíÉïµ¢±ÆÅµ½B½
  ³ñÌeLXgt@CðÒWµÈ¯êÎÈçÈ¢ÌÅ·ªA»Ì½ÍÁ
  ÙÇ¡GÈ\¶ðÁÄ¢Üµ½B
  µ©µ 8i ÅÍAJVM ªÁÄ¢é©¬èAKvÈÌÍ Net8 Easy Config v
  O¾¯Å·BÊÌ}VÌf[^x[XÉÇÒÌ}VðÚ±³¹é½
  ßÉÍAÌèÉ]ÁÄ¾³¢B

  1. oracle ÆµÄOCµÄ¢éÔÉAR}hvvgÅ netec Æ^
     CvµÄ "Net8 Easy Config" ðN®µÜ·B

  2. Java Ìú»ðµÎçÒÁ½ãAwelcome æÊª»êÜ·B»±Å½ð
     ·é©·©êéÍ¸Å·B¶ÌWI{^Í»ÌÜÜÉµÄ(ftHg
     Í create) eLXg{bNXÉf[^x[X¼ðüÍµÜ·BIíÁ½ç
     'Next' ðNbNB

  3. ñ³êévgRÌ¤¿PÂðIðµÜ·BÁÊÈ±ÆÅàÈ¢©¬
     èAftHgÌ 'TCP/IP' Å¢¢Åµå¤B'Next' ðµÜ·B

  4. [g}VÌzXg¼ (Ü½Í IP AhX)ðüÍµÜ·B|[gÔ
     Í¨»çÏX·éKvÍ èÜ¹ñB'Next' ðµÜ·B

  5. WI{^ðgÁÄf[^x[XÌíÞ(8i Ü½Í»Ì¼) ðIðµA
     KÈeLXg{bNXÉ»Ì¼OðüÍµÜ·B'Next' ðµÜ·B

  6. ±±ÅAüÍµ½îñª Oracle ÉÆÁÄÓ¡ðÈ·©eXgÅ«Ü·B
     àµÚ×ÉÔá¢ª éÆA'netec' ÍNbVµâ·¢±ÆÉCÃ«
     Üµ½B·×Äåäv¾ÆmMÅ«½çA'Next' ðµÜ·B'Back' {
     ^ðµ±¯Ä³ÉßèAÇñÈîñàù³·é±ÆªÅ«Ü·B

  7. üÍµ½îñÉ·×Ä«¢Á½çA'Finish' ðµÄ¾³¢B±êÅ
     IíèÅ·I

     vZXÉÎµÄ×©¢§äðÁ¦éÈçA"Net8 Assistant" ðg¤Kv
     ª é©àµêÜ¹ñB"Net8 Assistant" - ´çíµ¢IvVª½
     ³ñ éå«ÈEBhE - Í netasst R}hÅN®Å«Ü·B

  5.5.  p`

  5.5.1.  netasst ªN®Å«Ü¹ñB

  ±ÌâèÍQÂÌ·³OÌt@CÆÖWµÄ¢Ü·Bpb`ðCXg[
  ·êÎð·éÍ¸Å·B

  6.  ÑÌ¾t

  6.1.  ðÉ§Â\tgEFA

  ÈñÆ© Oracle ðCXg[Å«½ÌÅAµÉgÁÄÝ½¢ÆvÁÄ¢
  é±ÆÅµå¤BT[oÌ PC Å½ÅàÅ«Ü·ªAêÊIÉÍANCA
  gT[oÌ@\ðgpµÄA¼Ì}V©çf[^x[XÉANZX·éÌª
  xXgÅµå¤B

  RAOracle ÉÍA¨µÈ×Ä©Èèæ¢NCAg\tgEFAª½
  ³ñ èÜ·ªA±Ì_ÅÍ Linux pÍ Üè èÜ¹ñBOracle Ì\t
  gEFAÌÈ©ÅÍAÌàÌðüè·é±Æð©ßÜ·B

  o  Oracle Enterprise Manager. í©èÃç¢ ALTER USER Æ© ALTER
     SYSTEM R}hðo¦éæè¸ÁÆÈPÅ·B

  o  Oracle WebDB. CXg[·éÌÍ©Èèïµ¢àÌÌA HTML ðmç
     ÈÄà©h¦Ì·éEFuTCgð\zÅ«Ü·B

  µ©µÅÌ\tgEFAÍAåªA¼ÌÆ±ë©çâÁÄ«Ü·EEEB

  o  Tool for Oracle Application Development (T.O.A.D.).  ±êÍ©ÂÄÍ
     t[Åµ½ªA¢ÜÍ Quest Software <http://www.quest.com> ªL
     µÄ¢Ü·B (àµQ²ÆÉ_E[h·éCª éÈç) t[
     o[Wð_E[hµÄà¢¢µA é¢Í¨àð¥ÁÄà¢¢Å
     µå¤B³¿ÌàÌÆä×êÎ¢Æ¢¦Ü·ªA»ê¾¯Ì¿lª è
     Ü·B

  o  SQLNavigator. ±êà Quest Software <http://www.quest.com> Éæéà
     ÌÅ·BÀÍAÍgÁ½±ÆªÈ¢ÌÅ·ªAgÁ½l½¿ÍÝñÈ
     ©ßéÆ¾ÁÄ¢Ü·B

  o  Orac <http://www.kkitts.com/orac-dba/>.  RtBM[VÂ\
     Èæ¢ DBA c[Å·B

  6.2.  ðÉ§Â{

  Í¯»Æ{©ç Oracle ÉÖ·éîñÌåªðüèµ½CªµÜ·B¯»
  ð¨·»ª¯·éí¯ÉÍ¢«Ü¹ñªAª¨©ß·é{ÍÌÊèÅ·B

  o

     "Oracle Performance Tuning," Mark Gurry and Peter Corrigan,
     O'Reilly and Associates, ISBN 1-56592-237-9.

  o

     "Oracle Design," Dave Ensor and Ian Stevenson, O'Reilly and
     Associates, ISBN 1-56592-268-9.

  o

     "PL/SQL Programming," "PL/SQL Programming," Steven Feuerstein,
     O'Reilly and Associates, ISBN 1-56592-335-9.

  o

     "PL/SQL Built-in Packages," "PL/SQL Built-in Packages," Steven
     Feuerstein, O'Reilly and Associates, ISBN 1-56592-375-8.

     O'Reilly <http://www.ora.com> Ì{Î©è¾ÆCÃÆv¢Ü·BÍ
     Ü¾ O'Reilly Å_È{ð©½±Æª èÜ¹ñB¯lÉAOracle
     Press Å¢¢{ð©½±Æà èÜ¹ñB

  6.3.  C^[lbgãÌðÉ§Â\[X

  EFuÉÍðÉ§ÂàÌª½³ñ èÜ·B

  o  Oracle Technet <http://technet.oracle.com>.  Oracle Ì³¿T|[g
     Ì éöJEFuTCgBñíÉð§Âîñª½³ñ èÜ·B

  o  Oracle Metalink <http://support.oracle.com>. Oracle ÌñöJ (T|
     [g_ñðÔKvª é)T|[gEFuTCgBTechnet æèð§Âà
     ÌÌá¢Íí¸©Åµ© èÜ¹ñB

  o  Oracle Fans <http://www.orafans.com>.  _àÆT|[gÌtH[
     QBOracle ÆÍö®ÌÂÈªèÍ èÜ¹ñB (]ÁÄîñÉÎèªÈ
     ¢Å·)

  o

  o  OraFaq <http://www.orafaq.org>. ·×ÄÌvbgz[Ì Oracle É
     Â¢Äp`ðÚB

  o  Oracle Linux [OXg( ListGuru@fatcity.com
     <mailto:ListGuru@fatcity.com> É 'SUBSCRIBE ORACLE-LINUX-L' Æ{¶
     É¢Ä[ðé) (óFú{ÅÍAo4l ML (Oracle for Linux ML)
     ªL¼Å·Bú{INªåÃµÄ¢é ML ÅÍ èÜ¹ñBåÉ
     Linux Å Oracle Ìbèªc_³êÄ¢Ü·Bo^èÍo4l-
     ctl@blue.gr.jp  Ö subscribe Taro Yamada (¼OÍKÉÏ¦Ä¾³
     ¢) Æ¾¯¢½[ðêÎ OK Å·)

  o   ÆÌEFuTCg <http://www.zx81.org.uk>àYêÈ¢æ¤ÉI