Infrastructure at your Service

All Posts By

Clemens Bleile

Clemens Bleile

Workaround for bug 19566227/20563128 doing Cross Platform Migration (MOS Note 1389592.1)

By | Database Administration & Monitoring, Database management, Oracle | One Comment

In a project I have to move an Oracle 11.2.0.4-DB (around 7TB in size) from Sparc Solaris (called Source in the remainder of this Blog) to Linux x86-64 (called Target in the remainder of the Blog). I.e. a platform migration from Big Endian to Little Endian. A good method to do that is described in My Oracle Support Note 1389592.1: 11G – Reduce Transportable Tablespace Downtime using Cross Platform Incremental Backup Basically I copy the…

Read More
Clemens Bleile

Trace files segmented in multiple parts as a workaround for bug 23300142

By | Database Administration & Monitoring, Oracle | No Comments

Today I visited a customer, who deleted a Data Guard configuration (i.e. a temporary Data Guard setup through the broker was deleted). The LOG_ARCHIVE_DEST_STATE_2 on the primary database was set to DEFER temporarily. That resulted in trace-files with name *tt*.trc to become huge (GBytes after a couple of days). Analysis showed that this was caused by bug 23300142 in 12.1.0.2. See My Oracle Support Note Bug 23300142 – TT background process trace file message: async…

Read More
Clemens Bleile

SQL Plan Directives in 12cR2. Behavior is different than in 12cR1.

By | Database Administration & Monitoring, Database management, Oracle | 10 Comments

During the Frankfurter IT Tage I provided a presentation about SQL Plan Directives and how to reproduce a testcase in a test environment for a plan with used SQL Plan Directives (SPD). In that context I did a couple of tests with 12cR2 (12.2.0.1) and wanted to blog about the change in behavior in that release. Here is my testcase I did initially run in 12.1.0.2: First I created a table with 4 columns: A,…

Read More
Clemens Bleile

OTN Appreciation Day : External tables

By | Database Administration & Monitoring, Oracle | No Comments

As part of the OTN Appreciation Day (see https://oracle-base.com/blog/2016/09/28/otn-appreciation-day/) I’m writing about one of my favorite Oracle features: External tables. Traditionally people loaded data in an Oracle database using SQL*Loader. With the introduction of external tables, SQL*Loader became obsolete (in my view ;-)), because external tables provide the same loading capabilities and so much more than SQL*loader. Why? Because external tables can be accessed through SQL. You have all possibilities SQL-queries offer. Prallelism, difficult joins…

Read More
Clemens Bleile

Oracle Open World 2016 – Day 4 and 5

By | Database Administration & Monitoring, Oracle | No Comments

At the end of Oracle Open World my last BLOG concerning OOW 2016 covering day 4 and 5: Wednesday is the day of the Party: Oracle’s appreciation event, a concert with Gwen Stefani and Sting at the AT&T Park (Stadium of the San Francisco Baseball team, the Giants). It was a great event with awesome musicians. Before the party I visited the session “Oracle Active Data Guard: Power, Speed, Ease and Protection” provided by Larry…

Read More
Clemens Bleile

Oracle Open World 2016 – Day 3

By | Database Administration & Monitoring, Oracle | 2 Comments

On day 3 I visited various sessions about In-Memory and its many new features in 12gR2. Yesterday I already listed some new features of In-Memory. In this post I want to explain the new features more in detail:   In-Memory Join Groups: Columns are specified, which are used to join tables: CREATE INMEMORY JOIN GROUP V_name_jg (VEHICLES(NAME), SALES(NAME)); Those columns share the compression dictionary. My understanding on how this works is as follows: The joins…

Read More
Clemens Bleile

Oracle Open World 2016 – Day 2

By | Database Administration & Monitoring, Oracle | One Comment

Day 2 is the first official day of the Oracle Open World (OOW) 2016. As a parallel event the Oak Table Network organized his Oak Table World (OTW) close to the Open World. I attended several sessions from OOW and OTW: Jeremy Schneider: Ansible Ansible is a very light software written in Python, which allows automation in deploying applications and managing systems. The main goal of the developer of Ansible Michael DeHaan was to make…

Read More
Clemens Bleile

Oracle Open World 2016 – Day 1

By | Database Administration & Monitoring, Oracle | No Comments

Oracle Open World 2016 started on Sunday. The first day is always reserved for presentations provided by members of the various Oracle User Groups. However, the last part of the day is the first Keynote from Larry Elison. But let’s start by some of the sessions I visited Sunday: Ludovica Caldara: Migrating to Oracle Databases 12c: 300 databases in 300 days. Ludovica provided a presentation about the experience he gained during the migration project of…

Read More
Clemens Bleile

Database security: Where is my critical data?

By | Database Administration & Monitoring, Database management, Oracle | 3 Comments

Last week I visited the Oracle University Event “Expert Summit 2016” in Berlin, Germany. Besides the nice location in the Adlon Kempinski hotel, close to the Brandenburger Tor, I saw very interesting presentations from Jonathan Lewis (Database Troubleshooting and Tuning) and Pete Finnigan (Oracle Database Security Audit Training). The training from Pete was about how to do a database security audit. On the first day we learned a lot about potential security holes (vulnerabilities) in…

Read More
Clemens Bleile

Oracle kernel relink on Linux: Are my options stored persistently?

By | Database Administration & Monitoring, Database management, Oracle | 2 Comments

I recently visited an Oracle presentation about the Oracle-kernel built-in directNFS (dNFS) driver. To use dNFS in the database you have to enable it: cd $ORACLE_HOME/rdbms/lib make -f ins_rdbms.mk dnfs_on REMARK: In versions before 11gR2/12c the following manual steps were necessary: cd $ORACLE_HOME/lib mv libodm11.so libodm11.so_stub ln –s libnfsodm11.so libodm11.so In the context of make-commands, somebody in the audience asked the question how Oracle persistently stores the current link options, so that a future relink…

Read More