SQL Developer - can't connect, listener does not currently know of SID/service name
I know this is a common problem, I've tried everything I could find online and nothing solved my problem. I even uninstalled Oracle 11g XE and SQL Developer, deleted every file I could find and reinstalled, didn't help anything.
I can connect perfectly through the SQL*Plus command line and CMD.
I never had this problem but since today, when I try to connect with DQL Developer I keep getting this error:
AND
This is my tnsnames.ora file:
XE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = DESKTOP-5MFACN6)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XE)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)
listener.ora file:
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:oraclexeapporacleproduct11.2.0server)
(PROGRAM = extproc)
)
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = C:oraclexeapporacleproduct11.2.0server)
(PROGRAM = extproc)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = DESKTOP-5MFACN6)(PORT = 1521))
)
)
DEFAULT_SERVICE_LISTENER = (XE)
Output from some tests from SQL*Plus:
Connected to:
Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production
SQL> select value from v$parameter where name='service_names';
VALUE
--------------------------------------------------------------------------------
XE
SQL> select instance from v$thread;
INSTANCE
--------------------------------------------------------------------------------
xe
SQL> select host_name,instance_name,version from v$instance;
HOST_NAME
----------------------------------------------------------------
INSTANCE_NAME VERSION
---------------- -----------------
DESKTOP-5MFACN6
xe 11.2.0.2.0
SQL> select global_name from global_name;
GLOBAL_NAME
--------------------------------------------------------------------------------
XE
and listener status:
C:UsersArne>lsnrctl status
LSNRCTL for 64-bit Windows: Version 11.2.0.2.0 - Production on 23-OCT-2018 18:27:07
Copyright (c) 1991, 2014, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 64-bit Windows: Version 11.2.0.2.0 - Production
Start Date 23-OCT-2018 18:19:35
Uptime 0 days 0 hr. 7 min. 31 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Default Service XE
Listener Parameter File C:oraclexeapporacleproduct11.2.0servernetworkadminlistener.ora
Listener Log File C:oraclexeapporaclediagtnslsnrDESKTOP-5MFACN6listeneralertlog.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\.pipeEXTPROC1ipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=DESKTOP-5MFACN6)(PORT=1521)))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
Any idea on how to fix this? I really don't know what I can do anymore
oracle oracle-sqldeveloper sqlplus
add a comment |
I know this is a common problem, I've tried everything I could find online and nothing solved my problem. I even uninstalled Oracle 11g XE and SQL Developer, deleted every file I could find and reinstalled, didn't help anything.
I can connect perfectly through the SQL*Plus command line and CMD.
I never had this problem but since today, when I try to connect with DQL Developer I keep getting this error:
AND
This is my tnsnames.ora file:
XE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = DESKTOP-5MFACN6)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XE)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)
listener.ora file:
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:oraclexeapporacleproduct11.2.0server)
(PROGRAM = extproc)
)
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = C:oraclexeapporacleproduct11.2.0server)
(PROGRAM = extproc)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = DESKTOP-5MFACN6)(PORT = 1521))
)
)
DEFAULT_SERVICE_LISTENER = (XE)
Output from some tests from SQL*Plus:
Connected to:
Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production
SQL> select value from v$parameter where name='service_names';
VALUE
--------------------------------------------------------------------------------
XE
SQL> select instance from v$thread;
INSTANCE
--------------------------------------------------------------------------------
xe
SQL> select host_name,instance_name,version from v$instance;
HOST_NAME
----------------------------------------------------------------
INSTANCE_NAME VERSION
---------------- -----------------
DESKTOP-5MFACN6
xe 11.2.0.2.0
SQL> select global_name from global_name;
GLOBAL_NAME
--------------------------------------------------------------------------------
XE
and listener status:
C:UsersArne>lsnrctl status
LSNRCTL for 64-bit Windows: Version 11.2.0.2.0 - Production on 23-OCT-2018 18:27:07
Copyright (c) 1991, 2014, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 64-bit Windows: Version 11.2.0.2.0 - Production
Start Date 23-OCT-2018 18:19:35
Uptime 0 days 0 hr. 7 min. 31 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Default Service XE
Listener Parameter File C:oraclexeapporacleproduct11.2.0servernetworkadminlistener.ora
Listener Log File C:oraclexeapporaclediagtnslsnrDESKTOP-5MFACN6listeneralertlog.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\.pipeEXTPROC1ipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=DESKTOP-5MFACN6)(PORT=1521)))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
Any idea on how to fix this? I really don't know what I can do anymore
oracle oracle-sqldeveloper sqlplus
2
DoesDESKTOP-5MFACN6
resolve to the same as localhost, i.e. 127.0.0.1? WHat happens if you use that name for the connection in SQL Developer instead?
– Alex Poole
Oct 23 '18 at 16:52
I was even so desperate to try that, but that didnt work. ... but ... I turned off my computer, went away for a bit and when I was back I tried again, for some reason it worked again... ! Weird because restarting didn't do anything before. Now it is fixed for some reason. Such a relief. Hope it stays this way now because it need to get some work done. :)
– Kamarov
Oct 23 '18 at 19:52
Restarting your laptop would mean your listener was restarted, which is what was probably required.
– Jeffrey Kemp
Oct 24 '18 at 3:12
add a comment |
I know this is a common problem, I've tried everything I could find online and nothing solved my problem. I even uninstalled Oracle 11g XE and SQL Developer, deleted every file I could find and reinstalled, didn't help anything.
I can connect perfectly through the SQL*Plus command line and CMD.
I never had this problem but since today, when I try to connect with DQL Developer I keep getting this error:
AND
This is my tnsnames.ora file:
XE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = DESKTOP-5MFACN6)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XE)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)
listener.ora file:
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:oraclexeapporacleproduct11.2.0server)
(PROGRAM = extproc)
)
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = C:oraclexeapporacleproduct11.2.0server)
(PROGRAM = extproc)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = DESKTOP-5MFACN6)(PORT = 1521))
)
)
DEFAULT_SERVICE_LISTENER = (XE)
Output from some tests from SQL*Plus:
Connected to:
Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production
SQL> select value from v$parameter where name='service_names';
VALUE
--------------------------------------------------------------------------------
XE
SQL> select instance from v$thread;
INSTANCE
--------------------------------------------------------------------------------
xe
SQL> select host_name,instance_name,version from v$instance;
HOST_NAME
----------------------------------------------------------------
INSTANCE_NAME VERSION
---------------- -----------------
DESKTOP-5MFACN6
xe 11.2.0.2.0
SQL> select global_name from global_name;
GLOBAL_NAME
--------------------------------------------------------------------------------
XE
and listener status:
C:UsersArne>lsnrctl status
LSNRCTL for 64-bit Windows: Version 11.2.0.2.0 - Production on 23-OCT-2018 18:27:07
Copyright (c) 1991, 2014, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 64-bit Windows: Version 11.2.0.2.0 - Production
Start Date 23-OCT-2018 18:19:35
Uptime 0 days 0 hr. 7 min. 31 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Default Service XE
Listener Parameter File C:oraclexeapporacleproduct11.2.0servernetworkadminlistener.ora
Listener Log File C:oraclexeapporaclediagtnslsnrDESKTOP-5MFACN6listeneralertlog.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\.pipeEXTPROC1ipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=DESKTOP-5MFACN6)(PORT=1521)))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
Any idea on how to fix this? I really don't know what I can do anymore
oracle oracle-sqldeveloper sqlplus
I know this is a common problem, I've tried everything I could find online and nothing solved my problem. I even uninstalled Oracle 11g XE and SQL Developer, deleted every file I could find and reinstalled, didn't help anything.
I can connect perfectly through the SQL*Plus command line and CMD.
I never had this problem but since today, when I try to connect with DQL Developer I keep getting this error:
AND
This is my tnsnames.ora file:
XE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = DESKTOP-5MFACN6)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XE)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)
listener.ora file:
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:oraclexeapporacleproduct11.2.0server)
(PROGRAM = extproc)
)
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = C:oraclexeapporacleproduct11.2.0server)
(PROGRAM = extproc)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = DESKTOP-5MFACN6)(PORT = 1521))
)
)
DEFAULT_SERVICE_LISTENER = (XE)
Output from some tests from SQL*Plus:
Connected to:
Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production
SQL> select value from v$parameter where name='service_names';
VALUE
--------------------------------------------------------------------------------
XE
SQL> select instance from v$thread;
INSTANCE
--------------------------------------------------------------------------------
xe
SQL> select host_name,instance_name,version from v$instance;
HOST_NAME
----------------------------------------------------------------
INSTANCE_NAME VERSION
---------------- -----------------
DESKTOP-5MFACN6
xe 11.2.0.2.0
SQL> select global_name from global_name;
GLOBAL_NAME
--------------------------------------------------------------------------------
XE
and listener status:
C:UsersArne>lsnrctl status
LSNRCTL for 64-bit Windows: Version 11.2.0.2.0 - Production on 23-OCT-2018 18:27:07
Copyright (c) 1991, 2014, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 64-bit Windows: Version 11.2.0.2.0 - Production
Start Date 23-OCT-2018 18:19:35
Uptime 0 days 0 hr. 7 min. 31 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Default Service XE
Listener Parameter File C:oraclexeapporacleproduct11.2.0servernetworkadminlistener.ora
Listener Log File C:oraclexeapporaclediagtnslsnrDESKTOP-5MFACN6listeneralertlog.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\.pipeEXTPROC1ipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=DESKTOP-5MFACN6)(PORT=1521)))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
Any idea on how to fix this? I really don't know what I can do anymore
oracle oracle-sqldeveloper sqlplus
oracle oracle-sqldeveloper sqlplus
edited Oct 23 '18 at 16:56
Alex Poole
130k6101176
130k6101176
asked Oct 23 '18 at 16:50
KamarovKamarov
175
175
2
DoesDESKTOP-5MFACN6
resolve to the same as localhost, i.e. 127.0.0.1? WHat happens if you use that name for the connection in SQL Developer instead?
– Alex Poole
Oct 23 '18 at 16:52
I was even so desperate to try that, but that didnt work. ... but ... I turned off my computer, went away for a bit and when I was back I tried again, for some reason it worked again... ! Weird because restarting didn't do anything before. Now it is fixed for some reason. Such a relief. Hope it stays this way now because it need to get some work done. :)
– Kamarov
Oct 23 '18 at 19:52
Restarting your laptop would mean your listener was restarted, which is what was probably required.
– Jeffrey Kemp
Oct 24 '18 at 3:12
add a comment |
2
DoesDESKTOP-5MFACN6
resolve to the same as localhost, i.e. 127.0.0.1? WHat happens if you use that name for the connection in SQL Developer instead?
– Alex Poole
Oct 23 '18 at 16:52
I was even so desperate to try that, but that didnt work. ... but ... I turned off my computer, went away for a bit and when I was back I tried again, for some reason it worked again... ! Weird because restarting didn't do anything before. Now it is fixed for some reason. Such a relief. Hope it stays this way now because it need to get some work done. :)
– Kamarov
Oct 23 '18 at 19:52
Restarting your laptop would mean your listener was restarted, which is what was probably required.
– Jeffrey Kemp
Oct 24 '18 at 3:12
2
2
Does
DESKTOP-5MFACN6
resolve to the same as localhost, i.e. 127.0.0.1? WHat happens if you use that name for the connection in SQL Developer instead?– Alex Poole
Oct 23 '18 at 16:52
Does
DESKTOP-5MFACN6
resolve to the same as localhost, i.e. 127.0.0.1? WHat happens if you use that name for the connection in SQL Developer instead?– Alex Poole
Oct 23 '18 at 16:52
I was even so desperate to try that, but that didnt work. ... but ... I turned off my computer, went away for a bit and when I was back I tried again, for some reason it worked again... ! Weird because restarting didn't do anything before. Now it is fixed for some reason. Such a relief. Hope it stays this way now because it need to get some work done. :)
– Kamarov
Oct 23 '18 at 19:52
I was even so desperate to try that, but that didnt work. ... but ... I turned off my computer, went away for a bit and when I was back I tried again, for some reason it worked again... ! Weird because restarting didn't do anything before. Now it is fixed for some reason. Such a relief. Hope it stays this way now because it need to get some work done. :)
– Kamarov
Oct 23 '18 at 19:52
Restarting your laptop would mean your listener was restarted, which is what was probably required.
– Jeffrey Kemp
Oct 24 '18 at 3:12
Restarting your laptop would mean your listener was restarted, which is what was probably required.
– Jeffrey Kemp
Oct 24 '18 at 3:12
add a comment |
1 Answer
1
active
oldest
votes
Typically when I don't see a service listed, I run an alter system register which flushes the servicenames to the listener vs waiting on the listner to poll and find them itself
$ sql / as sysdba
SQL*Plus: Release 18.0.0.0.0 - Production on Tue Nov 13 14:17:28 2018
Version 18.3.0.0.0
Copyright (c) 1982, 2018, Oracle. All rights reserved.
Connected to:
Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production
Version 18.3.0.0.0
SQL> alter system register;
System altered.
SQL>
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f52954144%2fsql-developer-cant-connect-listener-does-not-currently-know-of-sid-service-n%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
Typically when I don't see a service listed, I run an alter system register which flushes the servicenames to the listener vs waiting on the listner to poll and find them itself
$ sql / as sysdba
SQL*Plus: Release 18.0.0.0.0 - Production on Tue Nov 13 14:17:28 2018
Version 18.3.0.0.0
Copyright (c) 1982, 2018, Oracle. All rights reserved.
Connected to:
Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production
Version 18.3.0.0.0
SQL> alter system register;
System altered.
SQL>
add a comment |
Typically when I don't see a service listed, I run an alter system register which flushes the servicenames to the listener vs waiting on the listner to poll and find them itself
$ sql / as sysdba
SQL*Plus: Release 18.0.0.0.0 - Production on Tue Nov 13 14:17:28 2018
Version 18.3.0.0.0
Copyright (c) 1982, 2018, Oracle. All rights reserved.
Connected to:
Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production
Version 18.3.0.0.0
SQL> alter system register;
System altered.
SQL>
add a comment |
Typically when I don't see a service listed, I run an alter system register which flushes the servicenames to the listener vs waiting on the listner to poll and find them itself
$ sql / as sysdba
SQL*Plus: Release 18.0.0.0.0 - Production on Tue Nov 13 14:17:28 2018
Version 18.3.0.0.0
Copyright (c) 1982, 2018, Oracle. All rights reserved.
Connected to:
Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production
Version 18.3.0.0.0
SQL> alter system register;
System altered.
SQL>
Typically when I don't see a service listed, I run an alter system register which flushes the servicenames to the listener vs waiting on the listner to poll and find them itself
$ sql / as sysdba
SQL*Plus: Release 18.0.0.0.0 - Production on Tue Nov 13 14:17:28 2018
Version 18.3.0.0.0
Copyright (c) 1982, 2018, Oracle. All rights reserved.
Connected to:
Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production
Version 18.3.0.0.0
SQL> alter system register;
System altered.
SQL>
answered Nov 13 '18 at 14:29
Kris RiceKris Rice
2,336728
2,336728
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f52954144%2fsql-developer-cant-connect-listener-does-not-currently-know-of-sid-service-n%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
2
Does
DESKTOP-5MFACN6
resolve to the same as localhost, i.e. 127.0.0.1? WHat happens if you use that name for the connection in SQL Developer instead?– Alex Poole
Oct 23 '18 at 16:52
I was even so desperate to try that, but that didnt work. ... but ... I turned off my computer, went away for a bit and when I was back I tried again, for some reason it worked again... ! Weird because restarting didn't do anything before. Now it is fixed for some reason. Such a relief. Hope it stays this way now because it need to get some work done. :)
– Kamarov
Oct 23 '18 at 19:52
Restarting your laptop would mean your listener was restarted, which is what was probably required.
– Jeffrey Kemp
Oct 24 '18 at 3:12