misterimran wrote:What error did you get?
I have just configured 2 Node RAC 11gR2 on Redhat Linux.
I can connect to SQLPlus from both RAC nodes and can access it through enterprise manager.
However I am unable to connect it from any client machines, even from SQL Developer on my machine, i have been doing the RAC installation from it. I have check from systems and there is no restriction on accessibility of these IPs.
These are my IPs
Public IP : 192.168.20.31, 192.168.20.33
Virtual IP: 192.168.20.32, 192.168.20.34
Single client access IP : 10.168.20.29 name: rac-scan
These are the contents of tnsadmin file from node 1.
(ADDRESS = (PROTOCOL = TCP)(HOST = rac-scan)(PORT = 1521))
(SERVER = DEDICATED)
(SERVICE_NAME = bssdb)
Should ichange the host from rac-scan to IP of the machine and then restart the listener?
Kindly help on this.
Edited by: P. Forstmann on 6 oct. 2011 14:05
... (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.20.29)(PORT = 1521)) (CONNECT_DATA = (SERVICE_NAME = bssdb)))