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: Wed Nov 02 15:35:48 2017 ALTER DATABASE RECOVER  managed standby database disconnect using current logfile Attempt to start background Managed Standby Recovery process (STDB5_DG) […]

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 . [root@oraclehelpdbms2 ~]# /opt/grid/product/11.2.0.3/bin/crsctl start has CLSU-00100: Operating System function: opendir failed with error data: 2 CLSU-00101: Operating System error message: No such file or directory CLSU-00103: error location: scrsearch1 […]

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” RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03009: failure of backup command on t1 channel at 12/04/2018 06:01:10 […]

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 Tue May 30 13:48:49 2018 alter database activate standby database ALTER DATABASE ACTIVATE [PHYSICAL] STANDBY DATABASE (testdb3) […]

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”. run{ allocate channel prmy1 type disk; allocate channel prmy2 type disk; allocate auxiliary channel stby type disk; duplicate target database for standby from active database spfile parameter_value_convert ‘oraclehelpdb01′,’oraclehelpdb02′ set db_name=’oraclehelpdb01′ set db_unique_name=’oraclehelpdb02′ set db_file_name_convert=’/oraclehelpdb01/’,’/oraclehelpdb02/’ set log_file_name_convert=’/oraclehelpdb01/’,’/oraclehelpdb02/’ set control_files=’+DATA’ set log_archive_max_processes=’4′ set standby_archive_dest = ‘/holding/oraclehelpdb02/standby_logs’ set log_archive_dest_1 = ‘LOCATION=/holding/oraclehelpdb02/archive_logs valid_for=(online_logfile, all_roles)’ set log_archive_dest_2 = ‘LOCATION=/holding/oraclehelpdb02/standby_logs valid_for=(standby_logfile, standby_role)’ set standby_file_management=’AUTO’ set log_archive_config=’dg_config=(oraclehelpdb01,oraclehelpdb02)’ ; […]

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.  ORA-39065: unexpected master process exception in SEND ORA-39079: unable to enqueue message RP,KUPC$C_3_20120305232114,MCP,KUPC$A_4_232736061619000,1,N ORA-06512: at “SYS.DBMS_SYS_ERROR”, line 86 […]

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” [root@oraclehelpdb2 ~]# /opt/grid/product/11.2.0.3/perl/bin/perl -I/opt/grid/product/11.2.0.3/perl/lib -I/opt/grid/product/11.2.0.3/crs/install /opt/grid/product/11.2.0.3/crs/install/roothas.pl Using configuration parameter file: /opt/grid/product/11.2.0.3/crs/install/crsconfig_params LOCAL ADD MODE Creating OCR keys for user ‘grid’, privgrp ‘oinstall’.. Operation successful. LOCAL ONLY MODE Successfully accumulated necessary OCR keys. Creating OCR keys for user ‘root’, privgrp […]

Read More