Oracle E-Business Suite 12.2.6 Now Available

Oracle E-Business Suite Release 12.2.6 is now available.

Instructions for downloading and applying this latest release update pack (RUP) for the EBS 12.2 codeline can be found here:


Oracle E-Business Suite 12.2.6 Readme (Doc ID 2114016.1)

What Does Release 12.2.6 Include?

• Official release announcement
• EBS 12.2.6 highlights video with Cliff Godwin, Senior Vice President of Application Development 

As a consolidated suite-wide patchset, this RUP includes new features, statutory and regulatory updates, and enhancements for stability, performance, and security.

Release 12.2.6 is cumulative. That means that as well as providing new updates for this release, it also includes updates that were originally made available as one-off patches for earlier 12.2 releases.

For a complete list of new features, refer to:
Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Documents (Doc ID 1302189.1)

RCU/jdk/jre/lib/i386/xawt/libmawt.so: libXtst.so.6: cannot open shared object file: No such file or directory

I got this error while installing RCU on OEL6.

$ ./rcu
Exception in thread "main" java.lang.UnsatisfiedLinkError:
/Installation/rcu/rcuHome/jdk/jre/lib/i386/xawt/libmawt.so:
libXtst.so.6: cannot open shared object file: No such file or directory
        at java.lang.ClassLoader$NativeLibrary.load(Native Method)
        at java.lang.ClassLoader.loadLibrary0(ClassLoader.java:1778)
        at java.lang.ClassLoader.loadLibrary(ClassLoader.java:1674)
        at java.lang.Runtime.load0(Runtime.java:770)
        at java.lang.System.load(System.java:1003)
        at java.lang.ClassLoader$NativeLibrary.load(Native Method)
        at java.lang.ClassLoader.loadLibrary0(ClassLoader.java:1778)
        at java.lang.ClassLoader.loadLibrary(ClassLoader.java:1695)
        at java.lang.Runtime.loadLibrary0(Runtime.java:823)
        at java.lang.System.loadLibrary(System.java:1028)

Cause: 
libXtst rpm for 32 bit is missing.

Fix:
Please check that the libXtst-xx.el6.i686.rpm (32 bit) installed.
rpm -qa |grep libXtst
If it is not installed the need to install:
rpm -ivh libXtst-xx.el6.i686.rpm

ORA-01654: unable to extend index APPLSYS.AD_PATCH_COMMON_ACTIONS_U2 by 16 in tablespace APPS_TS_TX_IDX

While applying an NLS Patch getting ORA-1654 errors occurred due to space issues.

Error:

ORA-01654: unable to extend index APPLSYS.AD_PATCH_COMMON_ACTIONS_U2 by 16 in tablespace APPS_TS_TX_IDX

ORA-01654: unable to extend index APPLSYS.AD_PROGRAM_RUN_TASK_JOBS_N1 by 16 in tablespace APPS_TS_TX_IDX

After fixing the ORA-1654 errors by setting the APPS_TS_TX_IDX datafile to autoextend, reapplying the same NLS patch gives the following warning message and the patch is skipped:

Fix:

1. Resolve the ORA-1654 error per any of the available methods.

2. Test reapplying the patch using following option:

adop phase=apply apply_mode=downtime patches=19676458 options=forceapply restart=no abandon=yes

3. Confirm the patch applied successfully using the above command.

INST-08109: An ORACLE_HOME environment variable should not be defined

I got the below error while installing Oracle BI 11.1.1.9 on Linux 5.7.

Error :

INST-08109: An ORACLE_HOME environment variable should not be defined

Fix:

unset ORACLE_HOME and try to re-install.

INST-08109: An ORACLE_HOME environment variable should not be defined

I got the below error while installing Oracle BI 11.1.1.9 on Linux 5.7.

Error :

INST-08109: An ORACLE_HOME environment variable should not be defined

Fix:

unset ORACLE_HOME and try to re-install.

Error in invoking target client_sharedlib of makefile

I am getting below error while installing Oracle Database 12c in OEL6. 

Error:

Fix:

Step 1:
Edit /etc/sysctl.conf file and entry followings.
#vi /etc/sysctl.conf
kernel.shmall = 2097152
kernel.shmmax = 536870912
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
fs.file-max = 65536
net.ipv4.ip_local_port_range = 1024 65000
net.core.rmem_default=262144
net.core.wmem_default=262144
net.core.rmem_max=262144
net.core.wmem_max=262144

Step 2:

Create the below soft links.

ln -s /etc /etc/rc.d
ln -s /usr/bin/awk /bin/awk
ln -s /usr/bin/basename /bin/basename
ln -s /usr/bin/rpm /bin/rpm
ln -s /lib/x86_64-linux-gnu/libgcc_s.so.1 /usr/lib64/
ln -s /usr/lib/x86_64-linux-gnu/libc_nonshared.a /usr/lib64/
ln -s /usr/lib/x86_64-linux-gnu/libpthread_nonshared.a /usr/lib64/
ln -s /usr/lib/x86_64-linux-gnu/libstdc++.so.6 /usr/lib64/

Issue resolved after done all the above steps/changes.

Error in invoking target 'client_sharedlib' of makefile

I am getting below error while installing Oracle Database 12c in OEL6. 

Error:

Fix:

Step 1:
Edit /etc/sysctl.conf file and entry followings.
#vi /etc/sysctl.conf
kernel.shmall = 2097152
kernel.shmmax = 536870912
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
fs.file-max = 65536
net.ipv4.ip_local_port_range = 1024 65000
net.core.rmem_default=262144
net.core.wmem_default=262144
net.core.rmem_max=262144
net.core.wmem_max=262144

Step 2:

Create the below soft links.

ln -s /etc /etc/rc.d
ln -s /usr/bin/awk /bin/awk
ln -s /usr/bin/basename /bin/basename
ln -s /usr/bin/rpm /bin/rpm
ln -s /lib/x86_64-linux-gnu/libgcc_s.so.1 /usr/lib64/
ln -s /usr/lib/x86_64-linux-gnu/libc_nonshared.a /usr/lib64/
ln -s /usr/lib/x86_64-linux-gnu/libpthread_nonshared.a /usr/lib64/
ln -s /usr/lib/x86_64-linux-gnu/libstdc++.so.6 /usr/lib64/

Issue resolved after done all the above steps/changes.

Error in invoking target 'client_sharedlib' of makefile

I am getting below error while installing Oracle Database 12c in OEL6. 

Error:

Fix:

Step 1:
Edit /etc/sysctl.conf file and entry followings.
#vi /etc/sysctl.conf
kernel.shmall = 2097152
kernel.shmmax = 536870912
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
fs.file-max = 65536
net.ipv4.ip_local_port_range = 1024 65000
net.core.rmem_default=262144
net.core.wmem_default=262144
net.core.rmem_max=262144
net.core.wmem_max=262144

Step 2:

Create the below soft links.

ln -s /etc /etc/rc.d
ln -s /usr/bin/awk /bin/awk
ln -s /usr/bin/basename /bin/basename
ln -s /usr/bin/rpm /bin/rpm
ln -s /lib/x86_64-linux-gnu/libgcc_s.so.1 /usr/lib64/
ln -s /usr/lib/x86_64-linux-gnu/libc_nonshared.a /usr/lib64/
ln -s /usr/lib/x86_64-linux-gnu/libpthread_nonshared.a /usr/lib64/
ln -s /usr/lib/x86_64-linux-gnu/libstdc++.so.6 /usr/lib64/

Issue resolved after done all the above steps/changes.

Insufficient free space in /tmp while installing SOA 12c

$JAVA_HOME/java -jar fmw_12.1.3.0.0_soa_quickstart.jar

Insufficient free space in /tmp/orcl4316142800341622207.tmp to extract the installer.  Actual 365 MB.  Required 3053 MB.

In my case we don't have free space under /tmp mount. So i have created /tmp directory under different location.

Fix:

1. mkdir -p /u01/tmp
2. chmod -R 777 /u01/tmp
3. export _JAVA_OPTIONS="-Djava.io.tmpdir=/u01/tmp"
4. java -jar fmw_12.1.3.0.0_soa_quickstart.jar

CXF Error Deploying Updated p6ws.war File

Getting below error message while deploying the p6ws.war File

Error:

Servlet: "cxf" failed to preload on startup in Web application: "p6ws.war".
java.lang.RuntimeException: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'org.apache.cxf.wsdl.WSDLManager' defined in URL [zip:/home/weblogic/Oracle/Middleware/user_projects/domains/iALM/servers/AdminServer/tmp/_WL_user/p6ws/nmdpik/war/WEB-INF/lib/cxf-bundle.jar!/META-INF/cxf/cxf.fixml]: Instantiation of bean failed; nested exception is java.lang.NoClassDefFoundError: javax/wsdl/WSDLException

Cause:

The wsdl4j-1.6.2.jar is missing from the p6ws.ear/p6ws.war file.

Fix:

1. In the <P6 Web Services Home Directory> edit the updateWSWar.cmd or updateWSWar.sh file. Ensure the CXF_HOME path is set to the folder where wsdl4j-1.6.2.jar has been copied.
2. Save and execute the updateWSWar file to update the p6ws.ear/p6ws.war file.
3. Redeploy the p6ws.ear/p6ws.war file.

Oracle.DataAccess.Client.OracleException: ORA-06550: line 1, column 15

Error:

We are getting below error while installing UPK Server and Client on windows server 2012 R2.

UPK client / server Installation fails with a Library Loader log:

@ System.ServiceModel.FaultException`1[System.ServiceModel.ExceptionDetail]:
@ ORA-06550: line 1, column 15:
@ PLS-00905: object ODSERVER_11.PART_EXISTS is invalid
@ ORA-06550: line 1, column 7:
@ PL/SQL: Statement ignored (Fault Detail is equal to An ExceptionDetail,
@ likely created by IncludeExceptionDetailInFaults=true, whose value is:
@ Oracle.DataAccess.Client.OracleException: ORA-06550: line 1, column 15:
@ PLS-00905: object ODSERVER_11.PART_EXISTS is invalid
@ ORA-06550: line 1, column 7:
@ PL/SQL: Statement ignored

Fix:

Stop the installer before running Library Loader and manually add grant permissions.

Steps:

• Drop the tablespace and users.  Start a fresh installation.
• Create a setupdiag.ini

Locate the ..\setup\Branding\UPK\Installer folder

Create a new notepad file called setupdiag.ini

Open the file and enter the following:

[SetupDebug]

Stopbeforelibraryloader=1

Save and close the file.

• Create a setupdiag.ini
• Start installer and enter credentials desired to be created
• Installer pauses 
• Grant the execute privileges

• Log in as SYSDBA, run the the following queries:

grant execute on sys.dbms_lob to ODSERVER;

grant execute on sys.dbms_lob to ODSERVER_APP;

•  Log into Oracle with the credentials of the schema created (i.e.,ODSERVER)

• Run the following query:

select object_name, object_type from obj where status !='VALID';

returned two FUNCTIONS:

ADD_PART

PART_EXISTS

•  Recompile the invalid objects

alter compile;

example: alter FUNCTION ADD_PART compile;

example: alter FUNCTION PART_EXISTS compile;

• Let installer continue

• Click Finish

ORA-20008 When Running "adop phase=prepare"

Error while running command: adop phase=prepare

ERROR at line 1:
ORA-20008: No Concurrent Manager is defined that can run concurrent program ADZDPATCH
ORA-6512: at "APPS.AD_ZD_ADOP", line 240

Fix:

Set the Run filesystem / environment and run command:

FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/afcpprog.lct $AD_TOP/patch/115/import/US/adzdpatch.ldt - CUSTOM_MODE=FORCE

[ERROR]: The value of s_file_edition is not set correctly in at least one of the context files

When attempting to run adop phase=prepare, the following error occurs.

[ERROR]: JDK TOP (or FMW JDK TOP) is not set up correctly.
[WARNING]: There could be issues while validating the ports used for E-Business Suite instance against ports used in /etc/services. Refer the log file for more details.
[ERROR]: Some of the ports specified for the patch file system are not available.
[ERROR]: The value of s_file_edition is not set correctly in at least one of the context files
[ERROR]: The values of s_current_base and s_other_base are not set correctly on both RUN and PATCH filesystems

Fix:

Delete duplicate context files and run autoconfig to create new ones.

1.Please backup FND_OAM_CONTEXT_FILES

SQL>create table FND_OAM_CONTEXT_FILES_BK as select * from FND_OAM_CONTEXT_FILES;

2.Please clear data from FND_OAM_CONTEXT_FILES table.

SQL>delete from FND_OAM_CONTEXT_FILES;

3.Please execute autoconfig from all nodes.

cd $ADMIN_SCRIPTS_HOME
./adautocfg.sh

4.Please confirm the new data from FND_OAM_CONTEXT_FILES;

SQL>select * from FND_OAM_CONTEXT_FILES;

5.Please execute the adop again.


Note: The patch file system context file is needed for adop to complete. Enoking the patch edition and running autoconfig on it should resolve that issue.

FRM-92101:There was a failure in the forms server during startup.

After upgrading to EBS 12.1.3 the following error appears when launching forms:

FRM-92101:There was a failure in the forms server during startup.

CAUSE:

Incorrect soft link to ldflags.

The ldflags softlink pointed to an incorrect file :
ls -atlr $ORACLE_HOME/lib32/ldflags

$ORACLE_HOME/lib32/ldflags ===> Patch Directory/RUP4XB6/apps/tech_st/10.1.2/lib/ldflags

SOLUTION:

Please execute the following steps to resolve the issue:

• Point the link to $ORACLE_HOME/lib/ldflags.

• Change into $ORACLE_HOME/forms/lib32 directory.

• Relink Forms : (make -f ins_forms.mk install)

• Restart the Forms-Server and retest the login.

"adop phase=finalize" Fails As ADOP Cannot Detect Any Application Tier Nodes In FND_NODES table. Ensure ICM is running and run autoconfig on all nodes

When attempting to perform "adop phase=finalize" the following error occurs.

ERROR
[UNEXPECTED]adop cannot detect any application tier nodes in FND_NODES table. Ensure ICM is running and run autoconfig on all nodes
[UNEXPECTED]Error while checking if this is a multi node instance

The issue occurs due to a null value for the concurrent/admin node status column in table FND_NODES.

More details are available via the following unpublished defect:
Bug 18533116 - AD:ADOP IN HOTPATCH FAILED FOR R12.TXK.C.DELTA.5

"In AD.Delta.4+one off patches we have a dependency on FND_NOTES.STATUS column

The column will be automatically set to 'Y' when ICM is up.

When the ICM is down the query will not detect any nodes with status 'Y',  and adop proceeds with only the current/admin node (inserts rows into AD_ADOP_SESSIONS for current/admin node only."

Fix:

To resolve the issue, test the following steps in a development instance and migrate accordingly:
Test the following steps:

    A. Set the "run" Application Tier environment
    B. Start ICM
    C. Run "adop phase=finalize" again.

Ref: (Doc ID 1904735.1)

After Upgrading EBS 12.2.5, Users Are Unable To Login And Receive The Following Error: "URL Validation Failed"

After an E-Business Suite 12.2 upgrade, user login fails with the following error:

Error

URL validation failed. The error could have been caused through the use of the browser's navigation buttons ( the browser Back button or refresh, for example). If the error persists, Please contact system administrator.

Fix:

Disable maintenance mode for the system to work as intended.

To resolve the issue, test the following steps in a development instance and migrate accordingly:

1. Check if maintenance mode is enabled via th following sql:

select fnd_profile.value('APPS_MAINTENANCE_MODE') from dual;

2. If the status of the above select does not return 'NORMAL', then maintenance mode is enabled. In this case disable it via the following sql:

sqlplus <APPS_Schema name>/<APPS Password>@adsetmmd.sql | DISABLE

Ref: (Doc ID 1592363.1)

Issues While Re-starting 12.2.4 RUP Patch 17919161 Failed With ORA-04063, ORA-06508, ORA-06512 on FND_CONC Package Invalid

When applying Oracle E-Business Suite 12.2.4 Release Update Pack Patch 17919161 on the run edition application environment, using downtime mode getting the error below:

$ adop phase=apply apply_mode=downtime patches=17919161 restart=yes

Error:

SQL> select ad_zd_adop.is_icm_alive() from dual
  *
ERROR at line 1:
ORA-04063: package body "APPS.FND_CONC" has errors
ORA-06508: PL/SQL: could not find program unit being called: "APPS.FND_CONC"
ORA-06512: at "APPS.AD_ZD_ADOP", line 1635
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

[UNEXPECTED] Error occurred

Cause:

An invalid FND_CONC package.

The error in the adop log file shows the following object is invalid and it needs to be validated so the patch can continue:

ERROR at line 1:
ORA-04063: package body "APPS.FND_CONC" has errors
ORA-06508: PL/SQL: could not find program unit being called: "APPS.FND_CONC"
ORA-06512: at "APPS.AD_ZD_ADOP", line 1635


Fix:

1. Run the script $FND_TOP/patch/115/sql/AFCPDIGB.pls to validate the FND_CONC package:

sqlplus apps/<appspwd> @$FND_TOP/patch/115/sql/AFCPDIGB.pls

2. Re-run adop.

Ref: (Doc ID 1926427.1)

BEA-000383 A critical service failed. The server will shut itself down

I am facing the below issue while starting the weblogic server after configuring the OBIEE application.

Error:
weblogic.security.providers.authentication.LDAPAtnLoginModuleImpl.login(LDAPAtnLoginModuleImpl.java:261)
        at com.bea.common.security.internal.service.LoginModuleWrapper$1.run(LoginModuleWrapper.java:110)
        at java.security.AccessController.doPrivileged(Native Method)
        at com.bea.common.security.internal.service.LoginModuleWrapper.login(LoginModuleWrapper.java:106)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        Truncated. see log file for complete stacktrace

May 29, 2016 11:30:55 AM PDT> <Notice> <WebLogicServer> <BEA-000365> <Server state changed to FAILED>
<May 29, 2016 11:30:55 AM PDT> <Error> <WebLogicServer> <BEA-000383> <A critical service failed. The server will shut itself down>
<May 29, 2016 11:30:55 AM PDT> <Notice> <WebLogicServer> <BEA-000365> <Server state changed to FORCE_SHUTTING_DOWN>

Fix:

Create the boot.properties file under $DOMAIN_HOME/servers/AdminServer/security/

[obiee@obiee security]$ pwd
/u0/u01/obiee/product/FMW_HOME/user_projects/domains/bifoundation_domain/servers/AdminServer/security

[obiee@obiee security]$ vi boot.properties
[obiee@obiee security]$ cat boot.properties
username=weblogic
password=welcome123

[ERROR]: Some of the ports specified for the patch file system are not available.

When attempting to run "adop phase=fs_clone" command the following error occurs:

ValidatePatchFSPortPool:
[ERROR]: Some of the ports specified for the patch file system are not available.

In my case here 7002 is run file system weblogic console port and 7001 is patch file system port.

This issue is caused by a port used by WLS Admin Server on the run file system which is not free (e.g port 7001).

Note:
The following command gives the current port used by the WLS Admin Server :
$ grep s_wls_adminport $CONTEXT_FILE

Cause:

In my case both Run and Patch file system admin servers are running.

Solution:

In my case both Run and Patch file system weblogic console ports are running.

To implement the solution, please execute the following steps:

1. Shutdown all apps services on RUN and PATCH file systems.

. /EBSapps.env R
cd $INST_TOP/admin/scripts
adstpall.sh apps/apps

. /EBSapps.env P
cd $INST_TOP/admin/scripts
adstpall.sh apps/apps

2. make sure that port used by the WLS Admin Server is free and no processes are running from your Patch file system via the following command

$ netstat -a | grep 7001
$ ps -eaf | grep 7001

replace 7001 by the port listed in the autoconfig s_wls_adminport parameter and in the error message (e.g. 7001, 7002, ...)
Note: The above commands should returns no activity on the related ports

3. On the RUN file system, start up adadmin server via the following command

. /EBSapps.env run
cd $INST_TOP/admin/scripts
$ adadminsrvctl.sh start

4. Start fs_clone from the beginning  

For Single Node
$ adop phase=fs_clone allnodes=no force=yes

For Multi Node
$ adop phase=fs_clone force=yes

ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance

SQL> startup
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.

Total System Global Area 2147483648 bytes
Fixed Size                  2926472 bytes
Variable Size            1392511096 bytes
Database Buffers          738197504 bytes
Redo Buffers               13848576 bytes
Database mounted.
Database opened.

SQL> SELECT name FROM v$parameter WHERE isdeprecated = 'TRUE';

NAME
--------------------------------------------------------------------------------
lock_name_space
instance_groups
resource_manager_cpu_allocation
active_instance_count
buffer_pool_keep
buffer_pool_recycle
log_archive_start
standby_archive_dest
parallel_server
parallel_server_instances
fast_start_io_target

NAME
--------------------------------------------------------------------------------
serial_reuse
rdbms_server_dn
max_enabled_roles
remote_os_authent
sec_case_sensitive_logon
global_context_pool_size
cursor_space_for_time
plsql_v2_compatibility
plsql_debug
background_dump_dest
user_dump_dest

NAME
--------------------------------------------------------------------------------
commit_write
sql_trace
parallel_automatic_tuning
parallel_io_cap_enabled

26 rows selected.

SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

[oracle@rysigo04 ~]$ oerr ora 32004
32004, 00000, "obsolete or deprecated parameter(s) specified for %s instance"
// *Cause:  Obsolete or deprecated parameters for this instance type
//          were specified in the SPFILE or the PFILE on the server side.

// *Action: See alert log for a list of parameters that are obsolete
//          or deprecated. Remove them from the SPFILE or the server
//          side PFILE.