DB Link between RAC and a standalone Database - HELP
Hi Guys,
I have a database DB1 on server1 (192.168.100.10), and then I have a RAC database on physical servers PROD1 192.168.100.1, and PROD2 192.168.100.5 with a load balancer. These two have virtual IPs 192.168.100.2 and 192.168.100.6. I have managed to create a DB Link on the RAC db pointing to DB1 with success, but when I create a db link on the DB1 server pointing to the RAC it fails. TNSPING works fine if I refer to the physical IP, but when I try the virtual IP it fails, but once I logon to the database I fail to connect using a db link or conn user1@prod1_link. Below are my tnsnames.ora entries.
#virtual IPs
PROD=
(DESCRIPTION=
(ADDRESS_LIST=
(LOAD_BALANCE=YES)
(FAILOVER=YES)
(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.100.2)(PORT=1529))
(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.100.6)(PORT=1529))
)
(CONNECT_DATA=
(SERVICE_NAME=PROD)
)
)
PROD1=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.100.2)(PORT=1529))
(CONNECT_DATA=
(SERVICE_NAME=PROD)
(INSTANCE_NAME=PROD1)
)
)
PROD2=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.100.6)(PORT=1529))
(CONNECT_DATA=
(SERVICE_NAME=PROD.econet.co.zw)
(INSTANCE_NAME=PROD2)
)
)
#physical IPs
P1_PROD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.100.1)(PORT = 1529))
)
(CONNECT_DATA =
(SID=PROD)
(INSTANCE_NAME=PROD1)
)
)
P2_PROD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.100.5)(PORT = 1529))
)
(CONNECT_DATA =
(SID=PROD)
(INSTANCE_NAME=PROD1)
)
)
oracle@server1> tnsping prod1
TNS Ping Utility for Linux: Version 11.2.0.1.0 - Production on 12-OCT-2010 11:52:06
Copyright (c) 1997, 2009, Oracle. All rights reserved.
Used parameter files:
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.100.2)(PORT=1529)) (CONNECT_DATA= (SERVICE_NAME=PROD) (INSTANCE_NAME=PROD1)))
TNS-12541: TNS:no listener
oracle@server1>
oracle@server1>
oracle@server1> tnsping p1_prod
TNS Ping Utility for Linux: Version 11.2.0.1.0 - Production on 12-OCT-2010 11:09:28
Copyright (c) 1997, 2009, Oracle. All rights reserved.
Used parameter files:
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.100.1)(PORT = 1529))) (CONNECT_DATA = (SID=PROD) (INSTANCE_NAME=PROD1)))
OK (0 msec)
oracle@server1>
SQL> Create Database Link prod_link
Connect to user1
identified by password
using 'P1_PROD';
Database link created.
SQL>
SQL> select * from global_name@prod_link;
select * from global_name@prod_link
*
ERROR at line 1:
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
SQL>
Help... sorry I could format the above using the "code" text.
Regards,
Kevin
Edited by: Kevin Honde on Oct 12, 2010 12:10 PM