Database Networking (MOSC)

MOSC Banner

How do I use Net Service Name to connect to remote database (on virtual machine) via SQL Developer?

edited Jul 8, 2024 3:05AM in Database Networking (MOSC) 6 commentsAnswered

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center