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,  參數(shù)：
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，參數(shù)文件：
pfile:
[oratest@rac1 dbs]$ cat initRACTEST1.ora
spfile='+DATA/RACTEST/spfileractest.ora'


[oratest@rac2 dbs]$ cat initRACTEST2.ora
spfile='+DATA/RACTEST/spfileractest.ora'
根據(jù)pfile創(chuàng)建spfile:
create spfile='+DATA/RACTEST/spfileractest.ora' from pfile;


5, 參數(shù)修改命令:
alter system set local_listener='RAC1_LOCAL' sid='RACTEST1' scope=both;
alter system set local_listener='RAC2_LOCAL' sid='RACTEST2' scope=both;

分享文章：OracleRAC和SCAN同時(shí)對(duì)外提供服務(wù)的配制方法
文章轉(zhuǎn)載：http://aaarwkj.com/article28/gpehcp.html

成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián)，為您提供網(wǎng)站維護(hù)、定制開(kāi)發(fā)、網(wǎng)站設(shè)計(jì)公司、外貿(mào)建站、全網(wǎng)營(yíng)銷(xiāo)推廣、建站公司

廣告

聲明：本網(wǎng)站發(fā)布的內(nèi)容（圖片、視頻和文字）以用戶(hù)投稿、用戶(hù)轉(zhuǎn)載內(nèi)容為主，如果涉及侵權(quán)請(qǐng)盡快告知，我們將會(huì)在第一時(shí)間刪除。文章觀(guān)點(diǎn)不代表本網(wǎng)站立場(chǎng)，如需處理請(qǐng)聯(lián)系客服。電話(huà)：028-86922220；郵箱：631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載，或轉(zhuǎn)載時(shí)需注明來(lái)源： 創(chuàng)新互聯(lián)