客户端使用SCNAIP连接11GRAC数据库报错ORA-12545解决(三)

################

实验2：修改RAC的local_listener参数，将参数值中HOST=的值改为scanip

[oracle@bysrac1 ~]$ sqlplus bys/bys
BYS@ bysrac1>show parameter local_listener
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
local_listener string (DESCRIPTION=(ADDRESS_LIST=(AD
DRESS=(PROTOCOL=TCP)(HOST=192.
168.1.226)(PORT=1521))))
BYS@ bysrac1>alter system set local_listener='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.228)(PORT=1521))))';
System altered.
BYS@ bysrac1>show parameter local_listener
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
local_listener string (DESCRIPTION=(ADDRESS_LIST=(AD
DRESS=(PROTOCOL=TCP)(HOST=192.

客户端使用VIP时报错ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

[oracle@bys3 admin]$ tnsping bysrac
TNS Ping Utility for Linux: Version 11.2.0.4.0 - Production on 01-JAN-2014 21:12:40
Copyright (c) 1997, 2013, Oracle. All rights reserved.
Used parameter files:
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.226)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = bysrac)))
OK (10 msec) -----tnsping可以正常联通，HOST = 192.168.1.226，这里tnsnames.ora里已经修改为RAC的一个节点的VIP了。。节约篇幅，没贴tnsnames.ora
[oracle@bys3 admin]$ sqlplus bys/bys@bysrac
SQL*Plus: Release 11.2.0.4.0 Production on Wed Jan 1 21:12:44 2014
Copyright (c) 1982, 2013, Oracle. All rights reserved.
ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

客户端使用SCANIP可以正常连接

[oracle@bys3 admin]$ tnsping bysrac
TNS Ping Utility for Linux: Version 11.2.0.4.0 - Production on 01-JAN-2014 21:13:01
Copyright (c) 1997, 2013, Oracle. All rights reserved.
Used parameter files:
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.228)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = bysrac)))
OK (10 msec) --tnsping可以正常联通，HOST = 192.168.1.228这里tnsnames.ora里已经修改为RAC的一个节点的SCANIP了。。节约篇幅，没贴tnsnames.ora
[oracle@bys3 admin]$ sqlplus bys/bys@bysrac
BYS@ bysrac>select instance_name,status from v$instance;
INSTANCE_NAME STATUS
---------------- ------------
bysrac1 OPEN
Elapsed: 00:00:00.01
BYS@ bysrac>