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 Oracle databases, understanding how to generate DDL of tablespaces is essential for database administrators and developers. The DDL (Data Definition Language) statements allow you to recreate tablespaces in case of migration or disaster recovery scenarios. In this short blog, we’ll explore the syntax and steps to retrieve the DDL of a tablespace in …
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: In the realm of Oracle Database management, server parameter files (SPFile) and parameter files (PFile) play a crucial role in configuring and customizing database settings. These files are essential for Oracle instances to function optimally. In this blog post, we’ll dive into the differences between SPFile and PFile, explore their significance, and provide syntax …
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 …
Introduction In the world of database management, Oracle stands as one of the most robust and widely-used relational database systems. Managing user accounts efficiently is crucial for maintaining data security and integrity. In this blog post, we’ll walk you through the process of creating new users and unlocking existing ones in Oracle, complete with the …
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 »
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 …
