   Ŭ ġ Ͽ

  :Stephen Darlington, stephen@zx81.org.uk

  $Id: oracle-howto.sgml, v1.12 2000/04/01 14:35:07 sd Exp $
  :ȣ(KwangHo, Yun), airplanez@kldp.org

  oracle-8-howto_kr.sgml, v0.04 2000/09/04 14:35

   Ͽ , ణ  ִٸ, "Oracle 8i Enterprise Edition
  for Linux"  ġ ͺ̽   Ʈӽ DB Ҽ
  ִ.  ̹ ֵ  ޸ 6.0 , Ư 
     ٸ  ɼ ִ.
  ______________________________________________________________________

  

  1. Ұ
     1.1 ⿡  ?
     1.2  Ѱ?
     1.3 ̹ 
     1.4 Ǹ
     1.5 ó е
     1.6 ۱

  2. 
     2.1 
     2.2 
     2.3  
        2.3.1  
        2.3.2 Ŀ Ķ
        2.3.3 Users and groups
     2.4  亯
        2.4.1  ޸𸮰 128Mb  ʿѰ?
        2.4.2 Ŭ8 RedHat 6.1 ۵ϳ?
        2.4.3 Debian/SuSE/Mandrake/some  ٸ  ۵ϳ?
        2.4.4  Ŀڿ ۵ϳ?

  3. ġα׷
     3.1 ?
     3.2 ġα׷  Ҽ ?
     3.3 ġ ġ
     3.4 ȯ漳
     3.5 ġ /亯
        3.5.1 ġα׷ 'CreateOUIProcess()' 
        3.5.2 ġα׷ ȭ鿡  Ÿ 
        3.5.3 ġα׷ ۽ ̻ ڹٿ(Strange Java errors)?
        3.5.4 ġα׷ ׸Ʈ(Segmentation Fault's)
        3.5.5 ̺귯 (loading)
        3.5.6 Pro*C  ۵ 
        3.5.7 ġ ġߴµ  !

  4. ͺ̽ 
     4.1 
     4.2 ܰ躰 
     4.3  亯
        4.3.1 ̰  ?
        4.3.2  ȭ ٸ ũ ִ°  ʿѰ?
        4.3.3 dbassist Ҽ .
        4.3.4 "ORA-01034: ORACLE not available"  ż
        4.3.5 "ORA-01012: Not logged in"  ż

  5. 
     5.1 
     5.2 ٸ(another user) 
     5.3 ٸ (another machine) 
     5.4 ٸ (another machine)  
     5.5 /亯
        5.5.1 'netasst' Ҽ 

  6. 
     6.1  Ʈ
     6.2  å
     6.3  ͳڷ

  ______________________________________________________________________

  1.  Ұ

  1.1.  ⿡  ?

   ư Ϲ ڿ ȣ  ˷ִ.
  н ȣ ѻ  װͿ ǵ ݴ뵵  ʴ´.

  Ŭ ϴٰ Ѵ. ó Ŭ ϱ .,
  ׷  ٸ RDBMS  Ҷ Ʊ .

  ΰ غ, 8i  ι° ̰,  ΰ
  ͼϴ  ߵ ʴ´ٴ  ˾ƾѴ.

   ġ ߴ. ׷  ־.    Ƶ̰ų
    ,  ϰ(?) ϱ װ͵ ȭ ߴ.

  1.2.   Ѱ?

  ,   Ŭ 8i( Ŭ  8.1.5) ġϱ 
   Ѱ̴.     ٷ ȴ´.   8.0
   ġϱ Ѵٸ (Linux Journals guide)
  <http://www2.linuxjournal.com/lj-issues/issue67/3572.html>  
  ϶ Ѵ. ׸  SCO   ġϱ Ѵٸ Paul
  Haigh Ŭ ͺ̽ Ͽ(Oracle Database HOWTO)
  <http://www.linuxdoc.org/HOWTO/Oracle-HOWTO.html>  ̿϶.

    'ٷ  (Oracle 8i)' ġϷ Ѵٸ, ⿡ 
  ׸ ⺻ ִ.   찡 ׷ٸ Ȯ 츮
   ó(same wave-length)  ִ°̴.

  o    н ߴ.  н  о̿.
     п SunOS/Solaris  ʸ ߰,   SunOS/Solaris
      Ŭ ž߰, HP-UX(1) , (5Ŀ, 
     ƴϰ ) Ŭ ߴ.

       Windows  NT ٰ̾ Ѵ.   Ŭ
     ġϴ   ƴ. ׶ ߱  ؾ 
       ִ.

  o    Ŭ ߾. DBA'd 7.1  7.3 ġ, 8.0
       ߾( Solaris ). Ե, Ŭ ġ
       . ׷ ڰ   ƴ
     Ŭ μ  ϴ.

      Ŭ  غ ʾҴٸ     ð
      ٸ   ڷᰡ  Ѵ.

    ̺о߿   ִٰ Ѵ.  Ŭ ġ
    ƴϸ, ׷  ̹ 'ġ ()'
   ̵  ̴.   ׷ " "
  Ѵٸ  HOWTO Ŭ Ƹ ٸ  ƴϴ.

  1.3.  ̹ 

   Ŭ  Ѵ.ٽøϸ   ݹ  ȴ.
     ѵδ      Ʈ
  <http://www.zx81.org.uk/computing/oracle/oracle-howto/>  ã
  ٶ.

  1.4.  Ǹ

     å̴.  õǰ ƴϰ   
   ʴ´.    Ҽ ִ   װ 
  å̴.

  1.5.  ó е

   HOWTO  Stephen Darlington  . ̹ Oracle
  Technet  ׷   亯 ̴ 
  .  ׷ ׺е鲲  ϰ  ó  ϴ
  Ϳ  ˼ϰ Ѵ!

  ̹  Ton Haver, Guy Cole, Iain Frerichs, Albert Braun,
  Steve Morando, Krill Kokoshka  Ѵ. ()

    HOWTO Ϲ , Ŭ  Ǽ ǵ
  ϸ stephen@zx81.org.uk <mailto:stephen@zx81.org.uk>  ̸
  .

  1.6.  ۱

  ̹ ۱ Stephen Darlington(copyright 2000) ִ.  
  ̹ Ӱ ϰ ϰ Ҽ ִ.

  o  ۱ǰ  ϰų ٲѴ.

  o   ȣ ¥ ϰų ٲȯ.

  o   ϴ° ϰų   WWW ٲѴ.

  o   ,  ǥְ    ׷϶.

  ̷  Ǿ ȿ ų,     
  ڸ ȣϱ Ѱ̴.

  ( ۱ǰ  Eric Raymond Ͽ  )

  2.  

  2.1.  

   ܶ Ŭ ġ  ҰԴϴ.

  Ŭ ġ  PC ,  ġ/, Ʈũ
   Ϸ Ŀ ۵ȴ.

  2.2.  

    ߿  װ(α׷ġ)  ʴ°Ͱ
  Ʈ  Ϳ ؼ  ؾϴ  ϰ
  ٸ ʴٴ ̴(??????).

    ̾߱:

  o   ó ū Ǽ Ŭ 128Mb  ʿ Ѵٴ 
       ̴.  Ŭ ι Sun  ׷ ϰ
     ġߴ.  CISC 谡 ʿ ϸ鼭.

     Ŭ (?) ٸٴ  Ͼ.   ٴ 
     ϱ ,  32Mb    ִ ý 1ð
     30 .

  o  Ŭ ڹ Ÿ ȯ  1.1.6(Java Runtime Environment
     version 1.1.6)  ʿϴٰ, " Ҹ,  װ 
     ݾ".ߴ.  ٵ ġ α׷ Ƹ  ʴ´.

     :  ϴ Blackdown's JRE 1.1.6v5  ٿε϶.
     ·ų ʴ Ұž.

  Ŭ κ    ݿ  δ.
   ġϷ ޿ ġ϶.  ٸ  õϴٰ
  ߴٴ ̾߱⸦ .

    6.0 ġ ſ   Ÿ.   JRE
  1.1.6.v5  ٿεϿ ġ 1999 8   ġ
  , Ŀ 2.2.13  ׷̵ߴ.  ׷ װ 
  Ʈī带 ϱ Ѱ̴.  2.2.5 Ŀڿ Ŭ
   ʴ´ٰ   .

  ϶, Ŭ ġα׷ JRE  /usr/local/jre/bin/jre 
  ġѴٰ ˰ ִ. ̰  JRE װ ݵ ġؾ
  Ѵٰ ϴ  ƴϰ JDK ġѴٸ Ŭ ġ Ѵٴ
   ϴ ̴.  ̰ ſ ߿ϱ⿡ ٽøϴµ ݵ JRE
  ϶, JDK ϸ Ŭ ġ Ѵ!

  JRE    ϶.

  1. Blackdown Ʈ <http://www.blackdown.org> ڹ Ÿ ȯ
     (JRE) ٿε϶.

  2. ٿε Ѱ JRE ġ (/usr/local) Űܶ.

     cd /usr/local

  3. ī̺긦 Ǯ,

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

  4.  ġ  Ŭ ϴ  ɺ ũ϶.

     ln -s jre116_v5 jre

  ϵ ؼ  ϴ ȯ̶ Ŭ Ѵ.
       466Mhz  128Mb ޸𸮿 8Gb
  ϵũ, DM9102 Ʈũ ī带 Ѵ. ̰ Ŵ
  ͺ̽ α׷  ǻʹ ƴ,  ׽Ʈ
  ȯ Ϻϰ ۵Ѵ.

  2.3.   

  2.3.1.   

   ܶ ߵ, Ŭ RedHat 6.0 ̿Ͽ ȯ漳
  Ѵ.  о ġ   Ƹ ̰ ϴ  
  ̴.

  ׷ Ŭ ϱ   ɼ ְ, 󸶳  
  Ű ġؾߵǴ°?

   ޸ 2 3  ƾѴ(ġ α׷ ϱ
  ؼ    ޸𸮸 ؼ 200Mb ޸𸮰 ־ Ѵ.)
  ϶ Ϲ ϴ Ͱ ޸  128Mb ū 
  Ҽ ִ.

   ٸ Ƽǿ  ߿Ҽ ִ. ϶ Ŭ
  α׷  OSƼǰ ٸ̾ϰ, Ŭ  ȭ 
  Ǵٸ Ƽǿ ġؾѴ. ̷  Ŭ ȭ л
  ´.( ȯ濡 Ŭ ؾ  ũ 
  ִ. װͿ    å  ִ.)

  Ʈ ؼ,  " ġɼ" ߰  Ű
  ġߴ.  Ƹ  'base' Ű, X Windows(ġ 
  ڹ GUI),  (tool)( α׷ ڵ ϴ ϴ)
  ʿҰ̴.  Ŭ ͺ̽ ϸ   ũ
  ſ, ⲯؾ ⰡƮ ̸̴.  Ϸ 
  ġϴ° .

  2.3.2.  Ŀ Ķ

       ޸    Ŀ ٲܰ
  Ѵ.  ׷ ϴ  ſ ٷӱ⶧(κ
   Ͻ Ŀ ٽ  ϴ°Ͱ Ʋ),  ϴ
  Ŀ 缳 Ŭ ġ ߵǰ Ѵ.   ⺻
  ÿ , ū    ý ؼ 
  ٽؾѴ.

  ,   Ŭ  ۵ϰ ϱ ؼ Ŀ ٽ
   ؾѴ.  װ  ǻͼ ۵ϴ ٸ 
  Ʈ  ȴٰ Ѵ.

  Ŀ ٽ  Ϸ Ŭ(ν CD  HTML)
    Ŀ ϿƮ(Linux Kernel HOWTO)
  <http://www.linuxdoc.org/HOWTO/Kernel-HOWTO.html>  .

  2.3.3.  Users and groups

  LinuxConf Ͽ, "dba" ο ׷(group) "dba" ϴ
  "oracle"̶  ο (user)  ʿ䰡 ִ.

    ڸ DBA group μ ٸ DBA  
  ִ.   DBA  ϴ  ȸ˻(auditing) 
   ̴.

  2.4.   亯

  2.4.1.   ޸𸮰 128Mb  ʿѰ?

   128Mb   ̻  õѴ.   ۿ
   ϴ.

  ׷.  ڹ ɼ , ޸  ۰ Ѵٸ,
    . 64Mb  ޸𸮿 ߴٴ  .
  32Mb Ƹ ۵  ̴.

    ִµ. Ŭ 䱸ϴ  ݸ Ǿ Ŭ 
  ִ. ׷ ġ غ ׵ 䱸 ϰ ȴ.   ν
  α׷ 150Mb  ޸𸮸 ٰ   쿡 120Mb
  ̻ ־ ߴ.  64Mb̰ų  ޸𸮸  ִٸ 
  Ұ γ  Ѵٴ  ϶.

  ٸ ( Ȯ  ) Ŭ ٸ ūǻͿ
  ġϰ $ORACLE_HOME  丮 ؼ ϴ ̴. 
  ڰ  ׷     ʰڴ°.

  2.4.2.  Ŭ8 RedHat 6.1 ۵ϳ?

  ڽ 6.0  ۵Ű ִ. ׷    6.1
  ߴٴ  ٰ ۿ Ҽ .

  ̹  ÿ Ŭ 8i RedHat 6.0 Ǿ, "ٸ
    " ̾.(Oracle 8i Patch FAQ).

  2.4.3.  Debian/SuSE/Mandrake/some  ٸ  ۵ϳ?

  Ŭ Ŀ  2.2 ̻ GLIBC  2.1   ޴ 
  ϰ ִ. ̷л õ 䱸 ϸ   
  Ѵ.

  δ Ŭ     ġÿ   
  ϰԵȴ. Ư      6.0 Ҽ ִ 
  ġ Ͽ ġ϶ Ѵ.

  2.4.4.   Ŀڿ ۵ϳ?

  ۵  Ȯ   -- 2.319  ѵ Ͽ.
  װ  ī带 Ͽ  ׷ ߱ ̴--
  ׷,   ʿ䰡 ٸ װ  
  ϰ̴.(????)   ̹ ԵǴ   
  Ŀڷ ư.

  3.  ġα׷

  3.1.  ?

  Ϲ  °  ̴. ׷ ϴ° 
  Ŭκ     ̴.(Ŭ α׷
       ߸Ǵ  ִ.. -װ ׷-
     ޴  ̴.)

  ̹  ͸ ٷ̴. ׷    Ŭ
    Ҽ ִ.

  3.2.  ġα׷  Ҽ ?

  Ŭ ġ ġα׷   . Ϲ 
    ڽ ,  Էϴ ˾ƾ Ѵ.

  1. ġα׷(runInstaller) user(oracle user)  Ѵ.

  2. ġα׷  ȭ ̴ٰ. 'Next' Ŭ϶.

  3. ġ('jar'ȭ) ҽ ִ 丮 ġ 丮
     Է϶ Ұ̴. (Ʈ) Էµ  ܵξ
     .  Ŭ Ȩ丮  Ŭ ġϷ ϴ ̴.
     Ŭ   ġϷ  /u01   װ
     ϰ /home/oracle  ġϿ. ̷ Ŭ 
     ° .  ڼ  Էߴٸ 'Next' Ŭ϶.

  4.  DBA ׷  ̴. ̰  ܶ  н
     ׷̸ Ƹ 'dba' ̴. ̰ Էϰ 'Next' ŬѴ.

  5.  'root' α Ͽ /tmp/OraInstall/orainstRoot.sh  
     䱸Ұ̴. ׷ ϶.(׷ ϱ  pdksh ̳ bash  
     Ѿ Ұ̴.) ׷ ϰ 'Retry' Ŭ϶.

  6.  ġҰ  ̴. ּ   ġϴ
     ġϴ ڼ ִ.)   ư ϰ

  7.   ġϷ   ڼϰ Ҽ ִ.  
      ϴ ˰ų Ư ũ   ƴ϶
      'Next' ŬϿ ׳ ġ ϰ ʹ.  Ϲ
     ġα׷     Ƿ, 
      ġ ʰڴٰ  ʴ´ٸ  ʿ.
     ׸  ǵư ٽ ߰Ҽ ִ.

  8. ġ α׷  ġϰڴٰ     ϴ 
     ġҼ ְ Ұ̴. ٽ , ׷ Ư 
      ׷ ϶.  Ǿ 'Next' .

  9.  ġα׷  䱸 α׷ ġҰ̴.
     ̰   ð ɸ  ޸𸮸 Ұ̴.

  10.
     α׷ġ   ̽ ̳İ .
       ޸𸮸  ְų γ  ʴٸ 
     'No' Ұ õѴ.  ġα׷ Ǵٸ
     ڹٰӽ(Java Virtual Machine) X츦 ϴ ó
     ̱ ̴. ϰԵ 2 JVM Ŭ  Ű
       128Mb  ʴ.     
      Ƽ װ   .( ͺ̽ 
     ġѴٸ ۵ ʴ´ٰ Ѵ.)

  11.
      ġα׷ Ŭ  Ʈũ 
     ̴.    ȭ  ־. μ ̰
      ϴ ˼ . ׷  'Next' ŬϿ,
      ߵǾ.

  12.
         .  ϴ  α׷
     ġǾ  غ Ǿ. մϴ!.

  3.3.  ġ ġ

  , Ŭ  CD  8.1.5.0.0 ϰ̴. 
  ׷ ù°    ְ( ȭ , ׷
  ġ  Ų.), 8.1.5.0.2 ġ ʼ̴.  
    "(5)" ܶ  䱸ȴ. ⼭ ϴ ġ
  ġ(cumulative patch)̴.  8.1.5.0.0  8.1.5.0.2 ġϱ
    ȭ Ѵ

  ʿ ȭ Ŭ Ʈ
  <http://technet.oracle.com/software/products/oracle8i/software_index.htm>
   ִ. ׸ ġϱ  .

  1.  ġ ù° ܰ ̹Ƿ "patches" 丮
     Ѱ .(  $ORACLE_HOME  .)

  2. ȭ ٿεϿ  丮 ϶.

  3. ȭ   .

     mkdir /tmp/orapatch
     cd /tmp/orapatch

  4. ȭ Ǯ.

     tar zvxf $ORACLE_HOME/patches/linux815patches.gz

  5.  丮  ũƮ Ѷ.

     ./linux_815patches.sh

   丮 ȭ Ǯ ʴ  ߿ϴٴ  ϶.  ġ
  ġα׷ Ȯ ȭ   ִ  Ѵ.  
  Ȯ  Ѵ.    ġ ī̺긦 ã ʹ 
  ȭ ãԵȴ.(????)

  3.4.  ȯ漳

  Ʒ   ".profile"  ߰϶.  (ƴϸ ڽ 
   ۿ ϴ ȭϿ)

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

  ü  Ŭ ġ α׷ ׷  ʴ 𸣰ڴ.

    α  "[: integer expression expected before
  -lt"   Եȴٸ, װ 'oraenv(Ŭȯ溯)'  Ʈ
  'unlimited'  ƴϰ ULIMIT  ϱ ̴.   
  ص ٸ ذ ٴ  ˰ ִ. ׷ ġ ʹٸ
  ULIMIT  ѵ  ٲٸȴ.

  3.5.  ġ /亯

  3.5.1.  ġα׷ 'CreateOUIProcess()' 

  , ´ JVM   Ȯ϶.  Ŭ ϴ
  𸣰, JVM  ſ ΰϴ.

  ι°, Ŭ CD  Ʈ runInstaller  ϴ 
  install/linux  ̵Ͽ runInst.sh ũƮ  ϶.

  ̹  6.0  6.1   ϸ Ƹ ο C
  ̺귯 ΰó δ.

    Ʋ  ׳(Gnome)  ޴,
  ζƮƮ(Enlightenment)  Ҷ ̷  Ÿٰ .
  ׷̵ ϰų KDE Fvwm2  ٸ  ޴ ϶.

  3.5.2.  ġα׷ ȭ鿡  Ÿ 

  ̰ 幮 ƴϴ.     Enlightenment
  Ҷ Ͼ. ׷̵ϰų ٸ X-window Ŵ ϸ
  ذҼ ִ.

    ġα׷   Ǹ ٳµ  80% 
   ɶ Ÿ. ̰ Ŭ ޸𸮰 ڶ Ÿ
  Ͱ. 200Mb ̻   ɰ̴.

  3.5.3.  ġα׷ ۽ ̻ ڹٿ(Strange Java errors)?

    ڹ  ӽ Ͻó?  ٸ 
  ġ ߴٰ , κ  JRE 1.1.6v5 
  ٿ׷̵  . JRE 1.1.6v5  Ŭ ڽŵ 
   õϴ ̴.

  ߿ ΰ : JRE  ϶ JDK   .  ι°
  "green" 带 ϶. THREADS_FLAG   'native' 
  ʾ Ȯ  Ѱ̴.

  3.5.4.  ġα׷ ׸Ʈ(Segmentation Fault's)

    GLIBC 2.1  ִ° ׷ 

  3.5.5.  ̺귯 (loading)

   Ϸ ϴ  ޼   :

   ̺귯  : libclntsh.so.8.0 :
   ȭ (cannot open shared object file) :
  ׷ȭ̳ 丮 (No such file or directory)

  ̰ NT DLL ã ٰ ϴ°͵ . ذ ϴ.
     Bourne   Ѵٸ  ".profil" 
     ߰ϸ ȴ.(𸥴ٸ  
  ):

  export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib

  Ǵ,  CSH   Ѵٸ  ߰϶:

  setenv LD_LIBRARY_PATH "$LD_LIBRARY_PATH
  $ORACLE_HOME/lib"

   C  ʱ    Ȯ غ Ѵ.

  3.5.6.  Pro*C  ۵ 

  װͿ   ܼ ξ.  ϴٸ Ŭ
  Ʈ   ã   ̴.

  Pro*C  Ʈ   ̺귯 𿡼 ãƾ ϴ 
  Ѵ. ġ  $ORACLE_HOME/precomp/admin/pcscfg.cfg 
  ְԵȴ.  ׷    ־Ѵ:

  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 ó 4 ȭ () ٿ
  ־Ѵ.)

  Ŭ  ̷Ϳ Ǹ  ʾ,
  $ORACLE_HOME/precomp/lib/env_precomp.mk  ؾ Ѵ.
  CCPSYSINCLUDE ϴ ο  ־:

  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)'

  ۾  6.0  ,  ߹ 
  ʿѰ̴.

  3.5.7.  ġ ġߴµ  !

  ̰ ȣϰ (ܿ) Ŭ  ȭ Ǿ, ׵
   α׷ ġα׷ η Ÿ.  ׵ װͿ 
  𰡸 ؾ ð̴.

   Ͼ°͵: Ŭ ϵ  Ŭ 
   (Oracle Enterprise Edition) ġϰ, ٷ  ̿밡
  ġ ġѴ.  ׸  Ϸ(pre-compilers)
  ʿϴٰ ϰ Ŭ α׷(Oracle Programmer) 
  CD(ġ ) ġѴ.

  Pro*C ġϱ  ͺ̽ ۵, Ŀ ۵
  ȴ´.

    ġ Ϸ(pre-compilers)  ġ
   ʾҰ  Ŭ   ڵ ġ ߱빮 ׷̴;
  Ŭ ġڴ ûؼ  ڵ ο  ع.

  ذ  ʴ. CD   ȭ ġҼ  
    Ǵٽ ؾ߸ Ѵ.  ġ ϱ  Ŭ
  α׷ (Oracle Programmer)  ߰ ϶.

  4.  ͺ̽ 

  4.1.  

    ܶ  , ͺ̽  ʾұ⸦ ٶ.

  κ  ,   ΰ ܾ Ҽ ִ:
  "'dbassist' ϶".  Ŭ غ  ̰ ó
  ƴ϶,     Ҽ (?????).

  Ϻ ϱ ,   ó ȹߴ   ()
  ȭҰ̴.  : ̰ ý۵ ߿(, ڰ
  ,  ϴ)  ý۵ ƴϴ.  8i 
  , ׸  8  ޶ ˾ƺ ؼ
  ̴.

   ϳ ϸ, 'dbassist'  ɼ ϸ  װ
  Ѵ. ׸ ٸ ũ  ٸ Ƽ õϸ 
  ׷ ߴ.  $ORACLE_HOME  /home/oracle ̴.  
  ϰ Ʈ  װ    ϳ Ƽǿ ξ.

  4.2.  ܰ躰 

  1.  Ʈ  Է϶:

     dbassist

  2.  ǻʹ "JNLS Exception: oracle.ntpg.jnls.JNLSException.
     Unable to find any National Character Sets."  ǥߴ.  Ŭ
     8i ġ FAQ  װ ˷ (884001)̴.  ׸
     ص ϴ.

  3. "Create a database"  ư ϰ "Next" .

  4. ΰ ɼ: Typical  Custom.    Ϸ ˰
     ִٸ ⸦  ʿ  ϰ Custom  ϶.  
     װ(Custom) ԽŰ ̴.   "Typical"
     ϰ "Next" ٰ Ұ̴.

  5.  ġڴ  ̴̽  CD  ̴ϸ
      ȭ  ̴.  ù° ɼ ,
     Ŭ  CD÷̾ ãߴ.( ù° ɼ
     ϶) ׷  ι° ɼ ٽ ߴ. װ 
     ʰ, ٸ   ð ɸ.

  6. ġڰ ͺ̽ ۵ ȯ  'Hybrid' 
     ° ƹ ()̴.

  7.  ġڴ 󸶳  ڰ  ͺ̸ Ұ
     ̴.  5 Էߴ

  8.   ο ͺ̽  ġҰ
     ̴.  ٽøڸ   ϴ°   
     ˰ ִ.

  9. Ŭ  "Global Database Name"  "SID" ʿ Ұ̴.
     ͺ̽ ̸(Database Name) FQDN(fully qualified domain
     name)  ϴ(׷ ٸ).  Ŭ ,
        ȸ簡 ϴ  ִٸ 
     Էؾ Ǵ ˰.   'dev1' ߴ.(SID ͺ̽
     ̸ )

  10.
     ,  '' ͺ̽ , ƴϸ ũƮ
      ϰ  ؾ Ѵ.  128Mb  ù°
     ɼ  Ͽ.

      ũƮ , X(window)  ޸𸮸  ϴ
     ٸ   ũƮ ߴ. ΰ(?)

  11.
         ʾ, ׷  ͺ̽
      װ(ѹ鼼׸Ʈ)  ۵ ʴ´!.  ̽ 
     'dbassist'  Ǿ, Ʈ  ѹ鼼׸Ʈ(user
     rollback segments)  off-line ü ִ. (:non-systerm
     users  Ʈ ʿ ϴ  ۵  ʴ´)

     Է϶.

     cd $ORACLE_HOME/dbs

   "init<SID>" (  "initdev1.ora")  ʿ䰡 ִ.

  ȭ ߰뿡   ڸƮ(comment, #) Ǿ ̴.

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

  ڸƲ ֶ(# ϶). ȭ ϸ Ȱ̴.

  12.
     ̷ Ŀ   ͺ̽  Ǹ Ҽ ִ.
     ׷ ý(system) йȣ Ƹ ˼ ̴.!

     ΰ ˾ƾ Ұ ִ. ù SYSTEM йȣ̴.  Ʈ
     'MANAGER'̴.(Ŭ йȣ  빮ڸ  ϴ
     Ͱ.  йȣ /ҹڸ  ʴ´.)   
     SQL*Plus Ʈ password  ؼ ٲٶ Ѵ.
     ( ALTER USER ϰ, 8i ϴ SQL*Plus
      ΰ ̴.)

      ʿ ٸ йȣ SYS Ѱ̴. Ʈ

  13.
     , SQL*Plus  α ϸ 'no profile'̶ 
      ִ ̴.

     SQL*Plus  'system'̶ ڷ α϶(sqlplus
     system/<password>).  ׸  Է϶:

     @?/sqlplus/admin/pupbld.sql

  ǹȣ(?) $ORACLE_HOME 丮 (alias)̴.

  ׸ װ,   ͺ̽ 밡ϴ.  SQL*Plus
  ̿Ͽ αҼ ִ.

  4.3.   亯

  4.3.1.  ̰  ?

  ׷ ׸ ׷ ʴ.     ų̰, 8i
  ο Ư¡  Ÿ  ͺ̽ "׷"̰,
    ͺ̽ Ϻϰ ׸  ۵ϰ ѷ Ѵٸ
  "׷ ʴ" ̴.

  ׷,  Ŭ   ȴٸ  Ʈ 
   ڴٴ   ˼ ̴.   ߿, 
  ý ̶ "Custom" ɼ ϶ ϰ ʹ.

   峭  ý 쿡    ٲپ.  
  ̺̽(table-spaces) ũ⸦ ø ٲپ.  װ͵
  ڵ þ ʾұ .( Ʈ ġ ȶ
  ϸ Ʈ Ⱦ.)

  4.3.2.   ȭ ٸ ũ ִ°  ʿѰ?

  ƴϴ. ׷  ʾƵ  Ѵ. ׷  ȭ 
  ũ  ϰ ʹ.

   ũ л ȭ , ȭ  ȭ Ѱ ְ
  ѹ ׸Ʈ ٸ  ִ,  ׻ ´.
    ϸ Ŭ DBA   å ϶.

  4.3.3.  dbassist Ҽ .

  ġ ʱ⿡  ȭ(zero-length files)  Ͼ.  ġ
  ġϸ ̹ ذϼ ִ.

  4.3.4.  "ORA-01034: ORACLE not available"  ż

  ª ̾߱ϸ, Ƹ  $ORACLE_SID  Ȯ ʾƼ .
  Ѵ.(, (Bourne shell)ȣȯ  export ORACLE_SID )

  4.3.5.  "ORA-01012: Not logged in"  ż

  ſ  ̴.  Ű  ٸ  ִ.

  ,  (Shared Server configuration)  ʾҴ
  Ȯغ.(MTS ˷) Dedicated Server  ̿ؼ
  ͺ̽ , ߿ ٲپ.

  װ ƴ϶,  NLS_LANG ȯ溯 Ȯغ. 彬
  ɼ װ  ʴ°̴.    ȯ溯 ϰ
  ʹٸ, Ȯ   ־ϴ. (ĺ 12° ?????)

  5.  

  5.1.  

  Ѵ.   ڽ Ŭ ۵ϰ Ǿ. 
  ̽   SQL*Plus Ͽ Ҽ ְ Ǿ.

  , ̰  ƴϴ. ̶̻  ٸ 迡 ٸ
  н  Ҽ ְ Ǿ. ̹ ܶ װͿ Ѱ̴.

  5.2.  ٸ(another user) 

   ܶ      ڼ 
  ϰ̴.     Ѱ ϶:

  o    Ѵٸ(bash  pdksh )

     . oraenv

  o   C- Ѵٸ

     source coraenv

   Ʈ  'bash' Ҷ "oraenv" ϸ 
  .  װ    Ƿ Ұ . װ
  ȴٸ

  5.3.  ٸ (another machine) 

   Ŭ ̼ ſ Ͽٰ Ѵ. ׷.
    ۵()ϴ Ͱ. ()  ߸
  Ǿų.   ؾų, ġ ȱ ִٰ ߴ.

   ߴ :

  1.

  2. "oraenv"  Ȯ϶.(,  $ORACLE_HOME  
     ° ƴ.)

  3.  Է:

     lsnrctl start

    Ŭ̾Ʈ ӽʿ ʿѰ ùٸ ӽ
  ϴ Ͱ ùٸ ͺ̽ νϽ̴.

   μ ϰ ϰ ʹٸ "Net8 Configuration
  Assistant" ('netec')   ̴ٰ.

  5.4.  ٸ (another machine)  

    Ŭ ſ  ̾. Ⱬϰ  
   ؽƮ ȭ Ʈ ؾߴ.

  ׷ 8I JVM  Ѵٸ  ʿѰ "Net8 Easy Config"
   α׷ Ű⸸ ϸ ȴ. Ʒ  ִ  Ѵٸ
  ٸ ǻ ͺ̽ Ҽ ִ.

  1.  ϶.

  2.  ٸ ڹٿ Ͽ ۵Ǹ ȯѴٴ ȭ̳´.
      ϳİ ̴.   ư ״ ζ
     (⺻ 'create') ׸ ͺ̽ ̸ ؽƮ ڽ 
     ־.  ׸  Ǿ 'Next' Ŭ϶.

  3. ϴ  ϳ϶. ٸ  𸥴ٸ ⺻
      Ǿ 'TCP/IP' ϶. ׸ 'Next' Ŭ.

  4.   ȣƮ̸(Ǵ IP ּ) Է϶. Ƹ Ʈ ȣ
      ʿ䰡  ̴. ׸ 'Next' Ŭ.

  5.  ư ̿ ͺ̽ Ÿ(8i Ǵ ٸ) Էϰ
     ؽƮڽ  ̸  Է϶. ׸ 'Next' Ŭ.

  6.   Է  Ŭ ϴ ˾ƺ ִ.
     Ŭ ϸ  'Next' . ׷ ʴٸ 'Back' 
     ڷ  ٽ Ȯϰ Էϸ ȴ.

  7. Է  ȮϿ    ƴٸ 'Finish'  
      .    ڼϰ Ϸ netasst 
     Ͽ"Net8 Assistant" (ū ȭ鿡  ɼ )
     ̿϶.

  5.5.  /亯

  5.5.1.

   (zero-length) ȭ϶  ̴. ġ
  ġϸ  ذҼ ִ.

  6.  

  6.1.   Ʈ

    Ŭ ġ  ˾, Ŭ ϰ ̴.
     server PC Ҽ , Ϲ
  Ŭ̾Ʈ- ü ̿ϴ Ͱ ٸ ǻͿ 
  ͺ̽ ϰ .

  Ϲ Ŭ  Ŵϰ   Ŭ̾Ʈ Ʈ 
   ִ. ׷   ؼ ׷ ϴ.  Ŭ
  Ʈ ,   °  ϰʹ.

  o  Oracle Enterprise Manager.  ALTER USER  ALTER SYSTEM  ָ
       ʾƵ  Ҽ ִ.

  o  Oracle WebDB.  ġϱ  쳪 HTML  
     Ʈ ִ.

  ׷   Ʈ ٸ  ´.....

  o  Tool for Oracle Application Development (T.O.A.D.).   
      Quest Software <http://www.quest.com>.   ̴.
      ų ص ȴ. ϴ°  ġ 
     뼺  ʴ.

  o  SQLNavigator, Quest Software <http://www.quest.com>.   ѹ
     ̰  ʾ,  ִ   õߴ.

  o  Orac <http://www.kkitts.com/orac-dba/>  DBA  

  6.2.   å

    Ŭ   å  .   ῡ
     Ʒ å õѴ:

  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," Steven Feuerstein, O'Reilly and Associates,
     ISBN 1-56592-335-9.

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

  O'Reilly <http://www.ora.com> å  ̴.  
   O'Reilly å ,  'Oracle Press'
  å߿  å ãƺ ߴ.

  6.3.   ͳڷ

     ڷ

  o  Oracle Technet <http://technet.oracle.com>. Ŭ / 
     Ʈ.  ߿ ڷᰡ Ҵ.

  o  Oracle Metalink <http://support.oracle.com>. Oracle's private (you
     need a support contract) support website. Only slightly more useful
     than Technet!

  o  Oracle Fans <http://www.orafans.com>.  缳  . 
     Ŭ  (׷   ̴)

  o  OraFaq <http://www.orafaq.org>.   Ǯ Ŭ  
     亯 Ʈ.

  o  Ŭ ϸ Ʈ('SUBSCRIBE ORACLE-LINUX-L'   ־
     ListGuru@fatcity.com <mailto:ListGuru@fatcity.com>  )

  o  ׸   Ʈ <http://www.zx81.org.uk>   ƶ!

