Wednesday, June 26, 2019

ORA-39142: incompatible version number 4.2 in dump file impdp

ORA-39142: incompatible version number 4.2 in dump file 

Impdp encountering error ORA-39142

ORA-39001: invalid argument value
ORA-39000: bad dump file specification
ORA-39142: incompatible version number 4.2 in dump file


Cause:
The issue is caused due to bug  Metalink Note 
Doc ID (2422236.1)

Workaround:

Use parameter VERSION=12.1 while performing the export.

Issue will be fixed .

Monday, June 24, 2019

EBS R12 Security

EBS Security 

 Very useful for implementing security and verification
Click on the link below.

Friday, June 21, 2019

Oracle Critical Patch Update Advisory - April 2019

Oracle Critical Patch Update Advisory - April 2019

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


Description

A Critical Patch Update is a collection of patches for multiple security vulnerabilities. Critical Patch Update patches are usually cumulative, but each advisory describes only the security fixes added since the previous Critical Patch Update advisory. Thus, prior Critical Patch Update advisories should be reviewed for information regarding earlier published security fixes. Please refer to:


Oracle continues to periodically receive reports of attempts to maliciously exploit vulnerabilities for which Oracle has already released fixes. In some instances, it has been reported that attackers have been successful because targeted customers had failed to apply available Oracle patches. Oracle therefore strongly recommends that customers remain on actively-supported versions and apply Critical Patch Update fixes without delay.
This Critical Patch Update contains 297 new security fixes across the product families listed below. Please note that an MOS note summarizing the content of this Critical Patch Update and other Oracle Software Security Assurance activities is located at April 2019 Critical Patch Update: Executive Summary and Analysis.

Select 
Oracle Database Server, versions 11.2.0.4, 12.1.0.2, 12.2.0.1, 18c, 19cDatabase
Oracle E-Business Suite, versions 0.9.8, 1.0.0, 1.0.1, 12.1.1, 12.1.2, 12.1.3, 12.2.3, 12.2.4, 12.2.5, 12.2.6, 12.2.7, 12.2.8E-Business Suite
For Ebsuiness suite click on any of the link .

Oracle E-Business Suite Release 12 Critical Patch Update Knowledge Document (April 2019) (Doc ID 2514102.1)



Patch number - 29252146 (Combo)

Security Patches for Technology Stack Components With a New Patch in This CPU

Oracle ProductLatest Security PatchesMy Oracle Support Knowledge Document References and Supplementary Comments
Oracle Database 12.1.0.2OJVM PSU 12.1.0.2.190416 and Database PSU 12.1.0.2.190416 Combo Patch 29252146Document 2498664.1Critical Patch Update (CPU) Program April 2019 Availability Document (PAD).

How To Enable And Disable Flashback In Oracle Database

How To Enable And Disable Flashback In Oracle Database

ENABLE FLASHBACK:

 Make sure the database is in archive log mode :
SQL> alter system set db_recovery_file_dest='/u01/app/oracle';
System altered.
SQL> alter system set db_recovery_file_dest_size=50G;
System altered.
SQL> show parameter db_recovery_file
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest string /u01/app/oracle
db_recovery_file_dest_size big integer 50G

SQL> select flashback_on from v$database;
FLASHBACK_ON
------------------
NO

SQL> alter database flashback on;
Database altered.
SQL> select flashback_on from v$database;
FLASHBACK_ON
------------------
YES


DISABLE FLASHBACK:

SQL> select flashback_on from v$database;
FLASHBACK_ON
------------------
YES
SQL> alter database flashback off;
Database altered.
SQL> select flashback_on from v$database;
FLASHBACK_ON
------------------
NO

Oracle E-Business Suite Release 12.2.7

Oracle E-Business Suite Release 12.2.7 Readme (Doc ID 2230783.1)

click on the link below

12.2.7 E-business suite

Oracle E-Business Suite Release 12.2.7

Oracle E-Business Suite Product Specific Release Notes, Release 12.2.7 (Doc ID 2243855.1)


Click on the link below for whole information

https://blogs.oracle.com/ebstech/oracle-e-business-suite-1227-now-available


Oracle E-Business Suite 12.2.7 Now Available

Steven Chan 
SENIOR DIRECTOR
I am pleased to announce that Oracle E-Business Suite Release 12.2.7 is now available.