Infrastructure at your Service

dbi services BLOG

Welcome to the dbi services Blog! This IT blog focuses on database, middleware, and OS technologies such as Oracle, Microsoft SQL Server & SharePoint, EMC Documentum, MySQL, PostgreSQL, Sybase, Unix/Linux, etc. The dbi services blog represents the view of our consultants, not necessarily that of dbi services. Feel free to comment on our blog postings.

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
Mouhamadou Diaw

Migrating from oracle to postgresql with ora2pg

By | Database Administration & Monitoring | No Comments
 

 PostgreSQL is one of the most used Rdbms. In this blog we are going to talk about migrating from oracle to postgresql using ora2pg. A previous blog about this topic can be found here. After installing ora2pg tool, we will see how to configure and to run it to migrate our data. We are using an oracle 12.1 database and a postgresql 9.6.2. The server is runing on OEL 7.2 The oracle database and the…

Read More
Daniel Westermann

Save the date: Swiss PGDay 2017

By | Database Administration & Monitoring | No Comments
 

 The 30th of June is not too far away and if you want to learn more about the “World’s most advanced open source database” you should register soon. The sessions are not yet officially announced but you can expect that to happen next week. What we can say already is that we will be there and that you can expect these sessions from dbi: How to migrate data from MongoDB to Postgres with ToroDB Elking…

Read More
Pierre Sicot

Oracle 12.2 tables, indexes new features

By | Database Administration & Monitoring | No Comments
 

 The Oracle 12.2.0.1 version has some interesting new features  concerning tables or indexes. The first new feature is about the online table move. In 12.2 version Oracle offers now the possibility to move non-partitioned tables without blocking any DML operations. To realise this operation, we must use the ONLINE keyword and/or the UPDATE_INDEXES clause. If you remember, in the previous Oracle version, we encountered the classical ORA-01502 error. If you remember in version 12.1, we have…

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

Does the wal segment size matter in PostgreSQL?

By | Database Administration & Monitoring | No Comments
 

 In PostgreSQL you configure the size of the wal (write ahead log) segments when you compile from source. If you use an installer or if you use the packages provided by your OS distribution the size of the wal segments is usually 16MB. Although 16MB seems very low you don’t need to worry about that in most of the cases, it just works fine. However there are cases where you might want to adjust this,…

Read More
Franck Pachot

12cR2 RMAN> REPAIR

By | Database management | No Comments
 

 Do you know the RMAN Recovery advisor? It detects the problems, and then you: RMAN> list failure; RMAN> advise failure; RMAN> repair failure; You need to have a failure detected. You can run Health Check if it was not detected automatically (see https://blog.dbi-services.com/oracle-12c-rman-list-failure-does-not-show-any-failure-even-if-there-is-one/). In 12.2 you can run the repair directly, by specifying what you want to repair.

Read More
Franck Pachot

SecureFiles on multi-datafiles tablespaces

By | Database management | 3 Comments
 

 When we have a tablespace with multiple datafiles, we are used to seeing the datafiles filled evenly, the extents being allocated in a round-robin fashion. In the old time, we used that to maximize performance, distributing the tables to all disks. Today, we use LVM striping, maximum Inter-Policy, ASM even distribution. And we may even use bigfile tablespaces, so that we don’t care about having multiple datafiles.

Read More
David Barbarin

SQL Server 2017 AlwaysOn AGs and new read-scale architectures

By | Database Administration & Monitoring | No Comments
 

 As you probably know Microsoft announced an official name for SQL Server vNext during the last Microsoft Data Amp event on April 19 2017. It becomes officially SQL Serve 2017. In my first blog post, I wrote about SQL Server on Linux and the introduction of availability groups features. At this moment the SQL Server release version was CTP 1.3. As a reminder, with previous CTP releases, listeners were unusable because they did not persist when…

Read More
Daniel Westermann

OGG: Patch 17030189 is required on your Oracle mining database for trail format RELEASE 12.2

By | Database Administration & Monitoring | No Comments
 

 Another GoldenGate 12.2 one: Some days ago I had this in the GoldenGate error log: 2017-04-12 14:56:08 WARNING OGG-02901 Oracle GoldenGate Capture for Oracle, extimch.prm: Replication of UDT and ANYDATA from redo logs is not supported with the Oracle compatible parameter setting. Using fetch instead. 2017-04-12 14:56:08 ERROR OGG-02912 Oracle GoldenGate Capture for Oracle, extimch.prm: Patch 17030189 is required on your Oracle mining database for trail format RELEASE 12.2 or later. Seemed pretty obvious that…

Read More
Saïd Mendi
m17bannernew

Welcome to M|17, part 2

By | Database Administration & Monitoring | No Comments
 

  Welcome to the second day of the MariaDB’s first user conference On the 12th, at 09:00, started the first-ever experimental MariaDB Associate certification exam and I was glad to be among the first and participate This exam was offered free of charges to all registered attendees As I wrote over, it was really experimental because all candidates faced many problems First, as this exam was proctored, the authentification process was very, very slow, essentially…

Read More