Forum Stats

  • 3,734,283 Users
  • 2,246,938 Discussions
  • 7,857,218 Comments

Discussions

Problem: Connect the SQL Developer to the Database

thetha
thetha Member Posts: 2
edited Jul 29, 2019 3:57PM in Database Installation

Hello everyone,

i have installed: 19c and I have SQL Developer.

But i am having Problems to connect.

It worked some hours ago,...but now i have bbroken something.

Here is the error:

lsnrctl status

LSNRCTL for 64-bit Windows: Version 19.0.0.0.0 - Production on 24-JUN-2019 21:00:10

Copyright (c) 1991, 2019, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)))

TNS-12541: TNS:no listener

TNS-12560: TNS:protocol adapter error

  TNS-00511: No listener

   64-bit Windows Error: 61: Unknown error

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))

TNS-12541: TNS:no listener

TNS-12560: TNS:protocol adapter error

  TNS-00511: No listener

   64-bit Windows Error: 2: No such file or directory

I had an error during the installation process.

And I had to reboot, delete all files and reg entries.

Then install again, then it worked.

Answers

  • Gaz in Oz
    Gaz in Oz Member Posts: 3,776 Bronze Crown
    edited Jun 25, 2019 10:15PM

    First of all do:

    C:\> lsnrctl start

    to start the listener. The "error" you show is just saying the listener is not currently running.

    If you are still having problems connecting via sqldev then read on:

    Is the listener now up and running on the database server?

    Is there an endpoint listening for the service_name you are using to try and connect to the database?

    What version of sqldeveloper are you using?

    Is sqldeveloper on the database server or on another machine?

    What does the connection set up look like in sqldeveloper?

    Can you connect to the database using sqlplus?

    ...

    thetha
  • thetha
    thetha Member Posts: 2
    edited Jul 29, 2019 3:06PM

    There is problem allways occurs if you change the wlan.

    I have fixed it--->Virtual Box Image. If something is broke, back to to initial state.

  • EdStevens
    EdStevens Member Posts: 28,143 Gold Crown
    edited Jul 29, 2019 3:57PM
    thetha wrote:There is problem allways occurs if you change the wlan. I have fixed it--->Virtual Box Image. If something is broke, back to to initial state.

    You should have told us it was on VBox.  My guess is you do not have your vbox networking set up correctly in the first place.

    I've created dozens, if not scores, of VBox machines.  My standard practice is to create two NICs on each. The first is configured NAT and at the guest OS is configured for a DHCP address.  You never address this yourself, it is simply to allow the guest to use the network of the host to reach the internet.  The second NIC is configured HOSTONLY and at the guest OS is assigned a fixed IP address.  For more details, read here:  https://edstevensdba.wordpress.com/2012/12/15/configure-the-virtualbox-network-2/

Sign In or Register to comment.