DBA Arena

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

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;

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

Read more...

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

Increasing oacore memory in EBS 12.2.x

Login to the Weblogic Console
http://hostname:port/console

Enter Username and Password.

Read more...

One of the most visible (and colorful!) user interface enhancements for Oracle E-Business Suite Release 12.2.4 is the new simplified home page:

Enabling the Simplified Home Page

When you first install or upgrade to Release 12.2.4, you will see the home page as it appeared in previous versions of Release 12.2 (configurable home page with tree-based navigator).
Read more...