单系统多数据库的Listener和Tnsnames的写法

Listener.ora

LISTENER =

  (DESCRIPTION_LIST =

    (DESCRIPTION =

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

    )

  )

 

ADR_BASE_LISTENER = /u01/app/oracle

 

Tnsnames.ora

ORCL11G =

  (DESCRIPTION =

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

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = orcl11g)

    )

  )

 

 

JLCC =

  (DESCRIPTION =

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

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = jlcc)

    )

  )

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/29029866/viewspace-1457975/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/29029866/viewspace-1457975/