Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: connect with internal user in oracle 8.0.5

Re: connect with internal user in oracle 8.0.5

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Fri, 21 Dec 2007 21:00:13 +0100
Message-ID: <c86b3$476c1b4d$524b5c40$29882@cache5.tilbu1.nb.home.nl>


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...
Received on Fri Dec 21 2007 - 14:00:13 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US