Hi Catherine,
That's pretty interesting. AFAIR, I didn't have to change any hard code when we
working with Oracle Apps 10.7 NCA.
What version you're working with?
Salu2
Mario Alberto Ramos
>>> "CHAN Chor Ling Catherine (CSC)" <[EMAIL PROTECTED]> 09/05/01 01:48 AM >>>
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:[EMAIL PROTECTED]]
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 Orcle
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
<[EMAIL PROTECTED]>
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.
>>> [EMAIL PROTECTED] 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: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858)
538-5051
San Diego, California -- Public Internet access /
Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself frm this mailing list, send an E-Mail
message
to: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
Re: RE: OT : Changing APPLSYS password in Oracle Human
Mario Alberto Ramos Arellano Wed, 05 Sep 2001 12:41:22 -0700
- RE: OT : Changing APPLSYS password in Oracl... Mario Alberto Ramos Arellano
- RE: OT : Changing APPLSYS password in ... CHAN Chor Ling Catherine (CSC)
