oracle监听配置

最新推荐文章于 2020-12-22 17:54:20 发布

diereng5160

最新推荐文章于 2020-12-22 17:54:20 发布

阅读量157

点赞数

文章标签：数据库网络

原文链接：http://www.cnblogs.com/ThatsMyTiger/p/7614714.html

版权

在listener.ora文件中指定监听的实例名和修改ip地址：

查看实例名：[localhost$] echo $ORACLE_SID

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.193.130)(PORT = 1521))
    )
  )

ADR_BASE_LISTENER = /home/oracle/app

SID_LIST_LISTENER =
(SID_LIST =
 (SID_DESC =
  (GLOBAL_DBNAME = orcl)
  (ORACLE_HOME = /home/oracle/app/oracle/product/11.2.0/dbhome_1)
  (SID_NAME = orcl)
 )
)

将服务器的tnsnames.ora的内容拷贝到客户端的tnsnames.ora记得修改ip

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

转载于:https://www.cnblogs.com/ThatsMyTiger/p/7614714.html