| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: OT : Changing APPLSYS password in Oracle Human Resources
Hi Mario,
Mario wrote :
>> That's not the way it works.
>> I remember I did 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.
The procedure that Jeram used is exactly the same as Note:1013526.102 in Metalink. I followed the procedure without changing the configuration files and I still cannot login to the Oracle HR applications. Anyway, I found an article in Metalink that states that the apps password which is hardcoded in the file wdbsvr.app must be changed to the new password.
TESTora/8.0.6/listener/cfg/wdbsvr.app
TESTora/webdb/listener/cfg/wdbsvr.app
I changed the passwords and now I can finally login to the Oracle Apps.
Regds,
New Bee
-----Original Message-----
From: Jeram [mailto:jeram_at_asaba.co.id]
Sent: Wednesday, September 05, 2001 12:41 PM
To: Multiple recipients of list ORACLE-L
Subject: 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.
9. 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).
-- 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).Received on Wed Sep 05 2001 - 00:48:48 CDT
 |
 |