  Oracle Database HOWTO

  Paul Haigh, paul@nailed.demon.co.uk <mailto:paul@nailed.demon.co.uk>

  (:ȫ chorr@uriel.net <mailto:chorr@uriel.net>)
  v1.1, 20 June 1998

   ýۿ Ŭ ͺ̽  ġ/ ̵

  ______________________________________________________________________

  

  1. 
     1.1 
     1.2 ۱
     1.3 åӿ  
     1.4 HowTo 
     1.5  

  2. Ŭ Ʈ ġ
     2.1 غ
        2.1.1 Ŭ 
     2.2 CDROM ġ
     2.3 ġ۾
        2.3.1 Root  ۾
        2.3.2 Oracle  ۾
        2.3.3    ִ κе

  3. ͺ̽ 
     3.1 ġ  ġ
     3.2 ͺ̽ ġ ũƮ 
     3.3 ͺ̽ ġ ũƮ 
     3.4 ͺ̽ Ű
     3.5 ͺ̽ Ű
     3.6 ⺻ 

  4.  SQL*Net ϱ
     4.1 tnsnames.ora
     4.2 listener.ora
     4.3 sqlnet.ora
     4.4 Listener Ű ϱ

  5. Ŭ̾Ʈ ȯ 
     5.1 ȯ Ŭ̾Ʈ
     5.2 Unix Ŭ̾Ʈ

  6. ڵ ۰ 
     6.1 dbstart & dbstop
     6.2 init.d & rc.d

  7. ٸ κе
     7.1  Ʈ

  8. ذ
     8.1 Oracle 7.2.x  ,  ͺ̽   .
     8.2 3.4.x. svrmgrl segmentation  .

  9. ֽ е

  ______________________________________________________________________

  1.  

  1.1.  

             v0.1 - 21 Feb 1998 - Paul Haigh -   .
             v0.2 - 01 Mar 1998 - Paul Haigh - .
             v1.0 - 10 Mar 1998 - Paul Haigh - LDP .
             v1.1 - 20 Jun 1998 - Paul Haigh - ذ κ߰.

  1.2.  ۱

   HOWTO  ۱   ڵ鿡 ִ.  
  HOWTO  ۱ Ǵ    ü  ü 
   ü Ȥ κμ     ִ.   
  Ǹ ȴ.   ̷ 쿡 ڿ ˷ֱ ٶ.
   ̳ Ļ ۾,  HOWTO  ϴ ۾
   ۱ ȳ   Ѵ.  ̴  HOWTO  ̿ ۾
  ϰ    ΰ  ޾Ƽ ȵȴٴ ̴.
   쿡  Ģ  ܵ   Ƿ, Ʒ ּҸ
  ؼ  HOWTO ڿ ϱ ٶ.   ؼ 츮 
        θ ؼ ϱ⸦ ٶ.  
  츮 HOWTO   ۱ Ǳ⸦ ٶ, HOWTO
  ϴ  ȹ 뺸ޱ⸦ ٶ.

  1.3.  åӿ  

  ڴ ɼ ִ  ùٸ  ϱ Ͽ Ͽ, 
   μ Ͼ Ͽ ؼ å   .  ڴ
  HOWTO      ؼ  , HOWTO 
   ϴ        Ϸ ۾ ؼ å  .

  1.4.  HowTo 

   Howto  ӽſ ϴ Ŭ̺̽
  ⺻μġ ⺻ κ ٷ ̴.  Ư
  Ŭ/SQL*Net ġ SQL*Net Ŭ̾Ʈ κ ٷ.  
   Ŭ ̽ ΰ Ǵ 뿡  ִ κ
  ٷ , ̿   ã   Ѵٸ O'ReillyǴ ٸ
  ǻ翡  å 캸 ٶ.  ̹ Unix
  ϴ Ŭα׷ ߿ ؼ  ʴ´. ̺κп
   ʿϴٸ SCO  SCO߽ý (OpenServer 5.X) 
   Ѵ. SCO ߽ý www.sco.com <http://www.sco.com>
  $19     ִ.  HOWTO  ϱ 
  ʿ  ׸  Ѵ.  ?Oracle Server CD for SCO
  OpenServer (version 7.3.3.0.0)

  ̰ չ 纻̾Ѵ.   Ŭ 
  ߱ϱ ȸ̸  ǰ  åִ.   SQL  ٸ
  ͺ̽ ϱ Ѵٸ PostgresSQLǴ ׿ 
  ͺ̽ ϸ ȴ.  Oracle Web Siteκ 60 
   ġ   ִ.    ̷  ġغ
  ʾ ̰    ƴϴ.

       Linux Server ̰͸ ġǾ ʴٸ  
  ʾ̴.  Kernel 2.0.30+ ٸ Kernel ؼ   .
  iBCS iBCS ġǾϴ  ſ߿ κ̰  ֱ
     õѴ.  (ڴ  iBCS-2.0-10.i386.rpm
  ϰ ִ.)  뷮ũ 600ްƮ̻  ũ 뷮
  ̴.  뷮 θ  ʿ䰡 ٰ Ѵٸ   
  ص ϴ.    õϰ  ʴ.  32Mb +
  Ram Ram   Ѵٰ  Ŭ Ÿ̽ 
   Ʈ  ؾѴ.  ׷ٰ ؼ Ŭ̳
  ڰ       Ŭ Ÿ̽ ۵ ʴ´ٴ 
  ƴϴ.  , õ   뷮 32ް Ʈ°̴.

  1.5.   

   HOWTO  Ŭ Ÿ̽  ü ؼ ٷ
  ʴ´.  ׷, ð ȴٸ  HOWTO  Ʒ ׸
  Խų̴.

  o  Oracle ̺귯  Oracle Pro* α׷ 

  o  ٸ Ŭ ġ

  o  Ŭ  ġ

  o  Oracle Kernel Relink

  2.  Ŭ Ʈ ġ

  2.1.  غ

  2.1.1.  Ŭ 

  Ŭͺ̽ ϱ ؼ Ŭͺ̽ /
  Ҽ ִ ڰ ־߸Ѵ.  츮 ŬĿ(Ŀ ڼ
  )缳Ϸ ǵ   츮 ̸ ׷̸
   Ŭ ϴ  ޾Ƶ鿩Ѵ.   κ 
  ORACLE ׷ DBA Ǿ ִ.

  1. Rootν α

  2. oracle  dba ׷ 

     ___________________________________________________________________
             $ groupadd dba
             $ useradd oracle
     ___________________________________________________________________

  3.  oracle  home 丮 

     ___________________________________________________________________
            $ mkdir /home/oracle
            $ mkdir /home/oracle/7.3.3.0.0 (Version of Oracle)
            $ chown -R oracle.dba /home/oracle
     ___________________________________________________________________

  2.2.  CDROM ġ

  ƽԵ SCO迭 ũ Oracle Installer  
           ̴. Core Dump ý  پ 
  Ͽ.          츮 CDROM ϵ Ͽ
   Ǯ ʿ䰡 ִ.  (CDROM ýۿ ƮǾ Ȯ)

  1. Oracle α

  2. /home/oracle/7.3.3.0.0丮 ̵

  3. CDROM ġ 

     ___________________________________________________________________
             $ cp -a /mnt/cdrom/* .
     ___________________________________________________________________

  4. CDROM ִ Oracle  Ǯ

     ___________________________________________________________________
             $ find . -name *_ -exec ~/7.3.3.0.0/orainst/oiuncomp {} \;
     ___________________________________________________________________

  2.3.  ġ۾

  2.3.1.  Root  ۾

  Oracle   ڸ  /etc/profile .profile 
  ߰Ѵ.

  ______________________________________________________________________
         # Oracle Specific
         ORACLE_HOME=/home/oracle/7.3.3.0.0
         ORACLE_SID=orcl
         ORACLE_TERM=vt100
         export ORACLE_HOME ORACLE_SID ORACLE_TERM
        # Alter path for Oracle
         PATH="$PATH:$ORACLE_HOME/bin"
  ______________________________________________________________________

  츮  ڸ ٲ ʿ䰡 ְ Oracle  ϰ
    ֵ ߰Ѵ.

  ______________________________________________________________________
         $ chown root.root $ORACLE_HOME/bin/osh
         $ chmod u+s $ORACLE_HOME/bin/osh

  ______________________________________________________________________

  2.3.2.  Oracle  ۾

  Ȯ  Ȯϱ  Oracle   Ѵ.

  ______________________________________________________________________
         $ chmod +x $ORACLE_HOME/bin/*
         $ chmod u+s $ORACLE_HOME/bin/oracle
  ______________________________________________________________________

  Oracle  $ORACLE_HOME/tool_name/mesg 丮 ִ
  ޽ 䱸Ѵ.  ׷ msg_ship丮 mseg丮
  msbϵ ű.

  ______________________________________________________________________
          $ mv $ORACLE_HOME/plsql/mesg/mesg_ship/*
          $ORACLE_HOME/plsql/mesg/.
          $ mv $ORACLE_HOME/rdbms/mesg/mesg_ship/*
          $ORACLE_HOME/rdbms/mesg/.
          $ mv $ORACLE_HOME/svrmgr/mesg/mesg_ship/*
          $ORACLE_HOME/svrmgr/mesg/.
  ______________________________________________________________________

    丮   Ѵ.

  ______________________________________________________________________
         $ mkdir $ORACLE_HOME/rdbms/log
         $ mkdir $ORACLE_HOME/rdbms/audit
         $ mkdir $ORACLE_HOME/network/log
  ______________________________________________________________________

  2.3.3.     ִ κе

   丮 ϰ ɼ ִ ͵̴.

          $ORACLE_HOME/guicommon2/
          $ORACLE_HOME/ctx/
          $ORACLE_HOME/md/
          $ORACLE_HOME/mlx/
          $ORACLE_HOME/precomp/
          $ORACLE_HOME/slax/

  3.  ͺ̽ 

  Oracle ġ ݺ ġ  ͺ̽ ġ
  ʿ䰡 ִ.   Oracle 7.2.x   Ѵٸ, Ʒκп
  ִ ذħ бٶ.

  3.1.  ġ  ġ

  $ORACLE_HOME/dbs/init.ora $ORACLE_HOME/dbs/initorcl.ora Ѵ.

  ______________________________________________________________________
          $ cd $ORACLE_HOME/dbs
          $ cp init.ora initorcl.ora
  ______________________________________________________________________

    Ͽ ߰Ѵ.

  ______________________________________________________________________
          db_name = orcl
          COMPATIBLE=7.3.3.0.0
  ______________________________________________________________________

  3.2.  ͺ̽ ġ ũƮ 

  $ORACLE_HOME/dbs丮  makedb.sql ̸  Ѵ.

  ______________________________________________________________________
          connect internal
          startup nomount
          set echo on
          spool makedb.log
          create database orcl
                 maxinstances 1
                 maxlogfiles  8
                 datafile '$ORACLE_HOME/dbs/orcl_syst_01.dbf' size 40M reuse
                 logfile
                         '$ORACLE_HOME/dbs/orcl_redo_01.dbf' size 1M reuse,
                         '$ORACLE_HOME/dbs/orcl_redo_02.dbf' size 1M reuse,
                         '$ORACLE_HOME/dbs/orcl_redo_03.dbf' size 1M reuse;
         @$ORACLE_HOME/rdbms/admin/catalog.sql
         create tablespace rollback
                 datafile '$ORACLE_HOME/dbs/orcl_roll_01.dbf' size 8.5M reuse;
         create tablespace temp
                 datafile '$ORACLE_HOME/dbs/orcl_temp_01.dbf' size 5M reuse
                 temporary;
         create tablespace users
                 datafile '$ORACLE_HOME/dbs/orcl_user_01.dbf' size 10M reuse;
         create rollback segment r1 tablespace rollback storage ( optimal 5M );
         alter rollback segment r1 online;
         connect system/manager
         @$ORACLE_HOME/rdbms/admin/catdbsyn.sql
         connect internal
         @$ORACLE_HOME/rdbms/admin/catproc.sql
         connect system/manager
         @$ORACLE_HOME/sqlplus/admin/pupbld.sql
         spool off
         exit
  ______________________________________________________________________

  3.3.  ͺ̽ ġ ũƮ 

  svrmgrl   ũƮ Ѵ.

  ______________________________________________________________________
          $ cd $ORACLE_HOME/dbs
          $ svrmgrl
          Oracle Server Manager Release 2.3.3.0.0 - Production
          Copyright (c) Oracle Corporation 1994, 1995. All rights reserved.
          Oracle7 Server Release 7.3.3.0.0 - Production Release
          PL/SQL Release 2.3.3.0.0 - Production
          SVRMGR> connect internal
          Connected.
          SVRMGR> startup nomount
          ORACLE instance started.
          Total System Global Area       4313312 bytes
          Fixed Size                       41876 bytes
          Variable Size                  4140364 bytes
          Database Buffers                122880 bytes
          Redo Buffers                      8192 bytes
          SVRMGR> @makedb
          <loads of messages>
          SVRMGR> exit
          Server Manager complete.
  ______________________________________________________________________

  3.4.  ͺ̽ Ű

  켱 (Ŀ ڵ  ̴.)ͺ̽
  ųʿ䰡 ִ.  Oracle ͺ̽ ϱؼ "connect
  internal" Ŀ "startup"̶ command ؾ Ѵ.

  ______________________________________________________________________
         $ svrmgrl
        Oracle Server Manager Release 2.3.3.0.0 - Production
        Copyright (c) Oracle Corporation 1994, 1995. All rights reserved.
        Oracle7 Server Release 7.3.3.0.0 - Production Release
         PL/SQL Release 2.3.3.0.0 - Production
        SVRMGR> connect internal
         Connected.
         SVRMGR> startup
         ORACLE instance started.
         Total System Global Area       4313316 bytes
         Fixed Size                       41876 bytes
         Variable Size                  4140368 bytes
         Database Buffers                122880 bytes
         Redo Buffers                      8192 bytes
         Database mounted.
         Database opened.
         SVRMGR> exit
         Server Manager complete.
  ______________________________________________________________________

  3.5.  ͺ̽ Ű

  Oracleͺ̽ Űʰ Linux Ű 
  ͺ̽ ıų  ִ ū  ִٴ  ؾ Ѵ.
  ׷Ƿ,Linux shutdown ϱ ͺ̽ Ű
   ٶѰ̴.

  ______________________________________________________________________
         $ svrmgrl
        Oracle Server Manager Release 2.3.3.0.0 - Production
        Copyright (c) Oracle Corporation 1994, 1995. All rights reserved.
        Oracle7 Server Release 7.3.3.0.0 - Production Release
         PL/SQL Release 2.3.3.0.0 - Production
        SVRMGR> connect internal
         Connected.
         SVRMGR> shutdown
         Database closed.
         Database dismounted.
         ORACLE instance shut down.
         SVRMGR> exit
         Server Manager complete.
  ______________________________________________________________________

  3.6.  ⺻ 

  ͺ̽ Ǹ鼭 ڵ   Ư ڰ
  ȴ.    κ Ѵ.

  ______________________________________________________________________
         Username                Password
        SYSTEM                  MANAGER
         SYS                     change_on_install
  ______________________________________________________________________

  ̷ ڰ  ͺ̽  ⺻
  ͵ųʸ ϱ  ̴.  ð
  ⺻  ȣ ٲٴ  .  ̷ κ 
    ȴ.

  ______________________________________________________________________
          sqlplus system/manager
          SQL*Plus: Release 3.3.3.0.0 - Production on Sat Feb 21 12:43:33 1998
          Copyright (c) Oracle Corporation 1979, 1996.  All rights reserved.

          Connected to:
          Oracle7 Server Release 7.3.3.0.0 - Production Release
          SQL> alter user system identified by <newpassword>;
          User altered.
          SQL> alter user sys identified by <newpassword>;
          User altered.
          SQL> exit;
          Disconnected from Oracle7 Server Release 7.3.3.0.0 - Production Release
          PL/SQL Release 2.3.3.0.0 - Production
  ______________________________________________________________________

  system/manager  Oracle   UNIXýۿ root
  ϴ Ͱ ϱ  츮  ߻Ű  ּȭϱ
   ǵ    ڸ  ʿ䰡 ִ.  (ڸ
  ϱ  ͺ̽ Ű  ϶) SQL*PLUS
  ϰ ڸ Ѵ.

  ______________________________________________________________________
         $ sqlplus system/manager
        SQL*Plus: Release 3.3.3.0.0 - Production on Sat Feb 21 12:43:33 1998
        Copyright (c) Oracle Corporation 1979, 1996.  All rights reserved.

        Connected to:
         Oracle7 Server Release 7.3.3.0.0 - Production Release
         PL/SQL Release 2.3.3.0.0 - Production
        SQL> create user <user> identified by <psw>
           2  default tablespace users
           3  temporary tablespace temp;
        User created.
        SQL> grant connect, resource to <user>
        Grant succeeded.
        SQL> exit
         Disconnected from Oracle7 Server Release 7.3.3.0.0 - Production Release
         PL/SQL Release 2.3.3.0.0 - Production
  ______________________________________________________________________

  ýۿ ο ڰ Ͽ  ο  
  ýۿ α Ҽ ִ.  Oracleͺ̽ αϱ ؼ
   .

  ______________________________________________________________________
         $ sqlplus <user>/<password>
  ______________________________________________________________________

  ̺κ ޼ ȴٸ,  Ŭ Ÿ̽
  ġѰ̴.    ƴ ٸ ȣƮ  Ŭ Ÿ̽
       ʴ´ٸ   ۾ ϷȰ̴.  ׷, κ
   Ʈũ ̿Ͽ  Ÿ̽  ϱ
  Ұ̴. ׷ ϱ ؼ    ؾѴ.

  4.   SQL*Net ϱ

   ̷ η ϵ Oracle Ʈũ õ
  Ʈ(SQL*Net,aka Net8 for Oracle8) Ѵ. ̷ ϵ
  $ORACLE_HOME/network/admin丮ȿ ν Ǿ Ѵ.

  4.1.  tnsnames.ora

  TNSNAMES.ORA   Ÿ̽ νϽ Ͽ
  ش.    ͺ̽ νϽ  Ʒκа 
  ߰Ѵ.

  ______________________________________________________________________
         orcl.world =
           (DESCRIPTION =
             (ADDRESS_LIST =
                 (ADDRESS =
                   (COMMUNITY = tcp.world)
                   (PROTOCOL = TCP)
                   (Host = <INSERT HOST NAME OF SERVER HERE> )
                   (Port = 1521)
                 )
                 (ADDRESS =
                   (COMMUNITY = tcp.world)
                   (PROTOCOL = TCP)
                   (Host = <INSERT HOST NAME OF SERVER HERE> )
                   (Port = 1526)
                 )
             )
             (CONNECT_DATA = (SID = ORCL)
             )
           )
  ______________________________________________________________________

  4.2.  listener.ora

  LISTENER.ORA ٸ ýۿ ϴ Ϳ õ κ ϰ
   listener  䱸Ǵ ٸ  Ѵ. listener̸,
  listenerּ, listener  Ǵ ͺ̽, Ű
   Ѵ.     ִ.

  ______________________________________________________________________
         # Name of listener and addresses to listen on
         LISTENER =
                 ( ADDRESS_LIST =
                         (ADDRESS =
                                 (PROTOCOL=tcp)
                                 (HOST=<INSERT HOST>)
                                 (PORT=1521)
                                 (COMMUNITY=UK_SUP_TCPIP)
                         )
                         (ADDRESS =
                                 (PROTOCOL=ipc)
                                 (KEY=700)
                                 (COMMUNITY=UK_SUP_TCPIP)
                         )
                 )
        # List of services served by this listener
         SID_LIST_LISTENER=
                 (SID_LIST=
                         (SID_DESC=
                                 (SID_NAME=orcl)
                                 (ORACLE_HOME=/home/oracle/7.3.3.0.0)
                         )
                 )
        # Start of configuration parameters.
         TRACE_LEVEL_LISTENER=OFF
         TRACE_FILE_LISTENER = "listener"
         LOG_FILE_LISTENER = "listener"
         CONNECT_TIMEOUT_LISTENER = 10
         STOP_LISTENER = YES
         DBA_GROUP = dba
  ______________________________________________________________________

  4.3.  sqlnet.ora

  SQLNET.ORA Ʈũ Ư (node)  
  Ѵ. ̰ ͺ̽ listener ʹ  . 
  Ͽ  ߿ κ Dead Connection Timeout ̴.Dead
  Connection Timeout ͺ̽ νϽ Ǵ 
  μ üũϰ,  信 õ Ŭ̾Ʈ ȮѴ.
  Ŭ̾Ʈ( )   ʴ´ٸ Oracle 
   μ ȴ.  ̰   Ŭ̾Ʈ
  ͺ̽ Ϸ  ſ Ѵ. Ư,
  Oracleͺ̽κ Ȯ µ ϴ Ŭ̾Ʈ
    ɼ ִ ߱Ⱓ  ȴٰ   ִ.
  Ʒκп   sqlnet.ora  ִ.

  ______________________________________________________________________
          TRACE_LEVEL_CLIENT = OFF
          sqlnet.expire_time = 30         # The number of seconds between
          client checks.
          names.default_domain = world
          name.default_zone = world
  ______________________________________________________________________

  4.4.  Listener Ű ϱ

  listener SQL*Net  Ƿ, Ʈũ Ʈ
  Ͽ ͺ̽   ִ.(ͺ̽  
  ϱ, 츮  Ŭ̾Ʈ ýۿ ϴ  
  ̴.)    Ͽ listener Ų.

  ______________________________________________________________________
         $ lsnrctl
          LSNRCTL for SCO System V/386: Version 2.3.3.0.0 - Production
          on 23-FEB-98 20:38:25
          Copyright (c) Oracle Corporation 1994.  All rights reserved.
          Welcome to LSNRCTL, type "help" for information.
          LSNRCTL> start
          Starting /home/oracle/7.3.3.0.0/bin/tnslsnr: please wait...
          TNSLSNR for SCO System V/386: Version 2.3.3.0.0 - Production
          System parameter file is
          /home/oracle/7.3.3.0.0/network/admin/listener.ora
          Log messages written to
          /home/oracle/7.3.3.0.0/network/log/listener.log
          Listening on:
          (ADDRESS=(PROTOCOL=tcp)(DEV=6)(HOST=192.168.1.1)(PORT=1521))
          Listening on: (ADDRESS=(PROTOCOL=ipc)(DEV=10)(KEY=700))
          Connecting to
          (ADDRESS=(PROTOCOL=tcp)(HOST=magic.com)(PORT=1521)
                  (COMMUNITY=UK_SUP_TCPIP))
          STATUS of the LISTENER
  ______________________________________________________________________

  ______________________________________________________________________
          Alias       LISTENER
          Version     TNSLSNR for SCO System V/386: Version 2.3.3.0.0 - Production
          Start Date  23-FEB-98 20:38:50
          Uptime       0 days 0 hr. 0 min. 0 sec
          Trace Level  off
          Security     OFF
          SNMP         ON
          Listener Parameter File
          /home/oracle/7.3.3.0.0/network/admin/listener.ora
          Listener Log File
          /home/oracle/7.3.3.0.0/network/log/listener.log
          Services Summary...
          orcl          has 1 service handler(s)
          The command completed successfully
          LSNRCTL> exit
  ______________________________________________________________________

  listener Ű ؼ  .

  ______________________________________________________________________
          $ lsnrctl
          LSNRCTL for SCO System V/386: Version 2.3.3.0.0 - Production
          on 23-FEB-98 20:43:20
          Copyright (c) Oracle Corporation 1994.  All rights reserved.
          Welcome to LSNRCTL, type "help" for information.
          LSNRCTL> stop
          Connecting to
          (ADDRESS=(PROTOCOL=tcp)
                   (HOST=magic.com)
                   (PORT=1521)
                   (COMMUNITY=UK_SUP_TCPIP)
          )
          The command completed successfully
          LSNRCTL> exit
  ______________________________________________________________________

  õ hostname  IPּҸ ȯ ʴ DNS ´ٸ, lis
  tener Ű, ų  ణ ð ҿȴ.(2-3, DNS
  timeout  õǾ) ̷ 쿡  , γ϶.
  ٸ.

  5.  Ŭ̾Ʈ ȯ 

  5.1.  ȯ Ŭ̾Ʈ

  ֱ  Oracle Client Software ϴ PC SQL*Net 
  ſ .  κ ϴ Ŭ̾Ʈ ġ ϴ 
  ()  Oracle ϴ SQL*Net Easy Configuration 
  ̿ϴ ̴.    tnsnames.ora sqlnet.ora  
    ִ   ̽ ´.  "Add Database Alias"
  ϰ, Ŀ ġ  "Database alias"  ̸ ԷѴ.
   alias ͺ̽ νͽ  ̸̰, νϽ
  ̸(̷ 쿡 orcl)  ̸̾ Ѵ.  ݷν
  TCP/IP ϰ, ͺ̽ ý hostname ͺ̽
  νϽ ̸ ԷѴ.  ϷǾ.  ׷, SQL*Net Easy
  Configuration Tool ٰ  .  ϴ  
  Ŭ̾Ʈ ýۿ $ORACLE_HOME/network/admin丮
  tnsnames.ora sqlnet.ora Ѵ. ̰ (
  ǹ̿ ׻  )  alias  ̴.

  5.2.  Unix Ŭ̾Ʈ

  UNIX Ŭ̾Ʈ  Ŭ̾Ʈ ſ ٸ ʴ. Oracle
  ϴ Network Manager ִٸ,     
  ϸ ȴ.  ׷   ٸ,  ϴ
  $ORACLE_HOME/network/admin丮 ִ ϵ   
  ̿ϸ ȴ.

  6.  ڵ ۰ 

  6.1.  dbstart & dbstop

  Oracle ͺ̽ ڵ ۰  Oracle ϴ 
  dbstart dbstop ̿Ͽ ( 7.3.3.0.0)  ִ. ̷
  ϵ ( dbstart dbshut ٲܼ , Ű 
  ִ.)  ִ etc/oratab  翩ο Ѵ.  /etc/oratab
     .

  ______________________________________________________________________
          SID:ORACLE_HOME:AUTO
  ______________________________________________________________________

  )

  ______________________________________________________________________
         orcl:/home/oracle/7.3.3.0.0:Y
         leaveup:/home/oracle/7.3.2.1.0:N
  ______________________________________________________________________

  6.2.  init.d & rc.d

   ý ۰̳  Ͽ Ÿ̽
  ۽Ű ų ִ.  ̰ ſ콱, 
  Linux(slackware, debian, redhat, etc)ý ϴĿ 
  ɼ ִٴ  ڴ Ѵ.    Redhat Linux
  5.0 ϴ   ̴.  ڽ Linux ýۿ 
  ϱؼ ڽ Linux ý  ڷḦ Ѵ.  (
  ׷  Unix ý Sys V 迭  Ϳ Ǵ) 켱,
  츮 /etc/rc.d/init.d 丮 ִ dbshut dbstart 
  ũƮ  ʿ䰡 ִ.

  ______________________________________________________________________
    #!/bin/sh
    #
    # /etc/rc.d/init.d/oracle
    # Description: Starts and stops the Oracle database and listeners
    # See how we were called.
    case "$1" in
      start)
            echo -n "Starting Oracle Databases: "
            echo "----------------------------------------------------"
            >> /var/log/oracle
            date +"! %T %a %D : Starting Oracle Databases as part of system up."
            >> /var/log/oracle
            echo "----------------------------------------------------"
            >> /var/log/oracle
            su - oracle -c dbstart >> /var/log/oracle
            echo "Done."
            echo -n "Starting Oracle Listeners: "
            su - oracle -c "lsnrctl start" >> /var/log/oracle
            echo "Done."
            echo ""
            echo "----------------------------------------------------"
            >> /var/log/oracle
            date +"! %T %a %D : Finished." >> /var/log/oracle
            echo "----------------------------------------------------"
            >> /var/log/oracle
            touch /var/lock/subsys/oracle
            ;;
      stop)
            echo -n "Shutting Down Oracle Listeners: "
            echo "----------------------------------------------------"
            >> /var/log/oracle
            date +"! %T %a %D : ShutDown Oracle Databases as part of system down."    >> /var/log/oracle
            echo "----------------------------------------------------"
            >> /var/log/oracle
            su - oracle -c "lsnrctl stop" >> /var/log/oracle
            echo "Done."
            rm -f /var/lock/subsys/oracle
            echo -n "Shutting Down Oracle Databases: "
            su - oracle -c dbshut >> /var/log/oracle
            echo "Done."
            echo ""
            echo "----------------------------------------------------"
            >> /var/log/oracle
            date +"! %T %a %D : Finished." >> /var/log/oracle
            echo "----------------------------------------------------"
            >> /var/log/oracle
            ;;
      restart)
            echo -n "Restarting Oracle Databases: "
            echo "----------------------------------------------------"
            >> /var/log/oracle
            date +"! %T %a %D : Restarting Oracle Databases as part of system up."    >> /var/log/oracle
            echo "----------------------------------------------------"
            >> /var/log/oracle
            su - oracle -c dbstop >> /var/log/oracle
            su - oracle -c dbstart >> /var/log/oracle
            echo "Done."
            echo -n "Restarting Oracle Listeners: "
            su - oracle -c "lsnrctl stop" >> /var/log/oracle
            su - oracle -c "lsnrctl start" >> /var/log/oracle
            echo "Done."
            echo ""
            echo "----------------------------------------------------"
            >> /var/log/oracle
            date +"! %T %a %D : Finished." >> /var/log/oracle
            echo "----------------------------------------------------"
            >> /var/log/oracle
            touch /var/lock/subsys/oracle
            ;;
      *)
            echo "Usage: oracle {start|stop|restart}"
            exit 1
    esac
  ______________________________________________________________________

     Ȯ  ýۿ  ͺ̽ ϰ
  Ű Ȯؾ Ѵ. ޼  /var/log/oracle log
   Ȯ϶.   ɵ  2,3,4 شϴ
  ׺̽ ô´  Ȯ  ̴.

  ______________________________________________________________________
         $ ln -s ../init.d/oracle /etc/rc.d/rc2.d/S99oracle
         $ ln -s ../init.d/oracle /etc/rc.d/rc3.d/S99oracle
         $ ln -s ../init.d/oracle /etc/rc.d/rc4.d/S99oracle
  ______________________________________________________________________

  ý  ϰų,  ų ͺ̽
  Űؼ 츮   (link) ʿѴ.

  ______________________________________________________________________
         $ ln -s ../init.d/oracle /etc/rc.d/rc0.d/K01oracle          # Halting
         $ ln -s ../init.d/oracle /etc/rc.d/rc6.d/K01oracle          # Rebooting
  ______________________________________________________________________

  7.  ٸ κе

  7.1.   Ʈ

  Oracle Intelligent Agent ʿ Ѵٸ, ȯ漳 ȭ
  ϴ. IA ϱ ؼ  .

  ______________________________________________________________________
         $ lsnrctl dbsnmp_start
  ______________________________________________________________________

  IA Ű ؼ  .

  ______________________________________________________________________
         $ lsnrctl dbsnmp_stop
  ______________________________________________________________________

   Ÿų Intelligent Agent ϰų, ϴ 
  ޽  ʴ´.  ڸƮ ޴ ŬŸ̽ 
  Ŭ̾Ʈ Ʈ Enterprise Manager ϱ ̴.
  Ȯϴ  Ŭ Enterprise Manager   ִ.

  8.  ذ

    پ ذ Ǹ(hints)  .

  8.1.  Oracle 7.2.x  ,  ͺ̽   .

  7.2.x ǰ߿ Oracle Ǵ ̷ ϵ ļȯ
  Ϸ  õϷ  Ȯ ʴ. Ǵ init.ora
      Ѵ.
  ______________________________________________________________________
         # define parallel server (multi-instance) parameters
         ifile = ora_system:initps.ora
  ______________________________________________________________________

   ذϱ ؼ ܼ ּó ϸȴ.

  ______________________________________________________________________
         # define parallel server (multi-instance) parameters
         #ifile = ora_system:initps.ora
  ______________________________________________________________________

  8.2.  3.4.x. svrmgrl segmentation  .

  ̷   鿡Լ ˷. Gerald Weber
  gerald_weber@master.co.at <mailto:gerald_weber@master.co.at>
  ذϿ.

  ______________________________________________________________________
          ȳ Paul,
            켱 Ѵ.  iBCS-emulator ü̴.
          Oracleý iBCS    ʴ sysconf-calls
          ϴ  .
          <7>[22]615 sysconf(34)
          <7>iBCS2 unsupported sysconf call 34
          <7>[22]615 sysconf error return linux=-22 -> ibcs=22 <Invalid argument>
          <7>[24]615 sysconf(34)
          <7>iBCS2 unsupported sysconf call 34
          <7>[24]615 sysconf error return linux=-22 -> ibcs=22 <Invalid argument>
   ذ :   diff-pach iBCS-source.apply Ѵ

   --- sysconf.c   Sun Apr 19 19:19:15 1998
    +++ sysconf.c.ori       Sun Apr 19 19:28:45 1998
    @@ -60,7 +60,6 @@
     #define _SC_JOB_CONTROL        5
     #define _SC_SAVED_IDS  6
     #define _SC_VERSION    7
    -#define _SC_HACK_FOR_ORACLE 34
    #define _SC_PAGESIZE   11
   @@ -97,11 +96,6 @@
                    case _SC_SAVED_IDS: {
                            return (1);
                    }
    -
    -               case _SC_HACK_FOR_ORACLE: {
    -                 return (1);
    -               }
    -
                   case _SC_PAGESIZE: {
                      return PAGE_SIZE;
  ______________________________________________________________________

  9.  ֽ е

  ̹ Bob Withers( bwit@pobox.com <mailto:bwit@pobox.com>) ۼ
   ⺻ Ͽ, Georg Rehfeld(rehfeld@wmd.de
  <mailto:rehfeld@wmd.de>) David Mansfield( david@claremont.com
  <mailto:david@claremont.com>)   ߰Ͽϴ.  Bob
  Withers, Mark Watling( mwatling@mjw-ltd.demon.co.uk
  <mailto:mwatling@mjw-ltd.demon.co.uk>), Peter
  Sodhi(petersodhi@unn.unisys.com <mailto:petersodhi@unn.unisys.com>)
  Greg Hankins(greg.hankins@cc.gatech.edu
  <mailto:greg.hankins@cc.gatech.edu>)  Ͽϴ.  Բ
  ϰ ۾   鿡 մϴ. ߰ ּ
    Bob Withers  Mark Watling  Ư մϴ.

