Re: Oracle 8.0.5 error

From: ddf <oratune_at_msn.com>
Date: Mon, 20 Jun 2011 16:55:40 -0700 (PDT)
Message-ID: <5cca0d56-3154-40e5-a9b4-2bd0dc74a8af_at_g12g2000yqd.googlegroups.com>

On Jun 20, 2:27 pm, Dan <daniel.oster..._at_visaer.com> wrote:
> Gerald,
>
> Good question.  I don't know why either.  I checked those
> environmental variables, neither are set.  I found that I can connect
> this way in svrmgr30:
>
> connect internal/<PW>_at_<SID>
>
> This means it clearly uses tns, but why?  Also I always get the
> ora-12203 error as soon as I get into svrmgr30, even before I do a
> connect internal.  I've found some people who've gotten this error and
> suggestions are always tns/listener or sqlnet.ora.  I even did some
> registry hacks in the HOME0 but no luck. I'm completely stumped.  It's
> probably something simple, but no luck so far.
>
> Dan
>
> On Jun 19, 2:47 pm, "Gerard H. Pille" <g..._at_skynet.be> wrote:
>
>
>
> > Why would svrmgr try to connect to a database using TNS?
>
> > Why would it try to connect to a remote database?
>
> > Do you perhaps have LOCAL or TWO_TASK defined?
>
> > open a dos-box in your whinedoze environment, and try
>
> > echo %LOCAL%
> > echo %TWO_TASK%
>
> > or verify the output from "set"- Hide quoted text -
>
> - Show quoted text -

Can you successfully tnsping the service? What HOST is being used in the listner.ora? Is a loopback adapter installed?

David Fitzjarrell Received on Mon Jun 20 2011 - 18:55:40 CDT