Home » SQL & PL/SQL » Client Tools » listener refused the connection with the following error:ORA12505
listener refused the connection with the following error:ORA12505 [message #679205] Sat, 15 February 2020 11:46 Go to next message
syed.javid.ali.ali@gmail.
Messages: 10
Registered: February 2020
Junior Member
listener refused the connection with the following error:ORA12505.

Iam new to this sql developer. i want to create a database and work on it. but iam not able to make a database. it is showing error as

listener refused the connection with the following error:ORA12505.

Can anyone help on this.
Re: listener refused the connection with the following error:ORA12505 [message #679206 is a reply to message #679205] Sat, 15 February 2020 12:09 Go to previous messageGo to next message
Michel Cadot
Messages: 67135
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA-12505: TNS:listener does not currently know of SID given in connect descriptor
 *Cause:  The listener received a request to establish a connection to a
 database or other service. The connect descriptor received by the listener
 specified a SID for an instance (usually a database instance) that either
 has not yet dynamically registered with the listener or has not been
 statically configured for the listener. This may be a temporary condition
 such as after the listener has started, but before the database instance
 has registered with the listener.
 *Action:
  - Wait a moment and try to connect a second time.
  - Check which instances are currently known by the listener by executing:
    lsnrctl services <listener name>
  - Check that the SID parameter in the connect descriptor specifies
    an instance known by the listener.
  - Check for an event in the listener.log file.
Re: listener refused the connection with the following error:ORA12505 [message #679207 is a reply to message #679205] Sat, 15 February 2020 12:47 Go to previous messageGo to next message
EdStevens
Messages: 1206
Registered: September 2013
Senior Member
Typically one would not use SQL Dev to create a database. That is what the 'dbca' utility is for. SQL Dev expects to connect to an existing database. I suppose one could set things up to connect SQL Dev to an 'idle instance', the issue CREATE DATABASE statements. But that would require special configuration of the listener. Far better to use the correct tool for the job.

That said, and for your future reference, if one expects to debug a connection error from SQL Dev. Wed first need to see exactly how the connection is defined in SQL Dev. And to that end, if it is of connection type=basic, we'd need to know the values of all the fields. Connection type=basic does NOT use tnsnames.ora. If it is connection type=tns, the tnsnames.ora IS used and we'd need to see the relevant entry. And for most connection errors, we'd need to see the output of 'lsnrctl status', as run on the machine hosting the database.
Re: listener refused the connection with the following error:ORA12505 [message #679208 is a reply to message #679205] Sat, 15 February 2020 13:35 Go to previous messageGo to next message
BlackSwan
Messages: 26703
Registered: January 2009
Location: SoCal
Senior Member
syed.javid.ali.ali@gmail. wrote on Sat, 15 February 2020 09:46
listener refused the connection with the following error:ORA12505.

Iam new to this sql developer. i want to create a database and work on it. but iam not able to make a database. it is showing error as

listener refused the connection with the following error:ORA12505.

Can anyone help on this.
Your connection request got the listener & the listener threw ORA-12505 error.
Every connection request that gets to the listener is logged into listener.log file.
Locate the record that contains the 12505 status code & post this line back here so we can see it.
Also post the FULL results of the two OS commands back here

lsnrctl status
lsnrctl service
Re: listener refused the connection with the following error:ORA12505 [message #679209 is a reply to message #679208] Sat, 15 February 2020 14:18 Go to previous messageGo to next message
syed.javid.ali.ali@gmail.
Messages: 10
Registered: February 2020
Junior Member
:\Users\Sayed>lsnrctl status

SNRCTL for 32-bit Windows: Version 11.2.0.1.0 - Production on 16-FEB-2020 00:1
15

opyright (c) 1991, 2010, Oracle. All rights reserved.

onnecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1523)))
TATUS of the LISTENER
-----------------------
lias LISTENER
ersion TNSLSNR for 32-bit Windows: Version 11.2.0.1.0 - Prod
tion
tart Date 14-FEB-2020 00:52:29
ptime 1 days 23 hr. 20 min. 46 sec
race Level off
ecurity ON: Local OS Authentication
NMP OFF
istener Parameter File D:\app\Sayed\product\11.2.0\dbhome_3\network\admin\li
ener.ora
istener Log File d:\app\sayed\diag\tnslsnr\Sayed-PC\listener\alert\log
ml
istening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1523ipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1523)))
ervices Summary...
ervice "CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
ervice "syed" has 1 instance(s).
Instance "syed", status READY, has 1 handler(s) for this service...
ervice "syedXDB" has 1 instance(s).
Instance "syed", status READY, has 1 handler(s) for this service...
he command completed successfully

:\Users\Sayed>lsnrctl status

SNRCTL for 32-bit Windows: Version 11.2.0.1.0 - Production on 16-FEB-2020 00:1
15

opyright (c) 1991, 2010, Oracle. All rights reserved.

onnecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1523)))
TATUS of the LISTENER
-----------------------
lias LISTENER
ersion TNSLSNR for 32-bit Windows: Version 11.2.0.1.0 - Prod
tion
tart Date 14-FEB-2020 00:52:29
ptime 1 days 23 hr. 20 min. 46 sec
race Level off
ecurity ON: Local OS Authentication
NMP OFF
istener Parameter File D:\app\Sayed\product\11.2.0\dbhome_3\network\admin\li
ener.ora
istener Log File d:\app\sayed\diag\tnslsnr\Sayed-PC\listener\alert\log
ml
istening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1523ipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1523)))
ervices Summary...
ervice "CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
ervice "syed" has 1 instance(s).
Instance "syed", status READY, has 1 handler(s) for this service...
ervice "syedXDB" has 1 instance(s).
Instance "syed", status READY, has 1 handler(s) for this service...
he command completed successfully

:\Users\Sayed>lsnrctl status

SNRCTL for 32-bit Windows: Version 11.2.0.1.0 - Production on 16-FEB-2020 00:1
00

opyright (c) 1991, 2010, Oracle. All rights reserved.

onnecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1523)))
TATUS of the LISTENER
-----------------------
lias LISTENER
ersion TNSLSNR for 32-bit Windows: Version 11.2.0.1.0 - Prod
tion
tart Date 14-FEB-2020 00:52:29
ptime 1 days 23 hr. 22 min. 31 sec
race Level off
ecurity ON: Local OS Authentication
NMP OFF
istener Parameter File D:\app\Sayed\product\11.2.0\dbhome_3\network\admin\li
ener.ora
istener Log File d:\app\sayed\diag\tnslsnr\Sayed-PC\listener\alert\log
ml
istening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1523ipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1523)))
ervices Summary...
ervice "CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
ervice "syed" has 1 instance(s).
Instance "syed", status READY, has 1 handler(s) for this service...
ervice "syedXDB" has 1 instance(s).
Instance "syed", status READY, has 1 handler(s) for this service...
he command completed successfully

:\Users\Sayed>




















Re: listener refused the connection with the following error:ORA12505 [message #679210 is a reply to message #679209] Sat, 15 February 2020 15:19 Go to previous messageGo to next message
BlackSwan
Messages: 26703
Registered: January 2009
Location: SoCal
Senior Member
post line from D:\app\Sayed\product\11.2.0\dbhome_3\network\admin\listener.ora that contains 12505 error status

Why is listener using NON-STANDARD port# 1523; not 1521?

It appears this system has multiple ORACLE_HOME directories; which has potential to produce errors & strange results; especially on Windows!
How many ORACLE_HOME trees exist & what versions of Oracle DB do they support?
Re: listener refused the connection with the following error:ORA12505 [message #679211 is a reply to message #679209] Sun, 16 February 2020 08:58 Go to previous messageGo to next message
John Watson
Messages: 8268
Registered: January 2010
Location: Global Village
Senior Member
What SID are you giving when you try to connect? It should be syed
Re: listener refused the connection with the following error:ORA12505 [message #679213 is a reply to message #679211] Sun, 16 February 2020 11:12 Go to previous messageGo to next message
syed.javid.ali.ali@gmail.
Messages: 10
Registered: February 2020
Junior Member
thanks for everyone. it is now working
Re: listener refused the connection with the following error:ORA12505 [message #679215 is a reply to message #679213] Sun, 16 February 2020 11:23 Go to previous messageGo to next message
John Watson
Messages: 8268
Registered: January 2010
Location: Global Village
Senior Member
What did you do to fix it? (Please remember! This forum is about contributing to help others, not only getting answers)
Re: listener refused the connection with the following error:ORA12505 [message #679220 is a reply to message #679213] Sun, 16 February 2020 14:48 Go to previous message
EdStevens
Messages: 1206
Registered: September 2013
Senior Member
syed.javid.ali.ali@gmail. wrote on Sun, 16 February 2020 11:12
thanks for everyone. it is now working
Care to explain _exactlY_ what you did to get it working?
Previous Topic: i require oracle sql developer tool for windows 7 pc. does anyone have it. kindly share the link pl
Next Topic: SQL Developer doesn't store passwords
Goto Forum:
  


Current Time: Thu May 28 20:08:17 CDT 2020