Home » RDBMS Server » Networking and Gateways » 4 types of connection errors
4 types of connection errors [message #266663] Tue, 11 September 2007 06:02 Go to next message
aviana
Messages: 101
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 Go to previous messageGo to next message
ThomasG
Messages: 3189
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.
Re: 4 types of connection errors [message #266766 is a reply to message #266667] Tue, 11 September 2007 10:32 Go to previous messageGo to next message
aviana
Messages: 101
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 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Your Oracle Version?
Re: 4 types of connection errors [message #266926 is a reply to message #266882] Wed, 12 September 2007 00:51 Go to previous messageGo to next message
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
Re: 4 types of connection errors [message #385004 is a reply to message #266926] Fri, 06 February 2009 01:50 Go to previous message
ramoradba
Messages: 2454
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
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:
  


Current Time: Sun Dec 04 10:24:00 CST 2016

Total time taken to generate the page: 0.37171 seconds