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 »
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.
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 »
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 »
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
Change the DBID and DBNAME for Oracle Databases Read More »
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
Step by Step Oracle 19c Installation On Linux Read More »
ORA-00257: archiver error. Connect AS SYSDBA only, until resolved. Cause: The archiver process received an error while trying to archive a redo log. If the problem is not resolved soon, the database will stop executing transactions. The most likely cause of this message is the destination device is out of space to store the redo
ORA-00257: Archiver Error Read More »
Adjusting The Password Expiration Policy / PASSWORD_LIFE_TIME Doing a default database installation will install a feature that all passwords will expire after 180 days and being unaware of that can be a serious problems in applications as they are unable to connect to the database post that time period. It will cause unnecessary downtime for the
Adjusting The Password Expiration Policy | PASSWORD_LIFE_TIME Read More »
