I have installed 12c R2 on Windows 10 machine with one pluggable database. I had to reboot the machine due to windows update and since then I am having problems connecting to an existing account in pluggable database. In SQL Developer the error I get is "Status: Failure -Test failed: IO Error: The Network Adapter could not establish the connection." when trying to Test the connection. I can connect to the SYS or SYSTEM accounts in the root database (corcl). Windows services TNSListener is successfully running. I have restarted it too, but still I am not able to connect. The pluggable database (CORCLPDB) is open in read write mode.
The tnsnames.ora file contents are as follows:
# tnsnames.ora Network Configuration File: C:\app\rak549\virtual\product\12.2.0\dbhome_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
CORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = corcl.SGF.EDUBEAR.NET)
)
)
CORCLPDB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = gl385-oracle)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = corclpdb.SGF.EDUBEAR.NET)
)
)
ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)
LISTENER_CORCL =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
When trying to connect through SQL Plus I get the following error:
SQL> connect cis528inst2/welcome@corclpdb
ERROR:
ORA-12541: TNS:no listener
When tnsping to pluggable database pluggable database corclpdb it gives error. However it does tnsping the root database corcl. See below:
C:\Users\rak549>tnsping corcl
TNS Ping Utility for 64-bit Windows: Version 12.2.0.1.0 - Production on 27-NOV-2017 20:50:57
Copyright (c) 1997, 2016, Oracle. All rights reserved.
Used parameter files:
C:\app\rak549\virtual\product\12.2.0\dbhome_1\network\admin\sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = corcl.SGF.EDUBEAR.NET)))
OK (0 msec)
C:\Users\rak549>tnsping corclpdb
TNS Ping Utility for 64-bit Windows: Version 12.2.0.1.0 - Production on 27-NOV-2017 20:51:25
Copyright (c) 1997, 2016, Oracle. All rights reserved.
Used parameter files:
C:\app\rak549\virtual\product\12.2.0\dbhome_1\network\admin\sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = gl385-oracle)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = corclpdb.SGF.EDUBEAR.NET)))
TNS-12541: TNS:no listener
C:\Users\rak549>
I don't understand what could have changed during the rebooting process for listener to deny access to pluggable database. Any workaround?
Thanks.