








			     Oracle Database HOWTO

		   ߣPaul Haigh, paul@nailed.demon.co.uk

		    ߣ￵, a9504480@graduate.hku.hk

	1.2 , һžŰգڡһžŰʮһգ



				   Abstract

      Linux ϵͳаװ趨 Oracle Ͽŷָ֮ϡ



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

 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
		 Ǹ֡ʹøٵĿռҲԣҪһЩҴӲʼһ᳢ָڳռ䡣









Oracle Database HOWTO							      3



    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
ҳӦûһžžϰƳ

οϣ

    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.  װ Oracle 

2.1  ŷ׼

2.1.1   Oracle û

ϣҪһû Oracle Ͽ⡣Ϊǲ Oracle
ģ̸Ҫ Oracle ڶʹ߼ȺƣʹΪ ORA
CLEȺΪ DBA

  1.   root ǩ

  2.  ʹ oracle Ⱥ dba


		$ groupadd dba
		$ useradd  oracle











Oracle Database HOWTO							      4



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

2.3.1  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 Database HOWTO							      5



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 Ŀ¼µ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


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



У


	  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 ִ









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  Ͽ

ʼʱҪϿ⣨⹤ԶҪ 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.









Oracle Database HOWTO							      8



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)
ϿС޸һ⡣






















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



ϵͳһûϵͳҪǩ 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 configu
ration parameters)

һӣ








Oracle Database HOWTO							     11



	  # ʽƼĵַ
	  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









Oracle Database HOWTO							     12



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


Ҫֹͣʽ

















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


 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 Ҳõġֻ $ORA
CLE_HOME/network/admin Ŀ¼нŷһģһ tnsnames.ora  sql
net.ora ʹõͬıһ⣩

5.2  Unix û

UNIX ûӴûֱ𲻴 Oracle  Network Man
agerϲࡣûеĻ˵һΣֻʹúŷ $ORACLE_HOME/net
work/admin Ŀ¼ͬ趨


6.  Զֹͣ











Oracle Database HOWTO							     14



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:

































Oracle Database HOWTO							     15



	  #!/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 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


Ҫ춼ûȷֹͣϵͳеϿ⡣¼(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.  Ž

һЩŽʾ








Oracle Database HOWTO							     17



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 









































Oracle Database HOWTO							     18



	  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 ĸİæ









Oracle Database HOWTO							     19





































































				   CONTENTS



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

2. װ Oracle  ......................................................... 3
   2.1 ŷ׼ ..................................................... 3
   2.2 ӹװ ........................................................... 4
   2.3 װĹ ......................................................... 4

3. һϿ ........................................................... 5
   3.1 ʼ (Initialisation File) ..................................... 5
   3.2 Ͽⰲװ ................................................. 6
   3.3 ִϿİװ ............................................... 6
   3.4 Ͽ ........................................................... 7
   3.5 ֹͣϿ ........................................................... 8
   3.6 ڶû (Default User) .......................................... 8

4. ŷ趨 SQL*Net .................................................. 10
   4.1 tnsnames.ora ........................................................ 10
   4.2 listener.ora ........................................................ 10
   4.3 sqlnet.ora .......................................................... 11
   4.4 ʼʽ .................................................. 12

5. û趨 .............................................................. 13
   5.1 Ӵû ............................................................ 13
   5.2 Unix û ........................................................... 13

6. Զֹͣ .......................................................... 13
   6.1 dbstart  dbstop ................................................... 14
   6.2 init.d  rc.d ...................................................... 14

7.  ................................................................ 16
   7.1 Intelligent Agent ................................................... 16

8. Ž ................................................................ 16
   8.1 Ҳ Oracle 7.2.x нϿ⡣ ................................ 17
   8.2 7.3.4.x  svrmgrl  segmentation fault ........................ 17

9.  .................................................................... 18









				       i


