Re: connect with internal user in oracle 8.0.5

From: joel garry <joel-garry_at_home.com>
Date: Thu, 20 Dec 2007 15:37:48 -0800 (PST)
Message-ID: <edf7e970-34a9-41e8-9ec6-f7a86e943882@s19g2000prg.googlegroups.com>

On Dec 20, 2:15 pm, chijar <chi..._at_gmail.com> wrote:
> dear all,
> i connect through svrmgr30 but it shows me an error:
>
> ORA-12203: TNS:no se ha podido conectar con el destino
> SVRMGR>
>
> SVRMGR> connect internal
> Clave:
> ORA-12203: TNS:no se ha podido conectar con el destino
> SVRMGR> connect internal
> Clave:
> ORA-12203: TNS:no se ha podido conectar con el destino
> SVRMGR>
>
> i put "oracle" and "manager" in clave field but it seems the same
> error.
>
> i had set ORACLE_SID=SERVICE but didn't function. shows the same
> error, or i must to restart the service ?
>
> oracle std 8.0.5
> windows 2000 server
>
> thanks again
> cesar.

$ oerr ora 12203
12203, 00000, "TNS:unable to connect to destination" // *Cause: Invalid TNS address supplied or destination is not listening.

// This error can also occur because of underlying network transport
// problems.
// *Action: Verify that the service name you entered on the command

line
// was correct. Ensure that the listener is running at the remote node and
// that the ADDRESS parameters specified in TNSNAMES.ORA are correct. // Finally, check that all Interchanges needed to make the connection are
// up and running.

OK, you perhaps want to be doing this locally? Please display your entire environment, it is likely that you have something set wrong, either pointing to the wrong home or TWO_TASK is overriding something, or the home is not in the path. Let's see your tnsnames.ora while you are at it.

ORACLE_SID=SERVICE? Your instance is named SERVICE? Sure it's not something like ORCL?

You may simply need to use oradim to delete and recreate the service. It's been too long, but I seem to recall situations where this would fix things.

Obadvice: 8.0.5!?@#$@!!!

--
@home.com is bogus.
http://www.wired.com/gadgets/gadgetreviews/multimedia/2007/12/YE_Vaporware

Received on Thu Dec 20 2007 - 17:37:48 CST