Re: How to use Sql*plus cross Fairwall

From: Rolf Hauck <Rolf.Hauck_at_datenrevision.de>
Date: Thu, 10 Dec 1998 08:00:50 +0100
Message-ID: <366F71A2.D45D30E0@datenrevision.de>

The port you use doesn't depend on sqlplus or worksheet, but on the listener which is set up for the database server. If you can configure that one, you have the choice of which port the listener will use. You have to make sure, that your local tnsnames.ora matches the tnsnames.ora on the server side. This file includes the portnumber. You can check your connection to the database with tnsping.

HTH
Rolf

Dong Tang schrieb:
>
> Hi:
>
> I have to reach out of companie's firewall to oracle database server. Since
> the firewall only allow specific port number get out the firewall. If I know
> or can configure my sql*plus to use certain port on my machine, then I can
> get out.
> Dose any one know how to tell sql*plus or sql worksheet in enterprise
> manager using a certain port?
>
> Don
Received on Thu Dec 10 1998 - 01:00:50 CST