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
Last activity: Jul 13, 2018, 12:40 PM