Infrastructure at your Service

Oracle Archives - Blog dbi services

Daniel Westermann

You do use the Oracle Trace File Analyzer, don’t you?

By | Database Administration & Monitoring | One Comment

When you do not know what the Oracle Trace File Analyzer (tfa) is or you have heard about it but you don’t know what it is for then you probably should read this, especially when you are working in clustered Oracle environments. You know, Oracle loves to create plenty of trace files in various places (yes, this got much better with the Automatic Diagnostics Repository(ADR)). Now imagine you have a cluster and something goes wrong,…

 
Read More
Clemens Bleile

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

By | Database Administration & Monitoring, Database management | No Comments

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
Daniel Westermann

opatchauto and “java.lang.UnsatisfiedLinkError”, Topology creation failed when applying 12.1.0.2.170418 PSU

By | Database Administration & Monitoring | No Comments

Yesterday I had fun with Opatch again. We wanted to apply the latest PSU (12.1.0.2.170418) on top of a 12.1.0.2 GI without any patches applied: xxxxx@xxxxx:/disk00/app/12.1.0/grid_2_4/diagnostics/ [+ASM2] opatch lsinv Oracle Interim Patch Installer version 12.2.0.1.8 Copyright (c) 2017, Oracle Corporation. All rights reserved. Oracle Home : /disk00/app/12.1.0/grid_2_4 Central Inventory : /disk00/app/oraInventory from : /disk00/app/12.1.0/grid_2_4/oraInst.loc OPatch version : 12.2.0.1.8 OUI version : 12.1.0.2.0 Log file location : /disk00/app/12.1.0/grid_2_4/cfgtoollogs/opatch/opatch2017-05-17_15-44-20PM_1.log Lsinventory Output file location : /disk00/app/12.1.0/grid_2_4/cfgtoollogs/opatch/lsinv/lsinventory2017-05-17_15-44-20PM.txt ——————————————————————————– Local…

 
Read More
Alain Lacour

APEX Connect 2017 – Day 2

By | Development & Performance | No Comments

After the Keynote about “Oracle Application Express – Ahead of it’s time. Leading the way forward” by Joel Kallmann (Director of Software Development for APEX) and some overall presentation about Development with APEX 5.1, I decided to attend presentations on following topics oriented towards tools to make developer’s life easier: – APEX OOS Tools and helper – Useful APEX plugins – LESS is more – JavaScript Debugging and Tuning – Introduction to Oracle JET Oracle…

 
Read More
Alain Lacour

APEX Connect 2017 – Day 1

By | Development & Performance | No Comments

This year again the APEX connect conference spans over three days with mixed topics around APEX, like JavaScript, CSS, SQL and much more. After the welcome speech and the Keynote about “Reconciling APEX and the Thick Database Paradigm” by Bryn Llewellyn I decided to attend presentations on following topics: – Temporal Validity and Flashback Data Archive – Universal Theme and Custom Themes in APEX 5.1 – Using REST Services in APEX applications the nice way…

 
Read More
Franck Pachot

What is in a transportable tablespace dumpfile?

By | Database Administration & Monitoring | 2 Comments

On 31st of May in Düsseldorf, at DOAG Datenbank, I’ll talk about transportable tablespaces and pluggable databases. Both methods are transporting data physically, the difference is in the transport of the metadata, which can be more flexible when transported logically, as with TTS, but faster when transported physically with PDB. I have a lot of demos to show transportable tablespaces with RMAN, and the different cloning features available in 12cR2. If I have time I’ll…

 
Read More
Joël Cattin

Oracle 12cR2 : Optimizer Statistics Advisor

By | Database Administration & Monitoring, Database management, Development & Performance | No Comments

The Optimizer Statistics Advisor is a new Advisor in Oracle 12.2. The goal of this Advisor is to check the way you gather the statistics on your database, and depending on what is found, it will makes some recommendations on how you can improve the statistics gathering strategy in order to provide more efficient statistics to the CBO. This Advisor is also able to generate remediation scripts to apply the statistics gathering “best practices”. The…

 
Read More
Daniel Westermann

Oracle OGG JAGENT 12.2 installation for GoldenGate monitoring using the Cloud Control plugin

By | Database Administration & Monitoring | No Comments

This post is mainly for self documentation as I have to search my old notes every time I want to do this (I am faster by searching on our blog ): If you want to monitor GoldenGate with Cloud Control using the GoldenGate plugin you’ll have to install the JAGENT on the host where GoldenGate is running on and the documentation is not quite clear on what you have to do exactly (at least when…

 
Read More
Daniel Westermann

A new OGG challenge: Migrate an Oracle 8.1.7.4 instance to 10.2.0.5

By | Database Administration & Monitoring | No Comments

Yes, these beasts still exist in production: [/u01/appl/ora817]$ sqlplus /nolog SQL*Plus: Release 8.1.7.0.0 – Production on Thu Apr 27 09:54:20 2017 (c) Copyright 2000 Oracle Corporation. All rights reserved. SQL> connect / as sysdba Connected. SQL> select * from v$version; BANNER —————————————————————- Oracle8i Enterprise Edition Release 8.1.7.4.0 – Production PL/SQL Release 8.1.7.4.0 – Production CORE 8.1.7.0.0 Production TNS for Solaris: Version 8.1.7.4.0 – Production NLSRTL Version 3.4.1.0.0 – Production  

 
Read More
Franck Pachot

Listener and Virtual IP

By | Database management | No Comments

When you configure a standby database, you want the application to transparently connect to the primary database, wherever it is. That’s the role of Transparent Application Failover, but this requires configuration on the client side. If you can’t configure TAF, you can use a virtual IP address. But then the question is how to configure the listener.ora to handle connections to this VIP.  

 
Read More