Skip to Main Content

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, Gopi.

Asked: September 06, 2018 - 4:05 am UTC

Last updated: September 26, 2018 - 12:43 am UTC

Version: 11.2.0

Viewed 1000+ times

You Asked

Hi,

I have installed oracle 11g and created database name XYZ in machine A

Two systems are connected in same network which is reachable by ping ip address

port is also open

How B machine will access the DB XYZ on A machine ??


Thanks in advance

Regards,
Gopi


and Connor said...

You connect to the database via a "Listener". It's a program that runs on the db server and (as the name suggests) listens for connection requests from other machines.

I did a video on how to create a listener (its for 12c but the basic process is the same)



You'll see from the video that the listener runs on a particular port (eg 1521). Then for a remote machine to connect to the database it will provide:

- hostname (of the database)
- service_name (the database name)
- port (1521)

eg

sqlplus scott/tiger@//myhost:1521/mydb


Rating

  (2 ratings)

Is this answer out of date? If it is, please let us know via a Comment

Comments

network Connection query

Gopi, September 07, 2018 - 3:05 am UTC

I am aware of listener ora file and i have provided machine B sql client with TNS details but still network could not established .
whether the oracle installation category must be choose as server class? i have chosen desktop class will that be an issue?

i can able to ping the network ip of machin A in which db installed


Connor McDonald
September 08, 2018 - 10:29 am UTC

What happens when you tnsping ? (And include the entire output please)

network connection issue

Gopi Krishnan Samyappan, September 23, 2018 - 5:38 pm UTC

Hi,

Machine A installed with oracle DB

Machine B which is client machine only sql developer exists and im giving the connection string but not getting connected.

whether the tnsnames creation must be done on client machine through wizard then only it will work?

can you please explain this?

if any command need to be performed to test the connection please let me know?
Connor McDonald
September 26, 2018 - 12:43 am UTC

Take a look here

https://asktom.oracle.com/pls/asktom/asktom.search?tag=tns-no-listener-issue

to check the listener on machine A, and use the output to then nominate the right port, host and service name on machine B when you fire up sql developer
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.

More to Explore

Administration

Need more information on Administration? Check out the Administrators guide for the Oracle Database