Database Analyser

SQL Query To Find The Space Utilization of Tablespaces In Oracle

In Oracle database, a tablespace is a logical storage container that is used to store data objects, such as tables, indexes, and partitions. It is a way to organize and manage the physical disk space used by the database. Each tablespace consists of one or more data files, which are the actual physical files on […]

SQL Query To Find The Space Utilization of Tablespaces In Oracle Read More »

Modification of SCAN Configuration in Oracle 19c RAC | How To Modify Scan Name In Oracle RAC

This article will discuss how to modify the SCAN name in Oracle RAC. There are situations when changing the SCAN name is necessary due to application requirements or migration/upgradation. Recently we came across such a situation where it’s necessary to change the SCAN name and below are the steps followed for modification of SCAN configuration.

Modification of SCAN Configuration in Oracle 19c RAC | How To Modify Scan Name In Oracle RAC Read More »

ORA-10873: file 1 needs to be either taken out of backup mode or media recovered

This article is about ORA-10873: file 1 needs to be either taken out of backup mode or media recovered. Cause This is may be due to database went down while database is in backup mode. Error in the alert log Errors in file F:ORACLEPRODUCTDIAGdiagrdbmsbwdbbwdbtracebwdb_ora_1268.trc: ORA-10873: file 1 needs to be either taken out of backup

ORA-10873: file 1 needs to be either taken out of backup mode or media recovered Read More »

How To Drop A Database In Oracle | How To Drop Oracle Database Manually

Through this article, we will learn to drop a whole database in Oracle manually with commands.  We can also use the DBCA utility to drop a whole database but this is not in scope for today’s discussion. Steps to follow for dropping a database Please follow the below steps to drop a database successfully.  Please

How To Drop A Database In Oracle | How To Drop Oracle Database Manually Read More »

CRS-6706 | CRS-4000 | Oracle Clusterware Release patch level (‘3051579437’) does not match Software patch level (‘3007461856’). Oracle Clusterware cannot be started.

This is the most common error we can get after operating system (OS) patching and during start of our cluster services. Steps to Recover the Error We need to follow the below steps to rectify the error and start the cluster services.                       

CRS-6706 | CRS-4000 | Oracle Clusterware Release patch level (‘3051579437’) does not match Software patch level (‘3007461856’). Oracle Clusterware cannot be started. Read More »

How to modify SCAN Listener port number

If we want to change the port of the scan listener we can do it through the below-mentioned steps. We will change it from default 1521 to 1531. Checking present configuration $ srvctl config scan_listener SCAN Listeners for network 1: Registration invited nodes: Registration invited subnets: Endpoints: TCP:1521 SCAN Listener LISTENER_SCAN1 exists SCAN Listener is

How to modify SCAN Listener port number Read More »

PL/SQL package SYS.DBMS_BACKUP_RESTORE Version is Not Current | PL/SQL package SYS.DBMS_RCVMAN version in TARGET database is not current

Post applying the database patch sometimes you may get below error in the alert log or RMAN prompt. PL/SQL package SYS.DBMS_BACKUP_RESTORE version 19.05.00.00 in TARGET database is not currentPL/SQL package SYS.DBMS_RCVMAN version 19.05.00.00 in TARGET database is not current Recent Changes The above-mentioned errors were reported post applying the database patch. Cause Might be that these

PL/SQL package SYS.DBMS_BACKUP_RESTORE Version is Not Current | PL/SQL package SYS.DBMS_RCVMAN version in TARGET database is not current Read More »

Rolling Forward Physical Standby Database Using Recover From Service Command

From 12C onwards Oracle has introduced a new way of rolling forward a physical standby database by using recover from service commands. There could be a scenario where we need to roll forward a standby database from an archive log gap where the standby lags behind the primary. Our aim is to remain the standby

Rolling Forward Physical Standby Database Using Recover From Service Command Read More »

Temp Tablespace Usage in Oracle

Below queries can be helpful to find details regarding temp tablespace usage. Temp segment usage per session SELECT   S.sid || ‘,’ || S.serial# sid_serial, S.username, S.osuser, P.spid, S.module, P.program, SUM (T.blocks) * TBS.block_size / 1024 / 1024 mb_used, T.tablespace, COUNT(*) statements FROM v$sort_usage T, v$session S, dba_tablespaces TBS, v$process P WHERE T.session_addr = S.saddr AND

Temp Tablespace Usage in Oracle Read More »