Home » RDBMS Server » Networking and Gateways » Problem Tracing JDBC Connection
Problem Tracing JDBC Connection [message #66509] Thu, 11 July 2002 00:07 Go to next message
B
Messages: 327
Registered: August 1999
Senior Member
Hi Every body !

I've some trouble. I've a client using JDBC and it seems there is some trouble with the connection ( loosing it and don't know why ). I've set the server and client in trace mode SUPPORT ( and i've try the ADMIN mode too ) up.
TRACE_LEVEL_CLIENT=SUPPORT
TRACE_LEVEL_SERVER=SUPPORT
TRACE_UNIQUE_CLIENT=ON
in the sqlnet.ora but when my JDBC client connect the database i've got any traces ? Others connections are traced ... seems weard ( to me .... ).

I'm using Oracle 8.1.7.1 on SUN SOLARIS 2.8.

Any Idea ??? Please....
Ooops Another Question [message #66510 is a reply to message #66509] Thu, 11 July 2002 00:10 Go to previous messageGo to next message
B
Messages: 327
Registered: August 1999
Senior Member
Hi again !

Somebody know why
trcasst return an internal error when i use it on trace generated in SUPPORT MODE ?
works fine with ADMIN MODE ... still in 8171 ...

Thanks ....
Re: Ooops Another Question [message #66513 is a reply to message #66510] Thu, 11 July 2002 13:08 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
May be the known bug (trailing spaces)??
Remove the trailing space after function name for hex packet dump.
1. Open the sqlnet trace file.
2. Search for nspsend and nsprecv.
3. For each nspsend and nsprecv entry, remove the space between the : and the
hex packet dump.
4. Save edited file.
5. Run Trace Assistant 

------------------------------------------------------
But im not sure. Becuase you sayin, that trace from ADMIN mode is good?
Thanks a lot Mahesh ... but know this ? [message #66514 is a reply to message #66510] Fri, 12 July 2002 00:06 Go to previous messageGo to next message
B
Messages: 327
Registered: August 1999
Senior Member
Hi Mahesh !

In fact the true priblemn is not ADMIN or SUPPORT mode.
Did you know why i can't trace my client using JDBC ???
When the client connect the database, or do something, i've got any traces ! And i don't understand why ...

Thanks ! ( a lot )
Re: Thanks a lot Mahesh ... but know this ? [message #66517 is a reply to message #66510] Fri, 12 July 2002 12:17 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
I beleive, you need to use OracleLog.
OracleLog class is accessible when you use
'import oracle.jdbc.driver.*'.
Previous Topic: Re: Transparent Gateway
Next Topic: No Listener error
Goto Forum:
  


Current Time: Wed Feb 28 04:07:35 CST 2024