一個節點rac+單節點dg網路配置(listener.ora與tnsnames.ora)
環境說明: 實驗環境是 一個節點的 rac + 單機dg (主備全部用asm儲存)
tnsnames.ora 檔案 (oracle使用者)
node 1 :
node1-> pwd
/u01/app/oracle/product/11.2.0/db_1/network/adminnode1-> 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)
)
)
)
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/31383567/viewspace-2135081/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 單節點DG的switchover切換介紹
- ElasticSearch(單節點)環境配置Elasticsearch
- RAC 雙節點 轉單節點流程
- rhel6.4-11.2.0.3-RAC搭建單節點DG
- 單節點DG的failover切換介紹AI
- 填充每個節點的下一個右側節點指標指標
- consul 多節點/單節點叢集搭建
- 三個節點,詳解網際網路簡史
- 填充每個節點的下一個右側節點指標 II指標
- MongoDB單節點部署與基本操作MongoDB
- oracle網路配置listener.ora、sqlnet.ora、tnsnames.oraOracleSQL
- oracle網路配置(listener.ora/sqlnet.ora/tnsnames.ora)OracleSQL
- JQuery2:節點選取與節點插入jQuery
- RAC一個節點恢復另一個節點在帶庫上的備份
- 一個4節點Hadoop叢集的配置示例Hadoop
- HAC叢集更改IP(單節點更改、全部節點更改)
- 二叉樹兩個節點的公共節點二叉樹
- ADAMoracle部署全球節點網路率先推出廣域節點報價系統Oracle
- [Kubernetes]node節點pod無法啟動/節點刪除網路重置
- js如何克隆一個節點物件JS物件
- javascript如何建立一個文字節點JavaScript
- 1.19 JQuery2:節點插入與節點選取jQuery
- JavaScript學習之DOM(節點、節點層級、節點操作)JavaScript
- greenplum單節點安裝
- 116. 填充每個節點的下一個右側節點指標指標
- dg搭建 單點-單點
- dom4j 根據xml節點路徑查詢節點,找到對應的目標節點下的子節點,對節點Text值進行修改XML
- ORACLE 11G 建立 DATAGUARD(雙節點RAC-->單例項DG)Oracle單例
- dubbo系列(一):linux安裝dubbo與zookeeper(單節點)Linux
- jquery獲取指定節點的第一級文字節點jQuery
- css 定位如何依次定位多個節點下面的子節點CSS
- mongodb主從仲裁節點配置MongoDB
- 四:OVS+GRE之網路節點
- redis cluster 強制kill某一個節點和shutdown某一個節點後修復過程Redis
- Oracle網路 - listener.ora , tnsnames.ora 等 [final]Oracle
- JavaScript 獲取下一個元素節點JavaScript
- 利用jQuery如何刪除一個節點jQuery
- Ext實現點選節點,父子節點反選