Hi Team,
I have just installed Oracle 12C on my windows 7 based machin.
However trying to connect from sqlplus with sys as sysdba I'm abe to connect to database
But whenever I'm trying to connect the same with SQL Developer it gives me the error
"Status : Failure -Test failed: IO Error: The Network Adapter could not establish the connection"
Also Listener status gives me the flowing error Msg
> lsnrctl stat
LSNRCTL for 64-bit Windows: Version 12.1.0.2.0 - Production on 21-OCT-2014 10:54
:13
Copyright (c) 1991, 2014, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
64-bit Windows Error: 61: Unknown error.
My Tnsnames.oRA and listener.ora has floowing content
Tnsnames.oRA
================================================
ORCL_PDB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl_pdb.oracle)
)
)
ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
listener.ora
================================================
SID_LIST_LISTENER2 =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = orcl)
(ORACLE_HOME = D:\ORACLE-12C-R1\app\ORADOMAIN\product\12.1.0\dbhome_2)
(SID_NAME = orcl)
)
)
LISTENER2 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)
Kindly help me to know if anything I'm missing in above files and to resolve this issue