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.


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


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

Read More


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


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


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

ORA-00600 [qosdExpStatRead: expcnt mismatch]

Recently started seeing this error on few of the Exadata environments. ORA–00600: internal error code, arguments:[qosdExpStatRead: expcnt mismatch] Cause  This is due to sys.exp_obj$. EXP_CNT mismatch rows of sys.exp_stat$ Following SQL is used to check issue data of some objects. if there are some rows return, that means data issue. With b as ( select count(*) cnt,objn,snapshot_id from sys.exp_stat$ […]

Read More