   Ŭ ġ Ͽ

  :Stephen Darlington, <stephen@zx81.org.uk>
  $Id: oracle-howto.sgml, v1.12 2000/04/01 14:35:07 sd Exp $
  :ȣ(KwangHo, Yun), <airplanez@hotmail.com>
  $Id: oracle-8-howto_kr.sgml, v0.01 2000/06/11

   Ͽ , ణ  ִٸ, "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.6  亯
        3.6.1 ̰  ?
        3.6.2  ȭ ٸ ũ ִ°  ʿѰ?
        3.6.3 dbassist Ҽ .
        3.6.4 "ORA-01034: ORACLE not available"  ż
        3.6.5 "ORA-01012: Not logged in"  ż

  4. 
     4.1 
     4.2 ٸ(another user) 
     4.3 ٸ (another machine) 
     4.4 ٸ (another machine)  
     4.5 /亯
        4.5.1 'netasst' Ҽ 

  5. 
     5.1  Ʈ
     5.2  å
     5.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>  ̿϶.

    'ٸ'(8i)  ġϷ Ѵٸ, ⿡ 
  ⺻ ִ.   찡 ׷ٸ Ȯ 츮  ó
  ִ°̴.

  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),  toll ( α׷ ڵ ϴ ϴ)
  ʿҰ̴.  Ŭ ͹̽ ϸ   ũ
  ſ, ⲯؾ ⰡƮ ̸̴.  Ϸ 
  ġϴ° .

  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)" ܶ  䱸ȴ. ⼭ ϴ ġ
  ġ̴.  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)'<verb>

  ۾  6.0   ,  ߹
   ʿѰ̴.

  <sect2>ġ ġߴµ  !
  <p>
  ̰ ()̴. ׵  α׷ ġα׷
   Ѱ͵ Ŭ  ȭ Ǿִ.  ׵ װͿ 
  𰡸 ؾ ð̴.(?)

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

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

    ġ   Ϸ(pre-compilers) 
  ٸ Ŭ  ڵ尡 ġ Ѱ Ѵٴ ̴: Ŭ ġ
   ûؼ  ڵ ο  ع.

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

  <sect>ͺ̽ 
  <sect1>
  <p>
    ܶ  , ͺ̽  ʾұ⸦ ٶ.

  κ  ,   ΰ ܾ Ҽ ִ:
  "'dbassist' ϶".  Ŭ غ  ̰
  ó̶,     Ҽ .

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

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

  <sect1>ܰ躰 
  <p>
  <enum>
  <item> Ʈ  Է϶:<verb>dbassist

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

  "Create a database"  ư ϰ "Next" .

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

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

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

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

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

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

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

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

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

  Է϶.

  cd $ORACLE_HOME/dbs

   "init.ora" (  "initdev1.ora")  ʿ䰡 ִ.

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

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

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

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

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

   ʿ ٸ йȣ SYS Ѱ̴. Ʈ

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

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

  @?/sqlplus/admin/pupbld.sql

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

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

  3.6.   亯

  3.6.1.  ̰  ?

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

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

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

  3.6.2.   ȭ ٸ ũ ִ°  ʿѰ?

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

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

  3.6.3.  dbassist Ҽ .

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

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

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

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

  ſ  ̴.  Ű  ٸ  ִ.

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

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

  4.  

  4.1.  

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

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

  4.2.  ٸ(another user) 

  ̴ܶ       ڼ 
  ϰ̴.     Ѱ ϶:

  o    Ѵٸ(bash  pdksh )

     . oraenv

  o   C- Ѵٸ

     source coraenv

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

  4.3.  ٸ (another machine) 

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

     1.

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

     3.  Է:

        lsnrctl start

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

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

  4.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" (ū ȭ鿡  ɼ
        ) ̿϶.

  4.5.  /亯

  4.5.1.

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

  5.  

  5.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  

  5.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'
     å߿  å ãƺ ߴ.

  5.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>   ƶ!

