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 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 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…
Deep technical terms difference B/W Oracle and DB2
ORACLE DB2 Instance Instance Database Database
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…
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…
How Devops Ansible Helps for Oracle DBA’s ???
Oracle Database Automation using Ansible Tool Installation and Configuration of Ansible Oracle Automation-Create a DBA User Using Ansible Tool Oracle Automation-Creating Oracle 12c Database Using Ansible Tool Oracle Automation-Applying PSU patch in Oracle 12c Database Using Ansible Tool New generation of IT Automation tools Ansible Salt Puppet Chef How these tools works ? What can…
Installation and Configuration of Ansible
Introduction to Ansible :- Ansible is an agent-less IT automation tool developed in 2012 by Michael DeHaan, a former Red Hat associate. The Ansible design goals are : minimal, consistent, secure, highly reliable, and easy to learn.Ansible is Written on Python language.It also available as Open Source. Why to use Ansible as automation tool ? There are many other…
Session – 16 (Time and Calendar)
Date & Time Time Tuple Time Functions (1/2) 1.Date & Time Date Time Calendar import time import calendar 2.Time Tuple 0 : tm_year YYYY ☼ _ _ _ _ 1 : tm_mon MM ☼ 1 → 12 2 : tm_mday DD ☼ 1 → 31 3 : tm_hour Hr ☼ 0 → 23 4 :…
Session – 15 (Sets)
Sets Sets Operations Sets Functions Sets Methods 1.Sets Collection of elements Unordered Unique – No Dup.. Ele.. (wihtin same Set) Immutable – No Modification Non-indexed Non-sliceable As a whole mutable { . , . , .} Built-in Func.. set ( int, float, char, str, list, tuple, dictionary) 2.Sets Operations Union : ← Sx_U_Sy_ele’s Intersection :…
Something went wrong. Please refresh the page and/or try again.
DayDreamsDatabases 