Able to connect to Oracle 12c database using SQL*Plus, but not Oracle SQL Developer

Question

I installed Oracle Database 12c on my Windows 10. I was able to connect to database using SQL*Plus. I created a user named USER1 in SQL*Plus and granted full access. I tried to connect to the database using SQL Developer but got an error that says, "Status : Failure -Test failed: IO Error: The Network Adapter could not establish the connection". How can I fix it?

None of similar old posts were helpful, so posting this question here.

More info:- I named my database as kitab. I made sure that all oracle services are running:-

This is what it shows when I check the status of listener:-

This is the information from listener.ora:-

I changed SID to CLRExtProc and it gives me same error:-

What else can I do to troubleshoot it?

Pretty sure your SID isn't XE. That's only for 11g Express Edition. — thatjeffsmith
– thatjeffsmith, Commented May 20, 2020 at 10:11
You are right. I tried with SID CLRExtProc, but it gives me same error. I added more info in my original post. — blissfulProgrammer
– blissfulProgrammer, Commented May 21, 2020 at 2:38
that's not it either - based on your listener setup, you don't have a database yet. did you use the database creation assistant (DBCA) to create a database? — thatjeffsmith
– thatjeffsmith, Commented May 21, 2020 at 12:55
Yes I used DBCA to create a database named kitab. And I am able to connect to kitab database in SQL Plus cmd. So what do I need to do to be able to connect through SQL developer? — blissfulProgrammer
– blissfulProgrammer, Commented May 21, 2020 at 17:31
then you should have a service running also called kitab - but you don't. the listener should have dynamically added it, but you may need to do so manually. — thatjeffsmith
– thatjeffsmith, Commented May 21, 2020 at 18:32

Littlefoot · Accepted Answer · 2020-05-20 05:54:43Z

1

Did you try to:

run "Services"
- I don't have Windows 10, but - on Windows 7, you can find it by
  - typing "services.msc" into "Start - Search Programs and Files", or
  - in "Administrative tools" within the "Control Panel"
check status of Oracle services
- I presume not all of them are started up. If so,
  - start them up now, manually, and then try to establish connection with SQL Developer
  - change their startup mode to "automatic" so that they are started every time you power on the computer

answered May 20, 2020 at 5:54

Littlefoot

144k15 gold badges42 silver badges65 bronze badges

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

1 Comment

blissfulProgrammer Over a year ago

I added more info in my post. Those are the services I see running. Am I missing any other necessary services?

Collectives™ on Stack Overflow

Able to connect to Oracle 12c database using SQL*Plus, but not Oracle SQL Developer

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related