oracle 11g rac 客户端如何配置
请教如何配置rac客户端如何配置,我的客户端连接单库是没问题的;第一次安装rac,不知道客户端改如何配置。
客户端配置:hosts文件
# localhost name resolution is handled within DNS itself.
# 127.0.0.1 localhost
# ::1 localhost
#eth0 Public
10.9.10.231racnode1.ctz.comracnode1
10.9.10.232racnode2.ctz.comracnode2
#eth1 Private
192.168.10.231racnode1-priv.ctz.comracnode1-priv
192.168.10.232racnode2-priv.ctz.comracnode2-priv
#Virtual
10.9.10.233racnode1-vip.ctz.comracnode1-vip
10.9.10.234racnode2-vip.ctz.comracnode2-vip
#SCAN
10.9.10.235 scan-yu.com
10.9.10.236 scan-yu.com
tnsnames.ora文件
不知道怎么配置
节点racnode1
-bash-3.2$ cat /etc/hosts
# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1 racnode1.ctz.com racnode1 localhost.localdomain localhost
::1 localhost6.localdomain6 localhost6
#eth0 Public
10.9.10.231racnode1.ctz.comracnode1
10.9.10.232racnode2.ctz.comracnode2
#eth1 Private
192.168.10.231racnode1-priv.ctz.comracnode1-priv
192.168.10.232racnode2-priv.ctz.comracnode2-priv
#Virtual
10.9.10.233racnode1-vip.ctz.comracnode1-vip
10.9.10.234racnode2-vip.ctz.comracnode2-vip
#SCAN
10.9.10.235 scan-yu.com
-bash-3.2$ lsnrctl status
LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 27-APR-2012 14:17:50
Copyright (c) 1991, 2009, Oracle.All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=racnode1.ctz.com)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date 27-APR-2012 13:12:35
Uptime 0 days 1 hr. 5 min. 15 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/11.2.0/grid/network/admin/listener.ora
Listener Log File /u01/app/11.2.0/grid/log/diag/tnslsnr/racnode1/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.9.10.233)(PORT=1521)))
Services Summary...
Service "+ASM" has 1 instance(s).
Instance "+ASM1", status READY, has 1 handler(s) for this service...
Service "ora11g" has 1 instance(s).
Instance "ora11g1", status READY, has 1 handler(s) for this service...
Service "ora11gXDB" has 1 instance(s).
Instance "ora11g1", status READY, has 1 handler(s) for this service...
The command completed successfully
-bash-3.2$ cat listener.ora
# listener.ora.racnode1 Network Configuration File: /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora.racnode1
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /u01/app/oracle/product/11.2.0/db_1)
(PROGRAM = extproc)
)
)
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_RAC = ON
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = racnode1.ctz.com)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)
-bash-3.2$ cat tnsnames.ora
# tnsnames.ora Network Configuration File: /u01/app/oracle/product/11.2.0/db_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
ORA11G =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = scan-yu.com)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ora11g)
)
)
节点racnode2
-bash-3.2$ cat /etc/hosts
# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1 racnode1.ctz.com racnode1 localhost.localdomain localhost
::1 localhost6.localdomain6 localhost6
#eth0 Public
10.9.10.231racnode1.ctz.comracnode1
10.9.10.232racnode2.ctz.comracnode2
#eth1 Private
192.168.10.231racnode1-priv.ctz.comracnode1-priv
192.168.10.232racnode2-priv.ctz.comracnode2-priv
#Virtual
10.9.10.233racnode1-vip.ctz.comracnode1-vip
10.9.10.234racnode2-vip.ctz.comracnode2-vip
#SCAN
10.9.10.235 scan-yu.com
-bash-3.2$ lsnrctl status
LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 27-APR-2012 14:24:49
Copyright (c) 1991, 2009, Oracle.All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date 27-APR-2012 13:12:35
Uptime 0 days 1 hr. 12 min. 14 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/11.2.0/grid/network/admin/listener.ora
Listener Log File /u01/app/11.2.0/grid/log/diag/tnslsnr/racnode1/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.9.10.233)(PORT=1521)))
Services Summary...
Service "+ASM" has 1 instance(s).
Instance "+ASM1", status READY, has 1 handler(s) for this service...
Service "ora11g" has 1 instance(s).
Instance "ora11g1", status READY, has 1 handler(s) for this service...
Service "ora11gXDB" has 1 instance(s).
Instance "ora11g1", status READY, has 1 handler(s) for this service...
The command completed successfully
-bash-3.2$ cat listener.ora
# listener.ora.racnode1 Network Configuration File: /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora.racnode1
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /u01/app/oracle/product/11.2.0/db_1)
(PROGRAM = extproc)
)
)
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_RAC = ON
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = racnode1.ctz.com)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)
-bash-3.2$ cat tnsnames.ora
# tnsnames.ora Network Configuration File: /u01/app/oracle/product/11.2.0/db_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
ORA11G =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = scan-yu.com)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ora11g)
)
)
修改了两个节点的local_listener参数
SQL> alter system set local_listener='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=10.9.10.233)(PORT=1521))))' scope=both sid='ora11g1';
SQL> show parameter local_listener;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
local_listener string (DESCRIPTION=(ADDRESS_LIST=(AD
DRESS=(PROTOCOL=TCP)(HOST=10.9
.10.233)(PORT=1521))))
SQL> alter system set local_listener='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=10.9.10.234)(PORT=1521))))' scope=both sid='ora11g2';
SQL> show parameter local_listener;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
local_listener string (DESCRIPTION=(ADDRESS_LIST=(AD
DRESS=(PROTOCOL=TCP)(HOST=10.9
.10.234)(PORT=1521))))
客户端tnsnames.ora文件配置内容
ORA11G =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.9.10.233)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.9.10.234)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ora11g)
(INSTANCE_NAME = ora11g1)
)
)
现在从客户端连接rac报连接超时
页:
[1]