Python

Uncategorized

How to clear MongoDB Administration certification?

What will this article cover? This article will focus on why you should consider attending a free MongoDB University course, why I did, and why you should think about getting your MongoDB certification in 2023/2024. Tips for new DBAs with the certification exam: 1. Attend MongoDB University: It’s useful for beginners and for expert DBAs…

DB2

DB2 Q && A -2

Is taking a backup of an active transaction directory the best way to go?Ideally it is not required. Instead, we can use the mirror log path, which is detailed below. If we set the value of the mirrorlogpath configuration parameter, the Db2 database system creates active log files in both the log path and the mirror log path. All…

DB2

DB2 Q && A : 1

Q : There is a database called “A” and transaction log file size is 200 MB and transactions are getting committed slowly to fill up the transaction log and assume one log per hour . Now scenario, incremental backup is completed on day at 9 a.m., with the next transaction log generated and committed at…

Oracle commands

1.Oracle Basic commands

To start the database in NOMOUNT state SQL>STARTUP NOMOUNT; To start the database in MOUNT state SQL>STARTUP MOUNT; To start the database in OPEN state SQL>STARTUP OPEN; To MOUNT the database that’s in NOMOUNT state SQL> ALTER DATABASE MOUNT; To OPEN the database that’s in MOUNT state SQL> ALTER DATABASE OPEN; To verify the open…

Devops

Oracle Automation-Creating Oracle 12c Database Using Ansible Tool

Description:- In this article we are going to see Oracle Automation-Oracle Database Creation Using Ansible Tool Let’s start the Demo:- Steps to create Oracle database using Ansible :- Step 1:- Download the ansible modules from  github site.Click Here Step 2:-Move the ZIP file to ansible server. [root@ansible SrikanthMac]# unzip ansible-oracle-master.zip Archive: ansible-oracle-master.zip 1bbb35d690c102e23488537754ff8d1e0a99dc15 creating: ansible-oracle-master/ [root@ansible SrikanthMac]# ls…