This content has been marked as final. Show 2 replies
add the entry of second database in ur tnsnames.ora and try to tnsping the other database
(ADDRESS = (PROTOCOL = TCP)(HOST = #hostname)(PORT = 1521))
(SERVER = DEDICATED)
vxnode1-> tnsping racdb1
TNS Ping Utility for Linux: Version 22.214.171.124.0 - Production on 18-SEP-2010 23:40:28
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 = scan.rac.example.com)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = racdb1.rac.example.com)))
Edited by: shaiffy on Sep 18, 2010 8:40 PM
Thanks for the reply.
Actually i added both the entries and it is working now.