©Ò¦³³o¨ÇÀɮ׳£·|¥Î©ó³]©w Oracle ªººôµ¸³n¥ó¡]SQL*Net¡A©M Oracle8 ªº Net8 ®t¤£¦h¡^¡C³o¨ÇÀÉ®×À³¸Ó³£«Ø¥ß¦b¦øªA¾¹¤¤ªº
$ORACLE_HOME/network/admin
¥Ø¿ý¡C
tnsnames.ora
TNSNAMES.ORA
Àɳ]©w©Ò¦³³o¹q¸£´£¨ÑªºªA°È¡C²{¦b§ÚÌ´yz©Ò¦³±¾¤W¤F¦øªA¾¹ªº¸ê®Æ®w¡C¹ï¦øªA¾¹¤W©Ò¦³¸ê®Æ®w§An¥[¤WÃþ¦ü¥H¤Uªº¤@¬q¡G
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)
)
)
listener.ora
listener.ora
ÀÉ´yz©Ò¦³¨ä¥L¹q¸£¥i±o¨ìªºªA°È¤Î¦øªA¾¹ªººÊÅ¥µ{¦¡
(listener) ©Ò»Ýªº©Ò¦³³]©w¡C
¥¦¦³¤@¬q¥]¬AºÊÅ¥µ{¦¡¦WºÙ¡BºÊÅ¥µ{¦¡¦a§}¡BºÊÅ¥µ{¦¡´£¨ÑªA°Èªº¸ê®Æ®w¤Î°Ñ¼Æ³]©w (listener name, listener address, databases served by the listener and configuration parameters)¡C
³o¸Ì¦³¤@Ó¨Ò¤l¡G
# ºÊÅ¥µ{¦¡¦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)
)
)
# ¦C¥XºÊÅ¥µ{¦¡´£¨Ñªºª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
sqlnet.ora
sqlnet.ora
ÀÉ¥]¬A¹ïºôµ¸¤W¤@Ó¯S©w¸`ÂI (node) ªº³]©w¡C³o¨Ç¸ê®Æ©M¸ê®Æ®wªº¼Æ¥Ø¤ÎºÊÅ¥µ{¦¡ªº¼Æ¥ØµLÃö¡C³oÓÀɮפ¤³Ì«nªºªF¦è¬O Dead Connection Timeout
Åܼƪº³]©w¡C
Dead connection timeout Àˬd¨C¤@Ó±µ¨ì¸Ó¸ê®Æ®wªº¦æµ{¤Î½T«O¥Î¤áºÝ¤´¦³¤ÏÀ³¡C¦pªG¨º¥Î¤á¡]Ãþ«¬¤£©ë¡^¨ÃµL¤ÏÀ³¡A¹ïÀ³ªº Oracle ¦øªA¾¹¼v¤l¦æµ{ (shadow process) «K·|³Q±þ¡C
¦pªG§A¦³«Ü¦h¥Î¤á¦s¨ú¨º¸ê®Æ®w¡A³oÂI«D±`¦³¥Î¡C¤×¨ä¬O·í§A¤´¦bµ{¦¡¶}µo¶¥¬q¡A¥Î¤á¦h¼Æ¤£¯à¥¿½T¦aµ²Éôªº®ÉÔ¡C
¥H¤U¬O§Úªº sqlnet.ora
ÀÉ¡A¨Ñ¦UŪªÌ°Ñ¦Ò¡G
TRACE_LEVEL_CLIENT = OFF
sqlnet.expire_time = 30 # ¨â¦¸Àˬd«È¤á¬Û®tªº¬í¼Æ
names.default_domain = world
name.default_zone = world
²{¦b¦³ÃöºÊÅ¥µ{¦¡¤Î SQL*Net ªº³]©w¤w¸g§¹¦¨¡A§ÚÌ¥i¥H¸Õ¥Îºôµ¸³n¥ó¨Ó»é¨ì¸ê®Æ®w¡C¡]¤§«e§ÚÌ¥u¬Oª½±µ³s±µ¨ì¸ê®Æ®w¡A²{¦b«h¬O¦b¼ÒÀÀ¨Ï¥Î»·µ{ (remote) ¥Î¤á¡C¡
¨Ï¥Î¥H¤Wªº³]©w¨Ó±Ò°ÊºÊÅ¥µ{¦¡¡G
$ lsnrctl
LSNRCTL for SCO System V/386: Version 2.3.3.0.0 - Production on 23-FEB-98 20:38:25
Copyright (c) Oracle Corporation 1994. All rights reserved.
Welcome to LSNRCTL, type "help" for information.
LSNRCTL> start
Starting /home/oracle/7.3.3.0.0/bin/tnslsnr: please wait...
TNSLSNR for SCO System V/386: Version 2.3.3.0.0 - Production
System parameter file is /home/oracle/7.3.3.0.0/network/admin/listener.ora
Log messages written to /home/oracle/7.3.3.0.0/network/log/listener.log
Listening on: (ADDRESS=(PROTOCOL=tcp)(DEV=6)(HOST=192.168.1.1)(PORT=1521))
Listening on: (ADDRESS=(PROTOCOL=ipc)(DEV=10)(KEY=700))
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=magic.com)(PORT=1521)(COMMUNITY=UK_SUP_TCPIP))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for SCO System V/386: Version 2.3.3.0.0 - Production
Start Date 23-FEB-98 20:38:50
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security OFF
SNMP ON
Listener Parameter File /home/oracle/7.3.3.0.0/network/admin/listener.ora
Listener Log File /home/oracle/7.3.3.0.0/network/log/listener.log
Services Summary...
orcl has 1 service handler(s)
The command completed successfully
LSNRCTL> exit
n°±¤îºÊÅ¥µ{¦¡¡G
$ 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
¦pªG§Aªº DNS ¨Ã¤£¶Ç¦^«ü©wªº¥D¾÷ªº IP ¦a§}¡A±Ò°Ê¤Îµ²ÉôºÊÅ¥µ{¦¡·|ªá¤@ÂI®É¶¡¡]¨Ì¾Ú DNS 2-3 ªº¹O®ÉÅÜ¼Æ (timeout variable)¡A¤jP¦b 2-3 ¤ÀÄÁ¤§¶¡¡^¡C¦pªG¯uªºµo¥Í³o±¡ªp¡A½Ð@¤ßµ¥«Ý¡A¤£¥²¾á¤ß¡C