ASM Instance cloning using RMAN in same host
Description: In this article step by step Cloning the asm instance in same host.Earlier we use to clone database using rman backup. After adding the database service entry and restore…
Read MoreHow to fix INVALID status for RAC component in dba_registry
Before upgrade or after upgrade, database may show INVALID status for component Real Application Clusters in dba_registry as below . SQL> select comp_name,version,status from dba_registry; … Oracle Real Application…
Read MoreKinsing (kdevtmpfsi and dbused) malware in linux impacting oracle
Introduction: Do you know there is malware in Linux that impacts your Oracle Database and Oracle Applications environment? This malware impacting critical Linux/Oracle systems is by Kinsing. The Malware’s primary…
Read MoreHOW TO RESOLVE THE ORA-01092: ORACLE instance terminated. Disconnection forced ORA-00704: bootstrap process failure ORA-39700: database must be opened with UPGRADE option
In this tutorial, we are going to learn about, “How to resolve these ORA ERRORS: ORA-01092, ORA-00704 and ORA-39700”. I got the below type of error while startup the database.…
Read MoreORA-65114: space usage in container is too high
ORA-65114: space usage in container is too high While an import for a pluggable database and it ran out of space so I tried to resize one of the datafile…
Read MoreScript to Detecting Unindexed Foreign Keys
SELECT table_name, constraint_name, cname1 || Nvl2(cname2,’,’ ||cname2,NULL) ||Nvl2(cname3,’,’ ||cname3,NULL) || Nvl2(cname4,’,’ ||cname4,NULL) ||Nvl2(cname5,’,’ ||cname5,NULL) || Nvl2(cname6,’,’ ||cname6,NULL) ||Nvl2(cname7,’,’ ||cname7,NULL) || Nvl2(cname8,’,’ ||cname8,NULL) columns from ( SELECT b.table_name, b.constraint_name, max(decode( position,…
Read MoreORA-01516: nonexistent log file, data file, or temporary file container in stand by Database
ORA-01516: nonexistent log file, data file, or temporary file container in stand by Database: ============================================================================================= ERROR at line 1: ORA-01511: error in renaming log/data files ORA-01516: nonexistent log file, data…
Read MoreInstalling Oracle 18c XE on Windows
This blog talks about How to Install Oracle Database 18c XE on Windows OS and Connect the database using SQL Plus and SQL Developer. It will help the developer to…
Read MoreHow to Create the boot.properties in IDCS Asserter
Problem: When you are running the weblogic in production mode and when you try to start the weblogic using nohup then there is no chance to enter the username and…
Read MoreHow to Change APEX admin password using SQL
Steps to change APEX admin password using SQL, 1. Change the current schema to the one relevant for your APEX version ALTER SESSION SET CURRENT_SCHEMA = APEX_050000; 2. Find the…
Read More