Infrastructure at your Service

Tag

DBA Archives - Page 2 of 6 - Blog dbi services

Oracle Team

Control File issues on duplicating with non patched Oracle version.

By | Database Administration & Monitoring, Oracle | No Comments

Introduction : RMAN has the ability to duplicate, or clone, a database from a backup or from an active database. It is possible to create a duplicate database on a remote server with the same file structure, or on a remote server with a different file structure or on the local server with a different file structure. For some old and  non patched Oracle versions such as that earlier than 11.2.0.4 , the duplicate (from…

Read More
Marc Wagner

Dbvisit Standby Archive Log Daemon

By | Database Administration & Monitoring, Oracle | No Comments

Dbvisit Standby version 8 comes with a nice feature, a daemon, which gives the benefit to send and apply the archive log automatically in the background. Bypassing the system scheduling, the daemon will facilitate customer RPO (Recovery Point Objective) and RTO (Recovery Time Objective) fine tuning. Monitoring to apply logs to the Standby only when needed, will also optimize use of resources. Originally available for the Linux based environments, the feature has been made available…

Read More
David Hueber

ODA 12.2.1.2.0: Some curious password management rules

By | Database Administration & Monitoring, Hardware & Storage | One Comment

While deploying an ODA based on the DCS stack (odacli), it is mandatory to provide a “master” password at appliance creation. The web GUI provides for that a small tooltip which describes the rules applied on password management. However it looks like there is some flexibility with those rules. Lets try to check this out with some basics tests.

Read More
David Hueber

ODA X7-2S/M 12.2.1.2.0: update-repository fails after re-image

By | Database Administration & Monitoring, Hardware & Storage | 5 Comments

While playing with a brand new ODA X7-2M, I faced a strange behaviour after re-imaging the ODA with the latest version 12.2.1.2.0. Basically after re-imaging and doing the configure-firstnet the next step is to import the GI clone in the repository before creating the appliance. Unfortunately this command fails with an error DCS-10001:Internal error encountered: Fail to start hand shake to localhost:7070. Why not having a look on how to fix it…

Read More
David Hueber

ODA 12.2.1.2.0 – VLAN Management

By | Database Administration & Monitoring | 2 Comments

Virtual Local Area Network (VLAN) have become since several years a standard in enterprise class networks. Most enterprises are now segregating their network, especially for security reasons, between server and user or prod and test or applications and backup and aso. In the new release of ODA we finally get the support for VLAN on the bare metal platform. This article will briefly demonstrate how these are managed using ODAADMCLI.

Read More
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. [email protected]:/home/oracle/ [RCAT12C] rman catalog rcat/manager Recovery Manager: Release 12.2.0.1.0 connected to recovery catalog database RMAN> import catalog rcat/[email protected]; 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 | 2 Comments

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. [email protected]:/home/oracle/ [RCAT11G] sqh SQL*Plus: Release 11.2.0.4.0 [email protected]:/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

Am I a DBA 3.0 or just an SQL*DBA?

By | Oracle | 2 Comments

By Franck Pachot . There are currently a lot of new buzz words and re-namings which suggest that our DBA role is changing, most of them escorted with a #cloud hashtag. Oracle Technology Network is now called Oracle Developer Community. Larry Ellison announced the database that does not need to be operated by humans. And people talking about the death of DBA, about the future of DBA, about DBA 3.0,… Those are all generalizations and…

Read More
Saïd Mendi

MySQL 8.0.0 DMR – First impression

By | Database management | One Comment

Last week (09/12/2016) was announced the new MySQL 8.0.0 DMR (Development Milestone Release) It is now available for download at dev.mysql.com I downloaded and installed it Following are my first impression on some new features First of all, when you remember the size of earlier versions, it is more & more gluttonous, see below mysql-5.0.96-linux-x86_64-glibc23.tar.gz    121.2M mysql-5.1.72-linux-x86_64-glibc23.tar.gz    127.8M mysql-5.5.52-linux2.6-x86_64.tar.gz            177.2M mysql-5.6.33-linux-glibc2.5-x86_64.tar.gz    299.7M mysql-5.7.15-linux-glibc2.5-x86_64.tar.gz   611.8M mysql-8.0.0-dmr-linux-glibc2.12-x86_64.tar.gz is around 1Gb and uncompressed 3.6Gb (Oups…) At…

Read More