Infrastructure at your Service

Category

Database management

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
Jérôme Dubar

Make Oracle database simple again!

By | Database Administration & Monitoring, Database management, Development & Performance, Hardware & Storage, Operation systems, Oracle | 6 Comments

Introduction Let’s have a look at how to make Oracle database as simple as it was before. Oracle database is a great piece of software, yes it’s quite expensive, but it’s still the reference and most of the companies can find a configuration that fits their needs according to a budget. Another complain about Oracle is the complexity: nothing is really simple, and you’ll need skillful DBA(s) to deploy, manage, upgrade, troubleshoot your databases. But…

Read More
Stéphane Haby

One day training @ Microsoft Azure Cloud Workshop

By | Big Data, Cloud, Database Administration & Monitoring, Database management, SQL Server, Technology Survey | No Comments

Today, with my colleague Christophe, we follow the Microsoft Azure Training Day: Data and Analytics @ Microsoft Zürich (Wallisellen to be exact). After a presentation of SQL Server 2019, we begin with the First Lab about SQL Server 2019 and new features and we going through intelligent query processing, Data Discovery and Classification for personally identifiable information (PII) and General Data Protection Regulation (GDPR) and secure enclave. One of my favorites part of the lab…

Read More
Stéphane Haby

SQL Server Tips: Orphan database user but not so orphan…

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

Beginning of this year, it is good to clean up orphan users in SQL Server databases. Even if this practice must be done regularly throughout the year of course. 😉 During my cleaning day, a new case appears that I never had before and enjoy to share it with you. To find orphan database-users, I use this query: SELECT *FROM sys.database_principals a LEFT OUTER JOIN sys.server_principals b ON a.sid = b.sid WHERE b.sid IS NULL…

Read More
Christophe Cosme

SQL Server – Collecting last backup information in an AlwaysOn environment

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

Introduction Sometimes you face interesting challenges with unusual environment. One of my customer needed a automated and flexible backup solution. Said like that nothing very complex you will say. But if I mention that some databases were 60TB big with more than 30 filegroups and around 600 database data files each and moreover synchronized in an AlwayOn availability group, it is not the same story and you can easily imagine that working with standard backup…

Read More