aix oracle监听配置_AIX HACMP下oracle监听配置 - Oracle数据库管理 - Oracle数据库数据恢复、性能优化来问问AskMaclean - ParnassusData...

本帖最后由 路人呵呵 于 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

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

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

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: 无法解析指定的连接标识符

哪里需要纠正的?