Re: Made stupid mistake, how can I recover?

From: Frank van Bortel <fvanbortel_at_netscape.net>
Date: Tue, 19 Apr 2005 18:36:52 +0200
Message-ID: <d43bsb$48m$1@news5.zwoll1.ov.home.nl>

Paul wrote:
> Frank van Bortel <fvanbortel_at_netscape.net> wrote:
>
>
>

>>I'm going to reply on my own posting, as I probably
>>had some wires seriously crossed.
>>Not being able to logon to Oracle is probably what
>>the OP meant - not being locked out from XP.

>
>
>
> Exactly!
>
>
>

>>If so - usual help handles involve: error messages
>>and version(s) of the Oracle software

>
>
>
> Didn't even obey my own .sig!
>
>
> Error is ORA-12560 TNS: protocol adapter error
>
>
> (When I try to log in as SYSTEM, SYS, or SCOTT!
>
>
> I think that I buggered something when I tried to create an Oracle
> Server Manager???
>
>
> Paul....
>
>
>

open a command session (also known as a "DOS-box"). set your oracle environment: set oracle_sid=orcl Of course, orcl might be different from your environment; adapt accordingly.
sqlplus "/ as sysdba"
if you already get an error here, try this first: net start oracleserviceorcl - again, orcl might be different for you. then try sqlplus "/ as sysdba" again.
you should now have 'connected to an idle instance' startup
connect scott/tiger, etc...

Here's a session:
C:\>sqlplus "/ as sysdba"
SQL*Plus: Release 9.2.0.4.0 - Production on Tue Apr 19 18:33:19 2005 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

ERROR:
ORA-12560: TNS:protocol adapter error

Enter user-name:
C:\>set oracle_sid=db920

C:\>sqlplus "/ as sysdba"
SQL*Plus: Release 9.2.0.4.0 - Production on Tue Apr 19 18:33:37 2005 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

ERROR:
ORA-12560: TNS:protocol adapter error

Enter user-name:
C:\>net start oracleserviceDB920
De OracleServiceDB920-service wordt gestart............... De OracleServiceDB920-service is gestart.

Connected to:
Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production (my DB920 instance is autostarting: starting the instance will mount and open the database - this need not be)

-- 
Regards,
Frank van Bortel

Received on Tue Apr 19 2005 - 11:36:52 CDT