August 3, 2005 at 12:05 pm
We had to install the latest Oracle for SQL.net provider on our sql box. It messed up our old client install, so I cleaned it all up and got it installed properly without any old stuff. However, now I use the dts package that connects to oracle, and it works just fine. But when I schedule it, it simply hangs. No error message -- it just sits there "executing step 1".
I'm baffled. I checked the file permission of the Oracle install folder and added "everyone, system, and the sqlservice account that runs sql" and gave them al Full Control.
Any ideas would be appreciated.
August 3, 2005 at 12:57 pm
Update: There must be some type of permissions problem. I normally have all my scheduled jobs run by a network user which has a lot of authority. I changed it to the 'sa' account, and now the packages were running. So I'm not sure what permissions problem i'm running into, but I'm going to keep looking.
August 5, 2005 at 10:24 pm
I'm sure you've checked this, but just to verify have you done a connect under the context of the network user account outside of SQL?
And - what were the versions involved in the Oracle client?
August 8, 2005 at 1:07 pm
I have the same problems, but my connection is to JDE.
My DTS work, but not in scheduler.
If you find it, let me know please.
I think it's user authorization problems.
Are you the AS?
i am not, but i have all the authorization for this data base.
August 25, 2005 at 9:47 am
The version is Oracle 9.2
I still haven't resolved the issue. Since it was working, I got pulled into other stuff and didn't have time to go revisit.
I am the System admin, so anything run under my context always runs. The scheduler is run under a context of a domain user, but has full system rights on the server and on the sql databases. That's why it doesn't make sense.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply