ora-12505 error with sql developer connecting to oracle11g on windows 7

Question

I installed oracle 11g successfully and was able to login with SQL plus. When I tried making a connection with the same username and password via SQL developer however I'm getting the ora-12505 error

error

Printout of my tnsname.ora:

# tnsnames.ora Network Configuration File: C:\Oracle11g\product\11.2.0\dbhome_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

ORACLE11G =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = oracle11g)
    )
  )

ORACLR_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
    (CONNECT_DATA =
      (SID = CLRExtProc)
      (PRESENTATION = RO)
    )
  )

When I execute the tnspint orcl; I get:

C:\Windows\system32>tnsping ORCL;

TNS Ping Utility for 32-bit Windows: Version 11.2.0.1.0 - Production on 22-JUL-2013 00:52:10

Copyright (c) 1997, 2010, Oracle.  All rights reserved.

Used parameter files:
C:\Oracle11g\product\11.2.0\dbhome_1\network\admin\sqlnet.ora

TNS-03505: Failed to resolve name

C:\Windows\system32>

Could anyone assist in solving this problem and getting sql developer connected with my oracle database?

Amritanshu Amritanshu · Accepted Answer · 2015-07-27T06:14:07

Just Run This command in RUN SQL Command after connecting to username and password credentials.

command:

alter system set local_listener='(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))';

ora-12505 error with sql developer connecting to oracle11g on windows 7

3 Answers