 Oracle Database HOWTO
 Paul Haigh, paul@nailed.demon.co.uk (:ȫ chorr@uriel.net)
 v1.1, 20 June 1998

 ýۿ Ŭ ͺ̽  ġ/ ̵
  ______________________________________________________________________

 1. 

     1.1 
     1.2 ۱
     1.3 åӿ  
     1.4 HOWTO  
     1.5 䱸
     1.6  

  2. Ŭ Ʈ ġ

     2.1  غ
        2.1.1 Ŭ  
     2.2 CDROM ġ
     2.3 ġ۾
        2.3.1 Root  ġ ۾
        2.3.2 Ŭ  ġ ۾
        2.3.3 Ǿ Ұ

  3. ͺ̽ 

     3.1 Initialisation ۼ
     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 н Ŭ̾Ʈ

  6. ڵ ۵/ 

     6.1 dbstart&dbstop
     6.2 init.d&rc.d

  7. ٸκе

     7.1  Ʈ

  8. Troubleshooting

     8.1 Oracle 7.2.x Ÿ̽ νϽ Ű Ҷ
     8.2 ׸Ʈ  ߻Ҷ

  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		 $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.6  

	 HOWTO  Ŭ Ÿ̽  ü ؼ ٷ ʴ	. ׷, ð ȴٸ  HOWTO  Ʒ ׸		Խų̴.
  
  	.Oracle ̺귯  Oracle Pro* α׷ 
  	.ٸ Ŭ ġ
  	.Ŭ  ġ
  	.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 ´ٸ,
	listener Ű, ų  ణ ð ҿȴ.(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. 7.3.4.x. svrmgrl segmentation  .

	̷   鿡Լ ˷. Gerald Weber
	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) ۼ  ⺻ Ͽ,
Georg Rehfeld(rehfeld@wmd.de) David Mansfield(
david@claremont.com)   ߰Ͽϴ.
Bob Withers, Mark Watling( mwatling@mjw-ltd.demon.co.uk), Peter
Sodhi(petersodhi@unn.unisys.com)
Greg Hankins(greg.hankins@cc.gatech.edu)  Ͽϴ.

Բ ϰ ۾   鿡 մϴ. ߰ ּ
  Bob Withers  Mark Watling 
 Ư մϴ.


	





