Home » RDBMS Server » Networking and Gateways » log file for connections
log file for connections [message #263024] Tue, 28 August 2007 14:58 Go to next message
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


Re: log file for connections [message #263025 is a reply to message #263024] Tue, 28 August 2007 15:05 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Check listener.log
Re: log file for connections [message #263027 is a reply to message #263025] Tue, 28 August 2007 15:14 Go to previous messageGo to next message
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 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Yes you are right.

What kind of ERROR you got?
Re: log file for connections [message #263043 is a reply to message #263024] Tue, 28 August 2007 22:24 Go to previous messageGo to next message
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).
Re: log file for connections [message #263337 is a reply to message #263043] Wed, 29 August 2007 14:14 Go to previous messageGo to next message
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

Re: log file for connections [message #263350 is a reply to message #263337] Wed, 29 August 2007 15:40 Go to previous messageGo to next message
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

Re: log file for connections [message #263351 is a reply to message #263350] Wed, 29 August 2007 15:58 Go to previous message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Thanks for your feedback.
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:
  


Current Time: Sun Dec 08 17:40:26 CST 2024