Home » RDBMS Server » Networking and Gateways » unable to connect to a database
unable to connect to a database [message #513354] Mon, 27 June 2011 00:48 Go to next message
Lama
Messages: 45
Registered: February 2006
Member
am getting this message when am connecting to a database :

ora-12519:Message 12519 not found;product=RDBMS80 facility = ORA

am not getting this message all the time, sometimes am connected without any problem sometimes i get this message and i have to try again several times until am connected

i searched the net and my database provider guided me to this log --> http://www.orafaq.com/forum/t/62379/0/

so am not sure if this is the cause and am not sure how to
set my ORACLE_HOME environment variable and with what ....

Report message to a moderator

Re: unable to connect to a database [message #513355 is a reply to message #513354] Mon, 27 June 2011 00:59 Go to previous messageGo to next message
Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
 
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.


Regards
Michel

Report message to a moderator

Re: unable to connect to a database [message #513356 is a reply to message #513355] Mon, 27 June 2011 01:10 Go to previous messageGo to next message
Lama
Messages: 45
Registered: February 2006
Member
Dear Michel thanks for the reply

i'll explain my case in details , we are connected to a remote database , our database provider gave us the tnsnames.ora and then we are connected ...
now in the past we didnt face a problem but recently we are getting this message many times but on the same client sometimes we are able to connect and sometimes we are getting this message and we have to try again ( without changing anything on the pc ) and then we are connected ...

so am not sure if this is sth to do with oracle_home in the environment variable and if yes ... what is the value that i should set my oracle_home with

Report message to a moderator

Re: unable to connect to a database [message #513357 is a reply to message #513356] Mon, 27 June 2011 01:20 Go to previous messageGo to next message
Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Maybe sometimes the service is up and sometimes it is not.
Activate SQL*Net trace if you want more.
Did you try the mentioned action?

Regards
Michel

Report message to a moderator

Re: unable to connect to a database [message #513369 is a reply to message #513357] Mon, 27 June 2011 02:16 Go to previous messageGo to next message
Lama
Messages: 45
Registered: February 2006
Member
Dear Michel,
this should be done on the server right? but i dont have access to the server and our provider insists that the problem is a client issue ...

so how can i be sure that the problem is from the database service or from our clients pc's

thanks alot

Report message to a moderator

Re: unable to connect to a database [message #513373 is a reply to message #513369] Mon, 27 June 2011 02:39 Go to previous messageGo to next message
Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Activate SQL*Net trace on the client.

Regards
Michel

Report message to a moderator

Re: unable to connect to a database [message #513402 is a reply to message #513369] Mon, 27 June 2011 06:23 Go to previous messageGo to next message
Lama
Messages: 45
Registered: February 2006
Member
please i need an answer so i can take a decision for our database provider , is it a client or database issue ?

Report message to a moderator

Re: unable to connect to a database [message #513404 is a reply to message #513402] Mon, 27 June 2011 06:31 Go to previous messageGo to next message
Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Please activate trace as we are NOT at your place and CAN'T know what problem you have.

Regards
Michel

[Updated on: Mon, 27 June 2011 06:31]

Report message to a moderator

Re: unable to connect to a database [message #513604 is a reply to message #513404] Tue, 28 June 2011 06:37 Go to previous messageGo to next message
Lama
Messages: 45
Registered: February 2006
Member
Dear Michel ,
how can i Activate SQL*Net trace , i dont have the server ... i might ask this from our database provider but from my side is the setting of oracle home in the environment variables might solve the problem ? if yes , then with what should I set it ?

Report message to a moderator

Re: unable to connect to a database [message #513616 is a reply to message #513604] Tue, 28 June 2011 07:01 Go to previous message
Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Michel Cadot wrote on Mon, 27 June 2011 09:39
Activate SQL*Net trace on the client.

Regards
Michel


See http://download.oracle.com/docs/cd/B19306_01/network.102/b14213/toc.htm, search TRACE on the page.

[Updated on: Tue, 28 June 2011 07:02]

Report message to a moderator

Previous Topic: Sun OS
Next Topic: Find list of database links
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Feb 08 11:23:27 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.