








			     Oracle Database HOWTO

		   @̡GPaul Haigh, paul@nailed.demon.co.uk

		    Ķ̡GFd, a9504480@graduate.hku.hk

	1.2 , @EEK~K|]½ĶJ@EEK~KTQ@^



				   Abstract

     b Linux tΤwˤγ]w Oracle ƮwAnC



1.  ɨ

1.1  v

    0.1  - @EEK~Gܤ@ - Paul Haigh - ̥C

    0.2  - @EEK~T@ - Paul Haigh - [WFչ̪סC

    1.0  - @EEK~TQ - Paul Haigh - b LDP XC

    1.1  - @EEK~GQ - Paul Haigh - szΥ[WƸѡC

    1.2  - @EEK~K| - Paul Haigh - [W Oracle Corporation
     sDΧRhӧi@`C

1.2  Copyright

The Oracle Database HOWTO copyright (c) 1998, Paul Haigh.

Like all Linux HOWTO documents, this may be reproduced and distributed in whole
or in part, in any medium, physical or electronic, so long as this copyright
notice is retained on all copies.

Commercial redistribution is allowed and encouraged; however the author would
like to be notified of such distributions. You may translate this HOWTO into
any language whatsoever provided that you leave this copyright statement and
disclaimer intact, and that you append a notice stating who translated the doc
ument.

1.3  Disclaimer

While I have tried to include the most correct and up to date information
available to me, I cannot guarantee that usage of information in this document
does not result in loss of data or equipment. I provide NO WARRANTY about the
information in the HOWTO and I cannot be made liable for any consequences
resulting from using the information in this HOWTO.


Oracle Database HOWTO							      1





Oracle Database HOWTO							      2



1.4   HOWTO ت

bo HOWTO ڷ|ջpwˤκ޲z@Ӧb Linux W檺 Oracle
ƮwAڷ|SO Oracle AwˡASQL*Net ]wΥΤ (client)
]wC

oäO@ϥΤκ޲z@ Oracle
ƮwJޡCpGAQnoơAO'Reilly ΨLXӳXo譱Χ@C

ڤ]|b Unix W Oracle {}oL{CpGAoݭnAګĳAq
SCO BʶR SCO development system (]A OpenServer
5.x)CڧکҪAoiHQXzQEq www.sco.com oC

1.5  tέnD

nqog HOWTO eAAݭnHUFC

    Oracle Server CD  SCO Openserver (7.3.3.0.0 )

		 oOXkCO Oracle
		 O@ȧQqAo|䲣~OCpGAQnKOӤS䴩 SQL
		 ƮwAХ PostgresSQL ΨLH{C

		 A]iq Oracle U@ tar
		 ɮסAqo@ӤQѪեγ\i (license) Φw Oracle
		 CڨèS˦۸չLAOgT{C


    @x Linux A


		 pGSܡAAN|\ŪoFAOܡH


    2.0.30+ ֤


		 ڤOҳoǫܹL֤ߨӻǽTC]ڹ 2.0.30
		 ]@XOҡKK^


    iBCS


		 wˤΨϥΧAҥΪx̷sD`nC]ڥbϥ Redhat
		 Linux  iBCS-2.0-10.i386.rpmC^


    jqϺЪŶ


		 600 Mb
		 HWOӦXzƦrCϥΧ֪Ŷ]iHAAݭn@X@묹Aڱqo˶}lCLAڷ|իXb̥i˥XŶC









Oracle Database HOWTO							      3



    32Mb HWO


		 ڪDoť_ӫܦhASOOH Linux ӻ, аO Oracle
		 OӽnCb SCOAA|ıoDI

		 ڤO Oracle bְO骺ΤUu@ALo˷|ֹL
		 Oracle ĳAڤ]٦o˰C


    Oracle \i (License)


		 ڪDڤwXLAڷQjaDoOnCS\iҦӨϥ
		 Oracle nOHkC


1.6  Oracle Corporation s

Oracle }AӦ Linux sOCOracle Corporation wgMwVb Linux
x Oracle 8 ѩx䴩C Oracle }AoN|b@EEK~QGXC

nO Oracle | Oracle γn󲾴Ө Linux xCھ Oracle
Aoӷ|b@EEE~Wb~XC

ѦҸơG

    http://www.oracle.com/html/linux.html

    http://www.news.com/News/Item/0,4,24436,00.html

    http://www.zdnet.com/pcweek/news/0720/20morac.html


2.  w Oracle n

2.1  AǳƤu

2.1.1  إ Oracle Τ

pjaҮơAڭ̻ݭn@ӥΤӫOs Oracle ƮwC]ڭ̤Qs쵲 Oracle
֤ߡ]eA͡^Aڭ̭n Oracle wϥΪ̤θsզW١AYϥΪ̬ ORA
CLEAӸsլ DBAC

  1.  H root ñJ

  2.  إߨϥΪ oracle θs dbaC


		$ groupadd dba
		$ useradd  oracle











Oracle Database HOWTO							      4



  3.  TOϥΪ oracle lؿ (home directory)


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


2.2  qЦw

aASCO Ъ Oracle w˵{B@CϥΪ̷|J@sꤣPDAq
core dump CҥHڭ̭nۤvqЧɮקۨwФθG

]TOФw (mount) tΤW^C

  1.  H Oracle ñJ

  2.   /home/oracle/7.3.3.0.0 ؿC

  3.  qЧۥXҦwɮ


		$ cp -a /mnt/cdrom/* .


  4.  ФWҦ Oracle ɮסC


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


2.3  w˫᪺u@

2.3.1  Root u@

HUƦ[ /etc/profile Υ[C@ӷ|ϥ Oracle ήa .profile C


	  # Oracle M
	  ORACLE_HOME=/home/oracle/7.3.3.0.0
	  ORACLE_SID=orcl
	  ORACLE_TERM=vt100
	  export ORACLE_HOME ORACLE_SID ORACLE_TERM

	  #  Oracle ק|
	  PATH="$PATH:$ORACLE_HOME/bin"


ڭ̤]ݭnק Oracle ulimit ɤu㪺֦Hγ\i (permissions)C


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









Oracle Database HOWTO							      5



2.3.2  Oracle u

ק Oracle ɮת\iӽTOާ@TC


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


Oracle unDTb $ORACLE_HOME/tool_name/mesg ؿCҥHڭ̭n
msg_ship ؿUmsg ɮײ mesg ؿUC


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



pGSHUؿAnإߥ̡G


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


2.3.3  iF

HUؿiHwaG

    $ORACLE_HOME/guicommon2/

    $ORACLE_HOME/ctx/

    $ORACLE_HOME/md/

    $ORACLE_HOME/mlx/

    $ORACLE_HOME/precomp/

    $ORACLE_HOME/slax/


3.  إߤ@ӸƮw

Oracle A{wwˤFAڭ̻ݭnإߤ@ӸƮwӴեC

pGAϥ Oracle 7.2.x ΤeAо\ŪUƸѳC

3.1  إߪl (Initialisation File)

 $ORACLE_HOME/dbs/init.ora ۨ $ORACLE_HOME/dbs/initorcl.ora:









Oracle Database HOWTO							      6



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



[WHUƦG


	  db_name = orcl
	  COMPATIBLE=7.3.3.0.0


3.2  إ߸Ʈww˩ROZ

b $ORACLE_HOME/dbs ؿUإߤ@ӦW makedb.sql ROZɡG


	  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  Ʈww˦wOZ

}l svrmgrl ΰROZJ









Oracle Database HOWTO							      7



	  $ 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  ҰʸƮw

}lɡAڭ̭nˤҰʸƮw]ڭ̵y|ou۰ʤơ^CnҰ Oracle
ƮwAڭ̭nӤs (connected internally) FpU startup OG


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









Oracle Database HOWTO							      8



3.5  Ʈw

nAb@ Oracle ƮwpUsҰ Linux
ܦi|ϸƮwlC

]Abڭ̰ Linux  shutdown Oe̦nƮwG


	  $ 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  إߤwΤ (Default User)

bإ߸ƮwɡA|۰ʲͨӯSOΤG


	  Username	 Password

	  SYSTEM	      MANAGER
	  SYS		 change_on_install


oǥΤq`OΨӫOsзǪƦr (data dictionary)
ƦbƮwCɧ֧KXקO@ӦnDNC

iHo˰G




















Oracle Database HOWTO							      9



	  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 Np UNIX 
rootA]ڭ̭nإߥt@vO֪ΤHlC]Oۭn}ҸƮw~إߥΤC^

s SQL*Plus ΫإߥΤG


	  $ 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 Database HOWTO							     10



tΤw@ӷsΤAAiHΥLӸեηstΡCnñJ Oracle ƮwG


	  $ sqlplus <user>/<password>


pGobS~TpUAAw@ӹB@ Oracle
ƮwCpGAu|qoqsoƮwAӤ|qLaAAi𮧤FI

LApGAjHQ]wnϧAiHqLqsA~ŪUhC


4.  bAW]w SQL*Net

Ҧoɮ׳|Ω]w Oracle n]SQL*NetAM Oracle8  Net8
th^CoɮӳإߦbA $ORACLE_HOME/network/admin ؿC

4.1  tnsnames.ora

TNSNAMES.ORA
ɳ]wҦoqѪAȡC{bڭ̴yzҦWFAƮwCAWҦƮwAn[WHU@qG


	  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 ɴyzҦLqio쪺AȤΦAť{ (listener)
һݪҦ]wC

@q]Ať{W١Bť{a}Bť{ѪAȪƮwΰѼƳ]w
(listener name, listener address, databases served by the listener and configu
ration parameters)C

o̦@ӨҤlG








Oracle Database HOWTO							     11



	  # ť{W٤ΩҦťa}
	  LISTENER =
		  ( ADDRESS_LIST =
			  (ADDRESS =
				  (PROTOCOL=tcp)
				  (HOST=<INSERT HOST>)
				  (PORT=1521)
				  (COMMUNITY=UK_SUP_TCPIP)
			  )
			  (ADDRESS =
				  (PROTOCOL=ipc)
				  (KEY=700)
				  (COMMUNITY=UK_SUP_TCPIP)
			  )
		  )

	  # CXť{ѪA
	  SID_LIST_LISTENER=
		  (SID_LIST=
			  (SID_DESC=
				  (SID_NAME=orcl)
				  (ORACLE_HOME=/home/oracle/7.3.3.0.0)
			  )
		  )

	  # }lѼƳ]w
	  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 ɥ]AW@ӯSw`I (node)
]wCoǸƩMƮwƥؤκť{ƥصLCoɮפ̭nFO
Dead Connection Timeout ܼƪ]wC

Dead connection timeout
ˬdC@ӱӸƮw{νTOΤݤCpGΤ]^õLA
Oracle Avl{ (shadow process) K|QC

pGAܦhΤsƮwAoID`ΡCרOAb{}oqAΤhƤॿTaɭԡC

HUOڪ sqlnet.ora ɡAѦUṴ̄ѦҡG


	  TRACE_LEVEL_CLIENT = OFF
	  sqlnet.expire_time = 30  # ⦸ˬdȤۮt
	  names.default_domain = world
	  name.default_zone = world









Oracle Database HOWTO							     12



4.4  }lεť{

{bť{ SQL*Net
]wwgAڭ̥iHեκnӻƮwC]eڭ̥uOsƮwA{bhObϥλ{
(remote) ΤC^

ϥΥHW]wӱҰʺť{G


	  $ 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


nť{G

















Oracle Database HOWTO							     13



	  $ 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


pGA DNS äǦ^wD IP a}AҰʤεť{|@Iɶ]̾
DNS 2-3 Oܼ (timeout variable)AjPb 2-3
^CpGuoͳopAЭ@ߵݡAߡC


5.  Τ᪺]w

5.1  Τ

b PC Wϥθs Oracle Client Software ]w SQL*Net
Q²C̨Ρ]]̤K^o@ӹB@`ΤOϥ Oracle Ѫ
SQL*Net Easy Configuration uC

ou㦳@ӺF (wizard) AiaA]w tnsnames.ora  sqlnet.ora
ɮסC

 "Add Database Alias"
ΦbQݤήɥJNW١CoNOAΥHwƮwW١AoөMƮwW٬ۦP]o̬O
orcl)C

bqTw (protocol)  TCP/IPAbQݤήɦ^DW (machine hosting
the database) θƮwW (instance name)C

NOoˤFC

LAYϧAS SQL*Net Easy Configuration u]ξߡCAuݦb $ORA
CLE_HOME/network/admin ؿإߩMbA@Ҥ@˪ tnsnames.ora M sql
net.ora ɡCo˷|ϧAoۦPOW]oO@ӦnDN^C

5.2  Unix Τ

UNIX ΤMΤOjCpGA Oracle  Network Man
agerAkMHWthCSܡAA@AuݨϥΩMA $ORACLE_HOME/net
work/admin ؿۦP]wɡC


6.  ۰ʱҰʤΰ











Oracle Database HOWTO							     14



6.1  dbstart  dbstop

Oracle Ʈw۰ʱҰʤΰiy Oracle Ѫ dbstart  dbshut ɹF (b
7.3.3.0.0 ^CoɮפSA̾a /etc/oratab sb~ϥΡ]M dbshut M
dbstart ɥiϸѰoC^

/etc/oratab ɮ榡pUG


	  SID:ORACLE_HOME:AUTO


Ҧp


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


6.2  init.d  rc.d

nb}ɦ۰ʱҰʩMƮwܡAAݭnק Linux
ҰʩROZCoäxALAڻݭnXoǧʦ]P Linux
o檩]slackware, debian, redhat ^ӦҤPCڳoǨҤlAΩ Redhat
5.0CnAҥΪ Linux @XקAХѦҧAYW Linux
C]MoڤWӾAΩҦ Sys V UNIXC^

Aڭ̭nإ߷| /etc/rc.d/init.d ؿ dbshut  dbstart
ROZCHUɮשRW /etc/rc.d/init.d/oracle:

































Oracle Database HOWTO							     15



	  #!/bin/sh
	  #
	  # /etc/rc.d/init.d/oracle
	  # ѻJҰʤΰ Oracle ƮwMť{
	  # ˬdpROZ
	  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 : Shutting Down 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








Oracle Database HOWTO							     16



		  touch /var/lock/subsys/oracle
		  ;;
	    *)
		  echo "Usage: oracle {start|stop|restart}"
		  exit 1
	  esac


n[ީˬdoɮר쩳SuTaҰʩMtΤƮwCˬdO(log
file)AݬݦS~TC

˧oROZAڭ̭nbT浥ťؿ (runlevel directories)
/etc/rc.d/rcX.d إߤΧRŸs (symbolic links)C

HUOTOb浥 2, 3  4 U|sXƮwJ


	  $ 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


nbsҰʮɰƮwAڭ̻ݭnHUsJ


	  $ ln -s ../init.d/oracle /etc/rc.d/rc0.d/K01oracle	      # 
	  $ ln -s ../init.d/oracle /etc/rc.d/rc6.d/K01oracle	      # sҰ



7.  LƩy

7.1  Intelligent Agent

pGAݭn Oracle Intelligent AgentAڵo{Aݭק]wK楦CnҰ
IA ܡJ


	  $ lsnrctl dbsnmp_start


n IAJ


	  $ lsnrctl dbsnmp_stop


|X{TҰʩΰ intelligent agent O_\CLAbΤݥ
Enterprise Manager @X^AҥHڰ]B@`C


8.  Ƹ

o̦@ƸѪܡC








Oracle Database HOWTO							     17



8.1  ڤb Oracle 7.2.x إ߸ƮwC

Oracle 7.2.x ~~a]AQ]wA (parallel server)Cm
init.ora ɤHU@yJ


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



nѨMoDuݧ⥦ܬѡJ


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


8.2  7.3.4.x  svrmgrl  segmentation faultC

֤HiLoDڡCGerald Weber gerald_weber@master.co.at ѨMFJ









































Oracle Database HOWTO							     18



	  Hi Paul,

	  D`P§AUALAAҷQ쪺DMکҹJ쪺LC
	  DXb iBCS C
	  G Oracle F@ӥثe iBCS ä䴩tγ]wIs (sysconf-calls)C
	  ЬݥHU traceJ

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

	  ѨMkJץ iBCS {XCϥΥHUץɡJ


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

oھ Bob Withers, bwit@pobox.com @ggCLƬOӦ Georg
Rehreld, rehfeld@wmd.de M David Mansfield,  david@claremont.com ҼgC

Lչu@ Bob Withers, Mark Watling, mwatling@mjw-ltd.demon.co.uk, Peter
Sodhi, petersodhi@unn.unisys.com and Greg Hankins, greg.hankins@cc.gatech.edu
C

ڭnh©ҦѻPog󪺤HΩҧ@XsCSOnh Bob Withers M
Mark Watling [NΧ@XC









Oracle Database HOWTO							     19





































































				   CONTENTS



1. ɨ ..................................................................... 1
   1.1 v ............................................................. 1
   1.2 Copyright ............................................................ 1
   1.3 Disclaimer ........................................................... 1
   1.4  HOWTO ت ...................................................... 2
   1.5 tέnD ............................................................. 2
   1.6 Oracle Corporation s .......................................... 3

2. w Oracle n ......................................................... 3
   2.1 AǳƤu ..................................................... 3
   2.2 qЦw ........................................................... 4
   2.3 w˫᪺u@ ......................................................... 4

3. إߤ@ӸƮw ........................................................... 5
   3.1 إߪl (Initialisation File) ..................................... 5
   3.2 إ߸Ʈww˩ROZ ................................................. 6
   3.3 Ʈww˦wOZ ............................................... 6
   3.4 ҰʸƮw ........................................................... 7
   3.5 Ʈw ........................................................... 8
   3.6 إߤwΤ (Default User) .......................................... 8

4. bAW]w SQL*Net .................................................. 10
   4.1 tnsnames.ora ........................................................ 10
   4.2 listener.ora ........................................................ 10
   4.3 sqlnet.ora .......................................................... 11
   4.4 }lεť{ .................................................. 12

5. Τ᪺]w .............................................................. 13
   5.1 Τ ............................................................ 13
   5.2 Unix Τ ........................................................... 13

6. ۰ʱҰʤΰ .......................................................... 13
   6.1 dbstart  dbstop ................................................... 14
   6.2 init.d  rc.d ...................................................... 14

7. LƩy ................................................................ 16
   7.1 Intelligent Agent ................................................... 16

8. Ƹ ................................................................ 16
   8.1 ڤb Oracle 7.2.x إ߸ƮwC ................................ 17
   8.2 7.3.4.x  svrmgrl  segmentation faultC ........................ 17

9. aA .................................................................... 18









				       i


