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,
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
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.
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/faqd
http://asktom.oracle.com/p
Else, ask someone who has the sys login information...
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
Business Accounts
Answer for Membership
by: catchmeifuwantPosted on 2004-11-24 at 02:51:20ID: 12663775
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;