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

ORA-01017 : invalid username/password Using Database Link

Let’s start a post with the steps which use for the solve ORA-01017: invalid username/password; logon denied (Using Database Link)  Create a database link with the wrong password

Test the DB link

Reason: Case sensitive login enabled in the target database. Check-in target database:

How to fix: Drop and recreate the database link […]

Read More

ORA-16000

Let’s have a look at the steps used for the error ORA-16000 ORA-16000: database open for read-only access

If we got the above output then your database is physical standby which is READ ONLY mode. You can only select when the database is in Read only mode. If you want to do any changes […]

Read More

ORA-00031: session marked for kill

Let’s have look on the steps used to solve the error Error(ORA-00031: session marked for the kill) Let’s have look on the steps Phase – 1 Find out thread id that needed to be killed from OS level

If you know the user detail you can filter the query.

Output:

Phase-2  Kill […]

Read More

RMAN Parallel Backup

Let’s have look on the commands are used for “RMAN Parallel Backup”. Run the backup

Create more allocate channel

Set the parallelism parameter and run the backup again

Thought of the day.. “You will get all you want in life if you help enough other people get what they want.” — Zig […]

Read More