
                             Oracle Database HOWTO
                                       
@̡GPaul Haigh, paul@nailed.demon.co.uk
Ķ̡GFd, a9504480@graduate.hku.hk

   1.2 , @EEK~K|]½ĶJ@EEK~KTQ@^
     _________________________________________________________________
   
   b Linux tΤwˤγ]w Oracle ƮwAnC
     _________________________________________________________________
   
1. ɨ

     * 1.1 v
     * 1.2 Copyright
     * 1.3 Disclaimer
     * 1.4  HOWTO ت
     * 1.5 tέnD
     * 1.6 Oracle Corporation s
       
2. w Oracle n

     * 2.1 AǳƤu
     * 2.2 qЦw
     * 2.3 w˫᪺u@
       
3. إߤ@ӸƮw

     * 3.1 إߪl (Initialisation File)
     * 3.2 إ߸Ʈww˩ROZ
     * 3.3 Ʈww˦wOZ
     * 3.4 ҰʸƮw
     * 3.5 Ʈw
     * 3.6 إߤwΤ (Default User)
       
4. bAW]w SQL*Net

     * 4.1 tnsnames.ora
     * 4.2 listener.ora
     * 4.3 sqlnet.ora
     * 4.4 }lεť{
       
5. Τ᪺]w

     * 5.1 Τ
     * 5.2 Unix Τ
       
6. ۰ʱҰʤΰ

     * 6.1 dbstart  dbstop
     * 6.2 init.d  rc.d
       
7. LƩy

     * 7.1 Intelligent Agent
       
8. Ƹ

     * 8.1 ڤb Oracle 7.2.x إ߸ƮwC
     * 8.2 7.3.4.x  svrmgrl  segmentation faultC
       
9. aA
     _________________________________________________________________
   
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 document.
   
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.
   
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˦۸չL
                AOgT{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
                
     * 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
     * [1]http://www.oracle.com/html/linux.html
     * [2]http://www.news.com/News/Item/0,4,24436,00.html
     * [3]http://www.zdnet.com/pcweek/news/0720/20morac.html
       
2. w Oracle n

2.1 AǳƤu

  إ Oracle Τ
  
   pjaҮơAڭ̻ݭn@ӥΤӫOs Oracle ƮwC]ڭ̤Qs
    Oracle ֤ߡ]eA͡^Aڭ̭n Oracle wϥΪ̤θsզW١A
   YϥΪ̬ ORACLEAӸsլ DBAC
   
    1. H root ñJ
    2. إߨϥΪ oracle θs dbaC
       ______________________________________________________________
     
$ groupadd dba
$ useradd  oracle
       ______________________________________________________________
     
    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ꤣP
   DAq 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@

  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 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
       ______________________________________________________________
     
  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:
       ______________________________________________________________
     
$ 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
       ______________________________________________________________
     
$ 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.
       ______________________________________________________________
     
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
       ______________________________________________________________
     
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
       ______________________________________________________________
     
   tΤw@ӷsΤAAiHΥLӸեηstΡCnñJ Oracle ƮwG
       ______________________________________________________________
     
$ sqlplus <user>/<password>
       ______________________________________________________________
     
   pGobS~TpUAAw@ӹB@ Oracle ƮwCp
   GAu|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 configuration parameters)C
   
   o̦@ӨҤlG
       ______________________________________________________________
     
# ť{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{}oq
   AΤ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
       ______________________________________________________________
     
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_S
UP_TCPIP))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for SCO System V/386: Version 2.3.3.0.0 - Pro
duction
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
       ______________________________________________________________
     
$ 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_S
UP_TCPIP))
The command completed successfully
LSNRCTL> exit
       ______________________________________________________________
     
   pGA DNS äǦ^wD IP a}AҰʤεť{|@I
   ]̾ DNS 2-3 Oܼ (timeout variable)AjPb 2-3 ^C
   pGuoͳ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
   $ORACLE_HOME/network/admin ؿإߩMbA@Ҥ@˪
   tnsnames.ora M sqlnet.ora ɡCo˷|ϧAoۦPOW]oO@ӦnDN
   ^C
   
5.2 Unix Τ

   UNIX ΤMΤOjCpGA Oracle  Network ManagerAkM
   HWthCSܡAA@AuݨϥΩMA
   $ORACLE_HOME/network/admin ؿۦP]wɡC
   
6. ۰ʱҰʤΰ

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 ҰʩROZC
   oäxALAڻݭnXoǧʦ]P Linux o檩
   ]slackware, debian, redhat ^ӦҤPCڳoǨҤlAΩ Redhat
   5.0CnAҥΪ Linux @XקAХѦҧAYW Linux C]M
   oڤWӾAΩҦ Sys V UNIXC^
   
   Aڭ̭nإ߷| /etc/rc.d/init.d ؿ dbshut  dbstart RO
   ZCHUɮשRW /etc/rc.d/init.d/oracle:
       ______________________________________________________________
     
#!/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 do
wn." >> /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
       ______________________________________________________________
     
   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
   
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 ѨMF
   J
       ______________________________________________________________
     
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

References

   1. http://www.oracle.com/html/linux.html
   2. http://www.news.com/News/Item/0,4,24436,00.html
   3. http://www.zdnet.com/pcweek/news/0720/20morac.html
