tnsnames1.ora

来自「介绍Oracle PL SQL编程」· ORA 代码 · 共 35 行

#
#  tnsnames1.ora
#  Chapter 12, Oracle10g PL/SQL Programming
#  by Ron Hardman, Michael McLaughlin and Scott Urman
# 
#  Standard single listener shell for tnsnames.ora file.
#

<database_sid> =
  (DESCRIPTION =
    (ADDRESS = 
      (PROTOCOL = TCP)
      (HOST = <machine_name>.<domain_name>)
      (PORT = <port_number>)
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = <database_sid>)
    )
  )

EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = 
        (PROTOCOL = IPC)
        (KEY = extproc))
    )
    (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
    )
  )