This article can guide you to alter the DBID for Oracle databases whenever we are in need of it. Here we will use DBNEWID utility to change the same. Below are the steps to follow. Steps to Change the DBID for Oracle Database Before starting the process of changing the DBID please ensure you have […]
Problem Description While restoring from an RMAN backup it’s failing with the following error. RMAN-06100: no channel to restore a backup or copy of datafile Example : – Connect target / RMAN> restore database; RMAN-03002: failure of restore command at 01/23/2022 12:29:17 RMAN-06026: some targets not found – aborting restore RMAN-06100: no channel to restore
This article will cover step by step Oracle 19C installation on Linux / Red Hat Enterprise Linux Server release 7.9. Before starting of the process you need to download the oracle 19.3 binary OTN: Oracle Database 19c (19.3) Software (64-bit) Oracle 19C Installation Prerequisites There are two options for completion of basic prerequisites. Automatic Setup Manual Setup
The error “ora-00980 synonym translation is no longer valid” received for a materialized view in one database. Through this article we will try to resolve the issue. Reason | Cause There can be two reasons either the user doesn’t have the required privilege or the object it’s referring to doesn’t exist. In our case, we
ORA-00980: Synonym Translation Is No Longer Valid Read More »
Oracle database is having of one or more logical storage units called tablespaces, which collectively store all of the database’s data. Every tablespace at Oracle database having one or more files called datafiles, which can be find at the operating system in which Oracle is running. This article will guide you for managing tablespaces with
Managing Tablespaces | Tablespace Administration Read More »
Tablespace management in an Oracle database is very much needed and something a DBA needs to do act on it very frequently. It’s DBA job to maintain enough space in the tablespaces in order to have smooth functioning of application and database. This tablespace query can be very helpful when you are trying to understand
Tablespace Utilization in Oracle | How to Check Oracle Database Tablespace Utilization Read More »
OPatch failed with following error. Prerequisite check “CheckSystemCommandAvailable” failed. The details are: Missing command :fuser UtilSession failed: Prerequisite check “CheckSystemCommandAvailable” failed. Error Description Oracle Interim Patch Installer version 12.2.0.1.27 Copyright (c) 2022, Oracle Corporation. All rights reserved. Oracle Home: /d01/oracle/product/19.13.0/dbhome_1 Central Inventory : /home/oracle/oraInventory from: /d01/oracle/product/19.13.0/dbhome_1/oraInst.loc OPatch version: 12.2.0.1.27 OUI version: 12.2.0.7.0 Log file
The DBMS_DST package was proposed to streamline the process of upgrading the database time zone file, along with the time zone data based on new time zone file. Problems Countries sometimes change their time zones, or alter the way they handle daylight saving time (DST). From Oracle 11gR2 onward, new time zone files are shipped
Upgrade the Database Time Zone File Using the DBMS_DST Package | ORA-56920 Read More »
This document will guide you for a step by step Oracle 19C RAC installation with ASM on a Linux platform. Each and every step is discussed here. We will RAC installation with ASM and version upgrade. Steps to Follow – Server Configuration Configure Oracle ASM Precheck for RAC setup Install GRID Infrastructure for RAC Install Oracle
Step By Step Guide To Install Oracle 19C RAC With ASM & Version Upgrade Read More »
Perform the below Manual Setup to complete the basic prerequisites Disabling Firewall: service iptables stop chkconfig iptables off Add or amend the following lines to the “/etc/sysctl.conf” file: fs.file-max = 6815744 kernel.sem = 250 32000 100 128 kernel.shmmni = 4096 kernel.panic_on_oops = 1 net.core.rmem_default = 262144 net.core.rmem_max = 4194304 net.core.wmem_default = 262144 net.core.wmem_max = 1048576
