Creating a local connection in Oracle SQL developer 12c

133 views Asked by At

Not sure if I'm missing anything. I'm trying to create a local connection in order to create a new user in Oracle SQL developer 12c. (AVOIDING CDB connection) After browsing for an hour, came across 2 methods.

  1. Using connection type as "Local/Bequeath"

Throws following error (Status : Failure -Test failed: ORA-01017: invalid username/password; logon denied)

  1. Using connection type as "Basic", Hostname as "localhost", Port as "1521", and Service name as "XEPDB1"

Throws following error (Status : Failure -Test failed: Listener refused the connection with the following error: ORA-12514, TNS:listener does not currently know of service requested in connect descriptor)

Thanks.

0

There are 0 answers