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...
Applying AD and TXK Release Update Packs to Oracle E-Business Suite Release 12.2
The latest RUPs while writing this post are R12.AD.C.Delta.10 (Patch 25820806) and R12.TXK.C.Delta.10 (Patch 25828573).
Apply Required Database Patches
AD-TXK Delta 10 requires a number of database bug fixes to install and operate correctly.
NOTE: Take Central Inventory backups on the database and application tiers.
Before you apply the AD and TXK Delta 10 release update packs (RUPs), you must run the latest version (available via Patch 17537119) of the EBS Technology Codelevel Checker (ETCC). Use the command checkDBpatch.sh (on UNIX) or checkDBpatch.cmd (on Windows).
Check the OPatch utility version.
/u01/oracle/product/dbhome1/OPatch/opatch version
OPatch Version: 11.2.0.3.16
OPatch succeeded.
Upgrade to the latest OPatch Utility.
[oracle@ebsdb01 OPatch]$ ./opatch version
OPatch Version: 11.2.0.3.18
OPatch succeeded.
Read more...
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
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...
Error occurred while Executing txkADOPValidation script when running fs_clone
While running fs_clone, it fails with the following error:
[applprod@erpapp01 ~]$ adop phase=fs_clone
Enter the APPS password:
Enter the SYSTEM password:
Enter the WLSADMIN password:
Validating credentials.
Initializing.
Run Edition context : /u01/oracle/ERPPROD/fs1/inst/apps/ERPPROD_erpapp01/appl/admin/ERPPROD_erpapp01.xml
Patch edition context: /u01/oracle/ERPPROD/fs2/inst/apps/ERPPROD_erpapp01/appl/admin/ERPPROD_erpapp01.xml
Patch file system free space: 355.97 GB
Validating system setup.
Node registry is valid.
[WARNING] ETCC: The following required database fixes have not been applied to node dx
12608451
21286665
Refer to My Oracle Support Knowledge Document 1594274.1 for instructions.
Checking for existing adop sessions.
No pending session exists.
Starting new adop session.
===========================================================================
ADOP (C.Delta.8)
Session ID: 3
Node: erpapp01
Phase: fs_clone
Log: /u02/oracle/ERPPROD/fs_ne/EBSapps/log/adop/3/20170807_123036/adop.log
===========================================================================
Read more...