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

Ronald,

Can you describe more about the problem you are having? After you reboot your machine, if you type
  net start
at command prompt. Do you see services
  OracleService{SID}
  OracleTNSListener{SID}
listed?

1. If they are listed, can you set ORACLE_SID={SID} and run svrmgr30 and connect to the database
2. If they are not listed, can you start them net start OracleService{SID} net start OracleTNSListener{SID} and then try the case 1 above?

Ken

     __ __ _ __ __
~~~~(__)|-< /-\(__ |__(-_ ~~~~~~~~~~~~~ Enabling the Information Age ~~~~~

In article <6p2gdj$3al$1_at_imsp009a.netvigator.com>,   "Ronald Wong" <spacew_at_hkstar.com> wrote:
> 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
> >
> >

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Thu Jul 23 1998 - 02:47:04 CDT