Oracle RAC和SCAN同時對外提供服務的配製方法
1, tnsnames.ora on two nodes:
RACTEST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = racscan.test.com)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = RACTEST.test.com)
)
)
RAC1_LOCAL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = rac1vip.test.com)(PORT = 1529))
)
RAC2_LOCAL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = rac2vip.test.com)(PORT = 1529))
)
RAC_REMOTE =
(DESCRIPTION=
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=tcp)(HOST=rac1vip.test.com)(PORT=1529))
(ADDRESS=(PROTOCOL=tcp)(HOST=rac2vip.test.com)(PORT=1529))
)
)
RAC_BALANCE=
(DESCRIPTION=
(ADDRESS_LIST=
(LOAD_BALANCE=YES)
(FAILOVER=YES)
(ADDRESS=(PROTOCOL=tcp)(HOST=rac1vip.test.com)(PORT=1529))
(ADDRESS=(PROTOCOL=tcp)(HOST=rac2vip.test.com)(PORT=1529))
)
(CONNECT_DATA=
(SERVICE_NAME=RACTEST.test.com)
)
)
2,listener.ora on two nodes:
node1:RAC=
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = rac1vip.test.com)(PORT = 1529))
)
SID_LIST_RAC=
(SID_LIST=
(SID_DESC = (ORACLE_HOME =/dbfs/app/oracle/product/11.2.0/dbhome_1)(SID_NAME=RACTEST1))
)
node2:RAC=
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = rac2vip.test.com)(PORT = 1529))
)
SID_LIST_RAC=
(SID_LIST=
(SID_DESC = (ORACLE_HOME =/dbfs/app/oracle/product/11.2.0/dbhome_1)(SID_NAME=RACTEST2))
)
3, 引數:
node1:
SQL> show parameter local_listener
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
local_listener string RAC1_LOCAL
SQL> show parameter remote_listener
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
remote_listener string racscan.test.com:1521
------------------------------------ ----------- --------------------------------------------------------------------------------------------------------------------------------------------------------------
node2:
SQL> show parameter local_listener
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
local_listener string RAC2_LOCAL
SQL> show parameter remote_listener
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
remote_listener string racscan.test.com:1521
4,引數檔案:
pfile:
[oratest@rac1 dbs]$ cat initRACTEST1.ora
spfile='+DATA/RACTEST/spfileractest.ora'
[oratest@rac2 dbs]$ cat initRACTEST2.ora
spfile='+DATA/RACTEST/spfileractest.ora'
根據pfile建立spfile:
create spfile='+DATA/RACTEST/spfileractest.ora' from pfile;
5, 引數修改命令:
alter system set local_listener='RAC1_LOCAL' sid='RACTEST1' scope=both;
alter system set local_listener='RAC2_LOCAL' sid='RACTEST2' scope=both;
RACTEST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = racscan.test.com)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = RACTEST.test.com)
)
)
RAC1_LOCAL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = rac1vip.test.com)(PORT = 1529))
)
RAC2_LOCAL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = rac2vip.test.com)(PORT = 1529))
)
RAC_REMOTE =
(DESCRIPTION=
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=tcp)(HOST=rac1vip.test.com)(PORT=1529))
(ADDRESS=(PROTOCOL=tcp)(HOST=rac2vip.test.com)(PORT=1529))
)
)
RAC_BALANCE=
(DESCRIPTION=
(ADDRESS_LIST=
(LOAD_BALANCE=YES)
(FAILOVER=YES)
(ADDRESS=(PROTOCOL=tcp)(HOST=rac1vip.test.com)(PORT=1529))
(ADDRESS=(PROTOCOL=tcp)(HOST=rac2vip.test.com)(PORT=1529))
)
(CONNECT_DATA=
(SERVICE_NAME=RACTEST.test.com)
)
)
2,listener.ora on two nodes:
node1:RAC=
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = rac1vip.test.com)(PORT = 1529))
)
SID_LIST_RAC=
(SID_LIST=
(SID_DESC = (ORACLE_HOME =/dbfs/app/oracle/product/11.2.0/dbhome_1)(SID_NAME=RACTEST1))
)
node2:RAC=
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = rac2vip.test.com)(PORT = 1529))
)
SID_LIST_RAC=
(SID_LIST=
(SID_DESC = (ORACLE_HOME =/dbfs/app/oracle/product/11.2.0/dbhome_1)(SID_NAME=RACTEST2))
)
3, 引數:
node1:
SQL> show parameter local_listener
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
local_listener string RAC1_LOCAL
SQL> show parameter remote_listener
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
remote_listener string racscan.test.com:1521
------------------------------------ ----------- --------------------------------------------------------------------------------------------------------------------------------------------------------------
node2:
SQL> show parameter local_listener
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
local_listener string RAC2_LOCAL
SQL> show parameter remote_listener
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
remote_listener string racscan.test.com:1521
4,引數檔案:
pfile:
[oratest@rac1 dbs]$ cat initRACTEST1.ora
spfile='+DATA/RACTEST/spfileractest.ora'
[oratest@rac2 dbs]$ cat initRACTEST2.ora
spfile='+DATA/RACTEST/spfileractest.ora'
根據pfile建立spfile:
create spfile='+DATA/RACTEST/spfileractest.ora' from pfile;
5, 引數修改命令:
alter system set local_listener='RAC1_LOCAL' sid='RACTEST1' scope=both;
alter system set local_listener='RAC2_LOCAL' sid='RACTEST2' scope=both;
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/29135257/viewspace-2144457/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Oracle RAC修改Scan IP,Public IP的方法Oracle
- Oracle對RAC gsd服務作用的解釋Oracle
- Oracle RAC中的Public IP, VIP和Internal IP,SCANOracle
- 如何讓服務端同時支援WebSocket和SSL加密的WebSocket(即同時支援ws和wss)?服務端Web加密
- go語言gRPC系列(三) - 使用grpc-gateway同時提供HTTP和gRPC服務GoRPCGatewayHTTP
- Laravel 服務容器和提供器Laravel
- 致同:為客戶提供全方位專業服務
- RAC改VIP和SCAN IP
- Oracle RAC修改public, VIP, SCAN IPOracle
- Linux NTP服務配置 for Oracle RACLinuxOracle
- Oracle 11G RAC CTSS服務Oracle
- Oracle11gR2——RAC中的服務Oracle
- oracle rac scan監聽更改埠號Oracle
- Oracle 11g修改RAC SCAN IPOracle
- Oracle RAC修改public,private,vip scan IPOracle
- Oracle10g RAC 服務的狀態是UNKNOWN解決方法Oracle
- 定製ORACLE RAC GUARD——RAC GUARD概念和管理Oracle
- oracle rac的scan監聽狀態Not All Endpoints RegisteredOracle
- Oracle 11g RAC SCAN ip的原理及配置Oracle
- golang 同時(一個專案)註冊http和GRPC服務GolangHTTPRPC
- Oracle 11gR2 RAC修改SCAN IPOracle
- oracle-rac--srvctl add scan_listenerOracle
- Ceph提供nfs服務NFS
- Maven工程 服務提供方啟動時沒有Starting ProtocolHandler的 解決方法MavenProtocol
- Laravel 服務提供者和門面模式Laravel模式
- Oracle 10gR2 RAC Clusterware ONS服務的管理Oracle 10g
- RAC重建SCAN IP
- RAC 增加SCAN IP
- Winodws同時連線內網和外網內網
- rac scan listener log 清理監聽日誌 oracleOracle
- Oracle 11gR2 RAC修改SCAN IP地址Oracle
- VPN服務嗅探工具ike-scan
- 將程式製作為服務執行的方法
- 如何使用ssh_scan遠端驗證SSH服務的配置和策略
- 使用swoole提供http服務HTTP
- 提供和中介軟體相關的一切服務
- 福特AI和機器學習之旅:從汽車製造商到移動服務提供商的轉身AI機器學習
- 【Oracle】RAC 11.2.0.4.0 OHASD服務無法啟動Oracle