I get the following error: Status : Failure -Test failed: Listener refused the connection with the following error: ORA-12505, TNS: listener does not currently know of SID given in connect descriptor. My services are below and my connection window. I believe the installation of oracle 12c was a success. Do you guys know what could be wrong, please.
First Logged in SQLPlus and Unlock the user
Run SQLPlus, connect as SYS user (use administrator's password you have entered during installation) . Suppose that here For your test connection unlock HR user and give him a new password:
C:\>sqlplus sys as sysdba SQL*Plus: Release 220.127.116.11.0 Production on Wed Jan 24 12:15:51 2018 Copyright (c) 1982, 2014, Oracle. All rights reserved. Enter password: Connected to: Oracle Database 12c Enterprise Edition Release 18.104.22.168.0 - 64bit Production With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options SQL> alter user hr identified by new_password; User altered. SQL> alter user hr account unlock; User altered.
For Creating a Database Connection
The first step to managing database objects using Oracle SQL Developer is to create a database connection.Perform the following steps:
Open Oracle SQL Developer.
In the Connections navigator, right-click Connections and select New Connection.
Enter test for the Connection Name (or any other name that identifies your connection), hr for the Username and Password, specify your
ORCL10(in your case, as it showing in your attached picture) for the
SID. Click Test.
The status of the connection was tested successfully. The connection was not saved however. Click Save to save the connection, and then click Connect.
- Ensure that you are on the correct home
- Ensure that the listener is started
- Make sure that the listener, tnsnames files include the database entries