471,073 Members | 1,449 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,073 software developers and data experts.

Connection to Oracle sometimes hangs

Hi,

For a customer we have implemented a datawarehouse with a connection to
Oracle. From the beginning of the project the connection to Oracle
gives troubles. The next morning is the connection still active and
when the customer looks in the processes of SQL Server a " Wait type,
RESOURCE_SEMAPHORE." is shown. For what i know. SQL Server is waiting
for a resource, in this case Oracle but doesn't tell me anything about
what could be the problem.

The customer uses the Oracle driver instead of a microsft oracle
driver.

What could it be? and how can we tackle this problem? Are there ways to
look from Oracle point of view? Can we monitor something?

Greetz,
Hennie

Jan 3 '06 #1
2 1837
Hi

I am not sure if this will be any help, but may be worth a read!
http://support.microsoft.com/kb/280106/

John

"Hennie7863" <hd********@hotmail.com> wrote in message
news:11**********************@g14g2000cwa.googlegr oups.com...
Hi,

For a customer we have implemented a datawarehouse with a connection to
Oracle. From the beginning of the project the connection to Oracle
gives troubles. The next morning is the connection still active and
when the customer looks in the processes of SQL Server a " Wait type,
RESOURCE_SEMAPHORE." is shown. For what i know. SQL Server is waiting
for a resource, in this case Oracle but doesn't tell me anything about
what could be the problem.

The customer uses the Oracle driver instead of a microsft oracle
driver.

What could it be? and how can we tackle this problem? Are there ways to
look from Oracle point of view? Can we monitor something?

Greetz,
Hennie

Jan 3 '06 #2
Hi john, Thanx for your answer, but we dont use linked server. Just an
OLEDB connection (via UDL's) with Oracle. Well the customer has
investigated a bit further and told me that a value of 70 characters
is written into a field of 40 characters. When he executes the packages
by hand it will throw an error. When executed with aid of a job it will
continue running. So I think it could be a JOB problem in SQL Server
2000. Any one ideas?

Jan 4 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

6 posts views Thread by Paul Robinson | last post: by
1 post views Thread by a153153153 | last post: by
4 posts views Thread by chris | last post: by
1 post views Thread by Cliff Cooley | last post: by
63 posts views Thread by Nick Palmer | last post: by
4 posts views Thread by =?Utf-8?B?U3RlcGhhbmllIERvaGVydHk=?= | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.