Re: Connecting to Oracle Server Over the 'Net

By default, Oracle uses a random port to communicate once a connection has been initiated by the listener ( which uses 1521 by default) , so you would need to open all ports ( no firewalls ) or, set a USE_SHARED_PORT ( or something like that ( if on Windows) parameter in the registry to specify that the same port should always be used..Read the docs about working with firewalls.

Once that is taken care of, you can create a tnsnames entry for that server/instance and connect to it from any client PC running SqlNet that can resolve your server's address..

"pret" <epal_at_yaho.com> wrote:

>Newbie alert:
>
>I just installed and set up Oracle 9.1. I can connect to it using SQL Plus
>on the host machine and I opened up the correct port on my router. Now, how
>do I connect to my machine from across the net?
>

----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==---- http://www.newsfeed.com The #1 Newsgroup Service in the World! >100,000 Newsgroups ---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =--- Received on Wed Jun 18 2003 - 15:44:23 CEST