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

Home -> Community -> Mailing Lists -> Oracle-L -> RE: To recover DBA password of Oracle 9.2.0.1 on Windows 2000

RE: To recover DBA password of Oracle 9.2.0.1 on Windows 2000

From: Ranjeesh K R. <ranjeeshk_at_infics.com>
Date: Fri, 23 Jul 2004 19:05:45 +0530
Message-ID: <A70AE049E81A6A40879D5DC0AC8C38C9ADDDC4@venus.infics.com>


Hi ,

tried out that . I guess it will work if we are having an OS = authenticated user and all. here I don't have any OS authenticated = users.
My current windows ID is aprt of ORA_DBA group of windows 2000. Tried = out even orapwd utility too.I have changed the values in=20 sqlnet.ora to SQLNET.AUTHENTICATION_SERVICES =3D (NTS). But still not = working=20

<<<<<<<<<<<<<<

Z:\>sqlplus / as sysdba
Usage: SQLPLUS [ [<option>] [<logon>] [<start>] ] where <option> ::=3D -H | -V | [ [-L] [-M <o>] [-R <n>] [-S] ]

      <logon> ::=3D <username>[/<password>][@<connect_string>] | / | = /NOLOG

      <start>  ::=3D @<URI>|<filename>[.<ext>] [<parameter> ...]

"-H" displays the SQL*Plus version banner and usage syntax
"-V" displays the SQL*Plus version banner
"-L" attempts log on just once
"-M <o>" uses HTML markup options <o>
"-R <n>" uses restricted mode <n>
"-S" uses silent mode

Z:\>sqlplus/nolog

SQL*Plus: Release 9.2.0.1.0 - Production on Fri Jul 23 15:10:48 2004

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

SQL> show user
USER is ""
SQL> Alter user sys identifed by 'test'; SP2-0640: Not connected

SQL>
SQL>
SQL> alter user sys identifed by 'test';
SP2-0640: Not connected
SQL> connect / as sysdba
ERROR:
ORA-01031: insufficient privileges

C:\>sqlplus "/ as sysdba"

SQL*Plus: Release 9.2.0.1.0 - Production on Fri Jul 23 18:38:53 2004

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

ERROR:
ORA-01041: internal error. hostdef extension doesn't exist

Enter user-name:

Tried this too


E:\oracle\ora90\bin>orapwd file=3D"E:\oracle\ora90\bin\pwd.txt" = password=3D"sys123"

E:\oracle\ora90\bin>

Z:\>sqlplus sys/sys123

SQL*Plus: Release 9.2.0.1.0 - Production on Fri Jul 23 15:32:06 2004

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

ERROR:
ORA-01017: invalid username/password; logon denied

Enter user-name: sys as sysdba
Enter password:
ERROR:
ORA-01017: invalid username/password; logon denied

Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon denied

SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus

Z:\>

Any thoughts ?

>>>>>>>>>>>>>

with thanks and regards=20
Ranjeesh K R=20
Senior Software Engineer=20
Infinite Computer Solutions (India) Private Limited=20

Ph           : 0091 80 2521 2901 Extn: 178=20
Mob        : 0091 80 9880 307939=20

Yahoo!!! : ranjeesh007=20

-----Original Message-----
From: Kumar, Dharminder [mailto:Dharminder.Kumar_at_Bmonb.com] Sent: Friday, July 23, 2004 3:14 AM
To: Ranjeesh K R.
Subject: RE: To recover DBA password of Oracle 9.2.0.1 on Windows 2000

Rajnish,
Following is the default password for sys and system user.

sys   	change_on_install
system	manager

If you have already changed the password and then forgot the password, = then try the following step.
Open a DOS session from windows.
C:>sqlplus / as sysdba=20
if you get the SQL prompt, then u can change the password by following = command.
SQL>Alter user sys identifed by 'new password';

HTH. -----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Ranjeesh K R. Sent: July 22, 2004 5:35 PM
Subject: To recover DBA password of Oracle 9.2.0.1 on Windows 2000 Importance: High

Hi,
I have forgot the the passwords of DBA Id's ( sys & system ) .Do you = know anyway to recover this password . I am logging in with the id with = which I installed oracle and all..

with thanks and regards=20
Ranjeesh K R=20



Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------


<FONT SIZE =3D =
1>***********************************************************************=
*****
This e-mail and any attachments may contain confidential and privileged =
information. If you are not the intended recipient, please notify the =
sender immediately by return e-mail, delete this e-mail and destroy any =
copies. Any dissemination or use of this information by a person other =
than the intended recipient is unauthorized and may be illegal. Unless =
otherwise stated, opinions expressed in this e-mail are those of the =
author and are not endorsed by the author's employer.</FONT>

----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Received on Fri Jul 23 2004 - 08:29:36 CDT

Original text of this message

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