Suddenly SQL server cannot connect to Oracle Server :( [message #311380] |
Fri, 04 April 2008 05:36 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
NickStan
Messages: 8 Registered: April 2008 Location: London, England
|
Junior Member |
|
|
I have a Microsoft SQL Server (Microsoft Windows Server 2003 R2, SP2, Windows NT 5.2, SQL Server V8) and an Oracle Machine (Fedcore5, Oracle 10G, SP2 I think!).
The SQL Server is used to host our reporting portal (and data) and the Linux/Oracle Server is used to connect to our US machines via links and to pass the data back to the SQL Server.
Now for some reason (after a 1.5 years of no problems) I cannot execute an oracle stored proc (from the SQL server), I cannot connect to Oracle (via TOAD), and all of my DTS packages that pull data from Oracle to SQL are failing - such a nightmare!
I can connect to the Oracle Machine from my laptop. I can run TOAD without any problems and I can run DTS packages without any problems.
When I try to connect in sqlplus I get the error messages:
SP2-1503: Unable to initialize Oracle call interface
SP2-0152: Oracle may not be functioning properly
When I try to execute an Oracle Stored Procedure from SQL, I get the following error:
SP2-1503: Unable to initialize Oracle call interface
SP2-0152: ORACLE may not be functioning properly
I have tried the following:
--Reinstalled Oracle on the SQL server
--Reinstalled TOAD on the SQL server
--Reinstalled ODBC Oracle Driver on the SQL server
--Copied the tnsnames.ora file from my laptop to the SQL server.
--I can ping the Oracle Server from the SQL Server.
I dont know what the problem can be.
As far as I know, nothing has changed on the SQL and Oracle Machines (apparently!)
I get the feeling that something is preventing the SQL machine from accessing the Oracle Machine.
But what?
Any help much appreciated.
Thanks
|
|
|
|
Re: Suddenly SQL server cannot connect to Oracle Server :( [message #311397 is a reply to message #311380] |
Fri, 04 April 2008 06:42 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
NickStan
Messages: 8 Registered: April 2008 Location: London, England
|
Junior Member |
|
|
The IP-Address of the Oracle Server has remained unchanged for the past 1.5 years too.
Firewall is 'Off'.
When I type in SQLPlus on the SQL Server I get the error:
SP2-1503: Unable to initialize Oracle call interface
SP2-0152: ORACLE may not be functioning properly
I renamed the tnsnames.ora file to tnsnames_back.ora, error message did not change.
Seems like Oracle does not even check the tnsnames.ora, it simply errors.
|
|
|
|
|
|
|
|
|
|
Re: Suddenly SQL server cannot connect to Oracle Server :( [message #311477 is a reply to message #311380] |
Fri, 04 April 2008 10:56 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
NickStan
Messages: 8 Registered: April 2008 Location: London, England
|
Junior Member |
|
|
Thanks Thomas, but Google was the first place I went to, to try and solve this.
I came to this forum as a result of me trying so many things that did not work.
So basically I am screwed now, I cant solve this and I have users going crazy because the reports have been down for 2 days now.
|
|
|
Re: Suddenly SQL server cannot connect to Oracle Server :( [message #311509 is a reply to message #311477] |
Fri, 04 April 2008 12:09 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
ThomasG
Messages: 3212 Registered: April 2005 Location: Heilbronn, Germany
|
Senior Member |
|
|
Well, the problem is that due to whatever reason the binaries and/or libaries on the client side can not be loaded correctly.
Which could have a lot of reasons, as the search turns up.
( File corruption, Access permission, Wrong Windows Group Policies, BUG #4684738 on MetaLink, "Create Global Objects" missing in Windows Security configuration, etc, etc, etc ... )
Have you searched the ENTIRE windows server for "sqlnet.log" files that could point to a more specific error, and have you looked at the Windows event logs?
|
|
|
|
Re: Suddenly SQL server cannot connect to Oracle Server :( [message #311522 is a reply to message #311380] |
Fri, 04 April 2008 12:29 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
NickStan
Messages: 8 Registered: April 2008 Location: London, England
|
Junior Member |
|
|
I wish I knew what has changed, but I dont.
As I said these 2 servers have communicated happily for about 1.5 years with no problems.
There have been no windows updates or SQL server updates applied recently (2 both machines) that could have caused anything.
I can now connect in SQLPlus from the SQL server to the Oracle server (after inserting a new environment variable), however I still cannot run a stored procedure from a DTS (using SQLPlus)
|
|
|
|
|
|