Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: OT : Changing APPLSYS password in Oracle Human

RE: OT : Changing APPLSYS password in Oracle Human

From: CHAN Chor Ling Catherine (CSC) <clchan_at_nie.edu.sg>
Date: Wed, 05 Sep 2001 17:10:26 -0700
Message-ID: <F001.003840A7.20010905171053@fatcity.com> 






Hi Mario,



Version 11i



Regds,


Catherine

                -----Original Message-----
                From:   Mario Alberto Ramos Arellano
[mailto:alramos_at_capufe.gob.mx]
                Sent:   Thursday, September 06, 2001 4:41 AM
                To:     Multiple recipients of list ORACLE-L
                Subject:        Re: RE: OT : Changing APPLSYS password in


Oracle Human


                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)" <clchan_at_nie.edu.sg>
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: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 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.
  
  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 frm 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: 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: 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 - 19:10:26 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US