Oracle Data Pump – New Diagnostic V$ Views For Performance Issues in 23ai
Oracle 23c AI introduces new V$ views to diagnose Data Pump performance issues. These views help monitor and troubleshoot Data Pump activities by providing detailed insights into job execution, resource usage, and potential bottlenecks. Key V$ Views: These views enable administrators to efficiently manage and optimize Data Pump tasks. The outputs will be needed, along […]
Postgres dB Installation in Linux
Red Hat Enterprise Linux 8 Step 1: Set up the EDB repository To determine if your repository exists, enter this command: If no output is generated, the repository isn’t installed. To set up the EDB repository: Install the EPEL repository: Enable additional repositories to resolve dependencies: Disable the built-in PostgreSQL module: Install the package Where <xx> is […]
NetworkManager tool in Linux
NetworkManager is a utility in Linux that simplifies the management of network connections and devices. It provides both command-line and graphical interfaces for configuring and controlling network settings. Two of the key tools associated with NetworkManager are nmtui and nmcli. 1. NetworkManager (nmcli): 2. NetworkManager TUI (nmtui): 3. Advantages of NetworkManager, nmtui, and nmcli:
CentOS 7 to Oracle Linux 8
CentOS 7 and Oracle Linux 8 are both popular Linux distributions that serve different purposes within the open-source community. CentOS 7: 1. Origin and Community-driven: Oracle Linux 8: Origin and Enterprise Focus: Transition from CentOS 7 to Oracle Linux 8: This guide explains how to combine a software upgrade and migration into a single process, […]
Basic SRVCTL Commands
SRVCTL, short for Server Control Utility, is a command-line tool, used to manage various entities in an Oracle Cluster environment, including databases, instances, listeners, services, and more. It allows you to perform various tasks like starting, stopping, modifying. Common Basic SRVCTL Commands: Start a database instance: SYNTAX – srvctl start database -d db_name [-o start_options] start_option – […]
Manual Oracle Database Grid Patching
As the database home owner execute: Run the pre root script (As Root User) Patch GI home. As the GI home owner execute: Patch DB home (As the database home owner execute:) Run the post script. As the root user execute:
Login from Non-Oracle User Run SQL*Plus
In Linux or Unix platform, installed SQL*Plus in database server can be executed by anyone. We just need to make the tnsnames.ora file readable by others. TNSNAMES Readable After this just login to the user you want to login the database and set the environment by .oraenv and providing the SID.
Oracle Database Patching
Oracle Database 19c standalone patching involves applying patches and updates to an existing Oracle Database 19c installation that is not part of an Oracle Real Application Clusters (RAC) configuration. High-Level steps for applying the patching Check current version of Opatch Tool Move the current OPatch tool as backup unzip the new OPatch tool to the […]