Oracle Database HOWTO : ¦b¦øªA¾¹¤W³]©w SQL*Net
Previous: «Ø¥ß¤@­Ó¸ê®Æ®w
Next: ¥Î¤áªº³]©w

4. ¦b¦øªA¾¹¤W³]©w SQL*Net

©Ò¦³³o¨ÇÀɮ׳£·|¥Î©ó³]©w Oracle ªººôµ¸³n¥ó¡]SQL*Net¡A©M Oracle8 ªº Net8 ®t¤£¦h¡^¡C³o¨ÇÀÉ®×À³¸Ó³£«Ø¥ß¦b¦øªA¾¹¤¤ªº $ORACLE_HOME/network/admin ¥Ø¿ý¡C

4.1. tnsnames.ora

TNSNAMES.ORA Àɳ]©w©Ò¦³³o¹q¸£´£¨ÑªºªA°È¡C²{¦b§Ú­Ì´y­z©Ò¦³±¾¤W¤F¦øªA¾¹ªº¸ê®Æ®w¡C¹ï¦øªA¾¹¤W©Ò¦³¸ê®Æ®w§A­n¥[¤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)
    )
  )

4.2. listener.ora

listener.ora ÀÉ´y­z©Ò¦³¨ä¥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

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

4.4. ¶}©l¤Îµ²ÉôºÊÅ¥µ{¦¡

²{¦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¤j­P¦b 2-3 ¤ÀÄÁ¤§¶¡¡^¡C¦pªG¯uªºµo¥Í³o±¡ªp¡A½Ð­@¤ßµ¥«Ý¡A¤£¥²¾á¤ß¡C


Oracle Database HOWTO : ¦b¦øªA¾¹¤W³]©w SQL*Net
Previous: «Ø¥ß¤@­Ó¸ê®Æ®w
Next: ¥Î¤áªº³]©w