Link to home
Start Free TrialLog in
Avatar of Natchiket
NatchiketFlag for United Kingdom of Great Britain and Northern Ireland

asked on

ODBC Access-Oracle Connectivity intermittent since server was switched

The admin guys here at work have switched our Oracle database over the weekend from an old creaking server to a new fast one

tnsnames.ora has been updated to point to the new location.

TOAD works fine ... good news
Have also tested using OLE DB ... DSN-less connection all fine

but ... most of my apps use ODBC DSNs and these are struggling.  Symptoms as follows:
In the Oracle ODBC Driver Configuration:  Test Connection gives Connection Successful.  However when in Access and attempting to connect to the tables using the DSN am getting ...[Oracle][ODBC][Ora]ORA-01033: ORACLE Initialization or shutdown in progress
(#1033)[Microsoft][ODBC Driver Manager] Drivers SetConnectAttr failed IM006 0 ...

Bizzarely there were one or two (short-lived) attempts when the connection succeeded
ASKER CERTIFIED SOLUTION
Avatar of dbmullen
dbmullen
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Avatar of schwertner
schwertner
Flag of Antarctica image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Natchiket

ASKER

I've managed a workaraound .. in the tnsnames.ora file I renamed the .WORLDs to something non-conventional (as far as this organisation is concerned)  RRWP2.WORLD= etc ... was renamed to RRWLALA.WORLD and then set the TNS Service Name in the Oracle ODBC Driver dialogue to RRWLALA.WORLD  seems to have done the trick.  I'm still intrigued though ... looks like something is hijacking RRWP2.WORLD and pointing it to a server which is now decomissioned ...
Yes, you hit the nail on the head! It is looking for wrong network name.
You can check this using the command
tnsping alias
It will show you if the connection action reaches the Listener of Oracle.
anyway  ... still limping along using my bastartised tnsnames.ora after the support guy  'fixed it' i.e. screwed it up again ... so it's time to close this one off ... equal points all round!!
Don't give up!
TNSNAMES.ORA
LISTENER.ORA
are the hearth of Oracle connectivity.
Learn them or suffer!