Changing APPS & APPLSYS password

[lukman]

Dear all,

Has anyone change their APPS & APPLSYS password? Please help.

Based on oracle documentation that we need to change APPS & APPLSYS password in post installation tasks, I got metalink doc (ID: 160337.1) that stated like this :

IMPORTANT NOTE: Please only use this note as a last resort. The supported
method of changing the APPLSYS password is to use FNDCPASS, and this will also
change the APPS password automatically. Additionally, it is recommended to not
change the APPLSYSPUB password.

When using this note, please remember that the APPLSYS and APPS passwords always
have to be the same. Always change both at the same time. When changing these
passwords, it is important to change the APPLSYS password first and the APPS
password second. If the correct procedure to change these passwords is not
followed, users will not be able to login after the change. As a precaution,
please back up the FND_ORACLE_ID and FND_USER tables before beginning.

I tried to find table FND_ORACLE_ID but couldn't find it. Is it really FND_ORACLE_ID or FND_ORACLE_USERID ?

Thanks.

[admin]

It is FND_ORACLE_USERID and pl check the following metalink note,

Subject: FNDCPASS Utility New Feature ALLORACLE
Doc ID: Note:398942.1 Type: HOWTO
Last Revision Date: 21-MAY-2007 Status: PUBLISHED

[lukman]

It is FND_ORACLE_USERID and pl check the following metalink note,

Subject: FNDCPASS Utility New Feature ALLORACLE
Doc ID: Note:398942.1 Type: HOWTO
Last Revision Date: 21-MAY-2007 Status: PUBLISHED

<i><div align="right">Originally posted by admin - 24/05/2007 : 01:03:36 AM</div id="right"></i>

So we must backup FND_ORACLE_USERID and FND_USER table?

Is the parameter of succes determined only if we can login using second browser to applications? I can login using second browser then but I couldn't use menu System Admnistrator - Security - ORACLE - Register. The error window said that maybe the database password is wrong or can't connect to the database.

Is it better if I use Metalink Doc ID: 398942.1 to change all ORACLE schema passwords or I better use Metalink Doc ID: 160337.1? Thanks

[sudhakarpv5]

Hi Yudi,

To change the APPS and APPLSYS password is simple.
Just use the FNDCPASS utility and change the password for APPS user and it gets effected to APPLSYS user as well.
To use the utility, below is the command:
FNDCPASS apps/oldpasswd 0 Y system/passwd SYSTEM APPLSYS newpasswd
--> This will change the APPS password.
Then run AutoConfig utility and then you can log into the applications without any problems.

The ALLORACLE option changes the passwords for all the existing users, irrespective of their role/functionality, etc.

HTH,

[lukman]

Hi sudhakarpv5,

The problem is, I already use FNDCPASS but I don't know whether it failed or not. I haven't execute autoconfig, though. I already use sysadmin responsibility too. Like I wrote before, is the parameter of succes determined only if we can login using second browser to applications? I can login using second browser then but I couldn't use menu System Admnistrator - Security - ORACLE - Register. The error window said that maybe the database password is wrong or can't connect to the database. If I proceed to autoconfig I'm afraid I can't login and I have to re-install.

Thanks.

Hi Yudi,

To change the APPS and APPLSYS password is simple.
Just use the FNDCPASS utility and change the password for APPS user and it gets effected to APPLSYS user as well.
To use the utility, below is the command:
FNDCPASS apps/oldpasswd 0 Y system/passwd SYSTEM APPLSYS newpasswd
--> This will change the APPS password.
Then run AutoConfig utility and then you can log into the applications without any problems.

The ALLORACLE option changes the passwords for all the existing users, irrespective of their role/functionality, etc.

HTH,

<i><div align="right">Originally posted by sudhakarpv5 - 24/05/2007 : 07:47:14 AM</div id="right"></i>

[lukman]

I tried to use FNDCPASS again to change APPLSYS password. Below were what I did:

1. Start db & apps normally
2. stop concurrent using adcmctl.sh
$ . adcmctl.sh stop apps/apps
3. execute environment in <APPLTOP>
$ . APPS<sid>_<hostname>.env
4. enter sqlplus to backup fnd_oracle_userid table
$ sqlplus /nolog
SQL> connect system/manager;
SQL> create table backup_fnd_oracle_userid as select * from fnd_oracle_userid;
SQL> commit;
SQL> connect apps/apps;
SQL> create table backup_fnd_user as select * from fnd_user;
SQL> commit;
SQL> exit;
5. Execute FNDCPASS
$ FNDCPASS APPS/apps 0 Y system/manager SYSTEM APPLSYS test
6. Enter sqlplus again
$ sqlplus /nolog
SQL> connect system/manager;
SQL> alter user APPLSYS identified by test;
SQL> exit;
7. Change to <AD_TOP>/admin folder and execute adconfig.sh script
$ cd <AD_TOP>/admin
$ adconfig.sh
8. Enter location of context file
/ <APPL_TOP>/admin/<SID>_<hostname>.xml
9. Enter new APPS password when requested
10. Wait until process finished
11. Open browser and enter application
12. Click E-Business Suite Home page

Here's what I got :

The requested URL /oa_servlets/AppsLogin was not found on this server.


Hhhhhhhhh .... tired. What's wrong this time? I'd spent 3 days to change APPLSYS & APPS default password and still not success. Please help. Thanks.

[admin]

A new topic is added in the document named FNDCPASS with demonstration of changing apps password. Have a look,

topic.asp?TOPIC_ID=16

[lukman]

Hi,

Thanks for the marvelous work to create 11i administration steps. Here I want to share my experience to change APPLSYS & APPS password using FNDCPASS. In some ways it's the same in administration doc.

1. Start db tier and apps tier normally

2. Stop concurrent manager using adcmctl.sh script (located in <SID>comn/admin/scripts/<context>/)

$ . adcmctl.sh stop [apps user] / [apps password]

3. Change to <APPL_TOP> directory and execute APPS<SID>_<hostname>.env e.g.:

$ . APPSVIS2_clone.env

4. Enter sqlplus and connect using system username and password
$ sqlplus /nolog

SQL> connect system/manager;

5. Backup table fnd_oracle_userid and fnd_user:

SQL> create table [backup_table_fnd_oracle_userid] as select * from fnd_oracle_userid;

SQL> commit;

SQL> exit;

SQL> connect apps/apps;

SQL> create table [backup_table_fnd_user] as select * from fnd_user;

SQL> commit;

SQL> exit;

6. Execute FNDCPASS for APPLSYS only

$ FNDCPASS APPS/[apps_password] 0 Y system/manager SYSTEM APPLSYS [apps_new_password]

7. Open wdbsrv.app file (usually located in /$ORACLE_HOME/iAS/Apache/modplsql/cfg> and change apps password to [apps_new_password] if it hadn?t been change

8. Open CGImd.dat (usually located in /$ORACLE_HOME/8.0.6/reports60/server) and change apps password to [apps_new_password] if it hadn?t been change

9. Change to <COMMON_TOP>/admin/scripts/context and execute adconfig.sh script

$ cd $COMMON_TOP/admin/script/<SID>_hostname/

$ adconfig.sh

10. Enter location of context file when requested, usually under /<APPL_TOP>/admin/<SID>_<hostname>.xml

11. Enter new APPS password, that have been used when doing alter, when requested: [apps_new_password]

12. Wait until process finished

13. Try to login

Remember to turn on adcmtl.sh if you want to continue your job. Hope that helps. Thanks.