In Oracle, the “startup” command is used to start the Oracle Database instance after it has been shut down. There are different types of oracle database startup modes available, depending on the situation and the level of recovery required. Here are the common types of startup in Oracle: This is the standard way to start…
Month: July 2023
Oracle Database Shutdown Modes
In Oracle, a “shutdown” refers to the process of stopping the Oracle Database instance. There are several types of shutdowns available, depending on the purpose and the level of activity in the database. Here are the common types of shutdowns in Oracle: 1. Shutdown Normal This is the regular and graceful way to shut down…
Add or Create A New ASM Disk
Adding or creating a new ASM (Automatic Storage Management) disk involves several steps. ASM is a feature of Oracle Database that manages database files and provides striping and mirroring for better performance and redundancy. Here’s a general outline of the process to add or create a new ASM disk: 1. Identify the Disk First, identify…
Speeding Up Windows OS: 7,8,10 and 11
Speeding up Windows OS involves optimizing system performance, reducing startup times, and improving overall responsiveness. Here are some tips and optimizations that can help enhance the performance of your Windows PC: Remember to back up your important data before making significant changes to your windows OS system. Additionally, the effectiveness of these tips may vary…
Primary & Standby SYNC Check
In Oracle Data Guard, you can check whether the standby database is in sync with the primary database by monitoring the apply lag. The apply lag represents the time delay between when a redo log is generated on the primary database and when it is applied on the standby database. A zero or low apply…
Chmod & Chown command in Linux
Chmod command & Chown command are two essential commands in Linux used to manage file and directory permissions and change file ownership, respectively. 1. Chmod (Change Mode) The chmod command is used to change the permissions (read, write, execute) of files and directories. It allows you to control who can access and modify them. File…
Linux Permissions for Files & Directory
In Linux file & directory permissions are crucial for maintaining security and controlling access to files and directories. Linux uses a permission system based on three levels of access: read (r), write (w), and execute (x). These permissions are defined separately for three types of users: the file owner, the group associated with the file,…
Oracle Data Guard
Oracle Data Guard is a high-availability solution provided by Oracle Corporation to enhance the resilience and availability of Oracle databases. It enables the creation, maintenance, and monitoring of one or more standby databases that can be used for disaster recovery, reporting, or backup purposes. The primary database (also known as the production database) is kept…
Linux Basics: Essential Commands and Usage
Linux is a powerful and widely used operating system with a command-line interface that allows users to interact with the system using text commands. Here are some basic Linux commands and their usage: Linux commands and usage: These are just a few of the basic Linux commands. Linux provides a rich set of commands and…
Oracle Architecture
Introduction Oracle, one of the world’s leading database management systems, serves as the backbone of countless enterprise applications and systems. With its robust architecture, oracle helps organizations to handle massive amounts of data while ensuring data security, integrity, and availability. In this blog, we will embark on a journey to explore the intricate details of…