Hi,

I'm having a problem with connecting to a version 9 Oracle database
with SQL Server 2005 and the Micrsoft Oracle Ole DB Provider with an
Oracle 10 client. Basically when I attempt to connect to a linked
server in SQL Server 2005 that uses the Microsoft Ole DB Provider I get
the following error - Msg 7303, Level 16, State 1 Cannot initialize the
data source object of OLE DB provider "MSDAORA" for linked server
"MSORACLE".

In attempting to get more info on the problem I discovered that
apparently my Oracle client is not logging any errors. I went into the
Oracle Net Manager and set the trace level to Admin and left all the
other parameters blank (assuming that it would just write to the
defaults), but no files are produced (sqlnet.trc or sqlnet.log).

Am I missing something here?

Thanks

On 19 Dec 2005 12:40:36 -0800, "Crazy Cat" <danbredy@hotmail.com>
wrote:

>Hi,
>
>I'm having a problem with connecting to a version 9 Oracle database
>with SQL Server 2005 and the Micrsoft Oracle Ole DB Provider with an
>Oracle 10 client. Basically when I attempt to connect to a linked
>server in SQL Server 2005 that uses the Microsoft Ole DB Provider I get
>the following error - Msg 7303, Level 16, State 1 Cannot initialize the
>data source object of OLE DB provider "MSDAORA" for linked server
>"MSORACLE".
>
> In attempting to get more info on the problem I discovered that
>apparently my Oracle client is not logging any errors. I went into the
>Oracle Net Manager and set the trace level to Admin and left all the
>other parameters blank (assuming that it would just write to the
>defaults), but no files are produced (sqlnet.trc or sqlnet.log).
>
>Am I missing something here?
>
>Thanks

I have observed in 9i that 'leaving the other parameters blank' is a
recipe for no tracing and logging.
Obviously, if you have access to it, you could also consult
listener.log on the server. All connections are logged there, unless
explicitly disabled.

--
Sybrand Bakker, Senior Oracle DBA

Hi,

This time I have a path for the log and one for trace as well as names
for each of the files, and I am still getting no logging.
I have only access to the server database so I can't user listener.log.

Is there anything else I can do ?

Thanks

Crazy Cat wrote:
> Hi,
>
> This time I have a path for the log and one for trace as well as names
> for each of the files, and I am still getting no logging.
> I have only access to the server database so I can't user listener.log.
>
> Is there anything else I can do ?
>
> Thanks

Given most of us have no access to previous posts to this thread I
haven't a clue what version of Oracle, what the problem is, what
entries you have in your SQLNET.ORA file, or anything else.

Expect little or no help unless there is sufficient information from
which someone can formulate a response. Have you looked at metalink
yet or is your firm yet another Oracle customer too cheap to pay for
support?
--
Daniel A. Morgan
http://www.psoug.org
damorgan@x.washington.edu
(replace x with u to respond)

Daniel A. Morgan wrote:
Crazy Cat wrote:
> Hi,

> This time I have a path for the log and one for trace as well as names
> for each of the files, and I am still getting no logging.
> I have only access to the server database so I can't user listener.log.


> Is there anything else I can do ?


> Thanks



Given most of us have no access to previous posts to this thread I
haven't a clue what version of Oracle, what the problem is, what
entries you have in your SQLNET.ORA file, or anything else.

Expect little or no help unless there is sufficient information from
which someone can formulate a response. Have you looked at metalink
yet or is your firm yet another Oracle customer too cheap to pay for
support?
--


My response :

Sorry about that --I'm using Google groups which doesn't automatically
paste the original message in the reply -- it's the only newsreader I
have access to unfortunately. Anyways here's what I got in my
sqlnet.ora --

# sqlnet.ora Network Configuration File:
D:\oracle\product\10.1.0\Client_1\NETWORK\ADMIN\sq lnet.ora
# Generated by Oracle configuration tools.

SQLNET.AUTHENTICATION_SERVICES= (NTS)

TRACE_LEVEL_CLIENT = ADMIN

NAMES.DIRECTORY_PATH= (TNSNAMES)

TRACE_DIRECTORY_CLIENT =
D:\oracle\product\10.1.0\Client_1\network\trace

TRACE_FILE_CLIENT = sqlnet.trc

LOG_FILE_CLIENT = sqlnet.log

LOG_DIRECTORY_CLIENT = D:\oracle\product\10.1.0\Client_1\network\log

As far as I know this company does not have metalink support.

What other info would you like me to supply? I'll post my original
message below -- once again I apologize for the lack of indentation
to make reading clearer, but I am using Google's subpar interface.


Thanks

Original message follows --

Crazy Cat
Dec 19, 3:40 pm hide options

Newsgroups: comp.databases.oracle.misc
From: "Crazy Cat" <danbr...@hotmail.com> - Find messages by this author

Date: 19 Dec 2005 12:40:36 -0800
Local: Mon, Dec 19 2005 3:40 pm
Subject: Oracle not logging or tracing
Reply | Reply to Author | Forward | Print | Individual Message | Show
original | Remove | Report Abuse

Hi,


I'm having a problem with connecting to a version 9 Oracle database
with SQL Server 2005 and the Micrsoft Oracle Ole DB Provider with an
Oracle 10 client. Basically when I attempt to connect to a linked
server in SQL Server 2005 that uses the Microsoft Ole DB Provider I get

the following error - Msg 7303, Level 16, State 1 Cannot initialize the

data source object of OLE DB provider "MSDAORA" for linked server
"MSORACLE".


In attempting to get more info on the problem I discovered that
apparently my Oracle client is not logging any errors. I went into the
Oracle Net Manager and set the trace level to Admin and left all the
other parameters blank (assuming that it would just write to the
defaults), but no files are produced (sqlnet.trc or sqlnet.log).


Am I missing something here?


Thanks

Crazy Cat wrote:
> Daniel A. Morgan wrote:
> Crazy Cat wrote:
>
>>Hi,
>
>
>>This time I have a path for the log and one for trace as well as names
>>for each of the files, and I am still getting no logging.
>>I have only access to the server database so I can't user listener.log.
>
>
>
>>Is there anything else I can do ?
>
>
>
>>Thanks
>
>
>
>
> Given most of us have no access to previous posts to this thread I
> haven't a clue what version of Oracle, what the problem is, what
> entries you have in your SQLNET.ORA file, or anything else.
>
> Expect little or no help unless there is sufficient information from
> which someone can formulate a response. Have you looked at metalink
> yet or is your firm yet another Oracle customer too cheap to pay for
> support?
> --
>
>
> My response :
>
> Sorry about that --I'm using Google groups which doesn't automatically
> paste the original message in the reply -- it's the only newsreader I
> have access to unfortunately. Anyways here's what I got in my
> sqlnet.ora --
>
> # sqlnet.ora Network Configuration File:
> D:\oracle\product\10.1.0\Client_1\NETWORK\ADMIN\sq lnet.ora
> # Generated by Oracle configuration tools.
>
> SQLNET.AUTHENTICATION_SERVICES= (NTS)
>
> TRACE_LEVEL_CLIENT = ADMIN
>
> NAMES.DIRECTORY_PATH= (TNSNAMES)
>
> TRACE_DIRECTORY_CLIENT =
> D:\oracle\product\10.1.0\Client_1\network\trace
>
> TRACE_FILE_CLIENT = sqlnet.trc
>
> LOG_FILE_CLIENT = sqlnet.log
>
> LOG_DIRECTORY_CLIENT = D:\oracle\product\10.1.0\Client_1\network\log
>
> As far as I know this company does not have metalink support.
>
> What other info would you like me to supply? I'll post my original
> message below -- once again I apologize for the lack of indentation
> to make reading clearer, but I am using Google's subpar interface.
>
>
> Thanks
>
> Original message follows --
>
> Crazy Cat
> Dec 19, 3:40 pm hide options
>
> Newsgroups: comp.databases.oracle.misc
> From: "Crazy Cat" <danbr...@hotmail.com> - Find messages by this author
>
> Date: 19 Dec 2005 12:40:36 -0800
> Local: Mon, Dec 19 2005 3:40 pm
> Subject: Oracle not logging or tracing
> Reply | Reply to Author | Forward | Print | Individual Message | Show
> original | Remove | Report Abuse
>
> Hi,
>
>
> I'm having a problem with connecting to a version 9 Oracle database
> with SQL Server 2005 and the Micrsoft Oracle Ole DB Provider with an
> Oracle 10 client. Basically when I attempt to connect to a linked
> server in SQL Server 2005 that uses the Microsoft Ole DB Provider I get
>
> the following error - Msg 7303, Level 16, State 1 Cannot initialize the
>
> data source object of OLE DB provider "MSDAORA" for linked server
> "MSORACLE".
>
>
> In attempting to get more info on the problem I discovered that
> apparently my Oracle client is not logging any errors. I went into the
> Oracle Net Manager and set the trace level to Admin and left all the
> other parameters blank (assuming that it would just write to the
> defaults), but no files are produced (sqlnet.trc or sqlnet.log).
>
>
> Am I missing something here?
>
>
> Thanks

Try this set

# Debugging Parameters
trace_level_client= 16
trace_file_client=client
trace_directory_client=c:\temp
trace_unique_client=true

Or the equivalent for your operating system if not Windows.
--
Daniel A. Morgan
http://www.psoug.org
damorgan@x.washington.edu
(replace x with u to respond)

DA Morgan wrote:
> Crazy Cat wrote:
> > Daniel A. Morgan wrote:
> > Crazy Cat wrote:
> >
> >>Hi,
> >
> >
> >>This time I have a path for the log and one for trace as well as names
> >>for each of the files, and I am still getting no logging.
> >>I have only access to the server database so I can't user listener.log.
> >
> >
> >
> >>Is there anything else I can do ?
> >
> >
> >
> >>Thanks
> >
> >
> >
> >
> > Given most of us have no access to previous posts to this thread I
> > haven't a clue what version of Oracle, what the problem is, what
> > entries you have in your SQLNET.ORA file, or anything else.
> >
> > Expect little or no help unless there is sufficient information from
> > which someone can formulate a response. Have you looked at metalink
> > yet or is your firm yet another Oracle customer too cheap to pay for
> > support?
> > --
> >
> >
> > My response :
> >
> > Sorry about that --I'm using Google groups which doesn't automatically
> > paste the original message in the reply -- it's the only newsreader I
> > have access to unfortunately. Anyways here's what I got in my
> > sqlnet.ora --
> >
> > # sqlnet.ora Network Configuration File:
> > D:\oracle\product\10.1.0\Client_1\NETWORK\ADMIN\sq lnet.ora
> > # Generated by Oracle configuration tools.
> >
> > SQLNET.AUTHENTICATION_SERVICES= (NTS)
> >
> > TRACE_LEVEL_CLIENT = ADMIN
> >
> > NAMES.DIRECTORY_PATH= (TNSNAMES)
> >
> > TRACE_DIRECTORY_CLIENT =
> > D:\oracle\product\10.1.0\Client_1\network\trace
> >
> > TRACE_FILE_CLIENT = sqlnet.trc
> >
> > LOG_FILE_CLIENT = sqlnet.log
> >
> > LOG_DIRECTORY_CLIENT = D:\oracle\product\10.1.0\Client_1\network\log
> >
> > As far as I know this company does not have metalink support.
> >
> > What other info would you like me to supply? I'll post my original
> > message below -- once again I apologize for the lack of indentation
> > to make reading clearer, but I am using Google's subpar interface.
> >
> >
> > Thanks
> >
> > Original message follows --
> >
> > Crazy Cat
> > Dec 19, 3:40 pm hide options
> >
> > Newsgroups: comp.databases.oracle.misc
> > From: "Crazy Cat" <danbr...@hotmail.com> - Find messages by this author
> >
> > Date: 19 Dec 2005 12:40:36 -0800
> > Local: Mon, Dec 19 2005 3:40 pm
> > Subject: Oracle not logging or tracing
> > Reply | Reply to Author | Forward | Print | Individual Message | Show
> > original | Remove | Report Abuse
> >
> > Hi,
> >
> >
> > I'm having a problem with connecting to a version 9 Oracle database
> > with SQL Server 2005 and the Micrsoft Oracle Ole DB Provider with an
> > Oracle 10 client. Basically when I attempt to connect to a linked
> > server in SQL Server 2005 that uses the Microsoft Ole DB Provider I get
> >
> > the following error - Msg 7303, Level 16, State 1 Cannot initialize the
> >
> > data source object of OLE DB provider "MSDAORA" for linked server
> > "MSORACLE".
> >
> >
> > In attempting to get more info on the problem I discovered that
> > apparently my Oracle client is not logging any errors. I went into the
> > Oracle Net Manager and set the trace level to Admin and left all the
> > other parameters blank (assuming that it would just write to the
> > defaults), but no files are produced (sqlnet.trc or sqlnet.log).
> >
> >
> > Am I missing something here?
> >
> >
> > Thanks
>
> Try this set
>
> # Debugging Parameters
> trace_level_client= 16
> trace_file_client=client
> trace_directory_client=c:\temp
> trace_unique_client=true
>
> Or the equivalent for your operating system if not Windows.

Hi Daniel,

(I finally found out how to quote previous messages in google -- it
wasn't very obvious).

I did this but no dice. Is there some service I should restart as well?
Thanks for your patience.

Thanks,

> --
> Daniel A. Morgan
> http://www.psoug.org
> damorgan@x.washington.edu
> (replace x with u to respond)

Crazy Cat wrote:
> DA Morgan wrote:
> > Crazy Cat wrote:
> > > Daniel A. Morgan wrote:
> > > Crazy Cat wrote:
> > >
> > >>Hi,
> > >
> > >
> > >>This time I have a path for the log and one for trace as well as names
> > >>for each of the files, and I am still getting no logging.
> > >>I have only access to the server database so I can't user listener.log.
> > >
> > >
> > >
> > >>Is there anything else I can do ?
> > >
> > >
> > >
> > >>Thanks
> > >
> > >
> > >
> > >
> > > Given most of us have no access to previous posts to this thread I
> > > haven't a clue what version of Oracle, what the problem is, what
> > > entries you have in your SQLNET.ORA file, or anything else.
> > >
> > > Expect little or no help unless there is sufficient information from
> > > which someone can formulate a response. Have you looked at metalink
> > > yet or is your firm yet another Oracle customer too cheap to pay for
> > > support?
> > > --
> > >
> > >
> > > My response :
> > >
> > > Sorry about that --I'm using Google groups which doesn't automatically
> > > paste the original message in the reply -- it's the only newsreader I
> > > have access to unfortunately. Anyways here's what I got in my
> > > sqlnet.ora --
> > >
> > > # sqlnet.ora Network Configuration File:
> > > D:\oracle\product\10.1.0\Client_1\NETWORK\ADMIN\sq lnet.ora
> > > # Generated by Oracle configuration tools.
> > >
> > > SQLNET.AUTHENTICATION_SERVICES= (NTS)
> > >
> > > TRACE_LEVEL_CLIENT = ADMIN
> > >
> > > NAMES.DIRECTORY_PATH= (TNSNAMES)
> > >
> > > TRACE_DIRECTORY_CLIENT =
> > > D:\oracle\product\10.1.0\Client_1\network\trace
> > >
> > > TRACE_FILE_CLIENT = sqlnet.trc
> > >
> > > LOG_FILE_CLIENT = sqlnet.log
> > >
> > > LOG_DIRECTORY_CLIENT = D:\oracle\product\10.1.0\Client_1\network\log
> > >
> > > As far as I know this company does not have metalink support.
> > >
> > > What other info would you like me to supply? I'll post my original
> > > message below -- once again I apologize for the lack of indentation
> > > to make reading clearer, but I am using Google's subpar interface.
> > >
> > >
> > > Thanks
> > >
> > > Original message follows --
> > >
> > > Crazy Cat
> > > Dec 19, 3:40 pm hide options
> > >
> > > Newsgroups: comp.databases.oracle.misc
> > > From: "Crazy Cat" <danbr...@hotmail.com> - Find messages by this author
> > >
> > > Date: 19 Dec 2005 12:40:36 -0800
> > > Local: Mon, Dec 19 2005 3:40 pm
> > > Subject: Oracle not logging or tracing
> > > Reply | Reply to Author | Forward | Print | Individual Message | Show
> > > original | Remove | Report Abuse
> > >
> > > Hi,
> > >
> > >
> > > I'm having a problem with connecting to a version 9 Oracle database
> > > with SQL Server 2005 and the Micrsoft Oracle Ole DB Provider with an
> > > Oracle 10 client. Basically when I attempt to connect to a linked
> > > server in SQL Server 2005 that uses the Microsoft Ole DB Provider I get
> > >
> > > the following error - Msg 7303, Level 16, State 1 Cannot initialize the
> > >
> > > data source object of OLE DB provider "MSDAORA" for linked server
> > > "MSORACLE".
> > >
> > >
> > > In attempting to get more info on the problem I discovered that
> > > apparently my Oracle client is not logging any errors. I went into the
> > > Oracle Net Manager and set the trace level to Admin and left all the
> > > other parameters blank (assuming that it would just write to the
> > > defaults), but no files are produced (sqlnet.trc or sqlnet.log).
> > >
> > >
> > > Am I missing something here?
> > >
> > >
> > > Thanks
> >
> > Try this set
> >
> > # Debugging Parameters
> > trace_level_client= 16
> > trace_file_client=client
> > trace_directory_client=c:\temp
> > trace_unique_client=true
> >
> > Or the equivalent for your operating system if not Windows.
>
> Hi Daniel,
>
> (I finally found out how to quote previous messages in google -- it
> wasn't very obvious).
>
> I did this but no dice. Is there some service I should restart as well?
> Thanks for your patience.
>
> Thanks,
>
> > --
> > Daniel A. Morgan
> > http://www.psoug.org
> > damorgan@x.washington.edu
> > (replace x with u to respond)

Don't know what happened, but I went back to check the directory where
the trace data should be and now I'm getting trace logs !!!

Thanks much

Crazy Cat wrote:
> DA Morgan wrote:
>
>>Crazy Cat wrote:
>>
>>>Daniel A. Morgan wrote:
>>>Crazy Cat wrote:
>>>
>>>
>>>>Hi,
>>>
>>>
>>>>This time I have a path for the log and one for trace as well as names
>>>>for each of the files, and I am still getting no logging.
>>>>I have only access to the server database so I can't user listener.log.
>>>
>>>
>>>
>>>>Is there anything else I can do ?
>>>
>>>
>>>
>>>>Thanks
>>>
>>>
>>>
>>>
>>>Given most of us have no access to previous posts to this thread I
>>>haven't a clue what version of Oracle, what the problem is, what
>>>entries you have in your SQLNET.ORA file, or anything else.
>>>
>>>Expect little or no help unless there is sufficient information from
>>>which someone can formulate a response. Have you looked at metalink
>>>yet or is your firm yet another Oracle customer too cheap to pay for
>>>support?
>>>--
>>>
>>>
>>>My response :
>>>
>>>Sorry about that --I'm using Google groups which doesn't automatically
>>>paste the original message in the reply -- it's the only newsreader I
>>>have access to unfortunately. Anyways here's what I got in my
>>>sqlnet.ora --
>>>
>>># sqlnet.ora Network Configuration File:
>>>D:\oracle\product\10.1.0\Client_1\NETWORK\ADMIN \sqlnet.ora
>>># Generated by Oracle configuration tools.
>>>
>>>SQLNET.AUTHENTICATION_SERVICES= (NTS)
>>>
>>>TRACE_LEVEL_CLIENT = ADMIN
>>>
>>>NAMES.DIRECTORY_PATH= (TNSNAMES)
>>>
>>>TRACE_DIRECTORY_CLIENT =
>>>D:\oracle\product\10.1.0\Client_1\network\tra ce
>>>
>>>TRACE_FILE_CLIENT = sqlnet.trc
>>>
>>>LOG_FILE_CLIENT = sqlnet.log
>>>
>>>LOG_DIRECTORY_CLIENT = D:\oracle\product\10.1.0\Client_1\network\log
>>>
>>>As far as I know this company does not have metalink support.
>>>
>>>What other info would you like me to supply? I'll post my original
>>>message below -- once again I apologize for the lack of indentation
>>>to make reading clearer, but I am using Google's subpar interface.
>>>
>>>
>>>Thanks
>>>
>>>Original message follows --
>>>
>>>Crazy Cat
>>> Dec 19, 3:40 pm hide options
>>>
>>>Newsgroups: comp.databases.oracle.misc
>>>From: "Crazy Cat" <danbr...@hotmail.com> - Find messages by this author
>>>
>>>Date: 19 Dec 2005 12:40:36 -0800
>>>Local: Mon, Dec 19 2005 3:40 pm
>>>Subject: Oracle not logging or tracing
>>>Reply | Reply to Author | Forward | Print | Individual Message | Show
>>>original | Remove | Report Abuse
>>>
>>>Hi,
>>>
>>>
>>>I'm having a problem with connecting to a version 9 Oracle database
>>>with SQL Server 2005 and the Micrsoft Oracle Ole DB Provider with an
>>>Oracle 10 client. Basically when I attempt to connect to a linked
>>>server in SQL Server 2005 that uses the Microsoft Ole DB Provider I get
>>>
>>>the following error - Msg 7303, Level 16, State 1 Cannot initialize the
>>>
>>>data source object of OLE DB provider "MSDAORA" for linked server
>>>"MSORACLE".
>>>
>>>
>>> In attempting to get more info on the problem I discovered that
>>>apparently my Oracle client is not logging any errors. I went into the
>>>Oracle Net Manager and set the trace level to Admin and left all the
>>>other parameters blank (assuming that it would just write to the
>>>defaults), but no files are produced (sqlnet.trc or sqlnet.log).
>>>
>>>
>>>Am I missing something here?
>>>
>>>
>>>Thanks
>>
>>Try this set
>>
>># Debugging Parameters
>>trace_level_client= 16
>>trace_file_client=client
>>trace_directory_client=c:\temp
>>trace_unique_client=true
>>
>>Or the equivalent for your operating system if not Windows.
>
>
> Hi Daniel,
>
> (I finally found out how to quote previous messages in google -- it
> wasn't very obvious).
>
> I did this but no dice. Is there some service I should restart as well?
> Thanks for your patience.
>
> Thanks,
>
>
>>--
>>Daniel A. Morgan
>>http://www.psoug.org
>>damorgan@x.washington.edu
>>(replace x with u to respond)

Still top posting. Can you find a solution to that too?

No there is nothing to start though you might want to restart the
listener and do a FIND for *log on every directory under ORACLE_BASE.
--
Daniel A. Morgan
http://www.psoug.org
damorgan@x.washington.edu
(replace x with u to respond)

Crazy Cat wrote:
> Crazy Cat wrote:
>
>>DA Morgan wrote:
>>
>>>Crazy Cat wrote:
>>>
>>>>Daniel A. Morgan wrote:
>>>>Crazy Cat wrote:
>>>>
>>>>
>>>>>Hi,
>>>>
>>>>
>>>>>This time I have a path for the log and one for trace as well as names
>>>>>for each of the files, and I am still getting no logging.
>>>>>I have only access to the server database so I can't user listener.log.
>>>>
>>>>
>>>>
>>>>>Is there anything else I can do ?
>>>>
>>>>
>>>>
>>>>>Thanks
>>>>
>>>>
>>>>
>>>>
>>>>Given most of us have no access to previous posts to this thread I
>>>>haven't a clue what version of Oracle, what the problem is, what
>>>>entries you have in your SQLNET.ORA file, or anything else.
>>>>
>>>>Expect little or no help unless there is sufficient information from
>>>>which someone can formulate a response. Have you looked at metalink
>>>>yet or is your firm yet another Oracle customer too cheap to pay for
>>>>support?
>>>>--
>>>>
>>>>
>>>>My response :
>>>>
>>>>Sorry about that --I'm using Google groups which doesn't automatically
>>>>paste the original message in the reply -- it's the only newsreader I
>>>>have access to unfortunately. Anyways here's what I got in my
>>>>sqlnet.ora --
>>>>
>>>># sqlnet.ora Network Configuration File:
>>>>D:\oracle\product\10.1.0\Client_1\NETWORK\ADMI N\sqlnet.ora
>>>># Generated by Oracle configuration tools.
>>>>
>>>>SQLNET.AUTHENTICATION_SERVICES= (NTS)
>>>>
>>>>TRACE_LEVEL_CLIENT = ADMIN
>>>>
>>>>NAMES.DIRECTORY_PATH= (TNSNAMES)
>>>>
>>>>TRACE_DIRECTORY_CLIENT =
>>>>D:\oracle\product\10.1.0\Client_1\network\trac e
>>>>
>>>>TRACE_FILE_CLIENT = sqlnet.trc
>>>>
>>>>LOG_FILE_CLIENT = sqlnet.log
>>>>
>>>>LOG_DIRECTORY_CLIENT = D:\oracle\product\10.1.0\Client_1\network\log
>>>>
>>>>As far as I know this company does not have metalink support.
>>>>
>>>>What other info would you like me to supply? I'll post my original
>>>>message below -- once again I apologize for the lack of indentation
>>>>to make reading clearer, but I am using Google's subpar interface.
>>>>
>>>>
>>>>Thanks
>>>>
>>>>Original message follows --
>>>>
>>>>Crazy Cat
>>>> Dec 19, 3:40 pm hide options
>>>>
>>>>Newsgroups: comp.databases.oracle.misc
>>>>From: "Crazy Cat" <danbr...@hotmail.com> - Find messages by this author
>>>>
>>>>Date: 19 Dec 2005 12:40:36 -0800
>>>>Local: Mon, Dec 19 2005 3:40 pm
>>>>Subject: Oracle not logging or tracing
>>>>Reply | Reply to Author | Forward | Print | Individual Message | Show
>>>>original | Remove | Report Abuse
>>>>
>>>>Hi,
>>>>
>>>>
>>>>I'm having a problem with connecting to a version 9 Oracle database
>>>>with SQL Server 2005 and the Micrsoft Oracle Ole DB Provider with an
>>>>Oracle 10 client. Basically when I attempt to connect to a linked
>>>>server in SQL Server 2005 that uses the Microsoft Ole DB Provider I get
>>>>
>>>>the following error - Msg 7303, Level 16, State 1 Cannot initialize the
>>>>
>>>>data source object of OLE DB provider "MSDAORA" for linked server
>>>>"MSORACLE".
>>>>
>>>>
>>>> In attempting to get more info on the problem I discovered that
>>>>apparently my Oracle client is not logging any errors. I went into the
>>>>Oracle Net Manager and set the trace level to Admin and left all the
>>>>other parameters blank (assuming that it would just write to the
>>>>defaults), but no files are produced (sqlnet.trc or sqlnet.log).
>>>>
>>>>
>>>>Am I missing something here?
>>>>
>>>>
>>>>Thanks
>>>
>>>Try this set
>>>
>>># Debugging Parameters
>>>trace_level_client= 16
>>>trace_file_client=client
>>>trace_directory_client=c:\temp
>>>trace_unique_client=true
>>>
>>>Or the equivalent for your operating system if not Windows.
>>
>>Hi Daniel,
>>
>>(I finally found out how to quote previous messages in google -- it
>>wasn't very obvious).
>>
>>I did this but no dice. Is there some service I should restart as well?
>>Thanks for your patience.
>>
>>Thanks,
>>
>>
>>>--
>>>Daniel A. Morgan
>>>http://www.psoug.org
>>>damorgan@x.washington.edu
>>>(replace x with u to respond)
>
>
> Don't know what happened, but I went back to check the directory where
> the trace data should be and now I'm getting trace logs !!!
>
> Thanks much

And you stopped top posting too. A victory on all fronts.

Glad you were successful.
--
Daniel A. Morgan
http://www.psoug.org
damorgan@x.washington.edu
(replace x with u to respond)