Re: SQL*Net 2.1/Multi Threaded Server (MTS) connectivity problem, ORA-12203
Date: 1995/10/10
Message-ID: <DG8Fr9.FHF_at_intruder.daytonoh.attgis.com>#1/1
We saw this problem with 2.0 when we were not taking the listoner down explicitly when we rebooted the system. We added
su - oracle -c "$ORACLE_HOME/bin/lsnrctl stop" to the oracle_stop script for system shutdown and once the listenor was taken down properly and then brought back up at system start, the problem went away.
HTH
Jim Gregory
>>=========="Östen Westman", 10/9/95==========
>>
>>After setting up SQL*Net 2.1 with Multi Threaded Server (MTS) parameters
>>our customer received an ORA-12203 error when trying to connect from a
>>client.
>>
>>When we checked the server process (tnslsnr) with the command
>>"lsnrctl status" we did not receive any indications of errors. The log
>>file listener.log did not contain any error messages at all.
>>
>>The connectivity problem disappeared after stop and start of the listener
>>process.
>>
>>Have anyone else encountered the same problem and is there any work
>>around available?
>>
>>oswe_at_ups.ifsab.se
>>
>>
Views and opinions expressed are mine and do not reflect my empoyer's or client's. Received on Tue Oct 10 1995 - 00:00:00 CET