环境说明：  实验环境是 一个节点的 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)
         )
        )
       )

最新文章

  1. Python 第三方模块安装出现的问题和解决方案.
  2. PHPStorm/webstorm tips
  3. C++ Code_ScrollBar
  4. esxi 5.1 由于断电错误无法启动 报错 bank5 invalid configuration
  5. 【转】Android NDK开发入门实例
  6. Python进阶之decorator装饰器
  7. .Net 内存对象分析
  8. 前端基础之初识 HTML
  9. Do-Now—团队 冲刺博客六
  10. [20180814]慎用查看表压缩率脚本.txt
  11. django中怎么使用自定义管理后台xadmin
  12. SNMP MIBs and IPv6
  13. itchat
  14. [UE4]Background Blur，背景模糊
  15. linux学习第八天 (Linux就该这么学)
  16. CS229 6.10 Neurons Networks implements of softmax regression
  17. 【洛谷】2473：[SCOI2008]奖励关【期望DP（倒推）】
  18. 时间控件 BeatPicker
  19. C++（三十二） — 常对象、常成员变量、常成员函数
  20. 廖雪峰JavaScript练习题2

热门文章

  1. CSS3 实现背景透明，文字不透明，兼容所有浏览器
  2. eclipse-jee版配置tomcat
  3. 对Oracle的rownum生成时机的理解
  4. Android防止过快点击造成多次事件
  5. ubuntu系统安装好后一些基本软件的安装
  6. 移除WordPress文章图片的宽度和高度属性
  7. 【Java并发编程实战】—–“J.U.C”：ReentrantLock之二lock方法分析
  8. yum 安装 mysql5.5 mysql 5.6 mysql5.7
  9. python 基础 7.8 json--下
  10. Python 深入剖析SocketServer模块（二）（V2.7.11）