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,
anandabrataAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

catchmeifuwantCommented:
Do you have any user with DBA privileges? If you have one, then login and change the system password..

alter user system identified by new_password;
0
anandabrataAuthor Commented:
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.
0
catchmeifuwantCommented:
sys - default password is change_on_install
system - manager

If you can login as sys (or any user with dba privileges) then it's easy to change the password for system user...

Else,if you are using a password file, then you can change it. Following are the links :

http://www.orafaq.com/faqdbase.htm
http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:1207835945571

Else, ask someone who has the sys login information...
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
VeluNCommented:
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
0
amiriCommented:
Hi use this statement:
>conn sys / as sysdba
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Databases

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.