
                             Oracle Database HOWTO
                                       
ߣPaul Haigh, paul@nailed.demon.co.uk
ߣ￵, a9504480@graduate.hku.hk

   1.2 , һžŰգڡһžŰʮһգ
     _________________________________________________________________
   
    Linux ϵͳаװ趨 Oracle Ͽŷָ֮ϡ
     _________________________________________________________________
   
1. 

     * 1.1 汾ʷ
     * 1.2 Copyright
     * 1.3 Disclaimer
     * 1.4  HOWTO Ŀ
     * 1.5 ϵͳҪ
     * 1.6 Oracle Corporation Ϣ
       
2. װ Oracle 

     * 2.1 ŷ׼
     * 2.2 ӹװ
     * 2.3 װĹ
       
3. һϿ

     * 3.1 ʼ (Initialisation File)
     * 3.2 Ͽⰲװ
     * 3.3 ִϿİװ
     * 3.4 Ͽ
     * 3.5 ֹͣϿ
     * 3.6 ڶû (Default User)
       
4. ŷ趨 SQL*Net

     * 4.1 tnsnames.ora
     * 4.2 listener.ora
     * 4.3 sqlnet.ora
     * 4.4 ʼʽ
       
5. û趨

     * 5.1 Ӵû
     * 5.2 Unix û
       
6. Զֹͣ

     * 6.1 dbstart  dbstop
     * 6.2 init.d  rc.d
       
7. 

     * 7.1 Intelligent Agent
       
8. Ž

     * 8.1 Ҳ Oracle 7.2.x нϿ⡣
     * 8.2 7.3.4.x  svrmgrl  segmentation fault
       
9. 
     _________________________________________________________________
   
1. 

1.1 汾ʷ

     * 0.1  - һžŰإһ - Paul Haigh - ȵİ汾
     * 0.2  - һžŰһ - Paul Haigh - Уߵۡ
     * 1.0  - һžŰʮ - Paul Haigh -  LDP 档
     * 1.1  - һžŰ¶ʮ - Paul Haigh - Ž
       
     * 1.2  - һžŰ - Paul Haigh -  Oracle Corporation
       żɾȥδĽһڡ
       
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 Ŀ

    HOWTO һ᳢˵ΰװһ Linux ִе Oracle 
   Ͽ⣬һر˵ Oracle ŷİװSQL*Net 趨û (client)
   趨
   
   ļһйʹüһ Oracle ϿָҪ
   ϣO'Reilly ̶Ƴⷽļ
   
   Ҳ˵ Unix  Oracle ʽĿ̡оҪ
    SCO  SCO development system ( OpenServer 5.x)
   ֪ʮֺʮſԪ www.sco.com õ
   
1.5 ϵͳҪ

   Ҫƪ HOWTO ݣҪ¶
     * Oracle Server CD е SCO Openserver (7.3.3.0.0 )
       
                ǺϷİ汾 Oracle һĲĹ˾
                ƷշѡҪѶ֧Ԯ SQL Ͽ⣬
                PostgresSQL Գʽ
                
                Ҳɴ Oracle ҳһ tar еõһʮ
                ֤ (license) װ Oracle ҲûԹ
                δȷϵġ
                
     * һ̨ Linux ŷ
       
                ûеĻͲĶļˣ
                
     * 2.0.30+ ĺ
       
                Ҳ֤Щָʾκ˵׼ȷҶ 2.0.30 Ҳ
                ֤
                
     * iBCS
       
                װʹõƽ̨°汾ǳҪʹ
                Redhat Linux  iBCS-2.0-10.i386.rpm
                
     * ŵռ
       
                600 Mb Ǹ֡ʹøٵĿռҲԣҪ
                һЩҴӲʼһ᳢ָ
                ռ䡣
                
     * 32Mb ϼ
       
                ֪ܶ࣬ر Linux ˵,  Oracle
                Ǹӵ SCO㲻⣡
                
                Ҳ˵ Oracle ڽټ¹
                 Oracle Ľ飬Ҳ޳
                
     * Oracle ֤ (License)
       
                ֪֪Ҫġû֤ʹ
                 Oracle Υġ
                
1.6 Oracle Corporation Ϣ

   Oracle  Linux ȺѹOracle Corporation Ѿ
   Linux ƽ̨ Oracle 8 ṩٷ֧Ԯ Oracle ַ˵⽫һžŰ
   ʮƳ
   
   õϢ Oracle  Oracle Ӧֲ Linux ƽ̨ Oracle
   ҳӦûһžžϰƳ
   
   οϣ
     * [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. װ Oracle 

2.1 ŷ׼

   Oracle û
  
   ϣҪһû Oracle Ͽ⡣Ϊǲ
    Oracle ģ̸Ҫ Oracle ڶʹ߼Ⱥƣ
   ʹΪ ORACLEȺΪ DBA
   
    1.  root ǩ
    2. ʹ oracle Ⱥ dba
       ______________________________________________________________
     
$ groupadd dba
$ useradd  oracle
       ______________________________________________________________
     
    3. ȷʹ oracle гʼĿ¼ (home directory)
       ______________________________________________________________
     
$ mkdir /home/oracle
$ mkdir /home/oracle/7.3.3.0.0 (Oracle İ汾)
$ chown -R oracle.dba /home/oracle
       ______________________________________________________________
     
2.2 ӹװ

   ҵأSCO  Oracle װʽʹ߻һͬ
   ⣬ core dump ҪԼӹѵӲѹ
   
   ȷѹ (mount) ϵͳϣ
    1.  Oracle ǩ
    2.  /home/oracle/7.3.3.0.0 Ŀ¼
    3. ӹаװ
       ______________________________________________________________
     
$ cp -a /mnt/cdrom/* .
       ______________________________________________________________
     
    4. ѹϵ Oracle 
       ______________________________________________________________
     
$ find . -name *_ -exec ~/7.3.3.0.0/orainst/oiuncomp {} \;
       ______________________________________________________________
     
2.3 װĹ

  Root Ĺ
  
   мӵ /etc/profile ӵÿһʹ Oracle üҵ
   .profile С
       ______________________________________________________________
     
# Oracle ר
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"
       ______________________________________________________________
     
   ҲҪ޸ Oracle ulimit ߵӵ˼ (permissions)
       ______________________________________________________________
     
$ chown root.root $ORACLE_HOME/bin/osh
$ chmod u+s $ORACLE_HOME/bin/osh
       ______________________________________________________________
     
  Oracle Ĺ
  
   ޸ Oracle ȷȷ
       ______________________________________________________________
     
$ chmod +x $ORACLE_HOME/bin/*
$ chmod u+s $ORACLE_HOME/bin/oracle
       ______________________________________________________________
     
   Oracle ĹҪѶϢ $ORACLE_HOME/tool_name/mesg Ŀ¼
   ҪѼ msg_ship Ŀ¼µmsg Ƶ mesg Ŀ¼¡
       ______________________________________________________________
     
$ 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
       ______________________________________________________________
     
  ƳĶ
  
   Ŀ¼԰ȫƳ
     * $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 ʼ (Initialisation File)

    $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 Ͽ⣬Ҫڲ (connected internally) ˵ִ
   startup ָ
       ______________________________________________________________
     
$ 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 ڶû (Default User)

   ڽϿʱԶرû
       ______________________________________________________________
     
Username                Password

SYSTEM                  MANAGER
SYS                     change_on_install
       ______________________________________________________________
     
   Щûͨ׼ֵ (data dictionary) ϿС
   ޸һ⡣
   
   
       ______________________________________________________________
     
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  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>
       ______________________________________________________________
     
   ûдѶϢɣһе Oracle Ͽ⡣
   ֻⲿӵϿ⣬طϢˣ
   
   󲿷˰趨ʹԴӣ
   ȥ
   
4. ŷ趨 SQL*Net

   Щ趨 Oracle SQL*Net Oracle8 
   Net8 ࣩЩӦöŷе
   $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 name, listener address, databases served by the
   listener and configuration parameters)
   
   һӣ
       ______________________________________________________________
     
# ʽƼĵַ
LISTENER =
        ( ADDRESS_LIST =
                (ADDRESS =
                        (PROTOCOL=tcp)
                        (HOST=<INSERT HOST>)
                        (PORT=1521)
                        (COMMUNITY=UK_SUP_TCPIP)
                )
                (ADDRESS =
                        (PROTOCOL=ipc)
                        (KEY=700)
                        (COMMUNITY=UK_SUP_TCPIP)
                )
        )

# гʽṩķ
SID_LIST_LISTENER=
        (SID_LIST=
                (SID_DESC=
                        (SID_NAME=orcl)
                        (ORACLE_HOME=/home/oracle/7.3.3.0.0)
                )
        )

# ʼ趨
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) 趨ЩϺϿ
   ĿʽĿ޹ءҪĶ Dead Connection
   Timeout 趨
   
   Dead connection timeout ÿһӵϿг̼ȷûз
   ӦûͲУ޷ӦӦ Oracle ŷӰг
   (shadow process) ᱻɱ
   
   кܶûȡϿ⣬ǳáǵڳʽ׶
   ûȷؽʱ
   
   ҵ sqlnet.ora ߲ο
       ______________________________________________________________
     
TRACE_LEVEL_CLIENT = OFF
sqlnet.expire_time = 30         # μͻ
names.default_domain = world
name.default_zone = world
       ______________________________________________________________
     
4.4 ʼʽ

   йؼʽ SQL*Net 趨Ѿɣǿ
   Ͽ⡣֮ǰֱֻӵϿ⣬ģʹԶ (remote)
   û
   
   ʹϵ趨ʽ
       ______________________________________________________________
     
$ 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
       ______________________________________________________________
     
   Ҫֹͣʽ
       ______________________________________________________________
     
$ 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
       ______________________________________________________________
     
    DNS ָ IP ַʽỨһʱ
   䣨 DNS 2-3 ʱ (timeout variable) 2-3 ֮䣩
   ķĵȴصġ
   
5. û趨

5.1 Ӵû

    PC ʹý°汾 Oracle Client Software 趨 SQL*Net ʮּ򵥡
   ѣҲ㣩õһȫûʹ Oracle ṩ SQL*Net
   Easy Configuration ߡ
   
   ⹤һ (wizard) Ľ棬ɴ趨 tnsnames.ora 
   sqlnet.ora 
   
   ѡ "Add Database Alias" ڱʼʱơָ
   ϿƣӦúϿͬ orcl)
   
   ͨѶЭ (protocol) ѡ TCP/IPڱʼʱش (machine
   hosting the database) Ͽ (instance name)
   
   ˡ
   
   ʹû SQL*Net Easy Configuration Ҳõġֻ
   $ORACLE_HOME/network/admin Ŀ¼нŷһģһ
   tnsnames.ora  sqlnet.ora ʹõͬıһ
   
   
5.2 Unix û

   UNIX ûӴûֱ𲻴 Oracle  Network Manager
   ϲࡣûеĻ˵һΣֻʹúŷ
   $ORACLE_HOME/network/admin Ŀ¼ͬ趨
   
6. Զֹͣ

6.1 dbstart  dbstop

   Oracle ϿԶֹͣɼ Oracle ṩ dbstart  dbshut 
    ( 7.3.3.0.0 УЩˣ /etc/oratab ڲʹãȻ
    dbshut  dbstart ʹơ
   
   /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 塣
   ⲢѣҪָЩĶӦͬ Linux а汾
   slackware, debian, redhat ȣͬЩ Redhat
   5.0ҪΪõ Linux ޸ģȲοͷϵ Linux ļȻ
   ʵӦ Sys V UNIX
   
   ȣҪִ /etc/rc.d/init.d Ŀ¼ dbshut  dbstart 
   塣µΪ /etc/rc.d/init.d/oracle:
       ______________________________________________________________
     
#!/bin/sh
#
# /etc/rc.d/init.d/oracle
# ˵ֹͣ Oracle Ͽͼʽ
# ִ
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
       ______________________________________________________________
     
   Ҫ춼ûȷֹͣϵͳеϿ⡣
   ¼(log file)ûдѶϢ
   
   ŪᣬҪȷִеȼĿ¼ (runlevel directories)
   /etc/rc.d/rcX.d нɾ (symbolic links)
   
   ָȷִеȼ 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
       ______________________________________________________________
     
   ҪʱֹͣϿ⣬Ҫ
       ______________________________________________________________
     
$ ln -s ../init.d/oracle /etc/rc.d/rc0.d/K01oracle          # ֹͣ
$ ln -s ../init.d/oracle /etc/rc.d/rc6.d/K01oracle          # 
       ______________________________________________________________
     
7. 

7.1 Intelligent Agent

   Ҫ Oracle Intelligent Agentҷ㲻޸κ趨ִ
   Ҫ IA Ļ
       ______________________________________________________________
     
$ lsnrctl dbsnmp_start
       ______________________________________________________________
     
   Ҫֹͣ IA
       ______________________________________________________________
     
$ lsnrctl dbsnmp_stop
       ______________________________________________________________
     
   κѶϢ˵ֹͣ intelligent agent Ƿɹû
   ж Enterprise Manager ӦҼ
   
8. Ž

   һЩŽʾ
   
8.1 Ҳ Oracle 7.2.x нϿ⡣

   Oracle 7.2.x Ʒؼ趨ƽŷ (parallel server)õ
   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 fault

   в˱ҡGerald Weber gerald_weber@master.co.at 
   
       ______________________________________________________________
     
Hi Paul,

ȷǳлİ뵽ȫ޹ء
 iBCS ģ
ƺ Oracle ִһĿǰ汾 iBCS ֧Ԯϵͳ趨 (sysconf-calls)
뿴µ trace

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

 iBCS Դʽ롣ʹµ


--- 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 Rehreld, rehfeld@wmd.de  David Mansfield, david@claremont.com
   дļ
   
   УԹ Bob Withers, Mark Watling,
   mwatling@mjw-ltd.demon.co.uk, Peter Sodhi, petersodhi@unn.unisys.com
   and Greg Hankins, greg.hankins@cc.gatech.edu ɡ
   
   Ҫлвƪļ˵ּ֧оرҪл Bob
   Withers  Mark Watling ĸİæ

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
