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\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\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..._at_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_at_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_at_x.washington.edu
(replace x with u to respond)
Received on Thu Dec 22 2005 - 10:53:53 CST
