RE: To recover DBA password of Oracle 9.2.0.1 on Windows 2000
- From: "Ranjeesh K R." <ranjeeshk@xxxxxxxxxx>
- To: "Kumar, Dharminder" <Dharminder.Kumar@xxxxxxxxx>
- Date: Fri, 23 Jul 2004 19:05:45 +0530
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@xxxxxxxxx]
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
