On Dec 21, 2:06 pm, joel garry <joel-ga..._at_home.com> wrote:
> 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...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
I remember there being an issue with connecting internal via Windows
Terminal Services on older versions of Oracle (well, it would have to
be an older version to have 'connect internal'). Check note MetaLink
note 66397.1, and search MetaLink for 'terminal services'.
Received on Fri Dec 21 2007 - 14:47:53 CST
