0

I've already seen a similar question but couldn't find a solution.

I can successfully connect to Oracle DB through SQL*PLUS as the following image shows

I get successfully a connection through SQL PLUS

but when I tried to get a connection through SQL DEVELOPER, using the same id/pwd it returns an error code:

I can get no connection

This is my tns configuration:

# tnsnames.ora Network Configuration File: D:\DB_Home\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.

LISTENER_ORCL =
  (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))


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

ORCL =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SID = orcl)
    )
  )

Any help? I've already seen a similar question and followed their advice, but did not work to me.

2

0

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.