0

I installed Oracle Database 19c and was able to connect to the database using sqlplus in command line. However when I try to use SQL developer I'm unable to connect. I noticed I don't have any listener service like I did when I had Oracle Database 21c installed on another computer. Is this why I can't access it on SQL developer? And if so how do I create that listener?

Access the database through SQL Developer.

Improve this question
4
  • This is definitely why you're not connecting. The listener is typically installed at the same time as the database. You can use the Network Manager utility to configure one if it isn't already done. Perhaps check the listener config files in $ORACLE_HOME/network/admin first; if listener.ora is already there, see if the lsnrctl utility can start it. Commented Mar 24, 2022 at 1:02
  • I would assume but there no network manager utility program installed either and trying to start with lsnrctl doesn't work either. Commented Mar 24, 2022 at 2:18
  • are you getting a specific error when starting the listener? Please add the commands attempted and the output to your question. Commented Mar 24, 2022 at 13:00
  • I was using lsnrctl start which was giving me error but ofc after one night of sleep it magically works without me doing anything. Commented Mar 24, 2022 at 16:28

1 Answer 1

Reset to default
0

(I don't have the reputation to comment, so I'm posting this here.)

Just wanted to say that I just encountered the same issue.

  1. I installed Oracle 19c on Windows as "Software Only".
  2. I used dbca.bat to create a database with a single pluggable database through the "basic" configuration. In the past I've gone through the "advanced" configuration, and I'm wondering if that's what lead to this.

So now I'm dropping the database and will try re-creating it to see if using the advanced DB installation provides a listener.

Edit

After deleting the database, then going back through the DB installation in dbca.bat via the "advanced" installation option, I noticed that the listener configuration was actually disabled by default, and I had to choose to add a listener.

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.