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

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-03297: file contains used data beyond requested RESIZE value

Today we are talking about the steps we use to solve the “error ORA-03297: file contains used data beyond requested RESIZE value” Let’s have look on the steps. QUERY 1 – datafile Allocated space, free space, High Water Mark location,%Free and resizeable MB

QUERY 2 – location of segments within a data file (Provide file_id […]

Read More

ORA-00257: archiver error

Let’s have look at the post of error’s solving steps. ORA-00257: archiver error. Connect internal only, until freed Or ORA-16020: fewer destinations available than specified by LOG_ARCHIVE_MIN_SUCCEED_DEST Symptoms: A user cannot connect to the database.

Cause: The flash_recovery_are is full. To perform archiving one destination is allowed (log_archive_min_succeed_dest= 1). Solution: Check the space limit and […]

Read More