Home » RDBMS Server » Server Administration » ORA-12519, Listener refused the connection
ORA-12519, Listener refused the connection [message #293671] Mon, 14 January 2008 09:07 Go to next message
umair.mehmood
Messages: 3
Registered: January 2008
Junior Member
Hello!
The listener starts behaving very strange and refuses connections after sometime, giving the following error:

java.sql.SQLException\: Listener refused the connection with the
following error\:\nORA-12519, TN


One solution for this Oracle error is to restart the listener, i tried to restart it but it doesn't allow:

LSNRCTL> stop
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC_FOR_XE)))
The command completed successfully
LSNRCTL> start
Starting /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 10.2.0.1.0 - Production
NL-00280: error creating log stream /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/network/log/listener.log
NL-00278: cannot open log file
SNL-00016: snlfohd: error opening file
Linux Error: 13: Permission denied


Finally the host has to be restarted and then it works fine.
Any help would be appreciated.
Re: ORA-12519, Listener refused the connection [message #293674 is a reply to message #293671] Mon, 14 January 2008 09:45 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

>Linux Error: 13: Permission denied
Do you have proper permission on oracle folder ?
Re: ORA-12519, Listener refused the connection [message #293679 is a reply to message #293674] Mon, 14 January 2008 10:02 Go to previous messageGo to next message
umair.mehmood
Messages: 3
Registered: January 2008
Junior Member
Oh yes. I have all the necessary permissions on the Oracle Folder.
That's the reason it works for few days and then it eventually crashes.
Re: ORA-12519, Listener refused the connection [message #293686 is a reply to message #293671] Mon, 14 January 2008 10:10 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
post the output from the following command back here
df -k
Re: ORA-12519, Listener refused the connection [message #293809 is a reply to message #293686] Tue, 15 January 2008 02:37 Go to previous message
umair.mehmood
Messages: 3
Registered: January 2008
Junior Member
(Formatting of this editor does not help)[mod-edit] yes it does
Filesystem           1K-blocks      Used Available Use% Mounted on
/dev/mapper/VolGroup00-LogVolRoot
                      37993992   1674780  34389180   5% /

/dev/sda1               124427     14058    103945  12% /boot
none                   1027868         0   1027868   0% /dev/shm
/dev/mapper/VolGroup00-LogVolHome
                      15126920   5454500   8904012  38% /home
/dev/mapper/VolGroup00-LogVolUsr
                      15126920   9302916   5055596  65% /usr

[Updated on: Tue, 15 January 2008 08:23] by Moderator

Report message to a moderator

Previous Topic: instance
Next Topic: dbms_aw package creation
Goto Forum:
  


Current Time: Mon Dec 02 05:31:17 CST 2024