Home » RDBMS Server » Networking and Gateways » How to Connect to Oracle
icon8.gif  How to Connect to Oracle [message #132421] Fri, 12 August 2005 12:06 Go to next message
sureddi
Messages: 10
Registered: June 2005
Location: Houston
Junior Member

HI ,

Iam facing this problem from last 2 days but still i could not resolve the problem.

Iam able to connect to my database using userid and password.
If I use host string it was not connecting and even from the remote system.Iam sure that listener.ora file and tnsnames.ora file are correct.when iam trying to connect to oracle from pl/sql Iam getting this message.
TNS-12541 :No Listner
TNS-12560 : TNS PROTOCOL ADAPTER ERROR


THE BELOW 2 ERRORS CAM WHEN I TRY TO CONNECT THROUGH COMMAND PROMPT
TNS--00511 NO LISTNER
32 BIT WINDOWS ERROR 61:UNKNOWN ERROR


WHEN I went to services and check I find that Oracle service is running and listner service is not running.when I try to start Iam getting this error message.

Could not start the oracle orahome 81TNSlistnertracit service on local computer.
The service did not return an error.This could be an internal windows error or an internal service error.If the problem Persist Contact your system administrator.

Bye
Sri
Re: How to Connect to Oracle [message #132875 is a reply to message #132421] Tue, 16 August 2005 08:50 Go to previous messageGo to next message
Uwe
Messages: 260
Registered: February 2003
Location: Z├╝rich, Switzerland
Senior Member
Hi Sri,

Than it may be possible that the listener.ora is misconfigured.
Most times it is because tome brackets are missing or to much.

It could help to post the listener.ora so we could see and tell you if there's something.

Uwe

Re: How to Connect to Oracle [message #226690 is a reply to message #132421] Mon, 26 March 2007 03:49 Go to previous messageGo to next message
daniele75
Messages: 2
Registered: March 2007
Junior Member
Hi all.
From this morning we have the same problem.
Friday evening Oracle was OK, on monday server has restarted (like any other friday, via scheduled job), and this morning oracle listener doesn't start, wuth any type of error in log.
Anyone has solved the problem?

Thanks a lot
Daniele
Re: How to Connect to Oracle [message #227137 is a reply to message #226690] Tue, 27 March 2007 07:26 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,
wuth any type of error in log.

Are you check listener.log file for any error.


regards
Taj
Re: How to Connect to Oracle [message #227169 is a reply to message #227137] Tue, 27 March 2007 08:15 Go to previous messageGo to next message
daniele75
Messages: 2
Registered: March 2007
Junior Member
Sorry sorry sorry and sorry Sad

I've discovered that an external company have modified listener.ora and tnsnames.ora Sad

I've commented out new row, and now all works properly again.

Thanks for your reply and sorry again

Bye
Re: How to Connect to Oracle [message #227181 is a reply to message #227169] Tue, 27 March 2007 08:24 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Sorry sorry sorry and sorry

Sorry for what ?

Happy you solve your problem Wink
regards
Taj
Previous Topic: Problem in Oracle Networking.
Next Topic: How to create a DB link
Goto Forum:
  


Current Time: Mon Dec 05 09:16:27 CST 2016

Total time taken to generate the page: 0.11425 seconds