OraFAQ Forum: Networking and Gateways » log file for connections

Home » RDBMS Server » Networking and Gateways » log file for connections

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

log file for connections [message #263024]

Tue, 28 August 2007 14:58

Koolwant
Messages: 49
Registered: June 2007
Location: new jersey

Member

Hey Experts

OS:- redhat enterprise linux 4
DB:- 10.2.0.1
Po
Does somebody know , if there is any connections.log in Oracle

I am trying to connect to database through JDBC connections on another server.I dont know much about JDBC connections .
All I know is we are trying to connect from .50 to .51 and we are getting login failed . I am wondering that if there is any connections.log so that I can figure out what can be the cause.

Thanks

Report message to a moderator

Re: log file for connections [message #263025 is a reply to message #263024]

Tue, 28 August 2007 15:05

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

Check listener.log

Report message to a moderator

Re: log file for connections [message #263027 is a reply to message #263025]

Tue, 28 August 2007 15:14

Koolwant
Messages: 49
Registered: June 2007
Location: new jersey

Member

If I'm not wrong,listener.log does have information only that which connection is established and which is not. But if I want to know that why the connection was not established then what can I do.

Thanks
& Regards

[Updated on: Tue, 28 August 2007 15:14]

Report message to a moderator

Re: log file for connections [message #263028 is a reply to message #263027]

Tue, 28 August 2007 15:23

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

Yes you are right.

What kind of ERROR you got?

Report message to a moderator

Re: log file for connections [message #263043 is a reply to message #263024]

Tue, 28 August 2007 22:24

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

if I want to know that why the connection was not established then what can I do.

First check your jdbc url. Whether computer name/ ip address is set properly or not. Database name is set properly or net.

Then check the username and password of the database.

Based on that take necessary steps.

Regards,
Mohammad Abdul Momin Arju,
Islamic University of Technology(IUT).

Report message to a moderator

Re: log file for connections [message #263337 is a reply to message #263043]

Wed, 29 August 2007 14:14

Koolwant
Messages: 49
Registered: June 2007
Location: new jersey

Member

Thanks DreamzZ,Mohammad

It's kind of difficult for me to understand , coz I am working together with crystal report , JDBC . I am not able to understand anything at this moment.
The error I'm getting is Database Connector Error:Not Implemented:- when I'm trying to generate crystal report.

Another error was
Logon Error: I/O Exception :The network adapter could not establish the connection .

Also I'm not getting any error in alert.log and I'm also checking listener.log from which i could not get much information.

Thanks

Report message to a moderator

Re: log file for connections [message #263350 is a reply to message #263337]

Wed, 29 August 2007 15:40

Koolwant
Messages: 49
Registered: June 2007
Location: new jersey

Member

Hello

Ya I came to know that the problem was with crystal report .rpt files.So they figured it out .

Thanks for your time and valuable advise.

Regards

Report message to a moderator

Re: log file for connections [message #263351 is a reply to message #263350]

Wed, 29 August 2007 15:58

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

Thanks for your feedback.

Report message to a moderator

Previous Topic:	TNS-01155: Incorrectly specified SID_LIST_LISTENER parameter in LISTENER.ORA
Next Topic:	ORA-20000: Oracle Text error:DRG-10599: column is not indexed

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Nov 25 19:37:42 CST 2024