Keeping a Tidy Software Library – Saved Patches

As we’ve started using the Life Cycle Management Pack we’ve started to accumulate some baggage in our Software Library.  You can find yours by going to the Saved Patches page under the Patches and Provisioing menu.



You can get the same results with emcli search_patches -swlib.  Pipe it through sort -n to display in patch number order. 

> emcli search_patches -swlib | sort -n

You can also dump those results to a csv (more...)

Support ID : How to enable and retrieve FND debug log messages

If you want to know about FND Debug log configuration in R12, this below document id is useful for you

How to enable and retrieve FND debug log messages (Doc ID 433199.1)

PERWSDOR form compile in r12



[appltrng@ebsdev bin]$   frmcmp_batch module=/u02/backup/appltrng/apps/apps_st/appl/au/12.0.0/forms/US/PERWSDOR.fmb userid=apps/Ace321b output_file=/u02/backup/appltrng/apps/apps_st/appl/per/12.0.0/forms/US/PERWSDOR.fmx module_type=form batch=no compile_all=yes

Compiling WHEN-BUTTON-PRESSED trigger on PREV_MONTH item in CALENDAR data block…
No compilation errors.

Compiling WHEN-BUTTON-PRESSED trigger on NEXT_MONTH item in CALENDAR data block…
No compilation errors.

Compiling WHEN-BUTTON-PRESSED trigger on NEXT_YEAR item in CALENDAR data block…
No compilation errors.

Compiling WHEN-BUTTON-PRESSED trigger on PREV_YEAR item in CALENDAR data block…
No compilation errors.
Created form file /u02/backup/appltrng/apps/apps_st/appl/per/12.0.0/forms/US/PERWSDOR.fmx

Oracle Critical Patch Update Advisory – July 2014

RSS content

Oracle has released July Critical Patch Update on 15 July 2014.

This Critical Patch Update provides 113 new security fixes across a wide range of product families including: Oracle Database, Oracle Fusion Middleware, Oracle Hyperion, Oracle Enterprise Manager Grid Control, Oracle E-Business Suite, Oracle PeopleSoft Enterprise, Oracle Siebel CRM, Oracle Industry Applications, Oracle Java SE, Oracle Linux and Virtualization, Oracle MySQL, and Oracle and Sun Systems Products Suite.

For more details, please click (more...)

OTN Article : Oracle Database 12c – Nuevas Características de "Oracle Partitioning"

Oracle Technology Network - OTN (Latina America) published our 6th article in Spanish Language.
This article entitled : Oracle Database 12c – Nuevas Características de "Oracle Partitioning") 
by Joel Perez (Oracle ACED) and Mahir M. Quluzade (OCE)  Published : 17 July 2014

Article link : Oracle Database 12c: Nuevas Características de “Oracle Partitioning”
This article covers a bit new features of "Oracle Partitioning" on Oracle Database 12c (12.1)

Mahir M. Quluzade 

Delivering DBaaS using EM12c

One of the jobs I’m currently working on is writing a technical whitepaper on Delivering DBaaS using EM12c. I realized as I was starting it that a technical whitepaper really isn’t the place for a step-by-step how-to sort of description, so I thought I’d better blog about it instead. Actually, I’m going to write a […]

have fun anyone heading out to OOW 2014

For anyone who has never attended a San Francisco Oracle Open World you really should go at some point.  The city is beautiful and the event well organized if a little on the chaotic side.

I have been lucky enough to attend quite a few of them over the last 10 years but missed out last year and also will be missing out this year.

It has been just once that one of my (more...)

Evaluating Quarterly Risk Matrices

Oracle provides risk matrices for all of its products with the quarterly Patch Set Update (PSU). This article provides some guidance about the Database Risk Matrix can be interpreted, but the interpretation and implementation decisions rest with the Oracle professional and their corporate security staff.

Each Database Risk Matrix lists specific risk vectors treated in the current patchset. Analysis of the Risk Matrix for your environment should be base on the potential impact of those (more...)

Crossplatform transportable tablespaces – part 1

There is couple of way to do heterogeneous migration of Oracle databases but staring with 12c there is whole set of new RMAN commands to transport data across different platforms.
I was looking for a best method of move tablespaces from HP-UX to Linux and after some research I found this presentation by Martin Bach from Enkitec (you can watch it online here). Martin describing Oracle Perl script (MOS ID 1389592.1) which allows (more...)

Oracle VirtualBox 4.3.14

Oracle has just released the Oracle VirtualBox 4.3.14. You can download the binaries here and the change log here. VirtualBox Articles

The post Oracle VirtualBox 4.3.14 appeared first on VitalSoftTech.

DevOps & Delphix : Chef recipes

Delphix Engines expose all features via a stable WEB API built on top of HTTP and JSON.

Clients choose an HTTP client to interact with Delphix and integrate within their environment.

Delphix Engines are bundled with a command line interface which guides users for automation and integration with third party tools.

Delphix CLI example

Adding a SQL Server Source Environment:

Enter these commands through the command line interface:


   set type=HostEnvironmentCreateParameters;

   set hostEnvironment.type=WindowsHostEnvironment;
   set  (more...)

VirtualBox 4.3.14

Oracle have given birth to VirtualBox 4.3.14. Mother and baby are doing well, with the downloads and changelog in the usual places.

Happy upgrading…




VirtualBox 4.3.14 was first posted on July 16, 2014 at 2:23 pm.
©2012 "The ORACLE-BASE Blog". Use of this feed is for personal non-commercial use only. If you are not reading this article in your feed reader, then the site is guilty of copyright infringement. DBUA silently changing NLS_TERRITORY init.ora Parameter during upgrade

In case you are planning to perform any upgrades with DBUA, double-check that the init.ora parameters after the upgrade. In a production upgrade at a client site, dbua silently changed init.ora parameter NLS_TERRITORY from GERMANY to AMERICA. It was only noticed when after the upgrade, decimal and grouping number characters were swapped, leading to application problem.

Support had to admit that it is unpublished bug 16538186 and that there is NO documentation of (more...)

Oracle Critical Patch Update Advisory – July 2014

The July Oracle Critical Patch has been released. This includes patches for Database Product Suite, Fusion Middleware Product Suite, Exalogic, and Enterprise Manager Suite Critical Patch Updates and Patch Set Updates. It includes 113 new security , 5 Oracle Database and a host of other bug fixes. More about the July 2014 Critical Patch Update […]

The post Oracle Critical Patch Update Advisory – July 2014 appeared first on VitalSoftTech.

Book Review: Troubleshooting Oracle Performance, Second Edition

July 15, 2014 Extensively Researched with Detailed Analysis Covering a Broad Range of Oracle Database Performance Topics, Providing Insight that is Not Available from Other Sources I pre-ordered this book in December 2013, having previously read the first edition of this book twice.  Once the printed copy of the second edition book arrived, I ordered […]

Granting Access to BI Publisher in EM

In my Configuring Highly Available BI Publisher in EM post, I covered how you configured BI Publisher in a highly available environment. When BI Publisher is configured, by default only the super-administrator accounts you have defined in your EM12c environment have access to the tool. That means that none of your normal administrator level […]

SAP deployed with Delphix

How does Delphix benefit a SAP project?

  • Speed up time to delivery for ASAP implementation methodology
  • Enable adoption of “Continuous Application Delivery” methodology
  • Reduce infrastructure overhead
  • Deliver higher quality projects

ASAP methodology is a framework for delivering large IT projects. SAP professionals are familiar with this, however given the size and complexity of SAP projects, many fail to fully adopt it. Delphix helps customers adopt and use ASAP methodology.

SAP Projects today are big, hairy beasts. They (more...)

It Pays To Be Smart

Exadata is a powerful system, able to provide exceptional performance. Much of this peformance is due to Smart Scans, Exadata’s mechanism for shifting the workload to the storage cells and having them filter and reduce the amount of data the database servers must process. Not every Smart Scan that starts ends up completing, though. Oracle may decide that a different path, one that doesn’t include a Smart Scan, may be more efficient. Certain conditions must (more...)

Oracle DBA Training Options Are Changing

Oracle DBA Training Options Are Changing

Training options for Oracle Database DBAs are changing. Generally, I don't think they are for the better. Companies don't value Oracle Database Administrators like they used to. And, it shows in the lack of their professional development investment.

When I travel a long way from home, I tend to get very reflective about life, death and beyond. On my way home from teaching an onsite two-day Oracle performance tuning (more...)

asm spfile

The below article useful to know about asm spfile and How asm instance started if spfile in diskgroup without mount.

This article he explained for  normal redundancy . If you want to find the spfile on external redundancy level, you can use below command

[oracle@asmoracle ~]$ asmcmd lsdsk -G DATA

[oracle@asmoracle ~]$ kfed read /dev/oracleasm/disks/DISK1 | grep -E 'spf|ausize'
kfdhdb.ausize: 1048576 ; 0x0bc: 0x00100000
kfdhdb.spfile: 1450 ;  (more...)