topic Re: System and sys password in Operating System - Microsoft

System and sys password

carl airiel — Fri, 10 Feb 2006 01:25:34 GMT

I have a newly configured oracle9i on my pc. I have installed it on WIndows platform. My problem is that I have forgot my password. Is there anyway that I coumd retrieve my password?Thanks

Re: System and sys password

Bharat Katkar — Fri, 10 Feb 2006 01:32:45 GMT

Hi,

Password is never recovered. Only way is to recall what you have given earlier.
If that is not an Administrator User then you can reset users password by logging in as administrator.

Regards,

Re: System and sys password

Arunvijai_4 — Fri, 10 Feb 2006 01:42:45 GMT

Hi Carl,

I dont think you can find out password. Probably, with some internal tools with Oracle ?

-Arun

Re: System and sys password

Steven E. Protter — Fri, 10 Feb 2006 02:49:07 GMT

Shalom carl,

Once the password is forgotten in oracle it is not recoverable.

Thats why we had a policy of writing down passwords for oracle during isntallation in Chicago.

Oracle actaully does a good job encrypting it so you can't just browse and hack it.

Re-install oracle and perhaps follow my advice above.

SEP

Re: System and sys password

Arunvijai_4 — Fri, 10 Feb 2006 03:07:48 GMT

Hi Carl,

I am not sure this will be useful infact, i never tried this. There are some password crackers available for Oracle to get the password, this link may help you,

http://www.petefinnigan.com/weblog/archives/00000648.htm
http://www.webmasterfree.com/software/Security-Privacy/PasswordRecoveryTools/oracle_password_cracker_1.6.html#

-Arun

Re: System and sys password

Indira Aramandla — Fri, 10 Feb 2006 03:50:10 GMT

Hi Carl,

If you did not change the passwords of sys and system then they will be the default passwords. From oracle 9i onwards svrmgrl is not supported. You can only loon as
sqlplus /nolog or
sqlplus "/ as sysdba"

On NT: On NT the OSOPER and OSDBA groups are hard coded names thus:

Group Name Oracle uses this as...
~~~~~~~~~~ ~~~~~~~~~~~~~~~~~~~~~
ORA_OPER OSOPER group for all instances
ORA_DBA OSDBA group for all instances
ORA_sid_OPER OSOPER group for a specific Oracle SID
ORA_sid_DBA OSDBA group for a specific Oracle SID

When you issue a 'CONNECT / AS SYSDBA' Oracle checks if your NT logon is a member of the 'ORA_sid_DBA' or 'ORA_DBA' group.

Indira A

Re: System and sys password

Vibhor Kumar Agarwal — Fri, 10 Feb 2006 06:35:52 GMT

Hey a small confusion,

You have lost the password of which:
Oracle or Windows

Couple of posts here suggest for windows and other couple for oracle :-)

Re: System and sys password

Yogeeraj_1 — Sat, 11 Feb 2006 05:24:44 GMT

hi,

assuming this is an Oracle password problem, you can just connect as "/as sysdba" on the local machine and do an "alter user system identified by xxxx;'

hope this helps!

kind regards
yogeeraj