Win Oracle 监听文件配置参考代码实例

# listener.ora Network Configuration File: C:\app\Administrator\product\11.2.0\dbhome_1\NETWORK\ADMIN\listener.ora

# Generated by Oracle configuration tools.

SID_LIST_LISTENER =

  (SID_LIST =

   (SID_DESC =

    (SID_NAME = CLRExtProc)

    (ORACLE_HOME = C:\app\Administrator\product\11.2.0\dbhome_1)

    (PROGRAM = extproc)

    (ENVS = "EXTPROC_DLLS=ONLY:C:\app\Administrator\product\11.2.0\dbhome_1\bin\oraclr11.dll" )

   )

  )

LISTENER =

  (DESCRIPTION_LIST =

   (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.125.134)(PORT = 1521))

   )

   (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))

   )

  )

ADR_BASE_LISTENER = C:\app\Administrator

# tnsnames.ora Network Configuration File: C:\app\Administrator\product\11.2.0\dbhome_1\NETWORK\ADMIN\tnsnames.ora

# Generated by Oracle configuration tools.

LISTENER_ORCL =

  (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))

ORACLR_CONNECTION_DATA =

  (DESCRIPTION =

   (ADDRESS_LIST =

    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))

   )

   (CONNECT_DATA =

    (SID = CLRExtProc)

    (PRESENTATION = RO)

   )

  )

ORCL =

  (DESCRIPTION =

   (ADDRESS_LIST =

    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))

    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.125.134)(PORT = 1521))

    (ADDRESS = (PROTOCOL = TCP)(HOST = WIN-LOPIL4J1KK4)(PORT = 1521))

    (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))

   )

   (CONNECT_DATA =

    (SERVER = DEDICATED)

    (SERVICE_NAME = orcl)

   )

  )