OraFAQ Forum: Networking and Gateways » How to Connect to Oracle

Home » RDBMS Server » Networking and Gateways » How to Connect to Oracle

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

How to Connect to Oracle [message #132421]

Fri, 12 August 2005 12:06

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

Report message to a moderator

Re: How to Connect to Oracle [message #132875 is a reply to message #132421]

Tue, 16 August 2005 08:50

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

Report message to a moderator

Re: How to Connect to Oracle [message #226690 is a reply to message #132421]

Mon, 26 March 2007 03:49

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

Report message to a moderator

Re: How to Connect to Oracle [message #227137 is a reply to message #226690]

Tue, 27 March 2007 07:26

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

Report message to a moderator

Re: How to Connect to Oracle [message #227169 is a reply to message #227137]

Tue, 27 March 2007 08:15

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

Report message to a moderator

Re: How to Connect to Oracle [message #227181 is a reply to message #227169]

Tue, 27 March 2007 08:24

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

Report message to a moderator

Previous Topic:	Problem in Oracle Networking.
Next Topic:	How to create a DB link

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 22 14:36:29 CST 2024