关闭

Oracle tnsnames.ora listener.ora 配置

928人阅读 评论(0) 收藏 举报
分类:

环境描述:

Linux + Oracle

问题描述: 

Oracle  tnsnames.ora   listener.ora 配置

解决办法:注意红色的标注

[root@orcl-db-01 ~]# cd $ORACLE_HOME/network/admin 

[root@orcl-db-01 admin]# ls
listener.ora  samples  shrept.lst  sqlnet.ora  tnsnames.ora

 listener.ora 配置:

[oracle@orcl-db-01 admin]$ cat listener.ora 

# listener.ora Network Configuration File: /u01/app/oracle/product/12.1.0.2.0/dbhome_1/network/admin/listener.ora
# Generated by Oracle configuration tools.

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = orcl-db-01)(PORT =1521))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
  )

SID_LIST_LISTENER =  
(SID_LIST =  
  (SID_DESC =  
  (GLOBAL_DBNAME = orcl)
  (SID_NAME = orcl)
  )
)

tnsnames.ora配置:

[oracle@orcl-db-01 admin]$ cat tnsnames.ora 
# tnsnames.ora Network Configuration File: /u01/app/oracle/product/12.1.0.2.0/dbhome_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

ORCL =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 11.11.180.101)(PORT =1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )

0
0

查看评论
* 以上用户言论只代表其个人观点,不代表CSDN网站的观点或立场
    个人资料
    • 访问:536270次
    • 积分:6666
    • 等级:
    • 排名:第3544名
    • 原创:135篇
    • 转载:198篇
    • 译文:0篇
    • 评论:26条
    最新评论