Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: LISTENER.ORA modification
Harald Diesveld wrote:
>
> Hello,
>
> I have trouble installing the gateway to SQL Server. I am not able to
> modify my listener.ora file as stated in the installation guide. When I
> do that I get an error restarting the listener service. My listener.ora
> file (before the changes) is quoted below:
> ......
> )
> )
> STARTUP_WAIT_TIME_LISTENER = 0
> CONNECT_TIMEOUT_LISTENER = 10
> TRACE_LEVEL_LISTENER = ADMIN
> SID_LIST_LISTENER =
> (SID_LIST =
> (SID_DESC =
> (SID_NAME = ORCL)
> )
> (SID_DESC =
> (SID_NAME = MSQL)
> )
> )
> PASSWORDS_LISTENER = (oracle)
> .......
Harald,
The SID_DESC goes in the SID_LIST list near the end of the LISTENER.ora file.
I have added it where appropriate above. Please look above for the modified LISTENER.ORA
-- Ashok F. Kapur | Galaxy Latin America | Project Engineer | (954)958-3373 | afkapur_at_ccgate.hac.comReceived on Tue Jan 14 1997 - 00:00:00 CST