Skip to Main Content

Oracle Database Express Edition (XE)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Unable to "Create a Database Connection" in JDeveloper

User_K06B1Oct 14 2019 — edited Oct 14 2019

Hello, I have Oracle Database 11g XE installed on my machine, but am having issues "Creating a Database Connection" in JDeveloper.

I am able to successfully start and stop the Listener and DB under the "Services" but for some reason when I go into JDeveloper and attempt to establish a Database Connection, I gives me the following error: "Test failed: Listener refused the connection with the following error: ORA-12505, TNS:listener does not currently know of SID given in connect descriptor". I have the following fields set: "Connection Name: XEConn", "Connection Type: Oracle (JDBC)", "Username: sys", "password: the password I set", "Role: SYSDBA", "driver: thin", "hostname: moizahme-t480.us.oracle.com", "SID: XE", "JDBC Port: 1521" (I have attached a screenshot also). I also tried with "hostname: localhost" but also gives an error.

I have also attached a screenshot of my environment variables.

Also, I am not connected to a VPN.

If anyone can help, that be greatly appreciated! Thanks

Comments
Post Details
Added on Oct 14 2019
3 comments
949 views