| Author |
sql link to oracle 10g
|
|
| jesenko k via SQLMonster.com 2005-12-27, 11:23 am |
| 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
| |
| Andrew J. Kelly 2005-12-27, 11:23 am |
| 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
| |
| jesenko k via SQLMonster.com 2005-12-28, 8:23 pm |
| 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
| |
| jesenko k via SQLMonster.com 2005-12-28, 8:23 pm |
| 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 components
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
| |
| Andrew J. Kelly 2005-12-29, 9:23 am |
| 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
| |
| jesenko k via SQLMonster.com 2005-12-29, 9:23 am |
| 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
| |
| Andrew J. Kelly 2005-12-29, 9:23 am |
| 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
| |
| jesenko k via SQLMonster.com 2005-12-29, 11:23 am |
| 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
| |
|
|
|
|