If you're only changing the Oracle password, I suggest you do it in 2
steps.
The biggest pain is that fact that you have to change the system user
password for every single user manually, so a quick change will make this
easier the next time you have to do it.
First step, copy (using create like) the Oracle JDE user to another user,
say JDESYS. The new JDESYS user will become the new system user for the
users to access the database, but use the JDE user for everything else.
Basically, this means you'll never have to change the password for JDESYS
again, since you won't be using it manually, only through OneWorld and no
one will have to know the password but you and the DBA.
Now you have to change each users security to use the new JDESYS user
(and password) instead of JDE. The nice thing is that the old JDE user still
works, and no one gets locked out of the system if they logout and back into
OW while you are making the changes, which can be done in the middle of the
day.
Second, you can change the JDE user's password and change the
RunOneWorld.sh, EndOneWorld.sh, and any cron jobs and custom scripts you
have created.
That should be it. Changing all the user's security is a pain, but this
way, you really only have to do it once. Just make sure any new users get
setup with the new system user.
Hope this helps.
Tim Woods
CNC / System Administrator
PTC Alliance <http://www.ptcalliance.com/>
(330) 829-5240
[email protected] <mailto:
[email protected]>