Åëëçíéêü Oracle Database HOWTO
Paul Haigh, paul@nailed.demon.co.uk
v1.0, 10 Ìáñôßïõ 1998
Åíáò ïäçãüò ãéá ôçí åãêáôÜóôáóç êáé ñýèìéóç ôïõ Oracle Database Server
óå Ýíá óýóôçìá Linux
______________________________________________________________________
Table of Contents
1. ÅéóáãùãÞ
1.1 Éóôïñßá ÁíáèåùñÞóåùí
1.2 ÐíåõìáôéêÜ Äéêáéþìáôá
1.3 Disclaimer
1.4 Óêïðüò áõôïý ôïõ HOWTO
1.5 ÁðáéôÞóåéò
1.6 ÌåëëïíôéêÝò Âåëôéþóåéò
2. ÅãêáôÜóôáóç ôïõ ëïãéóìéêïý ôçò Oracle
2.1 Ðñïåôïéìáóßá ôïõ Server
2.1.1 Äçìéïõñãßá åíüò ÷ñÞóôç Oracle
2.2 ÅãêáôÜóôáóç áðü CDROM
2.3 Åñãáóßåò ìåôÜ ôçí ÅãêáôÜóôáóç
2.3.1 Åñãáóßåò ãéá ôïí Root
2.3.2 Åñãáóßåò ãéá ôïí Oracle
2.3.3 ÐñÜãìáôá ðïõ ìðïñåßôå íá áðïìáêñýíåôå:
3. Äçìéïõñãßá ìéáò ÂÜóçò ÄåäïìÝíùí
3.1 Äçìéïõñãßá ôïõ Áñ÷åßïõ Áñ÷éêïðïßçóçò
3.2 ÄçìéïõñãÞóôå ôï Script ÅãêáôÜóôáóçò ÂÜóçò ÄåäïìÝíùí
3.3 ÅêôÝëåóç ôïõ Script ÅãêáôÜóôáóçò ÂÜóçò ÄåäïìÝíùí
3.4 Åêêßíçóç ôçò ÂÜóçò ÄåäïìÝíùí
3.5 Óôáìáôþíôáò ôçí ÂÜóç ÄåäïìÝíùí
3.6 Äçìéïõñãßá åíüò ÐñïêáèïñéóìÝíïõ ×ñÞóôç (Default User)
4. Ñõèìßóôå ôï SQL*Net ôïõ Server
4.1 (TT
4.2 (TT
4.3 (TT
4.4 Åêêßíçóç êáé Ôåñìáôéóìüò ôùí Listeners
5. Ñõèìßóåéò ÐåëÜôç (Client)
5.1 ÐåëÜôåò Windows
5.2 ÐåëÜôåò Unix
6. Áõôüìáôï ÁíÝâáóìá (Startup) êáé ÊáôÝâáóìá (Shutdown)
6.1 (TT
6.2 (TT
7. ¶ëëá ðñáãìáôÜêéá
7.1 Intelligent Agent
8. Åõ÷áñéóôßåò / Áíáãíùñßóåéò
9. Ðåñß ôçò ÅëëçíéêÞò ÌåôÜöñáóçò
______________________________________________________________________
[1m1. ÅéóáãùãÞ[0m
[1m1.1. Éóôïñßá ÁíáèåùñÞóåùí[0m
· v0.1 - 21 Öåâñïõáñßïõ 1998 - Paul Haigh - Áñ÷éêÞ ¸êäïóç
· v0.2 - 01 Ìáñôßïõ 1998 - Paul Haigh - ÐñïóôÝèçêáí ó÷üëéá ãéá ôá
Proofreaders
· v1.0 - 10 Ìáñôßïõ 1998 - Paul Haigh - Äçìïóßåõóç ôïõ óôï LDP
[1m1.2. ÐíåõìáôéêÜ Äéêáéþìáôá[0m
Oracle Database HOWTO copyright (c) 1998, Paul Haigh.
¼ðùò üëá ôá êåßìåíá Linux HOWTO, ìðïñåß íá åðáíáðáñá÷èåß êáé
äéáíåìçèåß ïëüêëçñï Þ ìÝñïò ôïõ, óå êÜèå ìÝóï, öõóéêü Þ çëåêôñïíéêü,
üóï áõôÞ ç óçìåßùóç ðåñß ðíåõìáôéêÞò éäéïêôçóßáò äéáôçñåßôáé óå üëá ôá
áíôßãñáöá.
Ç åìðïñéêÞ áíáäéáíïìÞ åðéôñÝðåôáé êáé åíèáññýíåôáé. Ðáñüëá áõôÜ, ï
óõããñáöÝáò èá Þèåëå íá åéäïðïéçèåß ãéá ôÝôïéåò äéáíïìÝò. Ìðïñåßôå íá
ìåôáöñÜóåôå áõôü ôï HOWTO óå êÜèå ãëþóóá, ìå ôçí ðñïûðüèåóç ðùò
áöÞíåôå áõôÞ ôç äÞëùóç ðåñß ðíåõìáôéêÞò éäéïêôçóßáò áêÝñáéç êáé ðùò èá
ðñïóèÝóåôå ìéá óçìåßùóç ðïõ íá äçëþíåé ôïí ìåôáöñáóôÞ ôïõ êåéìÝíïõ.
[1m1.3. Disclaimer[0m
Åíþ ðñïóðÜèçóá íá óõìðåñéëÜâù ôçí ðéï óùóôÞ êáé ðñüóöáôç ðëçñïöïñßá
ðïõ Þôáí äéáèÝóéìç óå ìÝíá, äåí ìðïñþ íá åããõçèþ ðùò ç ÷ñÞóç ôùí
ðëçñïöïñéþí áõôïý ôïõ êåéìÝíïõ, äåí èá êáôáëÞîåé óå áðþëåéá äåäïìÝíùí
Þ åîïðëéóìïý. ÄÅÍ ÐÁÑÅ×Ù ÊÁÌÉÁ ÅÃÃÕÇÓÇ ãéá ôéò ðëçñïöïñßåò ôïõ HOWTO
êáé äåí ìðïñþ íá èåùñçèþ íïìéêÜ õðåýèõíïò ãéá ü,ôé óõíÝðåéåò áðïññÝïõí
áðü ôçí ÷ñÞóç ôùí ðëçñïöïñßáò óå áõôü ôï HOWTO.
[1m1.4. Óêïðüò áõôïý ôïõ HOWTO[0m
Óå áõôü ôï HOWTO èá åðé÷åéñÞóù íá êáëýøù ôá èÝìáôá ôçò åãêáôÜóôáóçò
êáé ôçò âáóéêÞò äéá÷åßñéóçò ìéáò ÂÜóçò ÄåäïìÝíùí Oracle ðïõ ôñÝ÷åé óå
ìéá ìç÷áíÞ Linux. ÓõãêåêñéìÝíá, èá êáëýøù ôçí åãêáôÜóôáóç ôïõ Oracle
server, ôç ñýèìéóç ôïõ SQL*Net êáé ôïõ client.
Áõôü ôï êåßìåíï äåí áðïôåëåß Ýíá åéò âÜèïò åã÷åéñßäéï ôçò ÷ñÞóçò êáé
äéá÷åßñéóçò ìéáò Â.Ä. Oracle, êáé áí áõôü øÜ÷íåôå õðÜñ÷ïõí õðÝñï÷á
âéâëßá ãéá áõôÜ ôá èÝìáôá ðïõ Ý÷ïõí åêäïèåß áðü ôçí O'Reilly êáé
Üëëïõò.
Äåí ðñüêåéôáé íá êáëýøù ôçí áíÜðôõîç ðñïãñáììÜôùí óå Oracle êÜôù áðü
UNIX. Áí áõôü åßíáé áðïëýôùò áíáãêáßï ãéá åóÜò, èá óáò ðñüôåéíá íá
áãïñÜóåôå ôï SCO Developement System ôçò SCO (ìå ôïí OpenServer 5.x),
ðïõ ìïõ åßðáí ðùò ìðïñåß íá áðïêôçèåß óôçí ðïëý ëïãéêÞ ôéìÞ ôùí US
$19, áðü ôçí www.sco.com.
[1m1.5. ÁðáéôÞóåéò[0m
ÕðïèÝôù ðùò Ý÷åôå êÜðïéá óôïé÷åßá ðïõ èá ÷ñåéáóôåßôå ãéá íá
áêïëïõèÞóåôå áõôü ôï HOWTO.
· [1mOracle Server CD ãéá ôïí SCO Openserver (Version 7.3.3.0.0.)[0m
[1mÐñÝðåé [22míá åßíáé ìéá íüìéìç êüðéá. Íá èõìÜóôå ðùò ç Oracle åßíáé
ìéá êåñäïóêïðéêÞ åðé÷åßñçóç êáé ÷ñåþíåé ãéá ôá ðñïúüíôá ôçò. Áí
èÝëåôå ìéá äùñåÜí SQL óõìâáôÞ âÜóç äåäïìÝíùí ÷ñçóéìïðïéÞóôå ôçí
PostgresSQL Þ êÜðïéá ðáñüìïéá.
Åßíáé åðßóçò äõíáôüí íá åãêáôáóôÞóåôå ôçí oracle,
÷ñçóéìïðïéþíôáò ìéá Üäåéá äïêéìáóôéêÞò ÷ñÞóçò / áîéïëüãçóçò 60
çìåñþí, áðü áñ÷åßï ðïõ ìðïñåßôå íá êáôåâÜóåôå áðü ôï tar web
site ôçò Oracle. ÐñïóùðéêÜ äåí ôï Ý÷ù äïêéìÜóåé êáé åßíáé
ðëÞñùò áíåðéêýñùôï.
· [1m¸íá Linux Server[0m
Äåí èá ôï äéáâÜæáôå áõôü, åÜí äåí åß÷áôå. ÓùóôÜ;
· [1mÐõñÞíá 2.0.30+[0m
Äåí ìðïñþ íá åããõçèþ ðùò áõôÝò ïé ïäçãßåò èá åßíáé áêñéâåßò ãéá
ïðïéïíäÞðïôå Üëëï ðõñÞíá. (ü÷é üôé åããõþìáé êáé ãéá ôïí 2.0.30
...).
· [1miBCS[0m
Åßíáé ðïëý óçìáíôéêü íá ôï Ý÷åôå åãêáôáóôÞóåé êáé íá äïõëåýåôå
ìå ôçí ôåëåõôáßá äõíáôÞ Ýêäïóç ôïõ ãéá ôçí ðëáôöüñìá óáò.
(×ñçóéìïðïéþ ôï iBCS-2.0-10.i386.rpm ãéá Redhat Linux).
· [1mÌåãÜëï ÷þñï óôï äßóêï[0m
600 Mb+ åßíáé Ýíá ëïãéêü ðïóü. Åßíáé äõíáôü íá åãêáôáóôÞóåôå
êáé ìå ëéãüôåñï áëëÜ èá ÷ñåéáóôåß íá êÜíåôå êÜðïéåò èõóßåò, êáé
äåí ìïõ áñÝóåé ðïôÝ íá áñ÷ßæù Ýôóé. Ðáñüëá áõôÜ, èá ðñïóðáèÞóù
íá õðïäåßîù ôá óçìåßá åêåßíá óôá ïðïßá ìðïñåß íá åëåõèåñùèåß
÷þñïò.
· [1m32Mb+ Ram[0m
ÎÝñù ðùò áêïýãåôáé ìÜëëïí ðïëý, åéäéêüôåñá ãéá ôá ìÝôñá ôïõ
Linux, áëëÜ íá èõìÜóôå ðùò ç Oracle åßíáé Ýíá óýíèåôï êïììÜôé
ëïãéóìéêïý. Äåí èá åß÷áôå ôéò ßäéåò åðéöõëÜîåéò åÜí åß÷áôå SCO!
Äåí éó÷õñßæïìáé ðùò ç Oracle äåí äïõëåýåé ìå ëéãüôåñï, áðëÜ ëÝù
ðùò åÜí åßíáé ëéãüôåñï áðü üôé ç Oracle óõíéóôÜ êáé äåí èá ôï
ðñüôåéíá.
· [1m¢Üäåéåò áðü ôçí Oracle[0m
ÎÝñù ðùò ôï Ý÷ù Þäç áíáöÝñåé, áëëÜ èÝëù íá åßìáé îåêÜèáñïò ðùò
áõôü ôï èÝìá åßíáé óçìáíôéêü. ×ñÞóç ëïãéóìéêïý ôçò Oracle ÷ùñßò
Üäåéá åßíáé ðáñÜíïìç.
[1m1.6. ÌåëëïíôéêÝò Âåëôéþóåéò[0m
Áõôïß åßíáé ïé ôïìåßò ôïõ Oracle server ðïõ äåí êáëýðôïíôáé óå áõôü ôï
HOWTO. Ðáñüëá áõôÜ, áí ï ÷ñüíïò ôï åðéôñÝøåé, èá åðé÷åéñÞóù íá ôïõò
âÜëù óå åðüìåíåò åêäüóåéò ôïõ HOWTO.
· ÁíÜðôõîç ðñïãñáììÜôùí Oracle Pro* ÷ñçóéìïðïéþíôáò âéâëéïèÞêåò ôçò
Oracle.
· ÅãêáôÜóôáóç äéáöïñåôéêþí åêäüóåùí ôïõ Oracle server.
· ÅãêáôÜóôáóç ôïõ Oracle Web Server.
· Ðùò íá êÜíåôå relink ôïí ÐõñÞíá ôçò Oracle.
[1m2. ÅãêáôÜóôáóç ôïõ ëïãéóìéêïý ôçò Oracle[0m
[1m2.1. Ðñïåôïéìáóßá ôïõ Server[0m
[1m2.1.1. Äçìéïõñãßá åíüò ÷ñÞóôç Oracle[0m
¼ðùò åßíáé ëïãéêü ÷ñåéáæüìáóôå Ýíáí ÷ñÞóôç íá êñáôÜåé ôçí âÜóç
äåäïìÝíùí ôçò Oracle. Ìéá ðïõ äåí åðéèõìïýìå íá êÜíïõìå relink ôïí
ðõñÞíá ôçò Oracle (ðåñéóóüôåñá ãéá áõôü áñãüôåñá) èá ðñÝðåé íá
áðïäå÷ôïýìå ôéò ðñïêáèïñéóìÝíåò ðáñáìÝôñïõò ôçò Oracle ãéá ôï üíïìá
ôïõ ÷ñÞóôç êáé ôï üíïìá ôïõ group. ÁõôÝò óõìðåñéëáìâÜíïõí ôïí ÷ñÞóôç
ORACLE êáé ôï group DBA.
1. Óõíäåèåßôå ùò Root
2. Äçìéïõñãåßóôå ôï ÷ñÞóôç oracle êáé ôï group dba.
______________________________________________________________________
$ groupadd dba
$ useradd oracle
______________________________________________________________________
3. Âåâáéùèåßôå ðùò Ýíá home directory äçìéïõñãåßôáé ãéá ôïí ÷ñÞóôç
oracle.
______________________________________________________________________
$ mkdir /home/oracle
$ mkdir /home/oracle/7.3.3.0.0 (Version of Oracle)
$ chown -R oracle.dba /home/oracle
______________________________________________________________________
[1m2.2. ÅãêáôÜóôáóç áðü CDROM[0m
Äõóôõ÷þò ï Oracle Installer áðü ôï äéóêÜêé ôïõ SCO äåí èá äïõëÝøåé.
Ìðïñåß íá áíôéìåôùðßóåôå ðëçèþñá ðñïâëçìÜôùí, áðü core dumps ìÝ÷ñé
êñÝìáóìá. Óáí áðïôÝëåóìá, ÷ñåéÜæåôáé íá áíôéãñÜøïõìå ôá áñ÷åßá áðü ôï
CDROM ÷åéñùíáêôéêÜ êáé íá ôá áðïóõìðéÝóïõìå:
(Âåâáéùèåßôå ðùò ôï CDROM åßíáé ðñïóáñôçìÝíï (mounted) óôï óýóôçìá).
1. Óõíäåèåßôå óáí Oracle
2. ÁëëÜîôå directory óå /home/oracle/7.3.3.0.0.
3. ÁíôéãñÜøôå üëá ôá áñ÷åßá åãêáôÜóôáóçò áðü ôï CDROM
______________________________________________________________________
$ cp -a /mnt/cdrom/* .
______________________________________________________________________
4. ÁðïóõìðéÝóôå üëá ôá áñ÷åßá ôçò Oracle áðü ôï CDROM.
______________________________________________________________________
$ find . -name *_ -exec ~/7.3.3.0.0/orainst/oiuncomp {} \;
______________________________________________________________________
[1m2.3. Åñãáóßåò ìåôÜ ôçí ÅãêáôÜóôáóç[0m
[1m2.3.1. Åñãáóßåò ãéá ôïí Root[0m
ÐñïóèÝóôå ôéò åðüìåíåò ãñáììÝò óôï /etc/profile Þ óôï .profile ãéá
êÜèå ÷ñÞóôç ðïõ ðñüêåéôáé íá ÷ñçóéìïðïéÞóåé ôçí Oracle.
______________________________________________________________________
# Oracle Specific
ORACLE_HOME=/home/oracle/7.3.3.0.0
ORACLE_SID=orcl
ORACLE_TERM=vt100
export ORACLE_HOME ORACLE_SID ORACLE_TERM
# Alter path for Oracle
PATH="$PATH:$ORACLE_HOME/bin"
______________________________________________________________________
Åðßóçò ÷ñåéÜæåôáé íá áëëÜîïõìå ôïí éäéïêôÞôç êáé ôá ðñïíüìéá ÷ñÞóçò
ôçò âïçèçôéêÞò åöáñìïãÞò ôçò Oracle ulimit increase.
______________________________________________________________________
$ chown root.root $ORACLE_HOME/bin/osh
$ chmod u+s $ORACLE_HOME/bin/osh
______________________________________________________________________
[1m2.3.2. Åñãáóßåò ãéá ôïí Oracle[0m
ÁëëÜîôå ôá ðñïíüìéá ÷ñÞóçò ôùí áñ÷åßùí ôçò Oracle ãéá íá åîáóöáëßóåôå
ôçí óùóôÞ ëåéôïõñãßá.
______________________________________________________________________
$ chmod +x $ORACLE_HOME/bin/*
$ chmod u+s $ORACLE_HOME/bin/oracle
______________________________________________________________________
Ôá åñãáëåßá ôçò Oracle áðáéôïýí ôá ìçíýìáôá íá êñáôïýíôáé óôï
directory$ORACLE_HOME/tool_name/mesg. ¸ôóé, ìåôáêéíÞóôå ôá áñ÷åßá msb
áðü ôá directories msg_ship óôá directories 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/.
______________________________________________________________________
Äçìéïõñãåßóôå ôá áêüëïõèá directories áí äåí õðÜñ÷ïõí:
______________________________________________________________________
$ mkdir $ORACLE_HOME/rdbms/log
$ mkdir $ORACLE_HOME/rdbms/audit
$ mkdir $ORACLE_HOME/network/log
______________________________________________________________________
[1m2.3.3. ÐñÜãìáôá ðïõ ìðïñåßôå íá áðïìáêñýíåôå:[0m
Ôá ðáñáêÜôù directories ìðïñïýí íá áðïìáêñõíèïýí ìå áóöÜëåéá:
· $ORACLE_HOME/guicommon2/
· $ORACLE_HOME/ctx/
· $ORACLE_HOME/md/
· $ORACLE_HOME/mlx/
· $ORACLE_HOME/precomp/
· $ORACLE_HOME/slax/
[1m3. Äçìéïõñãßá ìéáò ÂÜóçò ÄåäïìÝíùí[0m
Ôþñá, ï Oracle server åßíáé åãêáôåóôçìÝíïò êáé ÷ñåéÜæåôáé íá
äçìéïõñãÞóïõìå ìéá âÜóç äåäïìÝíùí ãéá íá åëÝãîïõìå ôçí åãêáôÜóôáóç.
[1m3.1. Äçìéïõñãßá ôïõ Áñ÷åßïõ Áñ÷éêïðïßçóçò[0m
ÁíôéãñÜøôå ôï áñ÷åßï $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
______________________________________________________________________
[1m3.2. ÄçìéïõñãÞóôå ôï Script ÅãêáôÜóôáóçò ÂÜóçò ÄåäïìÝíùí[0m
ÄçìéïõñãÞóôå Ýíá áñ÷åßï script ðïõ íá ëÝãåôáé makedb.sql óôï
$ORACLE_HOME/dbs directory:
______________________________________________________________________
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 temporary
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
______________________________________________________________________
[1m3.3. ÅêôÝëåóç ôïõ Script ÅãêáôÜóôáóçò ÂÜóçò ÄåäïìÝíùí[0m
Áñ÷ßóôå ôï svrmgrl êáé ôñÝîôå ôï script:
______________________________________________________________________
$ 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
<ðïëëÜ ìçíýìáôá>
SVRMGR> exit
Server Manager complete.
______________________________________________________________________
[1m3.4. Åêêßíçóç ôçò ÂÜóçò ÄåäïìÝíùí[0m
Áñ÷éêÜ, ÷ñåéÜæåôáé íá óçêþóïõìå ôçí âÜóç äåäïìÝíùí ìå ôï ÷Ýñé (èá ôï
áõôïìáôïðïéÞóïõìå óôç óõíÝ÷åéá). Ãéá íá áñ÷ßóïõìå ìéá âÜóç äåäïìÝíùí
Oracle ÷ñåéÜæåôáé íá äþóïõìå ôçí åíôïëÞ 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.
______________________________________________________________________
[1m3.5. Óôáìáôþíôáò ôçí ÂÜóç ÄåäïìÝíùí[0m
Áîßæåé íá áíáöåñèåß ðùò ç åðáíåêêßíçóç åíüò Linux server ÷ùñßò ðñþôá
ôï êáôÝâáóìá (shutting down) ôçò âÜóçò äåäïìÝíùí ôçò Oracle, Ý÷åé Ýíá
ìåãÜëï êßíäõíï íá äéáâñþóåé (corrupt) ôç âÜóç äåäïìÝíùí.
¸ôóé, ðñéí äþóïõìå ôçí åíôïëÞ ôïõ 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.
______________________________________________________________________
[1m3.6. Äçìéïõñãßá åíüò ÐñïêáèïñéóìÝíïõ ×ñÞóôç (Default User)[0m
Ç âÜóç äåäïìÝíùí, üðùò äçìéïõñãÞèçêå, Ý÷åé äõï åéäéêïýò ÷ñÞóôåò ðïõ
äçìéïõñãïýíôáé áõôüìáôá. Áõôïß åßíáé:
______________________________________________________________________
Username Password
SYSTEM MANAGER
SYS change_on_install
______________________________________________________________________
Áõôïß ïé ÷ñÞóôåò ôõðéêÜ ÷ñçóéìïðïéïýíôáé ãéá íá êñáôÜí ôéò ðëçñïöïñßåò
ôïõ data dictionary information ãéá ôç âÜóç äåäïìÝíùí. Åßíáé êáëÞ
éäÝá íá áëëÜîïõìå ôá passwords áðü ôá ðñïêáèïñéóìÝíá üóï ðéï ãñÞãïñá
ãßíåôáé.
Áõôü ìðïñåß íá êáôïñèùèåß ìå:
______________________________________________________________________
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 åßíáé ðáñüìïéïò ìå ôï íá
÷ñçóéìïðïéåßò root óå ìéá ìç÷áíÞ UNIX, ÷ñåéÜæåôáé íá äçìéïõñãÞóïõìå
Ýíá ÷ñÞóôç ìå ëéãüôåñåò äõíáôüôçôåò íá âëÜøåé ôï óýóôçìá. (èõìçèåßôå
íá óçêþóåôå ôçí âÜóç äåäïìÝíùí ðñéí åðé÷åéñÞóåôå íá äçìéïõñãÞóåôå Ýíá
÷ñÞóôç)
Óõíäåèåßôå óôï 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 ðïõ
äïõëåýåé. Áí äåí èÝëåôå íá óõíäÝåóôå óôç âÜóç áõôÞ áðü ðïõèåíÜ ðëçí
áõôïý ôïõ Server, ôüôå ç äïõëåéÜ ôåëåßùóå, áðïëáýóôå ôçí!
Áí, ðáñüëá áõôÜ, üðùò êáé ïé ðåñéóóüôåñïé Üíèñùðïé èÝëåôå íá ñõèìßóåôå
ôï ëïãéóìéêü äéêôýùóçò, þóôå íá ìðïñåßôå íá óõíäÝåóôå êáé áðü Üëëåò
ìç÷áíÝò, óõíå÷ßóôå ôï äéÜâáóìá.
[1m4. Ñõèìßóôå ôï SQL*Net ôïõ Server[0m
¼ëá áõôÜ ôá áñ÷åßá ñõèìßæïõí ôï ëïãéóìéêü äéêôýùóçò ôçò Oracle
(SQL*Net, ôþñá Net8 for Oracle8). ÁõôÜ ôá áñ÷åßá èá ðñÝðåé íá Ý÷ïõí
Þäç äçìéïõñãçèåß óôï server óôï $ORACLE_HOME/network/admin directory.
[1m4.1. tnsnames.ora[0m
Ôï áñ÷åßï TNSNAMES.ORA áíáãíùñßæåé ôéò äéáèÝóéìåò õðçñåóßåò ôçò
ìç÷áíÞò. Óôï óôéãìéüôõðï (instance) ìáò èá ðåñéãñÜøïõìå üëåò ôéò
âÜóåéò äåäïìÝíùí ðïõ ï server Ý÷åé ðñïóêïëëçìÝíåò. Ãéá êÜèå Ýíá
óôéãìéüôõðï ôçò ÂÜóçò ÄåäïìÝíùí (database instance) ôïõ server óáò,
ðñïóèÝóôå Ýíá ôìÞìá óáí ôï ðáñáêÜôù:
______________________________________________________________________
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)
)
)
______________________________________________________________________
[1m4.2. listener.ora[0m
Ôï áñ÷åßï listener.ora ðåñéÝ÷åé ôéò ðåñéãñáöÝò ôùí õðçñåóéþí ìáò ðïõ
Üëëåò ìç÷áíÝò åðéôñÝðåôáé íá óõíäåèïýí ìå áõôÝò, êáèþò êáé ïðïéáäÞðïôå
ñýèìéóç ðïõ áðáéôåßôáé áðü ôïí listener ôïõ server.
ÐåñéÝ÷åé ôìÞìá ãéá ôï üíïìá êáé ôç äéåýèõíóç ôïõ listener, ôéò âÜóåéò
äåäïìÝíùí ðïõ åîõðçñåôïýíôáé áðü ôïí listener, êáèþò êáé ðáñáìÝôñïõò
ñýèìéóçò.
Íá Ýíá ðáñÜäåéãìá:
______________________________________________________________________
# Name of listener and addresses to listen on
LISTENER =
( ADDRESS_LIST =
(ADDRESS =
(PROTOCOL=tcp)
(HOST=<INSERT HOST>)
(PORT=1521)
(COMMUNITY=UK_SUP_TCPIP)
)
(ADDRESS =
(PROTOCOL=ipc)
(KEY=700)
(COMMUNITY=UK_SUP_TCPIP)
)
)
# List of services served by this listener
SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(SID_NAME=orcl)
(ORACLE_HOME=/home/oracle/7.3.3.0.0)
)
)
# Start of configuration parameters.
TRACE_LEVEL_LISTENER=OFF
TRACE_FILE_LISTENER = "listener"
LOG_FILE_LISTENER = "listener"
CONNECT_TIMEOUT_LISTENER = 10
STOP_LISTENER = YES
DBA_GROUP = dba
______________________________________________________________________
[1m4.3. sqlnet.ora[0m
Ôï áñ÷åßï sqlnet.ora ðåñéÝ÷åé ñõèìßóåéò ãéá Ýíáí óõãêåêñéìÝíï êüìâï
ôïõ äéêôýïõ. Áõôü åßíáé áíåîÜñôçôï ôïõ áñéèìïý ôùí âÜóåùí Þ ôïõ
áñéèìïý ôùí listeners. Ôï ðéï óçìáíôéêü ðñÜãìá óôï áñ÷åßï áõôü åßíáé
ç ìåôáâëçôÞ ñõèìßóåùí Dead Connection Timeout.
Ç Dead connection timeout åëÝã÷åé êÜèå åéóåñ÷üìåíç äéåñãáóßá (process)
ðñïò Ýíá óôéãìéüôõðï ìéáò âÜóçò äåäïìÝíùí êáé âåâáéþíåé ðùò ôï ìÝñïò
ôïõ ðåëÜôç (client) áíôáðïêñßíåôáé áêüìá. Áí ï ðåëÜôçò (áíåîáñôÞôùò
ôýðïõ) äåí áíôáðïêñßíåôáé ôüôå ç Oracle server shadow process
óêïôþíåôáé (kill).
Áõôü åßíáé ðïëý ÷ñÞóéìï ÅÜí Ý÷åôå ðïëëïýò ðåëÜôåò ðïõ êÜíïõí ðñüóâáóç
óôç âÜóç äåäïìÝíùí, åéäéêÜ óå öÜóç áíÜðôõîçò üðïõ áõôïß ïé ðåëÜôåò
åßíáé ðéèáíü íá áðïôõã÷Üíïõí íá âãïõí ïìáëÜ (exit cleanly) áðü ôçí
Â.Ä. ôçò Oracle.
ÐáñáêÜôù åßíáé Ýíá áíôßãñáöï ôïõ áñ÷åßïõ ìïõ sqlnet.ora ãéá íá
÷ñçóéìïðïéÞóåôå:
______________________________________________________________________
TRACE_LEVEL_CLIENT = OFF
sqlnet.expire_time = 30 # The number of seconds between client checks.
names.default_domain = world
name.default_zone = world
______________________________________________________________________
[1m4.4. Åêêßíçóç êáé Ôåñìáôéóìüò ôùí Listeners[0m
Ôþñá ðïõ ïé ñõèìßóåéò ôùí listeners êáé ôïõ SQL*Net ïëïêëçñþèçêáí,
ìðïñïýìå íá åðé÷åéñÞóïõìå íá óõíäåèïýìå óôç âÜóç, ÷ñçóéìïðïéþíôáò ôï
ëïãéóìéêü äéêôýùóçò. (Ðñéí, óõíäåüìáóôáí ìå áðåõèåßáò óýíäåóç óôç
âÜóç, åíþ åäþ ðñïóïìïéþíïõìå ìéá óýíäåóç áðü ìéá áðïìáêñõóìÝíç ìç÷áíÞ
ðåëÜôç)
Ãéá íá áñ÷ßóïõìå ôïí listener ìå ôéò ðáñáðÜíù ñõèìßóåéò:
______________________________________________________________________
$ lsnrctl
LSNRCTL for SCO System V/386: Version 2.3.3.0.0 - Production on 23-FEB-98 20:38:25
Copyright (c) Oracle Corporation 1994. All rights reserved.
Welcome to LSNRCTL, type "help" for information.
LSNRCTL> start
Starting /home/oracle/7.3.3.0.0/bin/tnslsnr: please wait...
TNSLSNR for SCO System V/386: Version 2.3.3.0.0 - Production
System parameter file is /home/oracle/7.3.3.0.0/network/admin/listener.ora
Log messages written to /home/oracle/7.3.3.0.0/network/log/listener.log
Listening on: (ADDRESS=(PROTOCOL=tcp)(DEV=6)(HOST=192.168.1.1)(PORT=1521))
Listening on: (ADDRESS=(PROTOCOL=ipc)(DEV=10)(KEY=700))
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=magic.com)(PORT=1521)(COMMUNITY=UK_SUP_TCPIP))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for SCO System V/386: Version 2.3.3.0.0 - Production
Start Date 23-FEB-98 20:38:50
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security OFF
SNMP ON
Listener Parameter File /home/oracle/7.3.3.0.0/network/admin/listener.ora
Listener Log File /home/oracle/7.3.3.0.0/network/log/listener.log
Services Summary...
orcl has 1 service handler(s)
The command completed successfully
LSNRCTL> exit
______________________________________________________________________
Ãéá íá ôåñìáôßóïõìå ôïõò listeners:
______________________________________________________________________
$ 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 ãéá ôï
hostname ðïõ äçëþóáôå, ç Ýíáñîç êáé ï ôåñìáôéóìüò ôïõ listener ìðïñåß
íá ðÜñåé êÜðïéá þñá (2-3 ëåðôÜ. åîáñôþìåíï áðü ôçí ôéìÞ ìåôáâëçôÞò ôïõ
÷ñüíïõ ëÞîçò ôïõ DNS). Áí áõôü óõìâáßíåé, ìçí áíçóõ÷åßôå, Ý÷åôå
õðïìïíÞ.
[1m5. Ñõèìßóåéò ÐåëÜôç (Client)[0m
[1m5.1. ÐåëÜôåò Windows[0m
Ç ñýèìéóç ôïõ SQL*Net óå PC ÷ñçóéìïðïéþíôáò ôéò íÝåò åêäüóåéò ôïõ
ëïãéóìéêïý Oracle Client åßíáé ðïëý åýêïëç. Ï êáëýôåñïò (êáé
åõêïëüôåñïò) ôñüðïò íá åðéôåõ÷èåß ìéá ðëÞñùò ëåéôïõñãéêÞ åãêáôÜóôáóç
åíüò ðåëÜôç, åßíáé íá ÷ñçóéìïðïéçèåß ôï åñãáëåßï SQL*Net Easy
Configuration ðïõ ðáñÝ÷åôáé áðü ôçí Oracle.
Ôï åñãáëåßï áõôü Ý÷åé Ýíá interface áõôïìáôïðïéçìÝíïõ ðñïãñÜììáôïò
(wizard) ãéá íá óáò ðåñÜóåé áðü ôçí åãêáôÜóôáóç ôùí áñ÷åßùí
tnsnames.ora êáé sqlnet.ora.
ÄéáëÝîôå "Add Database Alias" êáé âÜëôå Ýíá üíïìá ãéá ôï øåõäþíõìï
(alias) ôçò âÜóçò üôáí åñùôçèåßôå when prompted. Áõôü ôï øåõäþíõìï
åßíáé ôï üíïìá ìå ôï ïðïßï èá áíáöÝñåóôå óôï óôéãìéüôõðï ôçò âÜóçò,
êáé óáí ôÝôïéï èá ðñÝðåé íá åßíáé ßäéï ìå ôï üíïìá ôïõ óôéãìéüôõðïõ
(orcl óôçí ðåñßðôùóÞ ìáò).
Äþóôå ôï TCP/IP ùò ðñùôüêïëëï, êáé üôáí åñùôçèåßôå, äþóôå ôï hostname
ôçò ìç÷áíÞò ðïõ öéëïîåíåß ôç Â.Ä. êáé ôï üíïìá ôïõ óôéãìéüôõðïõ ôçò
âÜóçò äåäïìÝíùí.
Áõôü Þôáí.
Ðáñüëá áõôÜ, áí äåí Ý÷åôå ôï åñãáëåßï SQL*Net Easy Configuration ìçí
áíçóõ÷åßôå. Ìðïñåßôå áðëÜ íá äçìéïõñãÞóåôå ôá áñ÷åßá tnsnames.ora êáé
sqlnet.ora files óôï $ORACLE_HOME/network/admin directory ôïõ ðåëÜôç,
áêñéâþò üðùò åßíáé óôï server. Áõôü èá óáò ðáñÝ÷åé Ýíá øåõäþíõìï ßäéï
ìå ôï üíïìá óôïí server (ðïõ Ýôóé êáé áëëéþò áðïôåëåß ðÜíôá ìéá êáëÞ
ôáêôéêÞ).
[1m5.2. ÐåëÜôåò Unix[0m
Ïé ðåëÜôåò UNIX äåí åßíáé ðïëý äéáöïñåôéêïß áðü ôïõò ðåëÜôåò windows.
Áí Ý÷åôå ôï Network Manager ôçò Oracle ôüôå ÷ñçóéìïðïéÞóôå ôï ìå ôïí
ßäéï ôñüðï üðùò ðáñáðÜíù. Áí ü÷é, ðÜëé ìðïñåßôå íá ÷ñçóéìïðïéÞóåôå
áðëÜ ôá ßäéá áñ÷åßá ñõèìßóåùí ôïõ server óôï
$ORACLE_HOME/network/admin directory.
[1m6. Áõôüìáôï ÁíÝâáóìá (Startup) êáé ÊáôÝâáóìá (Shutdown)[0m
[1m6.1. dbstart & dbstop[0m
Ôï áõôüìáôï áíÝâáóìá (Startup) êáé êáôÝâáóìá (Shutdown) ôçò âÜóçò
äåäïìÝíùí Oracle ìðïñåß íá åðéôåõ÷èåß (óôçí 7.3.3.0.0) ìå ôá áñ÷åßá
dbstart êáédbshut, ðïõ êáé ôá äõï ðáñÝ÷ïíôáé áðü ôçí Oracle. ÁõôÜ ôá
áñ÷åßá âáóßæïíôáé óôçí ýðáñîç ôïõ áñ÷åßïõ /etc/oratab ãéá íá äïõëÝøïõí
(áí êáé áëëÜæïíôáò ôá áñ÷åßá dbshut êáé dbstart áõôü ìðïñåß íá
ìåôáöåñèåß).
Ôï format ôïõ áñ÷åßïõ /etc/oratab åßíáé ùò áêïëïýèùò:
______________________________________________________________________
SID:ORACLE_HOME:AUTO
______________________________________________________________________
¸íá ðáñÜäåéãìá:
______________________________________________________________________
orcl:/home/oracle/7.3.3.0.0:Y
leaveup:/home/oracle/7.3.2.1.0:N
______________________________________________________________________
[1m6.2. init.d & rc.d[0m
Ãéá íá åêêéíÞóåôå êáé óôáìáôÞóåôå ôç âÜóç äåäïìÝíùí üôáí ôï ìç÷Üíçìá
áíåâáßíåé êáé êáôåâáßíåé ìðïñåßôå íá áëëÜîåôå ôéò ñïõôßíåò åêêßíçóçò
ôçò Linux ìç÷áíÞò óáò. Åßíáé áñêåôÜ åýêïëï, áí êáé èá Þèåëá íá
óçìåéþóù åäþ, ðùò ìðïñåß íá äéáöÝñåé áíÜëïãá ìå ôçí Ýêäïóç Linux
(slackware, debian, redhat, etc). Èá äåßîù ðáñáäåßãìáôá ðïõ äïõëåýïõí
ãéá ôï Redhat Linux 5.0. Ãéá íá ôá ôñïðïðïéÞóåôå áíÜëïãá, ãéá ôç
äéêéÜ óáò Ýêäïóç ôïõ Linux, äéáâÜóôå ôçí ôåêìçñßùóç ôïõ Linux óáò.
(Ðáñüëï ðïõ èá ðñÝðåé íá óôÝêåé ãéá êÜèå UNIX ôýðïõ Sys V).
Ðñþôá, ÷ñåéÜæåôáé íá äçìéïõñãÞóïõìå ôï script ðïõ èá ôñÝ÷åé ôéò dbshut
êáé dbstart óôï directory /etc/rc.d/init.d. ÄçìéïõñãÞóôå ôï áêüëïõèï
áñ÷åßï ùò /etc/rc.d/init.d/oracle:
______________________________________________________________________
#!/bin/sh
#
# /etc/rc.d/init.d/oracle
# Description: Starts and stops the Oracle database and listeners
# See how we were called.
case "$1" in
start)
echo -n "Starting Oracle Databases: "
echo "----------------------------------------------------" >> /var/log/oracle
date +"! %T %a %D : Starting Oracle Databases as part of system up." >> /var/log/oracle
echo "----------------------------------------------------" >> /var/log/oracle
su - oracle -c dbstart >> /var/log/oracle
echo "Done."
echo -n "Starting Oracle Listeners: "
su - oracle -c "lsnrctl start" >> /var/log/oracle
echo "Done."
echo ""
echo "----------------------------------------------------" >> /var/log/oracle
date +"! %T %a %D : Finished." >> /var/log/oracle
echo "----------------------------------------------------" >> /var/log/oracle
touch /var/lock/subsys/oracle
;;
stop)
echo -n "Shutting Down Oracle Listeners: "
echo "----------------------------------------------------" >> /var/log/oracle
date +"! %T %a %D : 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
touch /var/lock/subsys/oracle
;;
*)
echo "Usage: oracle {start|stop|restart}"
exit 1
esac
______________________________________________________________________
Áîßæåé íá åëåã÷èåß ðùò ôï áñ÷åßï óôáìáôÜåé êáé áñ÷ßæåé ôç âÜóç
ðñáãìáôéêÜ óùóôÜ, óôï óýóôçìÜ óáò. ÊïéôÜîôå ôï áñ÷åßï ìçíõìÜôùí (log
file), /var/log/oracle ãéá ìçíýìáôá ëÜèïõò.
Áöïý ôï script áõôü äïõëåýåé, ÷ñåéÜæåôáé íá äçìéïõñãÞóïõìå óõìâïëéêÝò
åíþóåéò (symbolic links) start êáé kill óôá áíôßóôïé÷á runlevel
directories /etc/rc.d/rcX.d.
Ïé åðüìåíåò åíôïëÝò èá åîáóöáëßóïõí ðùò ïé âÜóåéò äåäïìÝíùí èá áíÝâïõí
óôá runlevels 2,3 and 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
______________________________________________________________________
Ãéá íá óôáìáôÞóåôå ôéò âÜóåéò äåäïìÝíùí óå åðáíåêêßíçóç èá ÷ñåéáóôïýìå
ôá áêüëïõèá links:
______________________________________________________________________
$ ln -s ../init.d/oracle /etc/rc.d/rc0.d/K01oracle # Halting
$ ln -s ../init.d/oracle /etc/rc.d/rc6.d/K01oracle # Rebooting
______________________________________________________________________
[1m7. ¶ëëá ðñáãìáôÜêéá[0m
[1m7.1. Intelligent Agent[0m
Áí Ý÷åôå áíÜãêç ãéá ôïí Oracle Intelligent Agent, âñÞêá ðùò ìðïñåßôå
íá ôïí ôñÝîåôå ÷ùñßò áëëáãÝò ñõèìßóåùí. Ãéá íá áñ÷ßóåôå ôïí IA
äïêéìÜóôå:
______________________________________________________________________
$ lsnrctl dbsnmp_start
______________________________________________________________________
Ãéá íá óôáìáôÞóåôå ôïí IA äïêéìÜóôå:
______________________________________________________________________
$ lsnrctl dbsnmp_stop
______________________________________________________________________
Äåí öáßíåôáé íá õðÜñ÷ïõí ìçíýìáôá ðïõ íá äåß÷íïõí ôçí åðéôõ÷çìÝíç Þ ìç
áñ÷Þ Þ ôåñìáôéóìü ôïõ intelligent agent. Ðáñüëá áõôÜ, ï IA áðÜíôçóå
óôïí Enterprise manager óôçí ðëåõñÜ ôïõ client êáé Ýôóé ìðïñþ íá
õðïèÝóù ðùò äïõëåýåé
[1m8. Åõ÷áñéóôßåò / Áíáãíùñßóåéò[0m
Ôï êåßìåíï âáóßóôçêå óå Ýíá êåßìåíï ôïõ Bob Withers, bwit@pobox.com.
ÅðéðëÝïí ðëçñïöïñßåò ðÜñèçêáí áðü êåßìåíá ðïõ ãñÜöôçêáí áðü ôïõò
Georg Rehfeld, rehfeld@wmd.de êáé David Mansfield,
david@claremont.com.
ÄéÜâáóìá êáé Ýëåã÷ïò ôïõ êåéìÝíïõ Ýãéíå áðü ôïõò Bob Withers, Mark
Watling, mwatling@mjw-ltd.demon.co.uk, Peter Sodhi,
petersodhi@unn.unisys.com êáé Greg Hankins,
greg.hankins@cc.gatech.edu.
Ïé åõ÷áñéóôßåò ìïõ óôçí ôñïìåñÞ õðïóôÞñéîç áðü ôïõò áíèñþðïõ ðïõ
áíáìß÷èçêáí óå áõôü ôï êåßìåíï êáé óôçí Ýñåõíá ðïõ Ýãéíå óå áõôü
ÅéäéêÝò åõ÷áñéóôßåò óôïí Bob Withers êáé ôïí Mark Watling ãéá ôá
åðéðëÝïí ó÷üëéá êáé âïÞèåéá ðïõ ðñïóÝöåñáí.
[1m9. Ðåñß ôçò ÅëëçíéêÞò ÌåôÜöñáóçò[0m
Ãéá ó÷üëéá, ðáñáôçñÞóåéò, äéïñèþóåéò, åíçìåñþóåéò ðåñß ôçò ÅëëçíéêÞò
ìåôÜöñáóçò áõôïý ôïõ HOWTO, óôåßëôå email óôçí Âïýëá ÓáíéäÜ :
voulariba@hellug.gr Þ óôïí Åõñéðßäç Ðáðáêþóôá : evris@hellug.gr êáé
åíáëëáêôéêÜ : ep@rocketmail.com
distrib
>
Mandriva
>
2010.0
>
i586
>
media
>
contrib-release
>
by-pkgid
>
b64a0ed9abef7306f12de680983610ea
>
files
>
32
