How to change apps& sysadmin passwords in R12.2
Important Note: These steps must be carried out on the run file system.
Step 1. Shut down the application tier services using the
[applmgr@document appl]$INST_TOP/admin/scripts/adstpall.sh
- Change the APPLSYS password.
[applmgr@document appl]$ FNDCPASS apps/apps 0 Y system/ manager SYSTEM APPLSYS <new apps passwd>
FNDCPASS apps/apps 0 Y system/manager SYSTEM APPLSYS newpasswd
- Start AdminServer using the $INST_TOP/admin/scripts/adadminsrvctl.sh
Note:Don’t start any other application tier services. - Change the “apps” password in WLS Datasource as follows:
Log in to WLS Administration Console. http://document.subnet.vcn.oraclevcn.com:8000/OA_HTML/AppsLogin
Click Lock & Edit in Change Center.
In the Domain Structure tree, expand Services, then select Data Sources.
On the “Summary of JDBC Data Sources” page, select EBSDataSource
On the “Settings for EBSDataSource” page, select the Connection Pool tab.
Enter the new password in the “Password” field.
Enter the new password in the “Confirm Password” field.
Click Save.
Check whether you are able to connect to DB using apps
sqlplus apps/<newpassword> from application tier.
Before Starting all the services. Run Autoconfig.
cd $ADMIN_SCRIPTS_HOME
sh adautocfg.sh
Now start the services.
Start all the application tier services using the
$INST_TOP/admin/scripts/adstrtal.sh script.
How to change the SYSADMIN password
[applmgr@document appl]$ FNDCPASS apps/*** 0 Y system/manager USER SYSADMIN new_password
What is Apps Schema?
Apps are a schema that does not contain any tables of itself. We can say APPS is the shared runtime schema for all E-Business Suite products. It contains all the synonyms of all the tables in Oracle apps. But it also contains packages, functions, procedures. The default password is apps.
What is Applsys Schema?
Applsys schema contains all the tables required for administrative purposes. The default password is apps. All the technical products’ database objects are consolidated into a single schema called Applsys
What is Applsyspub schema?
Applsyspub schema is responsible for password checking. The default password is pub.Applsyspub is used for authentication by having read-only views.
Why should Apps & Applsys passwords always be the same?
The need to have the same password for Apps and Applsys is because when you sign on to apps, initially it connects to a public schema called APPLSYSPUB. This validates the AOL username and password that we enter (operations/welcome using a guest user account. Once this is verified we select responsibility, this is validated by APPLSYS schema and then it connects to APPS schema.
Thank you for giving your valuable time to read the above information.
If you want to be updated with all our articles send us the Invitation or Follow us:
Ramkumar’s LinkedIn: https://www.linkedin.com/in/ramkumardba/
LinkedIn Group: https://www.linkedin.com/in/ramkumar-m-0061a0204/
Facebook Page: https://www.facebook.com/Oracleagent-344577549964301
Ramkumar’s Twitter: https://twitter.com/ramkuma02877110
Ramkumar’s Telegram: https://t.me/oracleageant
Ramkumar’s Facebook: https://www.facebook.com/ramkumarram8
