- 最后登录
- 2016-12-16
- 在线时间
- 34 小时
- 威望
- 87
- 金钱
- 348
- 注册时间
- 2011-10-12
- 阅读权限
- 50
- 帖子
- 43
- 精华
- 0
- 积分
- 87
- UID
- 13
|
1#
发表于 2013-10-8 16:15:33
|
查看: 5543 |
回复: 7
本帖最后由 路人呵呵 于 2013-10-8 16:29 编辑
双机+HACMP,上面部署ORACLE 11G,非RAC模式.客户端配置tnsnames.ora后,无法连接到数据库.
数据库环境
数据库版本:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
PL/SQL Release 11.2.0.3.0 - Production
CORE 11.2.0.3.0 Production
TNS for IBM/AIX RISC System/6000: Version 11.2.0.3.0 - Production
NLSRTL Version 11.2.0.3.0 – Production
网络环境:
主机A : 10.1.51.5 xyw_db1
主机B : 10.1.51.6 xyw_db2
虚地址 : 10.1.51.7 svc
在主机A 得到的信息:
$ ifconfig -a
en0: flags=1e080863,480<UP,BROADCAST,NOTRAILERS,RUNNING,SIMPLEX,MULTICAST,GROUPRT,64BIT,CHECKSUM_OFFLOAD(ACTIVE),CHAIN>
inet 172.16.20.1 netmask 0xffffff00 broadcast 172.16.20.255
inet 10.1.51.5 netmask 0xffffff00 broadcast 10.1.51.255
tcp_sendspace 262144 tcp_recvspace 262144 rfc1323 1
en1: flags=1e080863,480<UP,BROADCAST,NOTRAILERS,RUNNING,SIMPLEX,MULTICAST,GROUPRT,64BIT,CHECKSUM_OFFLOAD(ACTIVE),CHAIN>
inet 172.16.21.1 netmask 0xffffff00 broadcast 172.16.21.255
inet 10.1.51.7 netmask 0xffffff00 broadcast 10.1.51.255
tcp_sendspace 262144 tcp_recvspace 262144 rfc1323 1
lo0: flags=e08084b,c0<UP,BROADCAST,LOOPBACK,RUNNING,SIMPLEX,MULTICAST,GROUPRT,64BIT,LARGESEND,CHAIN>
inet 127.0.0.1 netmask 0xff000000 broadcast 127.255.255.255
inet6 ::1%1/0
tcp_sendspace 131072 tcp_recvspace 131072 rfc1323 1
主机A上的 listener.ora :
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = xyw_db1)(PORT = 1525))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1525))
)
)
#ADR_BASE_LISTENER = /u01/app/oracle
ADR_BASE_LISTENER = /appdata/oracle
主机上A的tnsnames.ora :
BB2 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.51.5)(PORT = 1525))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = bb2)
)
)
BB2TEST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.51.7)(PORT = 1525))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = bb2)
)
)
LISTENER_BB2 =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.51.5)(PORT = 1525))
客户端的tnsnames.ora:
BB2 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.51.5)(PORT = 1525))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = bb2)
)
)
BB2TEST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.51.7)(PORT = 1525))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = bb2)
)
)
----------------------------------------------------
客户机与数据库主机是相同的,防火墙是互信的.
而且当主机监听设置成 10.1.51.5, 客户端用也用这个地址是可以连通数据库.
我在主机A:
sqlplus scott/tiger@bb2test 可以连接数据库.
也可以用 tnsping bb2test 连通.
但是在客户端上 sqlplus scott/tiger@bb2test 提示:
ORA-12154: TNS: 无法解析指定的连接标识符
哪里需要纠正的?
|
|