Open the connection properties.
Is the host correct - can you ping it?
Is the port correct - does the listener listen on that port?
Is the sid or service correct?
Do you still have the older version of SQLDev installed - does the connection still work there?
Are you using TNSNames? It's possible the option to define which tns directory we're reading services from got messed up somehow, but that's just a wild guess.
The same config and connections were working fine, and I can connect to other databases, this is only with Oracle12c with pluggable db. I am not using tnsnames.ora file, everything is correct.
FYI I am using MAC OS version.
Everything is NOT correct, or we'd be able to connect.
>>Do you still have the older version of SQLDev installed - does the connection still work there?
Or, are you able to connect to your 12c PDB with any other client?
By the way, 12c PDB connections require you use SERVICE, not a SID.
It might help if you show us your connection properties.
can you please tell us if your database is a single instance, with only one Listener? Or do you have a RAC with SCAN listeners?
Just want to sort things out.
1. The connection properties was before the same and I was able to connect, I have migrated the preferences.
2. I can connect with TOAD.
3. I am using single instance not RAC with SCAN.
4. I am using SERVICE name, fully qualified with the host.
5. I can ping the server.
6. I can connect to Oracle 11g.
7. If you have direct mail I can send you screen shot with the connection properties.
So, it appears we have found a bug with the 12c JDBC driver we're shipping with.
Two things to try:
- Change the service name, IF you can, to no have a hyphen in the name.
- Try a thick connection using an 11203/4 client - this will force an 11gR2 JDBC driver and should let you connect
A better workaround
using the Advanced sub panel for the connection, specify the URL in TNS format
this works for thin as well