Linux AS3.0+Oracle9.2.0.7 RAC Listener.ora, tnsnames.ora,spfileSID.ora檔案設定
RAC 的hosts 設定 :
rac1 , rac2
程式碼:--------------------------------------------------------------------------------
DELL-RAC02$cat hosts
# Do not remove the following line, or various programs
# that require network functionality will fail.
#127.0.0.1 localhost.localdomain localhost DELL-RAC02
10.1.1.101 DELL-PRI01
10.161.8.101 DELL-RAC01
172.17.8.81 DELL-RAC01
10.1.1.102 DELL-PRI02
10.161.8.102 DELL-RAC02
172.17.8.82 DELL-RAC02
---------------------------------------------------------------------------------
------------------------------------------------------------------------------------
spfile 設定 , rac1, rac2
程式碼:--------------------------------------------------------------------------------
.......
orcl1.instance_name='orcl1'
orcl2.instance_name='orcl2'
orcl1.instance_number=1
orcl2.instance_number=2
orcl1.local_listener='listener_orcl1'
orcl2.local_listener='listener_orcl2'
*.remote_listener='listeners_orcl'
.....--------------------------------------------------------------------------------
------------------------------------------------------------------------------------
Listener.ora 設定 , rac1, rac2
程式碼:--------------------------------------------------------------------------------
rac1 :
DELL-RAC01$cat listener.ora
# LISTENER.ORA Network Configuration File: /u01/product/oracle/network/admin/listener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.17.8.81)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.161.8.101)(PORT = 1521))
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /u01/product/oracle)
(PROGRAM = extproc)
)
(SID_DESC =
(ORACLE_HOME = /u01/product/oracle)
(SID_NAME = orcl1)
)
)
rac2 -----
DELL-RAC01$cat listener.ora
# LISTENER.ORA Network Configuration File: /u01/product/oracle/network/admin/listener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.17.8.82)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.161.8.102)(PORT = 1521))
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /u01/product/oracle)
(PROGRAM = extproc)
)
(SID_DESC =
(ORACLE_HOME = /u01/product/oracle)
(SID_NAME = orcl2)
)
)--------------------------------------------------------------------------------
------------------------
tnsnames.ora 設定
程式碼:--------------------------------------------------------------------------------
rac1 :
---------------
DELL-RAC01$cat tnsnames.ora
# TNSNAMES.ORA Network Configuration File: /u01/product/oracle/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
LISTENERS_ORCL =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.161.8.101)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.17.8.81)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.161.8.102)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.17.8.82)(PORT = 1521))
)
LISTENER_ORCL1 =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.161.8.101)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.17.8.81)(PORT = 1521))
)
ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.161.8.101)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.17.8.81)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.161.8.102)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.17.8.82)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
INST1_HTTP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = DELL-RAC01)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = MODOSE)
(PRESENTATION = " target="_blank">)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
ORCL1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.161.8.101)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.17.8.81)(PORT = 1521))
(CONNECT_DATA =
(SERVICE_NAME = orcl)
(INSTANCE_NAME = orcl1)
)
)
ORCL2 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.161.8.102)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.17.8.82)(PORT = 1521))
(CONNECT_DATA =
(SERVICE_NAME = orcl)
(INSTANCE_NAME = orcl2)
)
)
-------------------------------
rac2 :
DELL-RAC02$cat tnsnames.ora
# TNSNAMES.ORA Network Configuration File: /u01/product/oracle/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
LISTENERS_ORCL =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.161.8.101)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.17.8.81)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.161.8.102)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.17.8.82)(PORT = 1521))
)
LISTENER_ORCL2 =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.161.8.102)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.17.8.82)(PORT = 1521))
)
ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.161.8.101)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.17.8.81)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.161.8.102)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.17.8.82)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
INST1_HTTP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = DELL-RAC01)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = MODOSE)
(PRESENTATION = " target="_blank">)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
ORCL1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.161.8.101)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.17.8.81)(PORT = 1521))
(CONNECT_DATA =
(SERVICE_NAME = orcl)
(INSTANCE_NAME = orcl1)
)
)
ORCL2 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.161.8.102)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.17.8.82)(PORT = 1521))
(CONNECT_DATA =
(SERVICE_NAME = orcl)
(INSTANCE_NAME = orcl2)
)
)
--------------------------------------------------------------------------------
客戶端連線:
RAC_NEW_TEST=
(DESCRIPTION=
(LOAD_BALANCE = yes)
(FAILOVER=on)
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=TCP)(HOST=10.161.8.101)(PORT=1521))
(ADDRESS=(PROTOCOL=TCP)(HOST=10.161.8.102)(PORT=1521))
)
(LOAD_BALANCE=yes)
(CONNECT_DATA=
(SERVICE_NAME=orcl)
(FAILOVER_MODE=
(TYPE=select)
(DELAY=5)
(METHOD=basic)
)
)
)
或者
RAC_NEW_TEST=
(DESCRIPTION=
(LOAD_BALANCE = yes)
(FAILOVER=on)
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=TCP)(HOST=172.17.8.81)(PORT=1521))
(ADDRESS=(PROTOCOL=TCP)(HOST=172.17.8.82)(PORT=1521))
)
(LOAD_BALANCE=yes)
(CONNECT_DATA=
(SERVICE_NAME=orcl)
(FAILOVER_MODE=
(TYPE=select)
(DELAY=5)
(METHOD=basic)
)
)
)
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/35489/viewspace-84845/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- [zt] 理解sqlnet.ora , tnsnames.ora , Listener.ora 檔案SQL
- listener.ora檔案與tnsnames.ora之間的關係
- Listener.ora、sqlnet.ora、tnsnames.ora三個配置檔案區別SQL
- Oracle 網路配置用到的sqlnet.ora, tnsnames.ora, listener.ora檔案OracleSQL
- Oracle的網路三大配置檔案(sqlnet.ora、tnsnames.ora、listener.ora)OracleSQL
- oracle listener.ora sqlnet.ora tnsnames.ora 三個檔案的關聯性OracleSQL
- oracle 11g 【listener.ora tnsnames.ora】Oracle
- 10g RAC另外加入一塊網路卡之後,設定listener.ora, tnsnames.ora偶爾發生連線超時。
- 一個節點rac+單節點dg網路配置(listener.ora與tnsnames.ora)
- ORACLE RAC 設定歸檔Oracle
- Oracle網路 - listener.ora , tnsnames.ora 等 [final]Oracle
- oracle實驗記錄 (listener.ora與 tnsnames.ora)Oracle
- 如何看spfilesid.ora檔案裡面內容
- 【監聽】listener.ora檔案理解
- linux下core檔案設定(轉)Linux
- 關於10g RAC監聽設定,tnsnames.ora設定,VIP及客戶端配置問題。客戶端
- Oracle10g RAC - 客戶端,Server端tnsnames.ora及監聽設定Oracle客戶端Server
- 【LINUX 學習】設定檔案系統Linux
- oracle網路配置listener.ora、sqlnet.ora、tnsnames.oraOracleSQL
- oracle網路配置(listener.ora/sqlnet.ora/tnsnames.ora)OracleSQL
- 10G RAC歸檔設定
- 關於listener.ora中的HOST設定
- RAC TAF 連線 (tnsnames.ora)
- linux下自啟動檔案的設定(轉)Linux
- tnsnames.ora監聽配置檔案詳解
- tnsnames.ora檔案的查詢路徑
- RAC 設定NFS作為歸檔目錄NFS
- .Prettierrc檔案的設定
- Linux RAC OCFS檔案系統與INODESLinux
- Oracle 多個例項 沒有listener.ora/sqlnet.ora/tnsnames.oraOracleSQL
- Oracle環境變數、監聽listener.ora、tnsnames.ora、sqlnet.ora配置Oracle變數SQL
- oracle資料庫中listener.ora sqlnet.ora tnsnames.ora的區別Oracle資料庫SQL
- listener.ora、sqlnet.ora、tnsnames.ora的關係以及手工配置舉例SQL
- [20160512]tnsnames.ora配置檔案.txt
- 設定 Windows Media Player 推薦設定的登錄檔檔案Windows
- Lumen 檔案上傳設定
- iOS SVN忽略檔案設定iOS
- MySQL 5.5 配置檔案設定MySql