Oracle

12c: Fun with WITH!

Last night I couldn’t sleep and what else you’re going to do? I was thinking about Oracle stuff. In Oracle version 12, Oracle has enhanced the WITH clause – traditionally used for sub-query factoring – to allow the declaration of functions and procedures. This can be (ab)used to create a very interesting scenario, that is not very…

In-Memory Column Store: 10046 May Be Lying to You!

The Oracle In-Memory Column Store (IMC) is a new database option available to Oracle Database Enterprise Edition (EE) customers. It introduces a new memory area housed in your SGA, which makes use of the new compression functionality brought by the Oracle Exadata platform, as well as the new column oriented data storage vs the traditional…

Create Windows Service for Oracle RAC

It’s my first time on RAC system for Windows and I’m happy to learn something new to share. I created a new service for database (restoredb) only to find out the ORACLE_HOME for the service is “c:\\oracle\\product\\10.2.0\\asm_1″ Any ideas as to what was wrong? C:\\dba_pythian>set oracle_home=C:\\oracle\\product\\10.2.0\\db_1 C:\\dba_pythian>echo %ORACLE_HOME% C:\\oracle\\product\\10.2.0\\db_1 C:\\dba_pythian>oradim -NEW -SID restoredb -STARTMODE manual…

Exploring Options of Using RMAN Configure to Simplify Backup

I am a simple person who likes simple things, especially RMAN backup implementation. I have yet to understand why RMAN backup implementation does not use configure command, and if you have a good explanation, please share. Examples for RMAN configure command configure device type disk parallelism 2 backup type to compressed backupset; configure channel device…

How To Correlate Oracle Database Transaction with GoldenGate

So there I was troubleshooting GoldenGate issue and was puzzled as to why GoldenGate transactions were not seen from Oracle database. I had the transaction XID correct; however, I was filtering by ACTIVE transaction from Oracle which was causing the issue. Please allow me to share a test case so that you don’t get stumped…

Changing Failgroup of ASM Disks in Exadata

There was a discrepancy in the failgroups of couple of ASM disks in Exadata. In Exadata, the cell name corresponds to the failgroup name. But there were couple of disks with different failgroup names. Using the following plan to rectify the issue online without any downtime:

What’s New with Apps Password Change in R12.2 E-Business Suite ?

Apps password change routine in Release 12.2 E-Business Suite changed a little bit. We have now extra options to change password, as well as some manual steps after changing the password using FNDCPASS. There is a new utility introduced called AFPASSWD. This utility unlike FNDCPASS wont require you to enter apps and system user password,…

Differences Between R12.1 and R12.2 Integration with OAM

With the revamp of technology stack in R12.2 of Oracle E-Business Suite (EBS) , the way we integrate Oracle Access Manager (OAM) has changed. R12.2 now is built on Weblogic techstack, which drastically changed how it integrates with Other Fusion Middleware Products like OAM Here is a overview of Steps to configure OAM with EBS…

Page 5 of 140« First Page...34567...10...Last Page »