OraFAQ Forum: Networking and Gateways » 4 types of connection errors

Home » RDBMS Server » Networking and Gateways » 4 types of connection errors

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

4 types of connection errors [message #266663]

Tue, 11 September 2007 06:02

aviana
Messages: 106
Registered: July 2007

Senior Member

I need to understand the difference between the 4 types of errors I am getting while trying to connect and their solutions pls

--Error1

SQL> conn sys@geodr as sysdba
Enter password:
ERROR:
ORA-12519: TNS:no appropriate service handler found

--Error2

SQL> conn sys@gebdmc02 as sysdba
Enter password:
ERROR:
ORA-12514: TNS:listener could not resolve SERVICE_NAME given in -connect descriptor

--Error3

SQL> conn sys@ttpdmc01 as sysdba
Enter password:
ERROR:
ORA-12541: TNS:no listener

--Error4

SQL> conn sys as sysdba
Enter password:
ERROR:
ORA-12560: TNS:protocol adapter error

Thanks much.

[Updated on: Tue, 11 September 2007 06:14]

Report message to a moderator

Re: 4 types of connection errors [message #266667 is a reply to message #266663]

Tue, 11 September 2007 06:16

ThomasG
Messages: 3212
Registered: April 2005
Location: Heilbronn, Germany

Senior Member

Look them up on http://www.ora-code.com/ or www.google.com.

Then you get the basic cause/action description, like for example :

ORA-12519:	TNS:no appropriate service handler found
Cause:	The listener could not find any available service 
        handlers that are appropriate for the client 
        connection.
Action:	Run "lsnrctl services" to ensure that the instance(s) 
        have registered with the listener, and are 
        accepting connections.

Report message to a moderator

Re: 4 types of connection errors [message #266766 is a reply to message #266667]

Tue, 11 September 2007 10:32

aviana
Messages: 106
Registered: July 2007

Senior Member

Thomas,Thanks for the link.It was indeed very helpful
Now something related to an error message,which I am not clear about.Pls see below:-

ORA-12519: TNS:no appropriate service handler found 
Cause: The listener could not find any available service handlers that are appropriate for the client connection. 
Action: Run "lsnrctl services" to ensure that the instance(s) have registered with the listener, and are accepting connections.

In the above, what is, lsnrctl services and where is it located?How will I run it and how will I check it?

[Updated on: Tue, 11 September 2007 10:33]

Report message to a moderator

Re: 4 types of connection errors [message #266882 is a reply to message #266663]

Tue, 11 September 2007 22:21

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

Senior Member

Your Oracle Version?

Report message to a moderator

Re: 4 types of connection errors [message #266926 is a reply to message #266882]

Wed, 12 September 2007 00:51

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

Hi,
Most possible reason for below 4 errors message. or if I say whenever you recevied below four errors first check ...

1. ORA-12519: TNS:no appropriate service handler found 

Suggestion: Increase PROCESSES parameter value. (It is not modifiable parameter means you have to shutdown/startup for change processes parameter.
or 
Check LISTENER.LOG file.

2. ORA-12514: TNS:listener could not resolve SERVICE_NAME given in -connect descriptor

Suggestion: Change listener registration from DYNAMIC to STATIC.
http://dbataj.blogspot.com/2007/02/ora-12514.html
or
sometime you will get this error when database is not open

3. ORA-12541: TNS:no listener

Suggestion: start your listener LSNRCTL START

4. ORA-12560: TNS:protocol adapter error

Suggestion: start Oracle Services. NET START OracleServiceSID
or
If database created through manually then first set ORACLE_SID enviourment variable.

Regards
Mohammed Taj

Report message to a moderator

Re: 4 types of connection errors [message #385004 is a reply to message #266926]

Fri, 06 February 2009 01:50

ramoradba
Messages: 2457
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...

Senior Member

Hi taj,thanks for reply.
i am using windows 2003 server.oracle 10.2.0.1.based on your post,i modified my processes parameter 150 to 600.so now my issue is which parameters should i check,to mailtain the availability,performance.(processes & no of session are co relative am i correct?)
regards
sriram

Report message to a moderator

Previous Topic:	Oracle Virtual Directory - Net Service Name Resolution
Next Topic:	Whether the Database client should be installed in the server (Unix box)?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 08 11:19:27 CST 2025