Change APPS password Oracle EBZ R12 (12.2)

🛠️ Changing APPS Password in Oracle EBS R12.2

Note: Always ensure you take proper backups before altering APPS, APPLSYS, or APPS_NE user passwords.

🔐 Tables to Backup

• FND_USER
• FND_ORACLE_USERID

create table FND_USER_BK as select * from FND_USER;
create table FND_ORACLE_USERID_BK as select * from FND_ORACLE_USERID;

⛔ Step 1: Shut Down the Application Tier

cd /u01/app/PROD
. EBSapps.env run
cd $ADMIN_SCRIPTS_HOME
adstpall.sh

🔄 Step 2: Change APPLSYS Password

A. Using FNDCPASS

FNDCPASS apps/<appspwd> 0 Y system/manager SYSTEM APPLSYS <new_password>

B. Using AFPASSWD

AFPASSWD -c apps@UAT -s APPLSYS

⚙️ Step 3: Run AutoConfig

cd /u01/app/PROD
. EBSapps.env run
cd $ADMIN_SCRIPTS_HOME
adautocfg.sh

🚀 Step 4: Restart Admin Server

cd $ADMIN_SCRIPTS_HOME
sh adadminsrvctl.sh start

📊 Step 5: Verify Server Status

sh adadminsrvctl.sh status

🔁 Step 6: Update WebLogic Datasource Password

A. For AD TXK Delta 7 or Higher

perl $FND_TOP/patch/115/bin/txkManageDBConnectionPool.pl

Choose: updateDSPassword

B. For AD TXK Delta Below 7

1. Login to WebLogic Console
2. Click "Lock and Edit"
3. Navigate: Services → Data Sources
4. Select EBSDataSource
5. Update apps user password in Connection Pool
6. Click “Activate Changes”

Getting Error while login to WebLogic Console Oracle Application R12 (12.2.14)

Getting Error while login to WebLogic Console Oracle Application R12 (12.2)

The Server is not able to service this request: [Socket:000445]Connection rejected, filter blocked Socket, weblogic.security.net.FilterException: [Security:090220]rule 2

 

Issue:
The error I encountered is related to a feature in WebLogic known as a connection filter. This mechanism provides network-layer access control, enabling the server to block unwanted communication based on various criteria.

Solution:

We need to update the connection filter value to 'allow' in the config.xml file located in the $EBS_DOMAIN_HOME/config folder

 

[applprod@cloner12 ~]$ cd $EBS_DOMAIN_HOME/config

[applprod@cloner12 config]$ ls -l config.xml

-rw-r----- 1 applprod dba 55688 Jun 18 22:37 config.xml

[applprod@cloner12 config]$ grep connection-filter config.xml

    <connection-filter>oracle.apps.ad.tools.configuration.wls.filter.EBSConnectionFilterImpl</connection-filter>

    <connection-filter-rule>cloner12.githesh.com * * allow</connection-filter-rule>

    <connection-filter-rule>0.0.0.0/0 * * deny</connection-filter-rule>

 

Backup the config.xml

 

[applprod@cloner12 config]$ cp -rf  config.xml  config.xml_bk

And change the value from deny to allow

 

[applprod@cloner12 config]$ sed -i 's/<connection-filter-rule>0\.0\.0\.0\/0 \* \* deny<\/connection-filter-rule>/<connection-filter-rule>0.0.0.0\/0 * * allow<\/connection-filter-rule>/' config.xml

[applprod@cloner12 config]$ grep connection-filter config.xml

    <connection-filter>oracle.apps.ad.tools.configuration.wls.filter.EBSConnectionFilterImpl</connection-filter>

    <connection-filter-rule>cloner12.githesh.com * * allow</connection-filter-rule>

    <connection-filter-rule>0.0.0.0/0 * * allow</connection-filter-rule>

 

 

Stop and Start the admin server

[applprod@cloner12 config]$ cd $ADMIN_SCRIPTS_HOME

[applprod@cloner12 scripts]$ ./adadminsrvctl.sh stop

[applprod@cloner12 scripts]$ ./adadminsrvctl.sh start

 

WebLogic Console