sql link to oracle 10g

5 day works, 3 days does not work, 2 days work, 1 day doesnot  ...ect......
with error

Error 7399: OLE DB provider 'MSDAORA' reported an error.
OLE DB error trace[OLE/DB Provider 'MSDAORA'  IDInitialize::Initia
lize
returned 0x80004005:  ].

Only daily activiti on server is shutdown for Backup.

Any clue ?

--
Message posted via http://www.webservertalk.com

Which server is shut down, SQL or Oracle?  If it is SQL Server why do you
shut it down just to do a backup?  In any case this seems like the driver is
having an issue talking to the Oracle server.  How stable are the
communications between the two?

--
Andrew J. Kelly  SQL MVP


"jesenko k via webservertalk.com" <u11642@uwe> wrote in message
 news:597770b8fd500@u
we...
>5 day works, 3 days does not work, 2 days work, 1 day doesnot  ...ect......
> with error
>
> Error 7399: OLE DB provider 'MSDAORA' reported an error.
> OLE DB error trace[OLE/DB Provider 'MSDAORA'  IDInitialize::Initia
lize
> returned 0x80004005:  ].
>
> Only daily activiti on server is shutdown for Backup.
>
> Any clue ?
>
> --
> Message posted via http://www.webservertalk.com

Which server is shut down, SQL or Oracle?
SQL

If it is SQL Server why do you shut it down just to do a backup?
company policy

In any case this seems like the driver is having an issue talking to the
Oracle server.

How stable are the communications between the two?
it worked last sunday, since then does not.

I've just reinstall Oracle Client on SQL server, still does not work.

--
Message posted via webservertalk.com
http://www.webservertalk.com/Uwe/Fo...server/200512/1

error we get from running quries
----------------------------------------------------------------------------
--
--------
Server: Msg 7399, Level 16, State 1, Procedure TMP$PBAImport, Line 2
OLE DB provider 'MSDAORA' reported an error.
[OLE/DB provider returned message: Oracle client and networking componen
ts
were not found. These components are supplied by Oracle Corporation and are
part of the Oracle Version 7.3.3 or later client software installation.

Provider is unable to function until these components are installed.]
OLE DB error trace [OLE/DB Provider 'MSDAORA'  IDBInitialize::Initi
alize
returned 0x80004005:   ].
----------------------------------------------------------------------------
--
--------

--
Message posted via webservertalk.com
http://www.webservertalk.com/Uwe/Fo...server/200512/1

Shutting down SQL Server just to do a backup is usually a bad policy,
Company or not. It makes me wonder if you are doing backups the proper way
to begin with.  If you are backing up the database files at OS level you
should definitely rethink that process.
From the errors you posted it sounds like the Oracle Client install did not
work properly.  The error you posted indicates that it is clearly having
issues finding the Oracle components so I would start there.

--
Andrew J. Kelly  SQL MVP


"jesenko k via webservertalk.com" <u11642@uwe> wrote in message
 news:5986117d02f4f@u
we...
> Which server is shut down, SQL or Oracle?
> SQL
>
> If it is SQL Server why do you shut it down just to do a backup?
> company policy
>
> In any case this seems like the driver is having an issue talking to the
> Oracle server.
>
> How stable are the communications between the two?
> it worked last sunday, since then does not.
>
> I've just reinstall Oracle Client on SQL server, still does not work.
>
> --
> Message posted via webservertalk.com
> http://www.webservertalk.com/Uwe/Fo...server/200512/1

yes, it is full OS level backup.

Oracle client is reinstalled and connection to oracle works from SQLplus.
Oracle / bin is in path.

I have development environment...the same structure ... everything works.

--
Message posted via http://www.webservertalk.com

You should really look at using the native SQL BACKUP instead. You can
backup to a file where your OS level backup software can copy that to tape.
That way you have no need to take the server down and you are more assured
of a consistent backup.
As for the connection sorry but I don't think I can suggest anything else.
Hopefully someone has seen this before and will jump in.
--
Andrew J. Kelly  SQL MVP


"jesenko k via webservertalk.com" <u11642@uwe> wrote in message
 news:598fe0ebd7e3a@u
we...
> yes, it is full OS level backup.
>
> Oracle client is reinstalled and connection to oracle works from SQLplus.
> Oracle / bin is in path.
>
> I have development environment...the same structure ... everything works.
>
> --
> Message posted via http://www.webservertalk.com

OK. It works now.

1. Use Oracle Provider...before Microsoft Provider for Oracle

2. Set AllowInProcess option for it

I am Oracle guy, SQL Server is my "part time duty"

--
Message posted via http://www.webservertalk.com

Stopped working again

Applied FIX from Oracle Metalink Doc 215255.1

It works now...so far

--
Message posted via webservertalk.com
http://www.webservertalk.com/Uwe/Fo...server/200512/1