ODBC ora error installing Oracle

User Im supporting is trying to install Oracle v.06.05.002.000 and gets error  [ IM006: [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed IM006 Microsoft  ODBC Driver Manager Driver's SQLSetConnectAttr failed$1000 ] Oracle ODBC Ora ORA-12541:TNS:no listener

It's working on all his other computers.  Hes using a known good ora file.

Any assistance is appreciated.
Thank you,
Mark
Mark O'BrienDispatch Software Support and Server AdministrationAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

slightwv (䄆 Netminder) Commented:
Make sure the sqlnet.ora file is also the same as working machines.

The error stats there isn't a listener running on the HOST you are trying to connect to.

Make sure you are going to the server you think you are going to.  Maybe a local hosts file is pointing to a wrong machine?
0
Mark O'BrienDispatch Software Support and Server AdministrationAuthor Commented:
It's working on all his other computers.  Hes using a known good ora file.
0
slightwv (䄆 Netminder) Commented:
I understand that is what you said from the first time you said it.

The fact that one machine doesn't work implies something about this machine is different.  There are only a few things it can be.

When people new to Oracle mention a "ora" file, them main one they are talking about is the tnsnames.ora file.  They forget about the sqlnet.ora file that can have some settings that make the tnsnames.ora file "work".
0
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

Mark GeerlingsDatabase AdministratorCommented:
I agree with what slightwv said.  One other possibility is multiple "Oracle_homes", that is: multiple, separate installations of Oracle client software on this "problem" PC.  If that is true, you may be looking at a tnsnames.ora file other than the one that the Microsoft ODBC driver is actually using.

Open RegEdit then check: Hkey-Local_machine, Software, Oracle and see if there is just one Oracle_home, or multiples.
0
Mark O'BrienDispatch Software Support and Server AdministrationAuthor Commented:
User states back, On the last reinstall, I deleted the registry entries for all the previous homes.  Please give me a more specific change or entry to check.
0
Mark GeerlingsDatabase AdministratorCommented:
When you "deleted the registry entries for all the previous homes" did you actually uninstall or physically delete the corresponding software?  Or, is that software still installed on that hard drive?  If that software is still physically on the hard drive, even if the Oracle-related registry entries have been deleted, Microsoft software may still be trying to use it.

Finding that software on disk could be a challenge!  Depending on who did the Oracle software installation, the top-level directory for it could be named anything, and it could be in any directory of the C:\drive (or any other drive on the PC, if it has multiple disks).
0
Mark O'BrienDispatch Software Support and Server AdministrationAuthor Commented:
stand by, checking that
0
Geert GOracle dbaCommented:
that's a long "stand by"
what daily rate do you pay for "standing by" ?
0
Mark O'BrienDispatch Software Support and Server AdministrationAuthor Commented:
Oh, the enduser said he moved the laptop to a diff domain and that "fixed it".  How that did it I have no idea
0
slightwv (䄆 Netminder) Commented:
Off the top of my head it might have been the sqlnet.ora parameter NAMES.DEFAULT_DOMAIN.
0
Mark O'BrienDispatch Software Support and Server AdministrationAuthor Commented:
I suggested a reimage b/c that's what Ive always done when stuck with this issue.  Is that not the easiest way?
0
slightwv (䄆 Netminder) Commented:
>>Is that not the easiest way?

Sure.  You can always tear down and rebuild your entire house because a toilet flapper needs replacing but it seems like over-kill.

Even if a reimage occurs, most people copy config files like the .ora files around so the reimage likely won't magically fix this.

Something between a working machine and non-working machine is different.  If a working machine is in the domain and the non-working was also in the domain, then I'm not sure how pulling it out magically worked.

It would be hard to diagnose if you didn't have hands-on access.
0
Mark O'BrienDispatch Software Support and Server AdministrationAuthor Commented:
- so probably easier to reimage....
0
slightwv (䄆 Netminder) Commented:
If it is an issue with the domain or sqlnet.ora or tnsnames.ora, a reimage will not fix it.  It is something in the config and likely not an out-of-the-box install issue.

So, I reimage the machine, rejoin it to the same domain, copy my oracle config files over.  I would bet that the problem isn't fixed.

If they still have one machine not working and one working, on those two machines, do an:  ipconfig /all  

Compare the results.  If the domains are the same, triple check the sqlnet.ora files are the same.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Mark O'BrienDispatch Software Support and Server AdministrationAuthor Commented:
All I know is that it worked again from the tech.  Not sure what else to say
0
Mark O'BrienDispatch Software Support and Server AdministrationAuthor Commented:
Thank you everyone.  Frustrating issues....
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Software

From novice to tech pro — start learning today.