Infrastructure at your Service

database Archives - Blog dbi services

Marc Wagner

RMAN debugging during catalog import

By | Database management, Oracle | No Comments

In this post I would like to share how I have been able to troubleshoot and solve a catalog import issue using RMAN debug function. As we can see, the error message provided by RMAN is not very helpful. oracle@vmtestoradg1:/home/oracle/ [RCAT12C] rman catalog rcat/manager Recovery Manager: Release 12.2.0.1.0 connected to recovery catalog database RMAN> import catalog rcat/manager@RCAT11G; Starting import catalog at 05-JAN-2018 14:11:45 connected to source recovery catalog database RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE…

 
Read More
Marc Wagner

ORACLE 11g to 12c RMAN catalog migration

By | Database management, Oracle | One Comment

This is a small migration demo of a 11g catalog (RCAT11G) to a new 12c catalog (RCAT12c). Demo databases environments have been easily managed thanks to DBI DMK tool. oracle@vmreforadg01:/home/oracle/ [RCAT11G] sqh SQL*Plus: Release 11.2.0.4.0 oracle@vmtestoradg1:/home/oracle/ [RCAT12C] sqh SQL*Plus: Release 12.2.0.1.0   Current configuration Displaying the list of databases registered in the RCAT11g catalog. SQL> select instance_name from v$instance; INSTANCE_NAME —————- RCAT11G SQL> select * from rcat.rc_database;     DB_KEY  DBINC_KEY       DBID NAME     RESETLOGS_CHANGE# RESETLOGS ———-…

 
Read More
Franck Pachot

Database is more than persistence. It is shared. My thoughts about Microservice Database.

By | Oracle | 4 Comments

The development teams often see the database as a ‘persistence layer’ only. And sometimes it is mentioned that the database is always the cause of the problems, especially when implementing continuous integration and trying to be agile. Then cames the idea to have this ‘persistence layer’ in an isolated environment, such as a docker container, with the database for each developer. However, this overlooks the real cause of the problems, which is not the persistence…

 
Read More
Nicolas Jardot

How to read XML database alert log?

By | Database Administration & Monitoring | No Comments

Since Oracle 11g, Oracle maintains two copies of the database’s alertlog in ADR: a flat text file in the sub-directory trace and an XML like in the folder alert. I had a case recently at a customer where the log.xml was moved to another place and compressed for archiving reason. As the regular text file was not containing old data, the goal was to exploit the archived XML -like file. When the file is still located…

 
Read More
Daniel Westermann

Migrating the Oracle 12cR1 sample schemas to PostgreSQL Plus Advanced Server 9.4

By | Database Administration & Monitoring | No Comments

This post takes a look on how to migrate the Oracle 12cR1 sample schemas to PPAS 9.4 (PostgreSQL Plus Advanced Server 9.4). I’ll not dig into how to install PPAS as this was described in detail some time ago. Just follow this post if you need a setup guide. If you wonder why I am doing this there are two reasons: to see if it works, to have fun and to learn PostgreSQL and PPAS…

 
Read More
Stéphane Savorgnano

SQL Server 2016 CTP3.0: Stretch Database enhancements

By | Database management, Technology Survey | No Comments

Some months ago, my colleague Nathan explained you the bases of the new Stretch Database functionality via two blogs here and here. With the new SQL Server 2016 CTP 3.0, Stretch Database now includes new features and enhancements that I will sow you in this blog.   In previous versions of SQL Server 2016 CTP 2.x, before to be allowed to Enable Stretch Database, you had to enable the “Remote Data Archive” option for the…

 
Read More
Franck Pachot

Trying AppDynamix – monitoring application from user to database

By | Development & Performance, Oracle | No Comments

I like to come upon new monitoring software that help to go quickly from user response time to root cause. And I love applications that can be installed easily and at which I can give a try without reading pages of manual. At DOAG 3rd floor I’ve visited the AppDynamics booth and immediately wanted to install the trial version and give it a try.  

 
Read More
Pierre Ochsenbein

Instance fails to start automatically

By | Database Administration & Monitoring | No Comments

Recently at a customer I was confronted with a problem of restarting the Oracle Database 12c automatically on a Windows Server 2008 R2 x64. I installed Oracle 12.1.0.1.0 with a user of service in a domain who has member of the Group ORA_DBA. The authentication service is correctly set with the NTS parameter in the sqlnet.ora file. This Installation has been successfully but after a reboot we can see the database are not OPEN. oracle@********:C:\Users\oracle\…

 
Read More
David Barbarin

Don’t use the default database file autogrow settings !

By | Application integration & Middleware | No Comments

I often noticed default values for database file autogrow settings during my audits. You don’t trust me? Let me talk about a funny story about an incredible (and extreme) situation that concerns a transaction log file and its default settings. First of all, during my intervention, my customer complained of some performance issues, so I decided to take a look at different areas of its instance. I found some interesting records inside the SQL Server…

 
Read More