Infrastructure at your Service

Category

Database management

Stéphane Haby

SQL Server Tool: MSSQL-CLI

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

MSSQL-CLI is a useful new command line tool. Not so new because this tool exist since 2018 but a little bit unknow. You find this tool on GitHub here. One of the big advantage is the number of platforms available, Windows of course but also macOS, Ubuntu, Debian, CentOs, Red Hat, OpenSuse, Suse Enterprise and Fedora. This interactive command-line query tool has many advantages like the full IntelliSense support, the auto-complete, the syntax highlighting, the…

Read More
Christophe Cosme

AWS Automation – Stop a RDS instance

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

Introduction I created a RDS SQL Server instance on AWS. I use it for test purpose and to minimize the costs I needed to ensure that my instance is stopped automatically at the end of the working day and also because on RDS instances are automatically activated when its schedule maintenance is triggered. In this article I will share the solution I implemented to achieve my goal. I assume you have already created a RDS…

Read More
Jérôme Dubar

Speed up datapump export for migrating big databases

By | Database Administration & Monitoring, Database management, Hardware & Storage, Oracle | 3 Comments

Introduction Big Oracle databases (several TB) are still tough to migrate to another version on a new server. For most of them, you’ll probably use RMAN restore or Data Guard, but datapump is always a cleaner way to migrate. With datapump, you can easily migrate to a new filesystem (ASM for example), rethink your tablespace organization, reorganize all the segments, exclude unneeded components, etc. All of these tasks in one operation. But datapump export can…

Read More
Mouhamadou Diaw

Oracle 20c Data Guard : Validating a Fast Start Failover Configuration

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

In Oracle 20c, we can now validate a Fast Start Failover configuration with the new command VALIDATE FAST_START FAILOVER. This command will help identifying issues in the configuration. I tested this new feature. The Fast Start Failover is configured and the observer is running fine as we can see below. DGMGRL> show configuration verbose Configuration – prod20 Protection Mode: MaxPerformance Members: prod20_site1 – Primary database prod20_site2 – (*) Physical standby database (*) Fast-Start Failover target…

Read More
Mouhamadou Diaw

Oracle 20c : The new PREPARE DATABASE FOR DATA GUARD

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

As you may know, Oracle 20c is in the cloud with new features. The one I have tested is the PREPARE DATABASE FOR DATA GUARD. This command configures a database for use as a primary database in a Data Guard broker configuration. Database initialization parameters are set to recommended values. Let’s see what this command will do for us The db_unique_name of the primary database is prod20 and in the Data Guard I will build,…

Read More
Jérôme Dubar

odacli create-database extremely slow on ODA X8-2 with 19.5

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

Introduction ODA X8-2, in the S, M or HA flavour, is the new database appliance from Oracle. But as a brand new product, you can experience troubles due to the lack of maturity. This time, it concerns database creation that can be extremely slow on these servers if you are using ODA 19.5. Deployment, appliance creation and core configuration X8-2 reimaging is fine, and appliance creation is done without any problem on X8-2. Don’t hesitate…

Read More

Control-M/EM – Update ctmuser & emuser DBO password

By | Control-M, Database Administration & Monitoring, Database management | No Comments

Introduction: For security purposes we sometimes must update the password of our Control M architecture. This task seems to be easy, but you must be careful to update the passwords wherever they are used. Today we will check how to update the password of our Control M infrastructure including application user and database owner for each of our databases.   Prerequisites: Be sure to have the old password to proceed easier.( not mandatory but easier…

Read More
Jérôme Dubar

Should I go for ODA 19.5 or should I wait until 19.6?

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

Introduction As you may know, Oracle Database 19c is available for new (X8-2) or older Oracle Database Appliances since several weeks. Current version is 19.5. But when you go to the official ODA documentation , it still first proposes version 18.7 not compatible with 19c databases. Here is why. 19c database is the final 12.2 First of all, 19c is an important release because it’s the terminal release of the 12.2, as 11.2.0.4 was for…

Read More
Stéphane Haby

SQL Server Tips: Path of the default trace file is null

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

In addition of my precedent blog about this subject “SQL Server Tips: Default trace enabled but no file is active…”, I add a new case where the default path of the trace file was empty. The first step was to verify if the default trace is enabled with the command: SELECT * FROM sys.configurations WHERE name=’default trace enable’ It is enabled, then I check the current running trace with the view sys.traces SELECT * FROM…

Read More