Session in killed state

Sometimes you see sessions does not wipe out immediately or you see “marked for kill” message and they stays in killed state. You can kill them using below query.

Read More

Background Media Recovery terminated with ORA-1274 after adding a Datafile

Today lt’s have a tour towards the steps which we are going to solve the issue regards “Background Media Recovery terminated with ORA-1274 after adding a Datafile“ Symptoms in alert.log file:

Trace file:

Cause: This Error occurs if we add a Datafile OR Tablespace in PRIMARY Database and that could not be translated […]

Read More

crsctl Error: CLSU-00100 CLSU-00101 CLSU-00103 CLSU-00104

Today we are going to work on the error of oracle “crsctl Error: CLSU-00100 CLSU-00101 CLSU-00103 CLSU-00104” .  Let’s have a look on the steps .

Cause: Hostname was changed, in this case it was changed to localhost Solution: Option 1:

Option 2:

Oracle Support Doc ID 1551791.1 Thank […]

Read More

ORA-19511: Error received from media manager layer

Today we are going to have a look on the steps which we use to resolve the issue “ORA-19511: Error received from media manager layer, error text: ANS1017E (RC-50) Session rejected: TCP/IP connection failure”

Solution: In this case TSM(Tivoli Storage Manager) died due to paging space. After started it again by Server responsible people […]

Read More

ORA-16014: log X sequence# XXX not archived in Standby

Today we are going to have a look on the steps which are used by DBA’s to resolve issue “ORA-16014: log X sequence# XXX not archived, no available destinations (In Standby Database)”. Problem: In the alert log file

Cause : In this case the problem was log_archive_dest_2 was set incorrectly.

Solution :

Please check […]

Read More

ORA-17502: ksfdcre:4 Failed to create file +DATA during Physical Standby creation using RMAN

We are going to follow some steps to solve the “ORA-17502: ksfdcre:4 Failed to create file +DATA during Physical Standby creation using RMAN”.

Solution: In my case when I checked the permission of $ORACLE_HOME and $GRID_HOME and the permission was incorrect which caused the problem. After fixing the permission it works fine.

The […]

Read More

EXPDP Failed with ORA-39065, ORA-39079, ORA-06512, ORA-06512, ORA-24033

Today we are going to have a look on the steps which we use to resolve the issue “EXPDP Failed with ORA-39065, ORA-39079, ORA-06512, ORA-06512, ORA-24033” ERROR : Error Description: IMPDP fails or terminate with following errors.

Solution : Remove the parallel clause from datapump expdp/impdp and retry the job. If that does not […]

Read More

OCR create keys failed for root with OCR error 27

Let’s have look on the steps which we use to solve the issue “OCR create keys failed for root with OCR error 27”

Cause: An asmadmin group is missing in grid user

Solution:

Rerun the roothas.pl

Today’s thought “Never complain, never explain. Resist the temptation to defend yourself or make excuses”. […]

Read More