Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 9677
  • Last Modified:

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,
0
anandabrata
Asked:
anandabrata
1 Solution
 
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
 
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

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now