Re: Why: ORA-12203: TNS:unable to connect to destination

Dear Tim Taylor,

I have similar problem too but more serious .... I found that the problem was due to the error when starting the instance. When I reboot the NT server, all instances are started. However, after a while, I checked the SERVICES and found that all of the OracleServiceSID were stopped .. (no STARTED message was shown).

Do you know what happens? I have tried to start the service manually but still failed. Whenever I connect to the database, the application returns error message "ORA-12203: TNS:unable to connect to destination".

BTW, I am using NT Oracle Server 8.0.3.0.0 ...

Thanks a lot.

Ronald

Tim Taylor ¼¶¼g©ó¤å³¹ <35B4B111.E3EB01DE_at_us.oracle.com>...
>Gene,
>
>Server Manager is attempting to connect to a 'default' database, probably
>the one identified by ORACLE_SID or LOCAL in your NT registry.
>
>Tim Taylor
>
>Gene Hubert wrote:
>
>> I'm running Oracle 8.0.3.2.2 on NT 4.0.
>>
>> Why do I get "ORA-12203: TNS:unable to connect to destination" when I
>> run Server Manager. I've been ignoring it and just typing a connect
>> command manually and all seems to work ok.
>>
>> Can this cause the heebie jeebies if I don't fix it?
>>
>> Gene Hubert
>> Qualex Inc.
>> Durham, NC
>
Received on Tue Jul 21 1998 - 11:42:26 CDT