在Oracle
以下將我的Oracle
由於RAC要設置多個地址
#
# Internet host table
#
我的監聽器文件配置如下
bash
# listener
File: /opt/oracle/product/
# Generated by Oracle configuration tools
LISTENER_DB
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = db
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST =
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
)
)
網絡服務名等配置如下
bash
# tnsnames
# Generated by Oracle configuration tools
EYGLE
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = db
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = eygle)
(INSTANCE_NAME = eygle
)
)
EYGLE
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = db
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = eygle)
(INSTANCE_NAME = eygle
)
)
EYGLE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = db
(ADDRESS = (PROTOCOL = TCP)(HOST = db
(LOAD_BALANCE = yes)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = eygle)
(FAILOVER_MODE =
(TYPE = SELECT)
(METHOD = BASIC)
(RETRIES =
(DELAY =
)
)
)
LISTENERS_EYGLE =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = db
(ADDRESS = (PROTOCOL = TCP)(HOST = db
)
這就是主要的一些配置文件
From:http://tw.wingwit.com/Article/program/Oracle/201311/19002.html