Introduction In Oracle database management, ensuring the integrity and availability of control files is crucial. Multiplexing of control files is a vital step in safeguarding against potential failures. This process involves creating multiple copies of control files and storing them in separate locations, reducing the risk of data loss due to a control file failure. …
Introduction ORA-12012 error is related to Oracle Database and is part of the Oracle Job Scheduler (DBMS_SCHEDULER). It usually occurs when an automatic task or job execution encounters an issue. The error message you’re seeing, “ORA$AT_OS_OPT_SY_<number>,” is specific to the job causing the problem. During the 12c database creation process , you can see ORA-12012 …
ORA-12012: error on auto execute of job SYS.ORA$AT_OS_OPT_SY_ Read More »
Introduction In the vast realm of Linux, understanding the directory structure is to comprehending the blueprint of a city. Just as every building has its specific purpose, every directory in Linux serves a distinct role. In this blog, we’ll dive into the intricacies of the Linux directory structure, shedding light on its organization and significance. …
Introduction:Transferring files between Linux servers is a common task for system administrators and developers. One of the most efficient and secure ways to accomplish this is by using the SCP (Secure Copy Protocol) command. In this guide, we’ll walk you through the process of using SCP to transfer files from one server to another, complete …
A local YUM repository in Linux is a collection of RPM (Red Hat Package Manager) packages stored on a local server or file system. YUM (Yellowdog Updater, Modified) is a package management tool commonly used in Red Hat-based Linux distributions like CentOS, Fedora, and Red Hat Enterprise Linux. It simplifies the process of installing, updating, …
1. Download & Install Oracle Linux from the Link: https://www.oracle.com/in/virtualization/technologies/vm/downloads/virtualbox-downloads.html 2. Download any ISO file from the link: https://yum.oracle.com/oracle-linux-isos.htmlI have downloaded 6.8 version iso 3. Let’s create the Linux machine using the same ISO.Click on New for creating new virtual machine. 4. Now Put Name and create a folder naming PROD or any other name …
Install Oracle Linux 6 or any version in VM Virtual Box Read More »
In a real time, we will not take Oracle database backup manually everyday. Some of the tasks can be automated like RMAN backups. In this post, we will see how to automate RMAN backup using shellscript and I personally use shellscript for import/export, rman backup and for monitoring alerts. • Create Backup directory• Create RMAN …
In the context of Oracle, FRA stands for “Flash Recovery Area.” It is a feature introduced in Oracle Database 10g that provides a centralized and automated location for managing backup and recovery-related files. The FRA simplifies the backup and recovery process by managing backup files, archived redo logs, and other recovery-related files, making it easier …
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 …
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, …
