OraFAQ Forum: Networking and Gateways » Problem Tracing JDBC Connection

Home » RDBMS Server » Networking and Gateways » Problem Tracing JDBC Connection

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Problem Tracing JDBC Connection [message #66509]

Thu, 11 July 2002 00:07

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....

Report message to a moderator

Ooops Another Question [message #66510 is a reply to message #66509]

Thu, 11 July 2002 00:10

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 ....

Report message to a moderator

Re: Ooops Another Question [message #66513 is a reply to message #66510]

Thu, 11 July 2002 13:08

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?

Report message to a moderator

Thanks a lot Mahesh ... but know this ? [message #66514 is a reply to message #66510]

Fri, 12 July 2002 00:06

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 )

Report message to a moderator

Re: Thanks a lot Mahesh ... but know this ? [message #66517 is a reply to message #66510]

Fri, 12 July 2002 12:17

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.*'.

Report message to a moderator

Previous Topic:	Re: Transparent Gateway
Next Topic:	No Listener error

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 18 13:05:33 CDT 2024