一個節點rac+單節點dg網路配置(listener.ora與tnsnames.ora)

張衝andy發表於2017-03-10

環境說明:  實驗環境是 一個節點的 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)
         )
        )
       )

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/31383567/viewspace-2135081/,如需轉載,請註明出處,否則將追究法律責任。

相關文章