Skip to Main Content

Oracle Database Discussions

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Sqldeveloper: ORA-12514, TNS:listener does not currently know of service re

user3096536May 22 2013 — edited May 22 2013
Hello everybody.

I want to connect with Sqldeveloper and I have the error :

ORA-12514, TNS:listener does not currently know of service re

But with SQL*PLUS, I connect correctly.

I have Windows Vista.

My tsnames.ora is

# tnsnames.ora Network Configuration File: C:\app\HP_Propietario\product\11.2.0\dbhome_3\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

LISTENER_ORCL =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.10.10)(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 = 10.10.10.10)(PORT = 1521))
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = orcl)
(INSTANCE_NAME = orcl)
)
)

PRUEBA =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.10.10)(PORT = 1521))
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = PRUEBA)
)
)



My listener.ora

# listener.ora Network Configuration File: C:\app\HP_Propietario\product\11.2.0\dbhome_3\network\admin\listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = C:\app\HP_Propietario\product\11.2.0\dbhome_3)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:C:\app\HP_Propietario\product\11.2.0\dbhome_3\bin\oraclr11.dll")
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.10.10)(PORT = 1521))
)
)

ADR_BASE_LISTENER = C:\app\HP_Propietario


I write the host 10.10.10.10 because I have installed a loopback adapter with address 10.10.10.10

The information in SQLDeveloper is:

Conection Type: BASIC
Host Name: 10.10.10.10 (address of loopback adapter in file of windows hosts)
Port 1521
Service Name : orcl


Could somebody help me?

Thanks in advance

Carlota ViƱa Sirgo
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 19 2013
Added on May 22 2013
5 comments
755 views