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.
Category: ORA-ERRORS
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) […]
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 […]
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 […]
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) […]
ORA-04021: timeout occurred while waiting to lock object %s%s%s%s%s
Cause: While waiting to lock a library object, a timeout is occurred. Action: Action depends on the root cause. Based on the cause you can choose to kill the session or wait until the other process has finished and release the lock. How to find out why an ORA-4021 error occurs: In that example I […]
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)’ ; […]
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 […]
ORA-14652: reference partitioning foreign key is not supported
Note : while creating reference partitioning table , foreign key must be not null
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 […]