Tuesday, January 5, 2021

How to change apps& sysadmin password in R12.2

 

How to change apps user password in R12.2.4


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

2. 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



3. Start AdminServer using the $INST_TOP/admin/scripts/adadminsrvctl.sh
Note:Don't start any other application tier services.


4. 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 is a schema which 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 table 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 administarative purpose. 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, intially it connects to a public schema called APPLSYSPUB. This validates AOL username and password that we enter (operations/welcome using guest user account. Once this is verified we select responsibility, this is validated by APPLSYS schema and then it connects to APPS schema.

 

 

No comments:

Table import and export.

Create Data Pump Directory. The first step in Oracle Data Pump is to create an OS level directory which will be used by Oracle for perform...