| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: connect with internal user in oracle 8.0.5
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:
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. Received on Fri Dec 21 2007 - 10:49:25 CST
 |
 |