Forgot Password

[amerbaig]

I forgot the System and Sys Passwords. I have no other account to manage DBA activity. Is there any way to solve this problem?

Regards,

Amer

 

[rcurva]

You can change the password of INTERNAL using the orapwd utility. Afterwards, change the sys and system users passwords.

To change the password of internal: Make sure that you have shutdown the database before you change the password. Do not remove or modify the password file if you have a database or instance mounted using REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE(or SHARED) in your init.ora. If you do, you will be unable to reconnect remotely using the password file. Even if you replace it, you cannot use the new password file, because the
timestamp and checksums will be wrong.

Here's how you do it:
$orapwd file=$ORACLE_HOME/dbs/pwd<SID>.ora password=oracle entries=5

where:
file = Path and name of the password file. (mandatory)
password = Password for SYS and INTERNAL. (Mandatory)
entries = Maximum number of distinct DBAs and OPERs. (Optional, default=5)

 

[harris79]

On Solaris, as the oracle user run the following commands

ORACLE_SID=sid; export ORACLE_SID

svrmgrl
connect internal

alter user sys identified by <password>;
alter user system identified by <password>;

exit

Steve

 

[rcurva]

By the way, you are the DBA at your site right?

 

[amerbaig]

I am just talking about my home computer. On which I have installed oracle 3 months ago and NOW want to use it for some work.

I just need some more help from you. I run the command u send but it is still using same password for SYS. DO I need to do something else?

Regards
Amer

 

[carp]

Did you change the passwords from their default?
If not, then try sys/change_on_install and system/manager.