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

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 […]

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

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.

Solution:

Today’s thought “You have to believe in what you do in order to get what you want.” – Larry Ellison Thank you for giving your valuable time to read the above information. If you want to be updated with all […]

Read More

$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”.

Solution:

Thought of the day ! “When I do something, it is all about self-discovery. I want to learn and discover […]

Read More

Oracleasm configure fails with selinux enable

Let’s fix up “Oracleasm configure fails with SELinux enable” with the help  of the following help.

Check the status

Change SELINUX=disabled in /etc/sysconfig/selinux file and save it. Reboot the server.

Run getenforce to confirm that SELinux is disabled:

Retry to configure the asm driver

Thought’s of the day! “I’m addicted […]

Read More

ORA-02291

When Insert Trigger is Disable:

No ORA-02067 error

In the trigger, we could catch the exception for ORA-02055 and rollback but the problem is a trigger cannot contain a commit or rollback statement, however by using autonomous transaction we can overcome this limitation but it’s considered bad practice but it is possible. Thought […]

Read More

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

Solution: Check the directory is exists or not, If not exist then create the directory with proper […]

Read More