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 […]
All posts by Anuradha Mudgal
Anuradha Mudgal
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 […]
New Features in Oracle Database 20c
Force Upgraded Password File to be Case Sensitive Starting in Oracle Database 20c, the parameter to enable or disable password file case sensitivity is removed. All passwords in new password files are case-sensitive. SYSLOG Destination for Common Unified Audit Policies Certain predefined columns of unified audit records from common unified audit policies can be written […]
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 […]
Execution failed: Can’t locate Env.pm in @INC (Perl script (roothas.pl))
Being a DBA we need to focus on the execution . With execution completion is incomplete. [root@oraclehelp1 ~]# /opt/grid/product/11.2.0.3/crs/install/roothas.pl -deconfig Can’t locate Env.pm in @INC (@INC contains: /usr/local/lib64/perl5 /usr/local/share/perl5 /usr/lib64/perl5/vendor_perl /usr/share/perl5/vendor_perl /usr/lib64/perl5 /usr/share/perl5 . /opt/grid/product/11.2.0.3/crs/install) at /opt/grid/product/11.2.0.3/crs/install/crsconfig_lib.pm line 642. BEGIN failed–compilation aborted at /opt/grid/product/11.2.0.3/crs/install/crsconfig_lib.pm line 642. Compilation failed in require at /opt/grid/product/11.2.0.3/crs/install/roothas.pl line 159. BEGIN failed–compilation aborted […]
$GRID_HOME/bin/ocrconfig.bin: error while loading shared libraries: libaio.so.1:
We are going to have look on the steps which use to solve the issues “$GRID_HOME/bin/ocrconfig.bin: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory”. [root@oraclehelpdb1~]# /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 /opt/grid/product/11.2.0.3/bin/ocrconfig.bin: error while loading shared libraries: libaio.so.1: cannot open shared object file: No […]
Oracleasm configure fails with selinux enable
Let’s fix up “Oracleasm configure fails with SELinux enable” with the help of the following help. [root@ oracledb1~]# /etc/init.d/oracleasm configure Configuring the Oracle ASM library driver. This will configure the on-boot properties of the Oracle ASM library driver. The following questions will determine whether the driver is loaded on boot and what permissions it will have. […]
ORA-02291
When Insert Trigger is Disable: SQL> Insert into Employee(name,roll,department) values(‘Tom’,12123, ‘Business’); ERROR at line 1: ORA-02291: integrity constraint (FK_STUDENT_DEPARTMENT_NAME) violated – parent key not found No ORA-02067 error SQL> select sysdate from dual; SYSDATE ——————- 2013-12-20 13:00:47 In the trigger, we could catch the exception for ORA-02055 and rollback but the problem is a trigger […]
ORA-39002
Let’s have look on today’s post which is about the error that occurs during the export and import the data. Let’s have look to resolve the issue with the following steps. Take export at the schema level [oracle@hostname ~]$ expdp scott/tiger DIRECTORY=dpump_dir DUMPFILE=scott.dmp logfile=scott.log schemas=scott Export: Release 11.2.0.3.0 – Production on Wed Dec 18 10:07:55 2013 […]