Debunking 10 Myths about Database Administrators! 🔥

Database administrators (DBAs) play a critical and often underappreciated role in the world of information technology. 

Agile is NOT FAST….

Agile is a widely adopted and highly effective approach to software development and project management in the IT environment. It has gained popularity for several reasons, and its principles and practices have proven to be beneficial for many organizations. 

Tracing Oracle Data Guard

 Tracing can also be enabled in dataguard using the parameter "Log_Archive_Trace"

The values can be set using DG-Broker (if configured) or at SQL prompt as below.

Feedspot - Top database blog list

Dear All,

I am pleased to inform  that I received this recognition from Feedspot and I'm proud to be part of the awesome family- Thank you Anuj and Team for this recognition!

12c Wallet creation and tablespace encryption

The following article describes the steps to create the wallet and perform a tablepsace encryption.

Datapump Errors and Solutions

   

SCOPE

The article covers common & complex error occurs during the Datapump Export and Import operations

Oracle Instance Startup Failure | Instance terminated by GEN0

  

SCOPE

Recently a server running both Oracle databases with version 11.1.0.2  had to be forced powered cycled due to a NFS issue. Since it wasn’t possible to login to the O/S to shutdown the DBs an instance recovery was required on both the 11.2 databases.

Resmgr:Cpu Quantum | Oracle wait event

 

SCOPE

Application job are running slow and DBA finds out the wait event as "Resmgr:Cpu Quantum" for multiple sessions running in database.

ASM Diskspace utilization categorized by Database/File names

SCOPE

Below script helps to identify the space utilization of Databases including the files such as Datafiles, Redologfiles, Archivelog files on ASM diskgroup categorized by Database names and their files.

ORA-12519: TNS:no appropriate service handler found (followed by ORA-00020)

SCOPE

Application complains about the error ORA-12519: TNS:no appropriate service handler found while connection to the database.

Object related scripts for Oracle

 

Open Resetlog Failure : ORA-00392: log 1 of thread 1 is being cleared, operation not allowed

SCOPE

Restoring the database using RMAN backup.

After completion of cloning to the staging environment, OPEN RESETLOGS fails with error as below.

ORA-00392: log 1 of thread 1 is being cleared, operation not allowed

ORA-20001: Job failed: ORA-01630: max # extents (4096) reached in temp segment in tablespace USERS

SCOPE

Application jobs fails with messages as below.

ORA-20001: Job failed

ORA-01630: max # extents (4096) reached in temp segment in tablespace USERS

ORA-00600: internal error code, arguments: [qcisSetPlsqlCtx:tzi init]

 Below document explains the issue faced after the upgrade, troubleshooting  and need for timezone files.

Oracle or PostgreSQL

 

At the point when you take a gander at PostgreSQL versus Prophet data set administration frameworks, the primary distinction between these two information bases is that PostgreSQL is an open-source data set, while Oracle is a shut data set framework.

Shutdown is taking forever, can only do a SHUTDOWN ABORT

We recently performed the cloning of the staging Database from a production database, but unfortunately we faced an issue.

Once the restore is complete, we were not able to stop the database to rename it and perform the post checks. 

Identifying PID/SPID for killed session in 11g

Many times when we kill a session with alter system kill session command  ( or Toad )

Uncommitted transactions in Oracle

 Lets assume that we have an update, insert or delete statement that running but has not been committed yet. So question is how to show uncommitted transactions ?

Read the sqlnet trace files

While troubleshooting sqlnet  issue a week back and we used very same article  to read trace files. It was very useful.

Open Oracle Database with Delay Option

Found an interesting event, that helps to open the database with delay option. The event db_open_begin delay (opening database with delay)  is undocumented event ( read unsupported )