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: [oracle-dev-l] RE: To recover DBA password of Oracle 9.2.0.1 on Win dows 2000

RE: [oracle-dev-l] RE: To recover DBA password of Oracle 9.2.0.1 on Win dows 2000

From: Ranjeesh K R. <ranjeeshk_at_infics.com>
Date: Sat, 24 Jul 2004 01:46:32 +0530
Message-ID: <A70AE049E81A6A40879D5DC0AC8C38C9ADDE76@venus.infics.com> 





Guys ,




At last it worked , problem was about the NAME & PATH of password file. =
Didn't know that it should be under $ORA_HOME/database dir and the name =
should be in the format of PWD{sid}.ora format . Freek D'Hooge's =
response was more specific . thanks a lot ..




<-------------



E:\oracle\ora90\bin>orapwd file=3DE:\oracle\ora90\database\PWDowb.ora =
password=3Dsys123



SQL> conn sys as sysdba


Enter password:


Connected.




-------------->





Thanks a lot guys & tons of cheers



Ranjeesh



-----Original Message-----



From: Diego Ricardo Barrueco via oracle-dev-l
[mailto:oracle-dev-l_at_Groups.ITtoolbox.com]
Sent: Friday, July 23, 2004 7:48 PM


To: Ranjeesh K R.


Cc: Oracle-L (E-mail)


Subject: [oracle-dev-l] RE: To recover DBA password of Oracle 9.2.0.1 on
Win dows 2000




# Resource Books for Oracle


# Read Paper: http://oracle.ITtoolbox.com/r/hdr.asp?r=3D29839



# View Group Archive: http://ITtoolbox.com/hrd.asp?i=3D821





Hi,



You said You have the OS user used to install Oracle DB ?



First of all, the sintax You're using is not correct:



        Sqlplus /nolog



And then



        Connect sys as sysdba



This should be done on command line. Not windows sqlplus.



Orapwd is NOT useful for You. Orapwd is used to create a password file =
to


authenticate OS users or remote users. In order to do that You need to =
know


the password. Also, to use a password file You need to set the
REMOTE_LOGIN_PASSWORDFILE db parameter.



The following command should tell You the current db_name:



        echo %ORACLE_SID%



If the name is null or it's not correct You should the values for =
ORACLE_SID



and ORACLE_HOME before trying to connect. If You don't know how, You can =
do


it through "Oracle Home Selector" ( Afterward You need to open a new =
command


line ). Once You have the correct ORACLE_HOME and ORACLE_SID You'll be =
able


to connect.



Then change the password



        alter user user_name identified by new_password;



Regards




-----Original Message-----



From: Ranjeesh K R. via oracle-dev-l


[mailto:oracle-dev-l_at_Groups.ITtoolbox.com]=20
Sent: Viernes, 23 de Julio de 2004 08:36 a.m.
To: Diego Ricardo Barrueco


Cc: Oracle-Dev-L (E-mail); Oracle-L (E-mail)
Subject: [oracle-dev-l] RE: To recover DBA password of Oracle 9.2.0.1 on =
Win


dows 2000


Importance: High





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>


*********Unstructured data integration...download WebQL******** For =
complex
Web and unstructured data integration projects Free download:
http://www.ITtoolbox.com/r/rd.asp?i=3D6224
***************************************************************
*Archives: http://Groups.ITtoolbox.com/g/oracle-dev-l.asp
*Manage Subscriptions: http://My.ITtoolbox.com
*Leave Group: mailto:leave-oracle-dev-l_at_Groups.ITtoolbox.com
*Need Subscription Help? mailto:Listmaster_at_ITtoolbox.com
*Terms of Use: http://www.ittoolbox.com/help/termsofuse.htm
*Copyright (c) ITtoolbox and message author. No redistribution.

*********Unstructured data integration...download WebQL********
For complex Web and unstructured data integration projects
Free download: http://www.ITtoolbox.com/r/rd.asp?i=3D6224
***************************************************************
*Archives: http://Groups.ITtoolbox.com/g/oracle-dev-l.asp
*Manage Subscriptions: http://My.ITtoolbox.com
*Leave Group: mailto:leave-oracle-dev-l_at_Groups.ITtoolbox.com
*Need Subscription Help? mailto:Listmaster_at_ITtoolbox.com
*Terms of Use: http://www.ittoolbox.com/help/termsofuse.htm
*Copyright (c) ITtoolbox and message author. No redistribution.



----------------------------------------------------------------

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 - 15:09:52 CDT












Original text of this message













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