Re: connect with internal user in oracle 8.0.5

On Dec 21, 8:49 am, chijar <chi..._at_gmail.com> wrote:
> On 20 dic, 18:37, joel garry <joel-ga..._at_home.com> wrote:
>
>
>
>
>
> > On Dec 20, 2:15 pm, chijar <chi..._at_gmail.com> wrote:
>
> > > dear all,
> > > iconnectthrough svrmgr30 but it shows me an error:
>
> > > ORA-12203: TNS:no se ha podido conectar con el destino
> > > SVRMGR>
>
> > > SVRMGR>connectinternal
> > > Clave:
> > > ORA-12203: TNS:no se ha podido conectar con el destino
> > > SVRMGR>connectinternal
> > > 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 toconnectto 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!?@#$@!!!
>
> > jg
> > --
> > @home.com is bogus.http://www.wired.com/gadgets/gadgetreviews/multimedia/2007/12/YE_Vapo...Ocultar texto de la cita -
>
> > - Mostrar texto de la cita -
>
> well..
> After that situation i could connect locally but with SYS.
> The error was that i connect through terminal server client to my
> oracle db server. when i connect in front of oracle db server i can
> connect but in this way:
>
> **********************************************************************
> C:\Documents and Settings\Administrador>svrmgr30
>
> Oracle Server Manager Release 3.0.5.0.0 - Production
>
> (c) Copyright 1997, Oracle Corporation. Todos los derechos reservados.
>
> Oracle8 Release 8.0.5.0.0 - Production
> PL/SQL Release 8.0.5.0.0 - Production
>
> SVRMGR> CONNECT
> Nombre de Usuario: SYS AS SYSDBA
> Clave:
> Conectado.
> ***********************************************************************
>
> but when i try to connect with internal, i can't, do you know what is
> default password of that? i put "oracle" and "manager" but it shows
> "invalid passsword, logon denied"
>
> thanks again

Likely causes are either you need to recreate the password file or you are in the wrong OS group. I really don't remember more than that!

jg

--
@home.com is bogus.
Those darn Spaniards!  http://www.signonsandiego.com/uniontrib/20071221/news_1b21vish.html