General discussion


Database access through Internet

By rajivnarayanan@hotmail ·
My database server running windows 2000 has a database with oracle. My vendor wants to view the database over a net connection.

How do I configure and permit access to that vendor? The Database server is behinde a firewall.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

Database access through Internet

by Joseph Moore In reply to Database access through I ...

I am not totall certain, but I believe Oracle uses TCP port 1521 for connectivity. So, you could open up this port on your firewall, allowing connectivity through on this port to your Oracle server.
Now, if your firewall lets you set up proper rulesets (like Checkpoint), then only allow the IP address for your vendor to connect to this port on your Oracle DB.

There are a few other ports that Oracle has, so I would check to make sure that 1521 is the right one. Your Oracle SQL server shouldhave that info.

Now, as soon as your vendor is done connecting over the Internet and done looking at your Oracle DB, I would then REMOVE this open port on your firewall. Keep it open only as long as is necessary.

Also, do you run a VPN? Your vendor could connect that way, and that is a little safer for you.

hope this helps

Collapse -

Database access through Internet

Poster rated this answer

Collapse -

Database access through Internet

This question was closed by the author

Related Discussions

Related Forums