Mushfique Khan
asked on
SCAN trouble shooting
Folks, I'm able to connect using the actual node ip, but when trying scan ip, giving all sorts of errors, using /etc/hosts file, attached is my hosts file too.
Need some assistance to troubleshoot, what exactly is the problem.
Thanks
hosts
Need some assistance to troubleshoot, what exactly is the problem.
Thanks
hosts
ASKER
Errors:
#1: $ sqlplus system/oracle@rac-scan.pri me.com:152 1/prod
SQL*Plus: Release 11.2.0.1.0 Production on Thu Feb 27 18:45:38 2014
Copyright (c) 1982, 2010, Oracle. All rights reserved.
ERROR:
ORA-12170: TNS:Connect timeout occurred
#2 $ sqlplus system/oracle@prod
SQL*Plus: Release 11.2.0.1.0 Production on Thu Feb 27 20:46:10 2014
Copyright (c) 1982, 2010, Oracle. All rights reserved.
ERROR:
ORA-12545: Connect failed because target host or object does not exist
Same error when using ip address, instead of name.
#1: $ sqlplus system/oracle@rac-scan.pri
SQL*Plus: Release 11.2.0.1.0 Production on Thu Feb 27 18:45:38 2014
Copyright (c) 1982, 2010, Oracle. All rights reserved.
ERROR:
ORA-12170: TNS:Connect timeout occurred
#2 $ sqlplus system/oracle@prod
SQL*Plus: Release 11.2.0.1.0 Production on Thu Feb 27 20:46:10 2014
Copyright (c) 1982, 2010, Oracle. All rights reserved.
ERROR:
ORA-12545: Connect failed because target host or object does not exist
Same error when using ip address, instead of name.
99.999% of the time an ORA-12170 is a firewall issue.
from a CMD prompt post the results of:
ping 192.168.1.21
tracert 192.168.1.21
For us to troubleshoot the ORA-12545 we need to see the tnsnames.ora file from the machine where you executed that command.
Also, is there any reason you are using EZConnect for the first try and not for the second?
from a CMD prompt post the results of:
ping 192.168.1.21
tracert 192.168.1.21
For us to troubleshoot the ORA-12545 we need to see the tnsnames.ora file from the machine where you executed that command.
Also, is there any reason you are using EZConnect for the first try and not for the second?
ASKER
[root@rac2 u01]# tracert 192.168.1.21
traceroute to 192.168.1.21 (192.168.1.21), 30 hops max, 40 byte packets
1 rac-scan.prime.com (192.168.1.21) 0.291 ms 0.257 ms 0.249 ms
[root@rac2 u01]# ping 192.168.1.21
PING 192.168.1.21 (192.168.1.21) 56(84) bytes of data.
64 bytes from 192.168.1.21: icmp_seq=1 ttl=64 time=0.223 ms
64 bytes from 192.168.1.21: icmp_seq=2 ttl=64 time=0.181 ms
64 bytes from 192.168.1.21: icmp_seq=3 ttl=64 time=0.272 ms
^C
--- 192.168.1.21 ping statistics ---
3 packets transmitted, 3 received, 0% packet loss, time 1999ms
rtt min/avg/max/mdev = 0.181/0.225/0.272/0.039 ms
[root@rac2 u01]#
tnsnames.ora
PROD =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = rac-scan.prime.com)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = prod)
)
)
PROD =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.21)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = prod)
)
)
And no reason, basically was trying all options, whatever works ... :(
traceroute to 192.168.1.21 (192.168.1.21), 30 hops max, 40 byte packets
1 rac-scan.prime.com (192.168.1.21) 0.291 ms 0.257 ms 0.249 ms
[root@rac2 u01]# ping 192.168.1.21
PING 192.168.1.21 (192.168.1.21) 56(84) bytes of data.
64 bytes from 192.168.1.21: icmp_seq=1 ttl=64 time=0.223 ms
64 bytes from 192.168.1.21: icmp_seq=2 ttl=64 time=0.181 ms
64 bytes from 192.168.1.21: icmp_seq=3 ttl=64 time=0.272 ms
^C
--- 192.168.1.21 ping statistics ---
3 packets transmitted, 3 received, 0% packet loss, time 1999ms
rtt min/avg/max/mdev = 0.181/0.225/0.272/0.039 ms
[root@rac2 u01]#
tnsnames.ora
PROD =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = rac-scan.prime.com)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = prod)
)
)
PROD =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.21)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = prod)
)
)
And no reason, basically was trying all options, whatever works ... :(
>>And no reason, basically was trying all options, whatever works ... :(
Which error do you wish to troubleshoot?
Based on your previous related questions I have to assume you are still trying to connect to the RAC cluster using the SCAN ip address so we can really ignore the attempts to connect to the local PROD instance?
If so, I don't see how this question is different than:
https://www.experts-exchange.com/questions/28375008/Oracle-11gR2-RAC-2-node-Network-Configuration.html
If this is a duplicate, one of them will have to be deleted. There is a 500 point maximum for a single question.
Which error do you wish to troubleshoot?
Based on your previous related questions I have to assume you are still trying to connect to the RAC cluster using the SCAN ip address so we can really ignore the attempts to connect to the local PROD instance?
If so, I don't see how this question is different than:
https://www.experts-exchange.com/questions/28375008/Oracle-11gR2-RAC-2-node-Network-Configuration.html
If this is a duplicate, one of them will have to be deleted. There is a 500 point maximum for a single question.
ASKER
Just want to connect using SCAN ... that's it
Try the following commands from this document:
http://www.oracle.com/technetwork/products/clustering/overview/scan-129069.pdf
They should show the setup for scan.
srvctl config scan_listener
and
srvctl confic scan
http://www.oracle.com/technetwork/products/clustering/overview/scan-129069.pdf
They should show the setup for scan.
srvctl config scan_listener
and
srvctl confic scan
ASKER
it looks good ... I think, please do have a look (attached)
scan.jpg
scan.jpg
ASKER
Gurus, attached is the raccheck report too, can you please take a look and identify, what exactly I'm missing here.
Sorry, can't attach html, any way to share that report?
Thanks.
Sorry, can't attach html, any way to share that report?
Thanks.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I suggest you accept your last post as the answer in case anyone else ever tries connecting through cygwin.
ASKER
As suggested
And these errors you talk about, are they a special secret you wish to keep?
What about posting some screenshots that are not invisible?