Thursday, 4 May 2023

How to change Apps Password in R12.1

 /* CHANGE APPLICATION USER PASSWORD USING FNDCPASS*/


FNDCPASS apps/APPS_PASSWORD 0 Y system/SYSTEM_PASSWORD USER USER_WHOSE_PASSWORD_WILL_BE_CHANGED NEWPASSWORD

Example: FNDCPASS apps/apps 0 Y system/manager USER SYSADMIN sysadmin

/* CHANGE "APPS" USER PASSWORD USING FNDCPASS in "R11"*/
 
FNDCPASS apps/apps 0 Y system/SYSTEM_PASSWORD SYSTEM APPLSYS NEWPASSWORD
Note: Changing apps password will also change applsys password. apps and applsys passwords are always the same..

/* CHANGE "APPS" USER PASSWORD USING FNDCPASS in "R12"*/
FNDCPASS apps/APPS_PASSWORD 0 Y system/SYSTEM_PASSWORD SYSTEM APPLSYS NEW_PASSWORD

Form Migration R12


FORM Compilation UAT to PRODà
Copy the given FMB file from UAT to PROD.
Goto à AU_TOP/forms
/d03/UATAPPL/apps/apps_st/appl/au/12.0.0/forms/USà Uat form location.
Copy the .fmb file to PROD.
Nowà goto PROD.
Form locationà
Cd /ProdApp/oracle/PROD/apps/apps_st/appl/au/12.0.0/forms/US
From root
Change the ownership and permission to .fmb file.
Chmod –R 777 .fmb
Chown –R applprod:dba
Su – applprod
Now run the form compilation command from AU_TOP/forms Location only
In PROD
frmcmp_batch userid=apps/oracledba1 module=XXLTCEL_IOT.fmb output_file=$XXLTK_TOP/forms/US/XXLTCEL_IOT.fmx module_type=form batch=no compile_all=yes

IN UAT
frmcmp_batch userid=apps/apps module=XXLTK_ORDER_SHIP_BILL_DETAILS.fmb output_file=$XXLTK_TOP/forms/US/XXLTK_ORDER_SHIP_BILL_DETAILS.fmx module_type=form batch=no compile_all=yes
.Pll file compilation:à
[appldev@ltk1 resource]$ ls -ltr JAINTPTY.pll
-rwxr-xr-x. 1 appldev dba 147456 Jun 15 08:06 JAINTPTY.pll
[appldev@ltk1 resource]$ frmcmp_batch module=JAINTPTY.pll userid=apps/apps module_type=library compile_all=special

1.frmcmp_batch userid=apps/oracledba1 module=JAINBOEI.fmb output_file=/ProdApp/oracle/PROD/apps/apps_st/appl/ja/12.0.0/forms/US/JAINBOEI.fmx module_type=form batch=no compile_all=yes

2.frmcmp_batch userid=apps/oracledba1 module=JAINBOER.fmb output_file=/ProdApp/oracle/PROD/apps/apps_st/appl/ja/12.0.0/forms/US/JAINBOER.fmx module_type=form batch=no compile_all=yes

3.frmcmp_batch userid=apps/oracledba1 module=JAINTXRP.fmb output_file=/ProdApp/oracle/PROD/apps/apps_st/appl/ja/12.0.0/forms/US/JAINTXRP.fmx module_type=form batch=no compile_all=yes





How to Change WebLogic Password in R12.2

 Changing Weblogic Password in R12.2 Environment. 

*Login to primary application Node. 

goto cd $FND_TOP/patch/115/bin and run below command.

[applmgr@sreeniapps bin]$ perl txkUpdateEBSDomain.pl action=updateAdminPassword

Program: txkUpdateEBSDomain.pl started at Thu May  4 21:52:00 2023


AdminServer will be re started after changing WebLogic Admin Password

All Mid Tier services should be SHUTDOWN before changing WebLogic Admin Password

Confirm if all Mid Tier services are in SHUTDOWN state. Enter "Yes" to proceed or anything else to exit: yes


Enter the full path of Applications Context File [DEFAULT - /u01/oracle/VIS/fs2/inst/apps/VIS_valiapps/appl/admin/VIS_valiapps.xml]:

Enter the WLS Admin Password:

Enter the new WLS Admin Password:

Enter the APPS user password:


Executing: /u01/oracle/VIS/fs2/FMW_Home/webtier/perl/bin/perl /u01/oracle/VIS/fs2/EBSapps/appl/ad/12.0.0/patch/115/bin/adProvisionEBS.pl  ebs-get-serverstatus -contextfile=/u01/oracle/VIS/fs2/inst/apps/VIS_valiapps/appl/admin/VIS_valiapps.xml -servername=AdminServer -promptmsg=hide -logfile=/u01/oracle/VIS/fs2/inst/apps/VIS_valiapps/logs/appl/rgf/TXK/txkUpdateEBSDomain_Thu_May_4_21_52_00_2023/EBSProvisioner.log


Updating Weblogic Domain in online mode

---------------------------------------

Backup Location : /u01/oracle/VIS/fs2/inst/apps/VIS_valiapps/logs/appl/rgf/TXK/txkUpdateEBSDomain_Thu_May_4_21_52_00_2023

Logfile Location: /u01/oracle/VIS/fs2/inst/apps/VIS_valiapps/logs/appl/rgf/TXK/txkUpdateEBSDomain_Thu_May_4_21_52_00_2023/updateAdminPassword.log


Executing: /u01/oracle/VIS/fs2/EBSapps/comn/util/jdk32/jre/bin/java -classpath :/u01/oracle/VIS/fs2/FMW_Home/wlserver_10.3/server/lib/weblogic.jar:/u01/oracle/VIS/fs2/FMW_Home/Oracle_EBS-app1/oui/jlib/srvm.jar:/u01/oracle/VIS/fs2/EBSapps/comn/java/classes:/u01/oracle/VIS/fs2/EBSapps/comn/shared-libs/ebs-3rdparty/WEB-INF/lib/ebs3rdpartyManifest.jar:/u01/oracle/VIS/fs2/FMW_Home/Oracle_EBS-app1/shared-libs/ebs-appsborg/WEB-INF/lib/ebsAppsborgManifest.jar oracle.apps.ad.util.UpdateEBSDomain updateAdminPassword  -contextfile /u01/oracle/VIS/fs2/inst/apps/VIS_valiapps/appl/admin/VIS_valiapps.xml -promptmsg hide -logdir /u01/oracle/VIS/fs2/inst/apps/VIS_valiapps/logs/appl/rgf/TXK/txkUpdateEBSDomain_Thu_May_4_21_52_00_2023 -logfile /u01/oracle/VIS/fs2/inst/apps/VIS_valiapps/logs/appl/rgf/TXK/txkUpdateEBSDomain_Thu_May_4_21_52_00_2023/updateAdminPassword.log


Domain updated successfully

Restarting AdminServer with new Admin Password.


You are running adadminsrvctl.sh version 120.10.12020000.11


Stopping WLS Admin Server...

Refer /u01/oracle/VIS/fs2/inst/apps/VIS_valiapps/logs/appl/admin/log/adadminsrvctl.txt for details


AdminServer logs are located at /u01/oracle/VIS/fs2/FMW_Home/user_projects/domains/EBS_domain_VIS/servers/AdminServer/logs


adadminsrvctl.sh: exiting with status 0


adadminsrvctl.sh: check the logfile /u01/oracle/VIS/fs2/inst/apps/VIS_valiapps/logs/appl/admin/log/adadminsrvctl.txt for more information ...



You are running adnodemgrctl.sh version 120.11.12020000.12



NodeManager log is located at /u01/oracle/VIS/fs2/FMW_Home/wlserver_10.3/common/nodemanager/nmHome1


adnodemgrctl.sh: exiting with status 0


adnodemgrctl.sh: check the logfile /u01/oracle/VIS/fs2/inst/apps/VIS_valiapps/logs/appl/admin/log/adnodemgrctl.txt for more information ...



You are running adadminsrvctl.sh version 120.10.12020000.11


Starting WLS Admin Server...

Refer /u01/oracle/VIS/fs2/inst/apps/VIS_valiapps/logs/appl/admin/log/adadminsrvctl.txt for details


AdminServer logs are located at /u01/oracle/VIS/fs2/FMW_Home/user_projects/domains/EBS_domain_VIS/servers/AdminServer/logs


adadminsrvctl.sh: exiting with status 0


adadminsrvctl.sh: check the logfile /u01/oracle/VIS/fs2/inst/apps/VIS_valiapps/logs/appl/admin/log/adadminsrvctl.txt for more information ...



*************** IMPORTANT ****************

WebLogic Admin Password is changed.

Restart all application tier services using control scripts.

********************************************



----------------------------------------

Inside generateMimeMappingsPropFile()...

----------------------------------------

/u01/oracle/VIS/fs2/FMW_Home/user_projects/domains/EBS_domain_VIS/config/mimemappings.properties already exists, updating it.

--------------------------------------

Inside updateMimeMappingsPropFile()...

--------------------------------------

-------------------------------------

Inside resetExistingMimeMappings()...

-------------------------------------

Overwriting the value for the parameter: png

Overwriting the value for the parameter: xml

Overwriting the value for the parameter: js

Overwriting the value for the parameter: svg

Overwriting the value for the parameter: swf

Reset of mime mappings completed.

---------------------------

Inside addMimeMappings()...

---------------------------

Adding of mime mappings completed.

Taking backup of existing mimemappings.properties.

Copying the file

----------------

SOURCE : /u01/oracle/VIS/fs2/FMW_Home/user_projects/domains/EBS_domain_VIS/config/mimemappings.properties

TARGET : /u01/oracle/VIS/fs2/FMW_Home/user_projects/domains/EBS_domain_VIS/config/mimemappings.properties_bkp

Copying temporary file as mimemappings.properties.

Copying the file

----------------

SOURCE : /u01/oracle/VIS/fs2/FMW_Home/user_projects/domains/EBS_domain_VIS/config/mimemappings.properties_temp

TARGET : /u01/oracle/VIS/fs2/FMW_Home/user_projects/domains/EBS_domain_VIS/config/mimemappings.properties

/u01/oracle/VIS/fs2/FMW_Home/user_projects/domains/EBS_domain_VIS/config/mimemappings.properties updated successfully.

Program: txkUpdateEBSDomain.pl completed at Thu May  4 21:55:28 2023

[applmgr@sreeniapps bin]$


*Start all application services using adstrtall.sh 

*Log in to the WebLogic Administrative console.

*Click Lock & Edit and click Domain.

Click on the Security tab and click on the Advanced tab.





Enter the new password that you want for the WebLogic admin user in the Node Manager Password.




click on save and activate changes









How to change Apps Password in R12.1

  /* CHANGE APPLICATION USER PASSWORD USING FNDCPASS*/ FNDCPASS apps/APPS_PASSWORD 0 Y system/SYSTEM_PASSWORD USER USER_WHOSE_PASSWORD_WILL_...