OraFAQ Forum: Networking and Gateways » unable to connect to a database

Home » RDBMS Server » Networking and Gateways » unable to connect to a database

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

unable to connect to a database [message #513354]

Mon, 27 June 2011 00:48

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

Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...

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

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

Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...

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

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

Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...

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

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

Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...

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

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

Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 09:37:26 CDT 2024