Oracle APPS DBA pieces

Tuesday, April 25, 2017

In EBS 12.1.3, Gather Schema Stats fails with Cause: FDPSTP failed due to ORA-29913: error in executing ODCIEXTTABLEOPEN callout

Recently in our environment, Gather Schema Statistics program were failing for custom schema with errors

Cause: FDPSTP failed due to ORA-29913: error in executing ODCIEXTTABLEOPEN callout
ORA-29400: data cartridge error
KUP-04040: file ***.csv in Custom Directory not found
ORA-06512: at "APPS.FND_STATS",

From the error message, we can easily conclude that the program was trying to find the file in the custom directory. The program failed because the program couldn't find the file in the respective directory

What could be the reason.

The primary cause of this issue is that an OS file for an "external table" existed at some point in time but does not now. However, the database still believes the OS file for the table exists since the dictionary information about the object has not been modified to reflect the change. When DBMS_STATS is run against the table in question, it makes a call out to the external table which fails because the object is not there. The error can also occur during data pump operations.

Solution:

By using the below query, identify the list of external tables in the custom schema

select el.table_name, el.owner, dir.directory_path||'/'||dir.directory_name "path"
from dba_external_locations el
, dba_directories dir
where el.table_name like '%&&table_pattern%'
and el.owner like '%&&owner%'
and el.directory_owner = dir.owner
and el.directory_name = dir.directory_name
order by 1, 2;

This will list down the table name,owner name and path. If the path is incorrect, modify it first.

Now there are two options.

1.Lock the stats collection for the respective external tables under custom schema.

exec DBMS_STATS.LOCK_TABLE_STATS('owner','external table name');

Then run the gather schema statistics.The program will complete nowmal now and the log message will show that the stats have not been gathered for the locked tables.

Once the program completes, it is feasible to unlock the stats gathering

exec DBMS_STATS.UNLOCK_TABLE_STATS('owner','external table name');

2. This is the best option. Run gather table statisctics for the respective tables one by one. For any external tables, if the program throws an error “file not found”, then create a 0 byte file manually and then run it. It should complete normal now
Once gather table stats completes for all the external tables, run gather schema statistics for custom schema

reference:-ORA-20011 ORA-29913 and ORA-29400 with Associated KUP-XXXXX Errors from DBMS_STATS.GATHER_STATS_JOB (Doc ID 1274653.1)

Monday, April 17, 2017

adoacorectl.sh , adformsctl.sh , adoafmctl.sh – exiting with status 204

OC4J:oafm, OC4J:forms not starting and existing with status 204

Processes in Instance: *****************
---------------------------------+--------------------+---------+---------
ias-component | process-type | pid | status
---------------------------------+--------------------+---------+---------
OC4JGroup:default_group | OC4J:oafm | | down
OC4JGroup:default_group | OC4J:oafm | down
OC4JGroup:default_group | OC4J:oafm | down
OC4JGroup:default_group | OC4J:oafm | down
OC4JGroup:default_group | OC4J:oafm | down
OC4JGroup:default_group | OC4J:forms | down
OC4JGroup:default_group | OC4J:oacore | 29781 | Alive
OC4JGroup:default_group | OC4J:oacore | 29780 | Alive
OC4JGroup:default_group | OC4J:oacore | 29778 | Alive
OC4JGroup:default_group | OC4J:oacore | 29779 | Alive
OC4JGroup:default_group | OC4J:oacore | 29777 | Alive
HTTP_Server | HTTP_Server | 29720 | Alive

Symptoms
Unable to start oafm using adstrtal.sh. Running adoafmctl.sh ends with timeout.

You are running adoafmctl.sh version 120.6.12000000.3
Starting OPMN managed OAFM OC4J instance ...
adoafmctl.sh: exiting with status 152
adoafmctl.sh: check the logfile.

Cause
Existing JSP Tag Library Cache content was preventing the TLD Cache for the mapviewer app from initialising correctly.

Solution:

To implement the solution, please execute the following steps:

1)stop all middle tier services

2)Delete/backup all the files under directory:

cd $COMMON_TOP
mv _TldCache _TldCache_bkp

Take persistance backup or remove it.
==================================================

rm -rf $INST_TOP/ora/10.1.3/j2ee/oacore/persistence/*
rm -rf $INST_TOP/ora/10.1.3/j2ee/oafm/persistence/*
rm -rf $INST_TOP/ora/10.1.3/j2ee/forms/persistence/*
rm -f $INST_TOP/ora/10.1.3/opmn/logs/states/.opmndat

3)start all middle tier services

after doing above steps issue got resolved .

You are running adoacorectl.sh version 120.13

Checking status of OPMN managed OACORE OC4J instance ...

Processes in Instance: **************
---------------------------------+--------------------+---------+---------
ias-component | process-type | pid | status
---------------------------------+--------------------+---------+---------
OC4JGroup:default_group | OC4J:oafm | 30149 | Alive
OC4JGroup:default_group | OC4J:oafm | 30148 | Alive
OC4JGroup:default_group | OC4J:oafm | 30147 | Alive
OC4JGroup:default_group | OC4J:oafm | 30146 | Alive
OC4JGroup:default_group | OC4J:oafm | 30145 | Alive
OC4JGroup:default_group | OC4J:forms | 30075 | Alive
OC4JGroup:default_group | OC4J:oacore | 29781 | Alive
OC4JGroup:default_group | OC4J:oacore | 29780 | Alive
OC4JGroup:default_group | OC4J:oacore | 29778 | Alive
OC4JGroup:default_group | OC4J:oacore | 29779 | Alive
OC4JGroup:default_group | OC4J:oacore | 29777 | Alive
HTTP_Server | HTTP_Server | 29720 | Alive

Reference
http://onlineappsdba.com/index.php/2009/07/23/adoacorectlsh-adformsctlsh-adoafmctlsh-exiting-with-status-204/
OAFM OC4J is Not Starting. Error: "time out while waiting for a managed process to start" [ID 952583.1]

Thursday, March 30, 2017

Not able to start EBS 12.1.3 services:[ons-secure] Failed to open wallet

Today i faced a strange issue where i was working in one of our cloned instance-EBS 12.1.3 and while starting the apps tier, i got the below error.

You are running adopmnctl.sh version 120.6.12010000.5

Checking status of OPMN managed processes...
Unable to connect to opmn.
Opmn may not be up.

adopmnctl.sh: exiting with status 0

adopmnctl.sh: check the logfile

if we get the above errors, we should check the OPMN logs and the logs were showing the error:

(file:$INST_TOP/certs/opmn) [default password]: 28759
15/11/15 15:01:28 [ons-secure] Failed to open wallet

Thus i come down to a conclusion that there is something wrong with my wallet files. I navigated to the directory and found that the files are there at the appropriate location $INST_TOP/certs/opmn and $INST_TOP/certs/Apache

Note:If the files are missing in the above directory then we need to copy the same from "APPS Mount/tech_st/10.1.3/opmn/conf/ssl.wlt/default to $INST_TOP/certs/opmn and $INST_TOP/certs/Apache.

Now in my case my files were in the directory, then why the error was coming. I remember that to renew our SSL certifcates which was SHA-2, i had to patch 10.1.3 Oracle HOME with minimum CPU OCT 2015 patch(21845960). As in EBS 12.1.3, we don't refresh $INST_TOP, so the existing wallets files were expecting that the binaries of 10.1.3 OH should be compatible with SHA-2 algorithm. During refresh from our PROD instance, the 10.1.3 OH which got drilled down to cloned instance, in that the binaries were only compatible with SHA-1 algorithm. I suspect that because of this incompatibility my wallet files were not able to be detected.

So to resolve the issue, i had to patch the 10.1.3 OH again(minimum CPU OCT 2015 patch(21845960)) and the issue got resolved. I was able to start all the services with ease and login page certs started using new certs SHA-2. Hope it helps.

Thursday, March 2, 2017

Oracle Database 12c Release 2 is here!!!!!!!!

Well, we all are aware that Oracle 12c release 2 is in the market. It is now available for download in OTN and edelivery sites.

Download link OTN Link

Some of the new features in 12C RELEASE 2 are

1. Lock inactive account automatically after specified number of days.

Addition of new INACTIVE_ACCOUNT_TIME parameter resource parameter under dba_profiles.

By default, it is set to UNLIMITED.
The minimum setting is 15 and the maximum is 24855.

SQL> select RESOURCE_NAME,limit from dba_profiles where profile='DEFAULT';

RESOURCE_NAME LIMIT
------------------------------------------- -----------------------
COMPOSITE_LIMIT UNLIMITED
SESSIONS_PER_USER UNLIMITED
CPU_PER_SESSION UNLIMITED
CPU_PER_CALL UNLIMITED
LOGICAL_READS_PER_SESSION UNLIMITED
LOGICAL_READS_PER_CALL UNLIMITED
IDLE_TIME UNLIMITED
CONNECT_TIME UNLIMITED
PRIVATE_SGA UNLIMITED
FAILED_LOGIN_ATTEMPTS 10
PASSWORD_LIFE_TIME 180
PASSWORD_REUSE_TIME UNLIMITED
PASSWORD_REUSE_MAX UNLIMITED
PASSWORD_VERIFY_FUNCTION NULL
PASSWORD_LOCK_TIME 1
PASSWORD_GRACE_TIME 7
INACTIVE_ACCOUNT_TIME UNLIMITED ----------- > This is the resource_name introduced in oracle 12.2.

17 rows selected.

To make an account lock automatically after 30 days of inactivity, Create a profile by setting INACTIVE_ACCOUNT_TIME to 30 and Set the profile to that user.

CREATE PROFILE "TEST"
LIMIT
COMPOSITE_LIMIT UNLIMITED
SESSIONS_PER_USER UNLIMITED
CPU_PER_SESSION UNLIMITED
CPU_PER_CALL UNLIMITED
LOGICAL_READS_PER_SESSION UNLIMITED
LOGICAL_READS_PER_CALL UNLIMITED
IDLE_TIME UNLIMITED
CONNECT_TIME UNLIMITED
PRIVATE_SGA UNLIMITED
FAILED_LOGIN_ATTEMPTS 10
PASSWORD_LIFE_TIME 15552000/86400
PASSWORD_REUSE_TIME UNLIMITED
PASSWORD_REUSE_MAX UNLIMITED
PASSWORD_VERIFY_FUNCTION NULL
PASSWORD_LOCK_TIME 86400/86400
PASSWORD_GRACE_TIME 604800/86400
INACTIVE_ACCOUNT_TIME 30;

SQL> select RESOURCE_NAME,limit from dba_profiles where profile='TEST' and resource_name='INACTIVE_ACCOUNT_TIME';

RESOURCE_NAME LIMIT
------------------------------------------- -----------------------
INACTIVE_ACCOUNT_TIME 30

SQL> CREATE USER testuser identified by testuser profile TEST;

User created.

2.Spool CSV in Oracle 12.2

Before this release we used to get the spool in txt or html format using SET MARKUP. But with this release, we can get the spool in .csv format.
Below is the snippet.

SQL> SET MARKUP CSV ON QUOTE OFF
SQL> SET MARKUP CSV ON DELIMITER |
SQL> select * from DBA_USERS where rownum < 10;

3. SQLPLUS history

In this release, sqlplus can keep the history and it has to be enabled manually. Below is the snippet

SQL> set history on

SQL> select * from v$database;

NAME
———
SAM

SQL> history
1 select name from v$database;

SQL> exit

You can run “show hist” to be sure that the history is enabled:

SQL> SHOW HIST
history is ON and set to “100”

You can delete all history by running “hist clear”:

SQL> HIST CLEAR
SQL> HIST
SP2-1651: History list is empty.

The following example shows you how to enable or disable command history, and how to check the command history status:

SQL> set history on

SQL> show history
History is ON and set to “100”

SQL> set history off

SQL> show history
History is OFF

— To keep history of 2000 sql command.

SQL> set history 2000

SQL> show history
History is ON and set to "2000"

4. Parfile contents can be seen the expdp/impdp log file. Another change is introduction of parallel option for metadata using expdp/impdp

Tuesday, February 7, 2017

Importance of LAST_CALL_ET column in V$session view

Well, we all know the importance of v$session view in oracle. We often look for status,sid,sql_text,program name and other object related things in this table. However there is also one important column inside it which we often tend to ignore which is LAST_CALL_ET(pointed by Connor Mcdonald in his blog-https://connormcdonald.wordpress.com/2016/04/13/active-and-inactive-sessions)

From his blog:

If the session STATUS is currently ACTIVE, then the value represents the elapsed time (in seconds) since the session has become active.

If the session STATUS is currently INACTIVE, then the value represents the elapsed time (in seconds) since the session has become inactive.

Thus this is a great column to get a view on what sessions are doing on your system, for example

select s.sid||','||s.serial# sess,
s.USERNAME,
s.last_call_et,
s.status,
s.sql_address,
s.program
from v$session s
where ( s.status = 'ACTIVE' and s.last_call_et > 10 ) or -- has been active for 10 seconds or more
( s.status != 'ACTIVE' and s.last_call_et > 1200 ); -- has been inactive for 20 mins or more

Sunday, February 5, 2017

Java VisualVM comes by default with EBS 12.2

Java VisualVM is a tool that provides a visual interface for viewing detailed information about Java applications while they are running on a Java Virtual Machine (JVM), and for troubleshooting and profiling these applications. Basically it helps in troubleshooting applications on top of Java. We can see how much CPU the applications are using and the server getting used etc.

More details can be found in -http://docs.oracle.com/javase/7/docs/technotes/guides/visualvm/

Before EBS 12.2, we have to download them separately but with EBS 12.2 it comes by default.
Path-$COMMON_TOP/util/jdk64/bin/jvisualvm

Saturday, February 4, 2017

EBS 12.2.6 - 12C DB installation on Linux

This is a fresh install of EBS 12.2.6 in Linux machine using latest startCD 51. There are considerable changes done in this release and the details can be found in my previous posts.

Lets get started:

Oracle E-Business Suite Installation and Upgrade Notes Release 12 (12.2) for Linux x86-64 (Doc ID 1330701.1)

1. Installation of Linux

2. Installing rpms for EBS 12.2 and RDBMS 12C

3. Check all rpms

rpm -qa --qf "%{n}-%{v}-%{r}.%{arch}\n" | grep openmotif21

4. Run ldconfig –v command to relink all symbolic libraries

5. Disable selinux and shutdown iptables,ip6tables services also on run levels

vi /etc/selinux/config ( change SELINUX=enforcing to SELINUX=disabled )

service iptables stop

service ip6tables stop

chkconfig --level 0123456 ip6tables off

chkconfig --level 0123456 iptables off

6. Check kernel settings for the parameters are correctly set

Note: If the current value for any parameter is higher than the value listed in the following table, then do not change the value of that parameter.

vi /etc/sysctl.conf

kernel.semmsl 256

kernel.semmns 32000

kernel.semopm 100

kernel.semmni 142

kernel.shmall 20971524

kernel.shmmax Half the size of the physical memory (in bytes), and at least 42949672952

kernel.shmmni 4096

kernel.msgmax 8192

kernel.msgmnb 65535

kernel.msgmni 2878

fs.file-max 6815744

fs.aio-max-nr 1048576

net.ipv4.ip_local_port_range 9000 65500

net.ipv4.tcp_tw_recycle 05

net.core.rmem_default 262144

net.core.rmem_max 4194304

net.core.wmem_default 262144

net.core.wmem_max 1048576

Note : Parameter kernel.sem = 250 32000 100 128 is changed to kernel.sem = 250 32000 100 142

7. Check Domain Name System (DNS) Resolver Parameters , it should be below

options attempts:5
options timeout:15

8. Verifying Host Names

· Verify that the /etc/hosts file is formatted as follows:

127.0.0.1 localhost.localdomain localhost
[ip_address] [node_name].[domain_name] [node_name]

· Verify that the /etc/sysconfig/network file is formatted as follows:
HOSTNAME=[node_name].[domain_name]
or as follows:

HOSTNAME=[node_name]
NISDOMAIN=[domain_name]

· If the /etc/sysconfig/networking/profiles/default/network file exists, remove it.

· If you changed any files in the previous steps, restart the system

9. Modify ulimit settings in limits.conf
vi /etc/security/limits.conf

# oracle-rdbms-server-11gR2-preinstall setting for nofile soft limit is 1024
oracle soft nofile 4096
# oracle-rdbms-server-11gR2-preinstall setting for nofile hard limit is 65536
oracle hard nofile 65536
# oracle-rdbms-server-11gR2-preinstall setting for nproc soft limit is 2047
oracle soft nproc 2047
# oracle-rdbms-server-11gR2-preinstall setting for nproc hard limit is 16384
oracle hard nproc 16384
# oracle-rdbms-server-11gR2-preinstall setting for stack soft limit is 10240KB
oracle soft stack 10240
# oracle-rdbms-server-11gR2-preinstall setting for stack hard limit is 32768KB

oracle hard stack 32768

R12.2: How To Create the Stage In Preparation For Installation (Doc ID 1596433.1)

Check the version of existing version of start CD:

[root@ebs1 rapidwiz]# ./RapidWizVersion

Oracle E-Business Suite Rapid Install Wizard

Version 12.2.0.51

[root@ebs1 rapidwiz]#

Build the stage

[root@ebs1 bin]# sh buildStage.sh

Redwood Shores, California, USA

Oracle E-Business Suite Rapid Install

Version 12.2.0

Press Enter to continue...

Build Stage Menu

------------------------------------------------------

1. Create new stage area

2. Copy patches to existing stage area

3. List files in TechPatches directory

4. Exit menu

Enter your choice [4]: 1

Rapid Install Platform Menu

------------------------------------------------------

1. Oracle Solaris SPARC (64-bit)

2. Linux x86 (64-bit)

3. IBM AIX on Power Systems (64-bit)

4. HP-UX Itanium

5. Exit Menu

Enter your choice [5]: 2

Running command:

/u01/stage/startCD/Disk1/rapidwiz/bin/../jre/Linux_x64/1.6.0/bin/java -classpath /u01/stage/startCD/Disk1/rapidwiz/bin/../jlib/emocmutl.jar:/u01/stage/startCD/Disk1/rapidwiz/bin/../jlib/ewt-3_4_22.jar:/u01/stage/startCD/Disk1/rapidwiz/bin/../jlib/share-1_1_18.jar:/u01/stage/startCD/Disk1/rapidwiz/bin/../jlib/jnls.jar:/u01/stage/startCD/Disk1/rapidwiz/bin/../jlib/ACC.JAR:/u01/stage/startCD/Disk1/rapidwiz/bin/../jlib/netcfg.jar:/u01/stage/startCD/Disk1/rapidwiz/bin/../jlib/ojdbc14.jar:/u01/stage/startCD/Disk1/rapidwiz/bin/../jlib/OraInstaller.jar:/u01/stage/startCD/Disk1/rapidwiz/bin/../jlib/java oracle.apps.ad.rapidwiz.util.StageBuilder /u01/stage/startCD/Disk1/rapidwiz/bin Linux_x64 Linux_x64

Specify the directory containing the zipped installation media:

/u01/stage

File list:

/u01/stage/startCD/Disk1/rapidwiz/bin/stageData/zipFiles.dat

The set of zip files is complete.

Unzip command is: /u01/stage/startCD/Disk1/rapidwiz/unzip/Linux_x64/unzip -o

Press Enter to continue...

Archive: /u01/stage/startCD/Disk1/rapidwiz/bin/stageData/epdFiles/epdLinux_x64.zip

extracting: /u01/stage/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/../TechPatches/MiddleTier/14272383/p14272383_1036_Generic.zip

extracting: /u01/stage/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/../TechPatches/MiddleTier/20484781/p20484781_111190_Generic.zip

extracting: /u01/stage/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/../TechPatches/MiddleTier/14577216/p14577216_101231_Generic.zip

extracting: /u01/stage/startCD/Disk1/rapidwiz/bin/../../../../TechPatches/../TechPatches/MiddleTier/16241466/p16241466_10123_LINUX.zip

Build Stage Menu

------------------------------------------------------

1. Create new stage area

2. Copy patches to existing stage area

3. List files in TechPatches directory

4. Exit menu

Enter your choice [4]: 2

Rapid Install Platform Menu

------------------------------------------------------

1. Oracle Solaris SPARC (64-bit)

2. Linux x86 (64-bit)

3. IBM AIX on Power Systems (64-bit)

4. HP-UX Itanium

5. Exit Menu

Enter your choice [5]: 2

Directory /u01/stage/TechPatches

Stage Builder will now stage the one-off patches for Linux_x64...

Press Enter to continue...

Archive: /u01/stage/startCD/Disk1/rapidwiz/bin/../Xpatches/Linux_x64.zip

Finished copying additional patches.

Press Enter to continue...

Build Stage Menu

------------------------------------------------------

1. Create new stage area

2. Copy patches to existing stage area

3. List files in TechPatches directory

4. Exit menu

Enter your choice [4]:4

Now, start the rapidwiz process.

cd /u01/stage/startCD/Disk1/rapidwiz

Now upgrade 12.2.0 to 12.2.6

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

SQL> select * from v$version;

BANNER

--------------------------------------------------------------------------------

CON_ID

----------

Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

PL/SQL Release 12.1.0.2.0 - Production

CORE 12.1.0.2.0 Production

BANNER

--------------------------------------------------------------------------------

CON_ID

----------

TNS for Linux: Version 12.1.0.2.0 - Production

NLSRTL Version 12.1.0.2.0 - Production

SQL> select release_name from apps.fnd_product_groups;

RELEASE_NAME

--------------------------------------------------

12.2.0

[applmgr@ebs1 appl]$ . ./PROD_ebs1.env run

[applmgr@ebs1 appl]$ echo $FILE_EDITION

run

[applmgr@ebs1 appl]$ pwd

/u01/r12/application/fs1/EBSapps/appl

[applmgr@ebs1 appl]$

EBS Technology Codelevel Checker(ETCC)--Doc ID 1594274.1)

In the database tier

created one directory /u01/r12/database/12.1.0/appsutil/etcc

[oracle@ebs1 etcc]$ pwd

/u01/r12/database/12.1.0/appsutil/etcc

[oracle@ebs1 etcc]$ ./checkDBpatch.sh

+===============================================================+

| Oracle E-Business Suite Release 12.2 |

| Database EBS Technology Codelevel Checker |

+===============================================================+

Using context file from currently set database environment:

/u01/r12/database/12.1.0/appsutil/PROD_ebs1.xml

Starting Database EBS Technology Codelevel Checker, Version 120.40

Tue Jan 24 01:08:48 EST 2017

Log file for this session : ./checkDBpatch_20236.log

Bugfix XML file version: 120.0.12020000.33

This file will be used for identifying missing bugfixes.

Mapping XML file version: 120.0.12020000.6

This file will be used for mapping bugfixes to patches.

[WARNING] DB-ETCC: Bugfix XML file (./txk_R1220_DB_base_bugs.xml) in current directory is more than 30 days old.

Check if a newer version is available in patch 17537119.

Identifying database release.

Database release set to 12.1.0.2.

Connecting to database.

PATCH RECOMMENDATION SUMMARY

===============================================================================

The default patch recommendations to install these missing bugfixes are:

-------------------------------------------------------------------------------

Oracle Database Release 12.1.0.2 (No PSU applied)

-------------------------------------------------------------------------------

Patch 23595848

- Filename: p23595848_121020_Linux-x86-64.zip

Patch 18793246

- Filename: p18793246_121020_Generic.zip

Patch 23745950

- Filename: p23745950_121020_Linux-x86-64.zip

Patch 19591608

- Filename: p19591608_121020_Linux-x86-64.zip

Patch 19908836

- Filename: p19908836_121020_Linux-x86-64.zip

Patch 24481723

- Filename: p24481723_121020_Linux-x86-64.zip

Patch 22098146

- Filename: p22098146_121020_Linux-x86-64.zip

Patch 21286665

- Filename: p21286665_121020_Linux-x86-64.zip

Patch 21321429

- Filename: p21321429_121020_Generic.zip

Patch 21387964

- Filename: p21387964_121020_Linux-x86-64.zip

Patch 21864513

- Filename: p21864513_121020_Linux-x86-64.zip

Patch 21904072

- Filename: p21904072_121020_Linux-x86-64.zip

Patch 21967332

- Filename: p21967332_121020_Linux-x86-64.zip

Patch 22338374

- Filename: p22338374_121020_Linux-x86-64.zip

Patch 22496904

- Filename: p22496904_121020_Linux-x86-64.zip

Patch 22731026

- Filename: p22731026_121020_Generic.zip

Patch 23089357

- Filename: p23089357_121020_Linux-x86-64.zip

Apply the required patches and rerun this script

You should check the patch READMEs for minimum opatch version requirements.

The latest opatch is available from My Oracle Support via Patch 6880880.

+-----------------------------------------------------------------------------+

A consolidated zip file with the required patches for Database Release

12.1.0.2.0 is available on My Oracle Support via:

Patch 24658746 [12.1.0.2.0 version]

- EBS RELEASE 12.2 CONSOLIDATED DATABASE FIXES FOR 161018 AND 160719

Note: This zip does not include any database bundle patches or PSUs.

+-----------------------------------------------------------------------------+

See Doc ID 1594274.1 for any special instructions for these patches.

Note: Footnotes in Doc ID 1594274.1 also apply to corresponding overlay patches.

Stored Technology Codelevel Checker results in the database PROD successfully.

Finished prerequisite patch testing : Tue Jan 24 01:10:06 EST 2017

Log file for this session: ./checkDBpatch_20236.log

===============================================================================

[applmgr@ebs1 patches]$ pwd

/u01/patches

[applmgr@ebs1 patches]$ sh checkMTpatch.sh

+===============================================================+

| Oracle E-Business Suite Release 12.2 |

| Middle Tier Technology Codelevel Checker |

+===============================================================+

Using context file from currently set applications environment:

/u01/r12/application/fs1/inst/apps/PROD_ebs1/appl/admin/PROD_ebs1.xml

Starting Middle Tier Technology Codelevel Checker, Version: 120.0.12020000.30.

Tue Jan 24 01:18:56 EST 2017

Log file for this session: /u01/patches/checkMTpatch_22029.log

Bugfix XML file version: 120.0.12020000.27

This file will be used for identifying missing bugfixes.

Mapping XML file version: 120.0.12020000.12

This file will be used for mapping bugfixes to patches.

Checking for prerequisite bugfixes in File Edition: run

Enter the password for the APPS user:

Connecting to database.

Database connection successful.

The installed AD.C codelevel does not support storing the results in the database.

===============================================================================

Oracle Forms and Reports

===============================================================================

Now examining product Oracle Forms and Reports.

Oracle Home = /u01/r12/application/fs1/EBSapps/10.1.2.

Product version = 10.1.2.3.0.

Checking required bugfixes for Oracle Forms and Reports 10.1.2.3.0.

Missing Bugfix: 17353142 -> Patch 22698265

Missing Bugfix: 20643256 -> Patch 22698265

Missing Bugfix: 16041055 -> Patch 22698265

Missing Bugfix: 16910762 -> Patch 22698265

Missing Bugfix: 20270659 -> Patch 22698265

Missing Bugfix: 17372642 -> Patch 22698265

Missing Bugfix: 17566694 -> Patch 22698265

Missing Bugfix: 20240480 -> Patch 22698265

Missing Bugfix: 19304738 -> Patch 22698265

Missing Bugfix: 20391574 -> Patch 22698265

Missing Bugfix: 22351071 -> Patch 22698265

Missing Bugfix: 21024122 -> Patch 22698265

Missing Bugfix: 19588847 -> Patch 22698265

The above list shows missing bugfixes for Oracle Forms and Reports.

Checking required bugfixes for RSF within Forms 10.1.0.5.0.

All required bugfixes are present for RSF within Forms.

===============================================================================

Oracle Fusion Middleware (FMW) - Web Tier

===============================================================================

Now examining product Oracle Fusion Middleware (FMW) - Web Tier.

Oracle Home = /u01/r12/application/fs1/FMW_Home/webtier.

Product Version = 11.1.1.9.0

Checking required bugfixes for FMW - Web Tier 11.1.1.9.0.

Missing Bugfix: 21300463 -> Patch 22288381

Missing Bugfix: 21892015 -> Patch 22288381

The above list shows missing bugfixes for FMW - Web Tier.

Checking required bugfixes for RSF within FMW Web tier 11.1.0.7.0.

All required bugfixes are present for RSF within FMW Web tier.

===============================================================================

Oracle Fusion Middleware (FMW) - oracle_common

===============================================================================

Now examining product Oracle Fusion Middleware (FMW) - oracle_common.

Oracle Home = /u01/r12/application/fs1/FMW_Home/oracle_common.

Product Version = 11.1.1.9.0

Checking required bugfixes for FMW - oracle common 11.1.1.9.0.

Missing Bugfix: 9905685 -> Patch 9905685

Missing Bugfix: 21366277 -> Patch 21366277

Missing Bugfix: 21628307 -> Patch 21628307

The above list shows missing bugfixes for FMW - oracle common.

===============================================================================

Oracle WebLogic Server (WLS)

===============================================================================

Now examining product Oracle WebLogic Server (WLS).

Oracle Home = /u01/r12/application/fs1/FMW_Home/wlserver_10.3.

Product Version = 10.3.6.0.7

Note that for Oracle WebLogic Server, patches rather than bugfixes are verified.

Checking required patches for Oracle WebLogic Server (WLS) 10.3.6.0.7.

Missing Patch ID: 20780171

Missing Patch ID: 22323006

The above list shows missing patches for Oracle WebLogic Server.

If you have applied other Oracle WebLogic Server patches, they may have included the bugfixes needed.

Contact Oracle Support if you require assistance in determining whether this is the case.

===============================================================================

Generating Patch Recommendation Summary.

===============================================================================

PATCH RECOMMENDATION SUMMARY

===============================================================================

One or more products have bugfixes missing.

The default patch recommendations to install these missing bugfixes are:

-------------------------------------------------------------------------------

Oracle Forms and Reports 10.1.2.3.0

-------------------------------------------------------------------------------

Patch 22698265

- Filename: p22698265_101232_LINUX.zip

-------------------------------------------------------------------------------

Oracle Fusion Middleware (FMW) - Web Tier 11.1.1.9.0

-------------------------------------------------------------------------------

Patch 22288381

- Filename: p22288381_111190_Generic.zip

-------------------------------------------------------------------------------

Oracle Fusion Middleware (FMW) - oracle_common 11.1.1.9.0

-------------------------------------------------------------------------------

Patch 9905685

- Filename: p9905685_111190_Generic.zip

Patch 21366277

- Filename: p21366277_111190_Generic.zip

Patch 21628307

- Filename: p21628307_111190_Generic.zip

-------------------------------------------------------------------------------

Oracle WebLogic Server (WLS) 10.3.6.0.7

-------------------------------------------------------------------------------

Patch 20780171 [SU Patch [EJUW]: WLS PSU 10.3.6.0.12]

- Filename: p20780171_1036_Generic.zip

Patch 22323006 [SU Patch [DI8E]]

- Filename: p22323006_1036_Generic.zip

Apply the required patches and rerun this script.

+-----------------------------------------------------------------------------+

A consolidated zip file with the required middle tier patches is available on

My Oracle Support via:

Patch 24658753

- EBS RELEASE 12.2 CONSOLIDATED FMW FIXES FOR 161018 AND 160719

+-----------------------------------------------------------------------------+

[WARNING] Patch 20780171 [SU Patch [EJUW]: WLS PSU 10.3.6.0.12] is missing.

This is the recommended minimum WLS patch set.

You should install it now, and then rerun this script to check for any

further fixes available.

+-----------------------------------------------------------------------------+

See Doc ID 1594274.1 for any special instructions regarding these patches.

Footnotes in Doc ID 1594274.1 also apply to corresponding overlay patches.

Finished checking prerequisite patches for File Edition: run.

Tue Jan 24 01:20:24 EST 2017

Log file for this session: /u01/patches/checkMTpatch_22029.log

===============================================================================

[applmgr@ebs1 patches]$

applied the required patches as mentioned in the list above.

Apply Consolidated Seed Table Upgrade Patch (Required)

Note: If the Release 12.2.0 Vision or PROD instance (New Installation) was created using startCD 12.2.0.51 (Patch 22066363), you must apply Consolidated Seed Table Upgrade Patch 17204589:12.2.0 by merging with Patch 21900871:12.2.0 on the run file system using adop hotpatch mode.

sh $ADMIN_SCRIPTS_HOME/adstpall.sh

sh $ADMIN_SCRIPTS_HOME/adadminsrvctl.sh start

$ adop phase=apply patches=17204589,21900871 merge=yes
hotpatch=yes

Successfully created out directory

    [STATEMENT] [END   2017/01/24 03:41:39] Performing Automatic DB
cutover

    [STATEMENT] [START
2017/01/24 03:41:40] Running cutover since in hotpatch mode

    [STATEMENT] [END   2017/01/24 03:41:42] Running cutover since
in hotpatch mode

    [STATEMENT] [START
2017/01/24 03:41:43] Compiling Invalid Objects

    [STATEMENT] [END   2017/01/24 03:41:48] Compiling Invalid
Objects

[STATEMENT] [END 2017/01/24 03:41:52] apply phase

  [STATEMENT] [START
2017/01/24 03:41:53] Generating Post Apply Reports

    [STATEMENT] APPLY Phase
END TIME: 24-01-2017 03:41:54

      [STATEMENT] [START
2017/01/24 03:41:56] Generating Report to spool all logs from ad_zd_logs

        [STATEMENT] Report:
/u01/r12/application/fs1/EBSapps/appl/ad/12.0.0/sql/ADZDSHOWLOG.sql

        [STATEMENT] Output:
/u01/r12/application/fs_ne/EBSapps/log/adop/2/apply_20170124_015013/PROD_ebs1/adzdshowlog.out

      [STATEMENT] [END   2017/01/24 03:42:00] Generating Report to
spool all logs from ad_zd_logs

  [STATEMENT] [END   2017/01/24 03:42:01] Generating Post Apply
Reports

[STATEMENT] [END  
2017/01/24 03:42:05] adzdoptl.pl run

[STATEMENT] adop phase=apply - Completed Successfully

[STATEMENT] Log file:
/u01/r12/application/fs_ne/EBSapps/log/adop/2/adop_20170124_015013.log

adop exiting with status = 0 (Success)

Apply the Latest AD and TXK Delta Release Update Packs

applied the patch

Patch 21841299 (R12.AD.C.Delta.8)
Patch 21830810 (R12.TXK.C.Delta.8)

adop phase=apply patches=21841299 hotpatch=yes

Upgrade and New Installation Customers upgrading to Oracle E-Business Suite 12.2.6 Release Update Pack

sh $ADMIN_SCRIPTS_HOME/adadminsrvctl.sh stop

adop phase=apply patches=21830810 hotpatch=yes

Apply Oracle E-Business Suite 12.2.6 Release Update Pack

Stop the Oracle Weblogic Admin Server and Node Manager services.

Applying the patch in downtime mode requires all application tier services to be down. Therefore, Weblogic AdminServer and Node Manager that were started previously when applying the latest Release Update Packs for AD and TXK for Release 12.2 need to be shut down.

Stop the Oracle Weblogic Admin Server on the run file system.

UNIX:

$ sh $ADMIN_SCRIPTS_HOME/adadminsrvctl.sh stop

Stop the Node Manager service on the run file system.

UNIX:

$ sh $ADMIN_SCRIPTS_HOME/adnodemgrctl.sh stop

Apply Oracle E-Business Suite 12.2.6 Release Update Pack Patch 21900901 on the run edition application environment, using downtime mode.

UNIX:

$ adop phase=apply apply_mode=downtime patches=21900901

-------------------------------------------------------------------------------------------------

Note:EBSapps.env will be created only when first autoconfig is run. And don't run autoconfig in patch file system because the it will throw errors

ORA-20099: E-Business Suite Patch Edition does not exist.

it should only be run when at-least patch edition exist which is adop phase=prepare

---------------------------------------------------------------------------------------------------

SQL> select release_name from fnd_product_groups;

RELEASE_NAME

--------------------------------------------------

12.2.6

Oracle APPS DBA pieces

Pages

Tuesday, April 25, 2017

In EBS 12.1.3, Gather Schema Stats fails with Cause: FDPSTP failed due to ORA-29913: error in executing ODCIEXTTABLEOPEN callout

Monday, April 17, 2017

adoacorectl.sh , adformsctl.sh , adoafmctl.sh – exiting with status 204

Thursday, March 30, 2017

Not able to start EBS 12.1.3 services:[ons-secure] Failed to open wallet

Thursday, March 2, 2017

Oracle Database 12c Release 2 is here!!!!!!!!

Tuesday, February 7, 2017

Importance of LAST_CALL_ET column in V$session view

Sunday, February 5, 2017

Java VisualVM comes by default with EBS 12.2

Saturday, February 4, 2017

EBS 12.2.6 - 12C DB installation on Linux

Apply the Latest AD and TXK Delta Release Update Packs

Upgrade and New Installation Customers upgrading to Oracle E-Business Suite 12.2.6 Release Update Pack

Apply Oracle E-Business Suite 12.2.6 Release Update Pack

Traffic