How do I use Net Service Name to connect to remote database (on virtual machine) via SQL Developer?
How do I connect from SQL developer (on Windows 11) to my my dummy database (on a Linux 6 virtual box) - via using Net Service Name (ORADBP)?
I can do this via Database Service Name, ORADBP.localdomain
tnsnames.ora
ORADBP =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = srv1.localdomain)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ORADBP.localdomain)
)
)
net_service_name =
(DESCRIPTION=
(ADDRESS = (PROTOCOL = TCP)(HOST = xxx.xxx.com)(PORT = 1521))
(CONNECT_DATA = (SERVER = DEDICATED)
(SERVICE_NAME=service_name)
)
)
This is how I successfully connect from SQL developer (on Windows 11) to my my dummy database (on a Linux 6 virtual box), using Database Service Name. It's working just fine.