I am able to establish a connection both on the virtual machine hosting the db and on my local machine using SQLplus. But when i try to create a connection via Oracle SQL Developer Extension for VSCode i get the following error using the same credentials.
I have tried using both the basic connection and using a TNS entry. Neither works.
Error: An error occurred when attempting to connect to the database.The following error occurred: ORA-17820: The network adapter could not establish the connection. (CONNECTION_ID=xpNXzFRfQcSjHA4Af2hLRQ==) https://docs.oracle.com/error-help/db/ora-17820/.Consult your database documentation for information on how to resolve the specified error code
Any help would be greatly appreciated.
Thanks!