SQL Developer - can't connect, listener does not currently know of SID/service name












0















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:



Error



AND



enter image description here



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










share|improve this question




















  • 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
















0















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:



Error



AND



enter image description here



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










share|improve this question




















  • 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














0












0








0








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:



Error



AND



enter image description here



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










share|improve this question
















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:



Error



AND



enter image description here



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






share|improve this question















share|improve this question













share|improve this question




share|improve this question








edited Oct 23 '18 at 16:56









Alex Poole

130k6101176




130k6101176










asked Oct 23 '18 at 16:50









KamarovKamarov

175




175








  • 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














  • 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








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












1 Answer
1






active

oldest

votes


















0














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>





share|improve this answer























    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
    });


    }
    });














    draft saved

    draft discarded


















    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









    0














    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>





    share|improve this answer




























      0














      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>





      share|improve this answer


























        0












        0








        0







        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>





        share|improve this answer













        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>






        share|improve this answer












        share|improve this answer



        share|improve this answer










        answered Nov 13 '18 at 14:29









        Kris RiceKris Rice

        2,336728




        2,336728






























            draft saved

            draft discarded




















































            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.




            draft saved


            draft discarded














            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





















































            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







            Popular posts from this blog

            Bressuire

            Vorschmack

            Quarantine