Posted by: repettas | July 29, 2014

That’s … Huge!

Originally posted on Oracle Tips and Tricks -- David Fitzjarrell:

Recently I’ve noticed the occasional thread in Oracle newsgroups and lists asking about hugepages support in Linux, including ‘best practices’ for hugepages configuration. This information is out on that ‘world-wide web’ in various places; I’d rather put a lot of that information in this post to provide an easier way to get to it. I’ll cover what hugepages are, what they do, what they can’t do and how best to allocate them for your particular installation. Let’s get started.

“Normal” memory pages in Linux are 4 KB in size and are allocated as needed where the memory map will allow so they are likely not contiguous. Hugepages, in comparison, are 2 MB pages locked in memory and are allocated in a contiguous ‘chunk'; these are allocated at boot time using a parameter in the /etc/sysctl.conf file named vm.nr_hugepages for RedHat Linux kernel 2.6 and a parameter named vm.hugetlb_pool for RedHat…

View original 1,371 more words

Posted by: repettas | July 29, 2014

Introduction to Fusion Applications Roles Concepts

Introduction to Fusion Applications Roles Concepts.

Originally posted on Martins Blog:

Oracle is out, after lots of announcements the product has finally been released. I had just extended my cluster to 3 nodes and was about to apply the July PSU when I saw the news. So why not try and upgrade to the brand new thing?

What struck me at first was the list of new features … Oracle’s patching strategy has really changed over time. I remember the days when Oracle didn’t usually add additional features into point releases. Have a look at the new features and that would possibly qualify to be 12c Release 2…

In summary the upgrade process is actually remarkably simple, and hasn’t changed much since earlier versions of the software. Here are the steps in chronological order.


I don’t know how often I have type ./ruinInstaller instead of runInstaller, but here you go. This is the first wizard screen after splash screen has…

View original 1,056 more words

ORACLE-BASE – Oracle Database 11g Release 2 (11.2) Installation On Oracle Linux 7 (OL7).

Posted by: repettas | July 29, 2014

12c and export/import from a lower version

Originally posted on dbwhisperer:

There is a serious problem with export/import utilities between versions.

The first command, executed on Oracle, Linux x86_64 was:

[oracle@oradb tmp]$ expdp system directory=tmp dumpfile=oe.dmp schemas=oe


Directory tmp was created as /tmp

Result was the following:

Export: Release – Production on Mon Jul 28 22:57:03 2014

Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights



Connected to: Oracle Database 11g Enterprise Edition Release -

64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing


Starting “SYSTEM”.”SYS_EXPORT_SCHEMA_01″: system/******** directory=tmp

dumpfile=oe.dmp schemas=oe logfile=oe.log



. . exported “OE”.”PRODUCT_DESCRIPTIONS” 2.379 MB 8640


ORA-39181: Only partial table data may be exported due to fine grain

access control on “OE”.”PURCHASEORDER”

. . exported “OE”.”PURCHASEORDER” 243.9 KB 132


. . exported “OE”.”WAREHOUSES” 12.46 KB 9


. . exported “OE”.”CUSTOMERS” 77.98 KB 319


. . exported “OE”.”PRODUCT_INFORMATION” 72.77 KB…

View original 483 more words

Posted by: repettas | July 29, 2014

12c and export/import from a lower version

12c and export/import from a lower version.

Posted by: repettas | July 29, 2014

Oracle ASM Filter Driver: First Impressions

Oracle ASM Filter Driver: First Impressions.

Originally posted on Kevin Closson's Blog: Platforms, Databases and Storage:

Enabled By Default. Not Usable By Default.

Series Links: Part I, Part II.

It was my intention to only write 2 installments on my short series about Oracle Database 12c In-Memory Column Store feature usage. My hopes were quickly dashed when the following developments occurred:

1. A quote from an Oracle spokesman cited on was pulled because (I assume) it corroborated my assertion that the feature is enabled by default. It is, enabled by default.

Citations: Tweet about the quote, link to the July 26, 2014 version of the article showing the Oracle spokesman quote: 26 July 2014.

The July 26, 2014 version of the article quoted an Oracle spokesman as having said the following:

Yes, Oracle Database In-Memory is an option and it is on by default, as have been all new options since Oracle Database 11g

2. An email from…

View original 692 more words

Posted by: repettas | July 26, 2014

Oracle ASM Filter Driver: First Impressions

Originally posted on flashdba:

This is a very quick post, because I’m about to log off and take an extended summer holiday (or vacation as my crazy American friends call it… but then they call football  “soccer” too). Before I go, I wanted to document my initial findings with the new ASM Filter Driver feature introduced in this week’s 12.1.o.2 patchset.

Currently a Linux-only feature, the ASM Filter Driver (or AFD) is a replacement for ASMLib and is described by Oracle as follows:

Oracle ASM Filter Driver (Oracle ASMFD) is a kernel module that resides in the I/O path of the Oracle ASM disks. Oracle ASM uses the filter driver to validate write I/O requests to Oracle ASM disks.

The Oracle ASMFD simplifies the configuration and management of disk devices by eliminating the need to rebind disk devices used with Oracle ASM each time the system is restarted.

The Oracle ASM Filter Driver rejects…

View original 1,522 more words

Posted by: repettas | July 24, 2014

Unlimited Session Timeout

Unlimited Session Timeout.

Older Posts »



Get every new post delivered to your Inbox.