After installing 11g on Windows Vista, everything works fine. The listener is up, I can connect with SQL*Plus and misc case tools, etc.
However, no other Windows box on the same network segment (and in the same Workgroup) can access the instance on Vista.
Even a simple ping from a nearby XP box fails with "request timed out."
Google searches for things like "unable to ping vista from xp", etc. yielded the usual "check these" suspects:
So, [click], I enable that sucker. Then, since I was already here, I created a new rule (the "Add port..." button) for port 1522:
However, no other Windows box on the same network segment (and in the same Workgroup) can access the instance on Vista.
Even a simple ping from a nearby XP box fails with "request timed out."
Google searches for things like "unable to ping vista from xp", etc. yielded the usual "check these" suspects:
- Workgroup name is the same
- Simple file sharing is on
- Network discovery is on
- Network is Private
All check out on both boxes for me. I even have both Windows Firewalls disabled, and neither computer has McAfee or Norton, so that's not it.
Finally after 2 days or trying, I figure it's time to do a Crazy Ivan. This is Microsoft we're dealing with... so, I do something crazy; I turn on the Windows Firewall on Vista. I then clicked over to the second tab on the Firewall dialog and looked thru the checklists.
Do you know what I noticed? The "File and Printer Sharing" checkbox isn't checked. (Thanks Microsoft for letting me enable file sharing in the Network and Sharing Center and not telling me it was off in the firewall!)
Now it's back to the XP box again... and VOILA! the ping starts working. I can even ping the Vista box by it's Windows name (that failed before). More importantly, I can connect to the ORCL database on vista from XP now!
So, I ~200,000 results in Google for "unable to ping Vista from XP" and it's as simple as a checkbox or two. This is a newer Vista install, so it appears that this checkbox is off by default, couple that with the inability of Vista to warn you when you enable file sharing, and I can see why almost a quarter million people are going "WTF?!"
Subscribe to:
Post Comments (Atom)
Popular Posts
-
What is ENUM? ENUM is short for enumeration. Its a useful programming type that contains an ordered list of string values. The program...
-
A colleague asked me some questions about FIRST_ROWS and ALL_ROWS, but I'm hesitant to blog about it because it's already been done...
-
Dear Blog Readers, Every now and then I do receive e-mails from the novice DBAs saying that: “We could not perform well at the interview...
-
HowTo: Create a universal UDM report page in OEM PROBLEM: You have a bunch of User Defined Metrics (UDM) setup in OEM, and you want to kn... -
Have you run the new Oracle 11g installer on *NIX and received a nasty message? It happened to me this week! So, let's say you downloa...
-
REM:********************************************************************************************** REM: Script : Max 50 I/O Informations R...
-
What is NOCOPY? 'NOCOPY' is an optional 'hint' to tell the PL/SQL 'compiler' not to go through the overhead of ma...
-
This blog post is for them; those who are desperately looking for free Oracle Certification dumps. Well, you might be surprised to see the...
-
I was browsing the Oracle Forums earlier today and this post with a bit of SQL to clear OEM alerts from mnazim , who always has good advice...
-
Having chosen Oracle SQL Developer as your preferred Oracle database tool, do you have to install and learn a new technology for supporting...
0 comments:
Post a Comment