ITPub博客

首页 > Linux操作系统 > Linux操作系统 > oracle 11g tns和监听配置

oracle 11g tns和监听配置

原创 Linux操作系统 作者:fei890910 时间:2013-11-22 19:12:48 0 删除 编辑
11g的监听配置
[oracle@node3 admin]$ more listener.ora 


LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.10.11)(PORT = 1521))
    )
  )


ADR_BASE_LISTENER = /u01/app/oracle


11g的tns配置


[oracle@node3 admin]$ more tnsnames.ora 
# tnsnames.ora Network Configuration File: /u01/app/oracle/product/11.2.0/dbhome_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.


PROD =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.10.11)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = prod)
    )
  )


test=
 (DESCRIPTION= 
  (ADDRESS= (PROTOCOL=tcp)(HOST=192.168.10.101)(PORT=1521))
  (CONNECT_DATA= 
     (SERVICE_NAME=test)
     (SERVER=dedicated)
   )
 )

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

上一篇: ORA-01919
下一篇: ORA-00119
请登录后发表评论 登录
全部评论

注册时间:2013-08-15

  • 博文量
    120
  • 访问量
    746459