you need to restart the database and the listener. I think you can also get
away with putting USE_SHARED_SOCKET=TRUE as a system enviroment variable. I
believe the firewall also has to know about sqlnet traffic.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
"Mr Pink" <MrPink_at_Technologist.com> wrote in message
news:3cf603de$0$10772$afc38c87_at_news.easynet.co.uk...
> Hello,
>
> I am running Oracle 8.1.7.3 on Windows 2000 Advanced Server. I am trying
to
> force traffic down a single port as they are currently being assigned
> randomly within the listener.log
>
> I have added USE_SHARED_SOCKET = TRUE into the registry at
> \HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME0 and it makes no difference. I
have
> also added USE_SHARED_SOCKET= TRUE within the SQLNET.ORA and still no
> difference.
>
> Does anyone know why Oracle refuses to force the traffic down the one
port?
>
> Many Thanks!
>
> Lee
>
>
Received on Thu May 30 2002 - 06:03:49 CDT
