Infrastructure at your Service

Oracle Archives - Blog dbi services

Jul 18 2017
Clemens Bleile

Recommended DB Parameters on the Oracle Database Appliance (ODA)

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

When creating a DB on the ODA using # oakcli create database -db <db-name> a template is used to set a couple of DB parameters like e.g. _datafile_write_errors_crash_instance=FALSE _db_writer_coalesce_area_size=16777216 _disable_interface_checking=TRUE _ENABLE_NUMA_SUPPORT=FALSE _FILE_SIZE_INCREASE_INCREMENT=2143289344 _gc_policy_time=0 _gc_undo_affinity=FALSE db_block_checking=’FULL’ db_block_checksum=’FULL’ db_lost_write_protect=’TYPICAL’ filesystemio_options=’setall’ parallel_adaptive_multi_user=FALSE parallel_execution_message_size=16384 parallel_threads_per_cpu=2 use_large_pages=’ONLY’ In recent projects I saw a couple of DBs running on ODA, which did not have (all) those parameters set, because the DBs were migrated from a non-ODA-platform and the customer took over…

 
Read More
Jun 28 2017
Franck Pachot

ODA X6 installation: re-image

By | Database management | No Comments

The Oracle Database Appliance is shipped with a bare-metal installation which may not be the latest version. You may want to have it virtualized, or get the latest version to avoid further upgrade, or install an earlier version to be in the same configuration as another ODA already in production. The easiest for all cases is to start with a re-image as soon as the ODA is plugged. This post is not a documentation, just…

 
Read More
Jun 27 2017
Daniel Westermann

Summer, autumn and winter: a lot of conferences ahead

By | Database Administration & Monitoring | No Comments

It is hot in Europe, it is summer, enjoy, but technology moves fast so you have the chance to already prepare for the next conferences. The IT Tage 2017 will happen the 11th to 14th of December this year and we are happy to be there again. This event covers a wide range of topics and we will be there again covering and talking about: Stéphane Haby, SQL Server 2017: Überblick Stéphane Haby, SQL Server:…

 
Read More
May 26 2017
Daniel Westermann

Getting Solaris 8 x86 up and running in Virtual Box

By | Database Administration & Monitoring | No Comments

As this project is going to start soon and I learned that there is a x86 version of Solaris 8, today I thought it would be great if I can get a test setup up and running. First issue: Where to get the Solaris 8 distribution from. This turned out be quite easy, there is a support note which links to all the releases: Where to download Oracle Solaris ISO images and Update Releases (Doc…

 
Read More
May 25 2017
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
May 24 2017
Clemens Bleile

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

By | Database Administration & Monitoring, Database management | 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
May 18 2017
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
May 10 2017
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
May 10 2017
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