Re: connect with internal user in oracle 8.0.5

On Dec 21, 12:00 pm, Frank van Bortel <frank.van.bor..._at_gmail.com> wrote:
> chijar 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.
>
> Because internal was invented with 8i - you're even before that.
> Any reason you're not on the terminal version of Oracle 8.0?
> --
> Regards,
> Frank van Bortel
>
> Top-posting is one way to shut me up...

???

"The following methods for authenticating database administrators replace the CONNECT INTERNAL syntax provided with earlier versions of the Oracle7 Server (CONNECT INTERNAL continues to be supported for backwards compatibility only): * operating system authentication
* password files" - http://download.oracle.com/docs/pdf/A32535_1.pdf Oracle7 Server Administrator's
Guide

Anyways, I think Ed got it with the terminal services thing that seems to be in a black hole in my brain.

jg

--
@home.com is bogus.
http://www.sciencemag.org/sciext/btoy2007/