| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: To recover DBA password of Oracle 9.2.0.1 on Windows 2000
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
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
-----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
-- 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
 |
 |