My tnsnames.ora looks like this:
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) (SERVICE_NAME = orcl) ) )**
But when I try connecting using SQL Developer as follows I get the error: No more data to read from socket.
Role: SYSDBA ConnectionType: Basic
HostName: localhost Port: 1521 SID: CLRExtProc
Can you please let me know what I am doing wrong? I can connect using the service_name, or when using service name in SID, but why does it not work when I use the SID defined in tnsnames.ora.
As per my understanding, the SID corresponds to the instance name for the database. Is it not possible to connect using it?
Best Regards, Harshit