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…
Month: August 2023
Oracle Users Create & Unlock
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 necessary…
Creating/Dropping an Undo Tablespace in Oracle Database
Introduction: In the realm of Oracle databases, managing storage and maintaining data integrity are crucial tasks. The Undo tablespace plays a pivotal role in maintaining transaction consistency and enabling data rollback. This SEO-friendly blog post will guide you through the process of creating and dropping an Undo tablespace in an Oracle database, complete with syntax…
Creating a New User in Oracle Database
Are you new to Oracle Database and looking to learn how to create a new user? In this guide, we’ll walk you through the process of creating a new user in Oracle Database using the appropriate syntax. Creating a new user is an essential skill for database administrators and developers, so let’s get started! Step…
Enable Archive Log Mode in Oracle 12c and Above
Introduction: Enable Archive Log Mode in Oracle 12c and above is a crucial step to ensure data integrity, disaster recovery, and point-in-time recovery capabilities for your database. In this comprehensive guide, we’ll walk you through the process of enabling Archive Log Mode in Oracle 12c and above, providing step-by-step instructions and valuable insights to help…
Create Local Yum Repository In Linux From ISO
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,…
Install Oracle Linux 6 or any version in VM Virtual Box
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…
Clean Temp and Junk Files from Windows
To clean temp and junk files from Windows, you can use the built-in Disk Cleanup tool and manually deleting temporary files. It helps you remove various unnecessary files, including temporary files, system cache, old Windows updates, and more. Here’s how you can do it: 1. Cleaning Temp & Prefetch Files Press the Windows key +…
Create a User Account in Windows
Create a separate user account for each employee in Windows 10 lets each person adjust his or her individual profile settings. To create a new user account in Windows 10, follow these six steps. 1. Right-click the Windows Start menu button 2. Select Control Panel 3. Select User Accounts 4. Select Manage another account 5. Select Add a new user in…
RMAN Backup using ShellScript
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…