anandabrata
asked on
How to change system password for Oracle 9i
Hi,
I have an Oracle 9i server. I want to change the "system" password for the same and I am not aware of the old password.
Please suggest how I can do the same.
Regards,
I have an Oracle 9i server. I want to change the "system" password for the same and I am not aware of the old password.
Please suggest how I can do the same.
Regards,
ASKER
I do not have any user with dba permission. But I have heard that the "sys" user has dba priviliges. I am not sure incase sys and system are the same user. And even if they are not then is the default password of the sys user change_on_install.
I tried sys/change_on_install as sysdba ..the same is also not being accepted at prompt. Isn't there any other way to resolve this issue.
I tried sys/change_on_install as sysdba ..the same is also not being accepted at prompt. Isn't there any other way to resolve this issue.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Hi,
You know need to have SYS password if your loging from same server where database is installed.
if its windows:
Start->Run-> sqlplusw /nolog
SQL> connect / as sysdba
SQL> aler user system identified by manager;
SQL> connect system/manager
if its unix:
oracle$ sqlplus /nolog
SQL> connect / as sysdba
SQL> aler user system identified by manager;
SQL> connect system/manager
Rgds,
Velu N
You know need to have SYS password if your loging from same server where database is installed.
if its windows:
Start->Run-> sqlplusw /nolog
SQL> connect / as sysdba
SQL> aler user system identified by manager;
SQL> connect system/manager
if its unix:
oracle$ sqlplus /nolog
SQL> connect / as sysdba
SQL> aler user system identified by manager;
SQL> connect system/manager
Rgds,
Velu N
Hi use this statement:
>conn sys / as sysdba
>conn sys / as sysdba
alter user system identified by new_password;