Linux AS4.0 64bit
Oracle10g 10.2.0.1 RAC OCFS2
数据库名称tpc
每个节点有两个public nic , 一个private nic .
------------------------------------------------
1. 参数文件中Listener相关的参数 (两个节点)
SQL> show parameter listener
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
local_listener string LOCAL_TPC
remote_listener string LISTENERS_TPC
其中 LOCAL_TPC 会在后面的每个节点 tnsnames.ora 中设置。
---------------------------------------------------
2. hosts :
gnd-rac01$cat hosts
# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1 localhost.localdomain localhost
10.155.4.95 gnd-rac01 # public nic1
172.20.1.19 gnd-rac01 # public nic2 --- VIP统一网段
10.1.0.1 gnd-pri01 # private nic
172.20.1.29 gnd-vip01 # VIP
10.155.4.96 gnd-rac02
172.20.1.18 gnd-rac02
10.1.0.2 gnd-pri02
172.20.1.28 gnd-vip02
不过在安装CRS的时候 public nic 10.155.4.95 (96) 被设置为Do Not Use . VIP使用的是 172.20 段的.
而且vipca的时候选择的也是 172.20 的这块public nic .
---------------------------------------------------
3. 节点1的tnsnames.ora 及listener.ora 设置 。
TPC2 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.20.1.28)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.155.4.96)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = tpc)
(INSTANCE_NAME = tpc2)
)
)
TPC1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.20.1.29)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.155.4.95)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = tpc)
(INSTANCE_NAME = tpc1)
)
)
TPC =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.20.1.29)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.20.1.28)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.155.4.95)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.155.4.96)(PORT = 1521))
(LOAD_BALANCE = yes)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = tpc)
)
)
LISTENERS_TPC =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.20.1.29)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.20.1.28)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.155.4.95)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.155.4.96)(PORT = 1521))
)
# LOCAL_TPC 对应spfile中的local_listener . 自己加入的。 [节点1]
LOCAL_TPC =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.20.1.19)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.155.4.95)(PORT = 1521))
)
节点1 监听:
LISTENER_GND-RAC01 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.20.1.29)(PORT = 1521)(IP = FIRST))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.155.4.95)(PORT = 1521)(IP = FIRST))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
)
)
---------------------------------------------------
4. 节点 2 的tnsnames.ora 及listener.ora 设置 。
TPC2 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.20.1.28)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.155.4.96)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = tpc)
(INSTANCE_NAME = tpc2)
)
)
TPC1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.20.1.29)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.155.4.95)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = tpc)
(INSTANCE_NAME = tpc1)
)
)
TPC =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.20.1.29)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.20.1.28)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.155.4.95)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.155.4.96)(PORT = 1521))
(LOAD_BALANCE = yes)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = tpc)
)
)
LISTENERS_TPC =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.20.1.29)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.20.1.28)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.155.4.95)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.155.4.96)(PORT = 1521))
)
# LOCAL_TPC 对应spfile中的local_listener . 自己加入的。 [节点2]
LOCAL_TPC =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.20.1.18)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.155.4.96)(PORT = 1521))
)
节点2 监听:
LISTENER_GND-RAC02 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.20.1.28)(PORT = 1521)(IP = FIRST))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.155.4.96)(PORT = 1521)(IP = FIRST))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
)
)
[ 本帖最后由 tolywang 于 2007-12-14 18:31 编辑 ]
Oracle10g 10.2.0.1 RAC OCFS2
数据库名称tpc
每个节点有两个public nic , 一个private nic .
------------------------------------------------
1. 参数文件中Listener相关的参数 (两个节点)
SQL> show parameter listener
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
local_listener string LOCAL_TPC
remote_listener string LISTENERS_TPC
其中 LOCAL_TPC 会在后面的每个节点 tnsnames.ora 中设置。
---------------------------------------------------
2. hosts :
gnd-rac01$cat hosts
# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1 localhost.localdomain localhost
10.155.4.95 gnd-rac01 # public nic1
172.20.1.19 gnd-rac01 # public nic2 --- VIP统一网段
10.1.0.1 gnd-pri01 # private nic
172.20.1.29 gnd-vip01 # VIP
10.155.4.96 gnd-rac02
172.20.1.18 gnd-rac02
10.1.0.2 gnd-pri02
172.20.1.28 gnd-vip02
不过在安装CRS的时候 public nic 10.155.4.95 (96) 被设置为Do Not Use . VIP使用的是 172.20 段的.
而且vipca的时候选择的也是 172.20 的这块public nic .
---------------------------------------------------
3. 节点1的tnsnames.ora 及listener.ora 设置 。
TPC2 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.20.1.28)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.155.4.96)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = tpc)
(INSTANCE_NAME = tpc2)
)
)
TPC1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.20.1.29)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.155.4.95)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = tpc)
(INSTANCE_NAME = tpc1)
)
)
TPC =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.20.1.29)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.20.1.28)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.155.4.95)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.155.4.96)(PORT = 1521))
(LOAD_BALANCE = yes)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = tpc)
)
)
LISTENERS_TPC =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.20.1.29)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.20.1.28)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.155.4.95)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.155.4.96)(PORT = 1521))
)
# LOCAL_TPC 对应spfile中的local_listener . 自己加入的。 [节点1]
LOCAL_TPC =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.20.1.19)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.155.4.95)(PORT = 1521))
)
节点1 监听:
LISTENER_GND-RAC01 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.20.1.29)(PORT = 1521)(IP = FIRST))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.155.4.95)(PORT = 1521)(IP = FIRST))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
)
)
---------------------------------------------------
4. 节点 2 的tnsnames.ora 及listener.ora 设置 。
TPC2 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.20.1.28)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.155.4.96)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = tpc)
(INSTANCE_NAME = tpc2)
)
)
TPC1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.20.1.29)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.155.4.95)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = tpc)
(INSTANCE_NAME = tpc1)
)
)
TPC =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.20.1.29)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.20.1.28)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.155.4.95)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.155.4.96)(PORT = 1521))
(LOAD_BALANCE = yes)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = tpc)
)
)
LISTENERS_TPC =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.20.1.29)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.20.1.28)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.155.4.95)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.155.4.96)(PORT = 1521))
)
# LOCAL_TPC 对应spfile中的local_listener . 自己加入的。 [节点2]
LOCAL_TPC =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.20.1.18)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.155.4.96)(PORT = 1521))
)
节点2 监听:
LISTENER_GND-RAC02 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.20.1.28)(PORT = 1521)(IP = FIRST))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.155.4.96)(PORT = 1521)(IP = FIRST))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
)
)
[ 本帖最后由 tolywang 于 2007-12-14 18:31 编辑 ]
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/35489/viewspace-127532/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/35489/viewspace-127532/