Re: OT : Changing APPLSYS password in Oracle Human Resources

Hi..

This is the way How I changed my apps and applsys password :

1. Shutdown your concurrent manager and make sure there is noone using the application.
2. Start your oracle APPS and logon as Sysadmin (with System Administrator Responsibility)
3. Go to security--->Oracle--->register
4. Query all users in Oracle APPS ( if you are using Oracle APPS 11 or 11i just type ctrl+f11 it will display all users)
5. Click in the Password column(tab) for Apps and Applsys user , type new password and press enter then retype it again for confirmation, do it one by one for APPS and APPLSYS user.
6. Save your work and exit from oracle apps.
7. now you have to use SQLPLUS to logon to the database connect as SYSTEM or SYS 8.type " alter user apps identified by (the same password entered from application level)" do it for applsys also.
8. task completed

If possible do it first in you Test environment, test it, if it is OK then try in Production, or before doing it take a full backup of your application and database also.

Hope this can help you.

Thanks
Jeram
-----Original Message-----
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Date: Wednesday, September 05, 2001 10:19 AM

That's not the way it works.
I remember I dit it once and the right steps are on metalink (you need to do it in Oracle Apps and afterwards in the database). Be pretty careful as you might screw your whole application up on changing the apps password.

>>> clchan_at_nie.edu.sg 09/04/01 07:30 AM >>>
Hi Oracle App DBA Gurus,

Does anyone have a list of files that "hardcode" the APPLSYS & APPS password in the oracle software directory ? I am about to change the APPS & APPLSYS password but worry that the HR application will not run smoothly as I believe the passwords of APPLSYS & APPS accounts are "hardcoded" in the configuration files. Any pointers ? TIA

Regds,
New Bee

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: CHAN Chor Ling Catherine (CSC)
  INET: clchan_at_nie.edu.sg

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mario Alberto Ramos Arellano
  INET: alramos_at_capufe.gob.mx

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jeram
  INET: jeram_at_ASABA.CO.ID

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).