Change Oracle SYSADM password

[gkemner]

Has anyone ever had to change the password for the Oracle SYSADM user?
We want to do so, but are not sure the best method to do so. I logged a
call with PTC and they said the question was outside of the scope of
their responsibility so they were no help.

Anything to watch out for or that could get messed up by changing it?
Any info on how to change the password for the Oracle SYSADM would be
appreciated.

Thanks!

[BobLehman2]

On 3/19/2010 12:12 PM, Kemner, Greg (AS) wrote:
I assume you are not using that password for connecting as windchill or
for cognos reporting, so I do not see why this would be an issue. I did
to a customer system because they forgot the password and have not seen
any ramifications from doing so. If anyone knows differently I would be
really interested in hearing what the issues were..
>
> Has anyone ever had to change the password for the Oracle SYSADM
> user? We want to do so, but are not sure the best method to do so. I
> logged a call with PTC and they said the question was outside of the
> scope of their responsibility so they were no help.
>
> Anything to watch out for or that could get messed up by changing it?
> Any info on how to change the password for the Oracle SYSADM would be
> appreciated.
>
> Thanks!
>

[ssenthil]

Can't we use FNDCPASS

FNDCPASS logon 0 Y system/password mode username new_password



Where logon is username/password[@connect]
System/password is password of the system account of that database
Mode is SYSTEM/USER/ORACLE
Username is the username where you want to change its password
new_password is the new password in unencrypted format





Thank you and have a great time.

Best Regards

Swamy Senthil

973 216 0456(M)

866 908 6561(F)

Swasen Inc

www.swasen.com

[patrick.chin1]

I've done this mostly for a unix systems where the installation of oracle has the requirement for sysdba password disabled:

• if you log into the actual physical server where oracle database is installed as the oracle system unix user that belongs to the dba system unix group, you can then run this command in sqlplus mode
  • $ORACLE_HOME/bin/sqlplus

SQL*Plus: Release 11.1.0.6.0 - Production on Mon Nov 5 00:00:31 2007
Copyright (c) 1982, 2007, Oracle. All rights reserved.
Enter user-name: / as sysdba

SQL> alter user SYSADM identified by <enter password=" here=">;

SQL> commit;

SQL> exit;

this is a backdoor to change passwords if you forgot them.