3
May

Change APPS password in EBS R12.2.x Delta 6 or below

Important: These steps must be carried out on the run file system. The FND_USER and FND_ORACLE_USERID tables should be backed up before any passwords are changed. Remove the backups after you have confirmed that the changes are successfully completed. Passwords for all the 3 schemas, APPS, APPLSYS and APPS_NE will be changed together while changing APPLSYS password.

1. Shut down the application tier services using the below script:

$INST_TOP/admin/scripts/adstpall.sh

2. Change the APPLSYS password using

 
There are 2 ways to change the APPLSYS password:
Read more...

16
Apr

Login to internal node gets redirected to external node after adding new DMZ node in EBS R12.2.x

Symptoms:

For some users, login to internal node gets redirected to external node.

 

Cause:

In $IAS_ORACLE_HOME/instances/EBS_web_SID_OHS1/config/OHS/EBS_web_SID/mod_wl_ohs.conf and apps.conf files, the cluster includes the external node external.domain.com.

 

Solution:

 

To fix this issue, make the following changes to the run file system of the internal node:
Remove any reference to external.domain.com from both the files i.e. mod_wl_ohs.conf and apps.conf.

 
Node 1: /u02/oracle/EBSPROD/fs1/FMW_Home/webtier/instances/EBS_web_EBSPROD_OHS1/config/OHS/EBS_web_EBSPROD
 
Node 2: /u02/oracle/EBSPROD/fs1/FMW_Home/webtier/instances/EBS_web_EBSPROD_OHS3/config/OHS/EBS_web_EBSPROD
 
DMZ Node: /u02/oracle/EBSPROD/fs2/FMW_Home/webtier/instances/EBS_web_EBSPROD_OHS2/config/OHS/EBS_web_EBSPROD
 
Read more...

7
Mar

Change Weblogic admin password in Oracle E-Business Suite R12.2.x

The steps mentioned in this document can be used to change the Oracle WebLogic Server Administration User Password in R12.2.x when the weblogic password is known.

Pre-requisite:

R12.AD.C.Delta.7 and R12.TXK.C.Delta.7 or later.
 

The release of R12.AD.C.Delta.7and R12.TXK.C.Delta.7 has brought in a lot of new features, one of them is a script to automate Changing Oracle WebLogic Server Administration User Password (Conditional to be on patch set level R12.AD.C.Delta.7 and R12.TXK.C.Delta.7 ).

The procedure used to change the Oracle WebLogic Server Administration User Password has been simplified and largely automated by the introduction of a new utility that performs what were previously manual steps.

The option to set the Oracle WebLogic Server Administration User password to a non-default value is available during Oracle E-Business Suite installation. This section describes the procedure to use (on the run file system) if you need to change the password at a later time.
 
The EBS WebLogic Domain uses Node Manager to control the Administration Server and the managed servers. For the EBS WebLogic Domain, the Node Manager and WebLogic Server Administration User passwords must be same, otherwise the AD control scripts will not work properly.
 
Important:
If you need to change the Administration User password, you must change the Node Manager password first. If you do not do this, the WebLogic Server configuration change will not be detected and the next online patching cycle may fail.
 
The instructions that follow should be performed on the run file system. The password change will be automatically propagated to the patch file system during the next adop prepare phase or fs_clone operation.
 
Read more...

24
Jan

After Upgrading From 12.2.0 to 12.2.x Apache Does Not Start And Errors With Could not open configuration file

Error:

/u02/oracle/ERPPROD/fs1/FMW_Home/webtier/ohs/bin/apachectl startssl: execing httpd
 
Killedworker: Syntax error on line 1039 of /u02/oracle/ERPPROD/fs1/FMW_Home/webtier/instances/EBS_web_ERPPROD_OHS1/config/OHS/EBS_web_ERPPROD/httpd.conf: Syntax error on line 115 of /u02/oracle/EBS_web_ERPPROD_OHS1/config/OHS/EBS_web_ERPPROD/ssl.conf: Could not open configuration file
You have new mail in /var/spool/mail/applprod
 

[applprod@erpapp01 ~]$ ls -ltr
/u02/oracle/ERPPROD/fs1/FMW_Home/webtier/instances/EBS_web_ERPPROD_OHS1/OHS/EBS_web_ERPPROD/oracle_apache_ssl.conf: No such file or directory

Cause:

In the runfilesystem xml file the value of variable s_ohs_installed is set to False.
This will stop the configuration file from getting generated.

Hence the file oracle_apache_ssl.conf was not created and the services are not starting.


[applprod@erpapp01 ~]$ grep -i s_ohs_installed $CONTEXT_FILE
false

Read more...

5
Dec

On Oracle Applications 12.2 version, Online Enablement patch fails on APPS.AD_ZD_PREP package

Symptoms:

On Oracle Applications 12.2 version, online enablement patch 13543062 fails with:


begin
*
ERROR at line 1:
ORA-04063: package body "APPS.AD_ZD_PREP" has errors
ORA-06508: PL/SQL: could not find program unit being called: "APPS.AD_ZD_PREP"
ORA-06512: at line 4

 
Try to compile the package:

SQL> alter package apps.AD_ZD_PREP compile body;

Warning: Package Body altered with compilation errors.
 
SQL> show error
Errors for PACKAGE BODY APPS.AD_ZD_PREP:

LINE/COL ERROR
-------- -----------------------------------------------------------------
308/6 PL/SQL: Statement ignored
308/6 PLS-00201: identifier 'SYS.DBMS_OBJECTS_APPS_UTILS' must be
declared

670/4 PL/SQL: Statement ignored
670/4 PLS-00201: identifier 'SYS.DBMS_OBJECTS_APPS_UTILS' must be
declared

753/6 PL/SQL: Statement ignored
753/6 PLS-00201: identifier 'SYS.DBMS_OBJECTS_APPS_UTILS' must be
declared

LINE/COL ERROR
-------- -----------------------------------------------------------------

1152/4 PL/SQL: Statement ignored
1152/17 PLS-00201: identifier 'SYS.DBMS_OBJECTS_APPS_UTILS' must be
declared

Read more...

Back to Top