Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

SCAN trouble shooting

Posted on 2014-02-27
12
Medium Priority
?
364 Views
Last Modified: 2014-03-09
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
0
Comment
Question by:Mushfique Khan
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 7
  • 4
12 Comments
 
LVL 29

Expert Comment

by:MikeOM_DBA
ID: 39892461
The "hosts" file does not provide any useful information,
And these errors you talk about, are they a special secret you wish to keep?
What about posting some screenshots that are not invisible?
0
 

Author Comment

by:Mushfique Khan
ID: 39893685
Errors:
#1: $ sqlplus system/oracle@rac-scan.prime.com:1521/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.
0
 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 39893691
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?
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 

Author Comment

by:Mushfique Khan
ID: 39893777
[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 ... :(
0
 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 39893796
>>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:
http://www.experts-exchange.com/Database/Oracle/Q_28375008.html

If this is a duplicate, one of them will have to be deleted.  There is a 500 point maximum for a single question.
0
 

Author Comment

by:Mushfique Khan
ID: 39894447
Just want to connect using SCAN ... that's it
0
 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 39895438
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
0
 

Author Comment

by:Mushfique Khan
ID: 39897178
it looks good ... I think, please do have a look (attached)
scan.jpg
0
 

Author Comment

by:Mushfique Khan
ID: 39897698
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.
0
 

Accepted Solution

by:
Mushfique Khan earned 0 total points
ID: 39898597
sorry Gurus ... my fault, I was trying to connect using cygwin and when tried putty, all looks good, I think, cygwin configuration needs to be checked.

I think, this question should be deleted ... please advice.

Thanks
0
 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 39899186
I suggest you accept your last post as the answer in case anyone else ever tries connecting through cygwin.
0
 

Author Closing Comment

by:Mushfique Khan
ID: 39915653
As suggested
0

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.

721 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question