Sample Header Ad - 728x90

ora-12514 Error While Connecting local Oracle EXPRESS EDITION 11

1 vote
1 answer
2345 views
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. - OracleXETnsListener,OracleServiceXE service 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.?
Asked by Mert Serimer (111 rep)
Jul 13, 2018, 10:46 AM
Last activity: Jul 13, 2018, 12:40 PM