| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Trivia question - not of any practical use.
Dear Listers,
Given below is a script that I execute from within SQL*Plus for WinNT:
temp.sql:
While running it always displays 'SQL>set echo off' before muffling the echo. Is there any way to stop this line from appearing?
I vaguely remember that in some language you could put @ in front of the 'set echo off' command to suppress it. Is there something similar possible.
TIA.
Regards,
Charu.
-----Original Message-----
Sent: Thursday, October 24, 2002 12:26 PM
To: Multiple recipients of list ORACLE-L
the firewall should use sqlnet proxy. most firewalls support it and if this one doesn't scrap it! only the initial connection is made on port 1521.
>>> adar76_at_inter.net.il 10/24/02 05:44AM >>>
we had the same problem and we found that oracle use the standard port only
to make the initial connection. All the traffic after that is done on
different ports. So you need to open the range that oracle use in the
firewall.
Yechiel Adar
Mehish
----- Original Message -----
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
Sent: Thursday, October 24, 2002 8:13 AM
> Environment:
> Oracle 8.1.6
> AIX server behind a firewall
> db is accessed by a Windows application running on a IIS web server
> sitting outside the firewall
> db uses port 1521
>
>
> After a flurry of email between the Unix admin and the 4 software vendors
> concerned, all the fingers are now pointing at "that damn oracle
> database". The Unix admin is asking two questions:
>
> 1) what Oracle is doing with the four ports 20,000 - 20,003
> 2) can he shut them down?
>
>
> Any ideas are appreciated.
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Don
> INET: dondealy_at_teleport.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: adar76_at_inter.net.il Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gene Sais INET: Gsais_at_co.palm-beach.fl.us Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ********************************************************* Disclaimer This message (including any attachments) contains confidential information intended for a specific individual and purpose, and is protected by law. If you are not the intended recipient, you should delete this message and are hereby notified that any disclosure, copying, or distribution of this message, or the taking of any action based on it, is strictly prohibited. ********************************************************* Visit us at http://www.mahindrabt.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Charu Joshi INET: joshic_at_mahindrabt.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Thu Oct 24 2002 - 11:24:04 CDT
 |
 |