I have recently installed Oracle XE 11 on my local machine and then installed SQL Developer. But when I try to create a new connection (for my localhost) or add from 'database detected local XE' it returns either ora-12514 or ora-12505. I know the password that I entered during the installation.
OracleServiceXEservice is running
- Tried connecting via localhost, 127.0.0.1 and computer_name
- Opened localhost tns and wrote the information there
But I am still not able to connect.
It bugs me that even a simple localhost connection is problematic when it comes to Oracle tools. It should be as easy as using Microsoft tools. I can't even connect to a localhost xe oracle.
What is wrong?
Edit: I may have found the issue.. I have installed Oracle XE 11.2 as domain user so probably there is some other configuration that needs to be done to access.?