博客
关于我
强烈建议你试试无所不能的chatGPT,快点击我
一个节点rac+单节点dg网络配置(listener.ora与tnsnames.ora)
阅读量:5820 次
发布时间:2019-06-18

本文共 1944 字,大约阅读时间需要 6 分钟。

环境说明:  实验环境是 一个节点的 rac + 单机dg    (主备全部用asm存储)

 

tnsnames.ora  文件  (oracle用户)

node 1 :

node1-> pwd

/u01/app/oracle/product/11.2.0/db_1/network/admin

node1-> cat tnsnames.ora 

 

DEVDB =

 (DESCRIPTION =

  (ADDRESS = (PROTOCOL = TCP)(HOST = 10.100.25.100)(PORT =1521))
  (CONNECT_DATA =
   (SERVER = DEDICATED)
   (SERVICE_NAME = devdb)
  )
 )
devdb1 =
 (DESCRIPTION =
  (ADDRESS = (PROTOCOL = TCP)(HOST = 10.100.25.10)(PORT = 1521))
  (CONNECT_DATA =
   (SERVER = DEDICATED)
   (SERVICE_NAME = devdb)
   (INSTANCE_NAME = devdb1)
  )
 )
phydb =
 (DESCRIPTION =
  (ADDRESS = (PROTOCOL = TCP)(HOST = 10.100.25.15)(PORT = 1521))
  (CONNECT_DATA =
   (SERVER = DEDICATED)
   (SERVICE_NAME = phydb)
  )

 )  

 

 

dg :

phydb-> pwd

/u01/app/oracle/product/11.2.0/db_1/network/admin
phydb-> cat tnsnames.ora 

DEVDB =

 (DESCRIPTION =
  (ADDRESS = (PROTOCOL = TCP)(HOST = 10.100.25.100)(PORT =1521))
  (CONNECT_DATA =
   (SERVER = DEDICATED)
   (SERVICE_NAME = devdb)
  )
 )
devdb1 =
 (DESCRIPTION =
  (ADDRESS = (PROTOCOL = TCP)(HOST = 10.100.25.10)(PORT = 1521))
  (CONNECT_DATA =
   (SERVER = DEDICATED)
   (SERVICE_NAME = devdb)
   (INSTANCE_NAME = devdb1)
  )
 )
phydb =
 (DESCRIPTION =
  (ADDRESS = (PROTOCOL = TCP)(HOST = 10.100.25.15)(PORT = 1521))
  (CONNECT_DATA =
   (SERVER = DEDICATED)
   (SERVICE_NAME = phydb)
  )
 )  

 

listener.ora  文件 (grid用户)

 

node 1 :

node1-> pwd

/u01/app/11.2.0/grid/network/admin
node1-> cat listener.ora

LSN2 =

  (ADDRESS_LIST=
        (ADDRESS=(PROTOCOL=tcp)(HOST=10.100.25.10)(PORT=1521))
        (ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
SID_LIST_LSN2=
   (SID_LIST=
        (SID_DESC=
          (GLOBAL_DBNAME=devdb)
          (SID_NAME=devdb1)
          (ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1)
         )
        )
       )

 

dg:

phydb-> pwd

/u01/app/11.2.0/grid/network/admin
phydb-> cat listener.ora

 

LSN2 =

  (ADDRESS_LIST=
        (ADDRESS=(PROTOCOL=tcp)(HOST=10.100.25.15)(PORT=1521))
        (ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
SID_LIST_LSN2=
   (SID_LIST=
        (SID_DESC=
          (GLOBAL_DBNAME=phydb)
          (SID_NAME=phydb)
          (ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1)
         )
        )
       )

转载于:https://www.cnblogs.com/andy6/p/6530048.html

你可能感兴趣的文章
网络抓包的部署和工具Wireshark【图书节选】
查看>>
Redis在Windows+linux平台下的安装配置
查看>>
Maven入门实战笔记-11节[6]
查看>>
Local declaration of 'content' hides instance variable
查看>>
ASP.NET中 HTML标签总结及使用
查看>>
Linux下日志系统的设计
查看>>
爬虫IP被禁的简单解决方法——切换UserAgent
查看>>
selenium + python 添加等待时间
查看>>
php生成word,并下载
查看>>
python 函数参数
查看>>
紫书 习题8-11 UVa 1615 (区间选点问题)
查看>>
asp.net mvc学习(Vs技巧与Httpcontext)
查看>>
float数据在内存中是怎么存储的
查看>>
开发经验和习惯
查看>>
dedecms 修改标题长度可以修改数据库
查看>>
Matplotlib学习---用matplotlib画直方图/密度图(histogram, density plot)
查看>>
云时代架构读后感(一)
查看>>
MySQL案列之主从复制出错问题以及pt-slave-restart工具的使用
查看>>
在JS中调用JAVA变量
查看>>
linux 查看剩余内存数
查看>>