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

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

Read More

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

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

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 SQL> create database link test_link connect to scott identified by tiger using ‘Test’; Test the DB link SQL> select * from dual@test_link; ORA-01017: invalid username/password; logon denied ORA-02063: preceding line from VODCMS Reason: Case sensitive login enabled in the target database. Check-in target database: […]

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 SQL>  select log_mode,open_mode , database_role from v$database; LOG_MODE             OPEN_MODE                                       DATABASE_ROLE ———————————– ————————————————————————— ARCHIVELOG         READ ONLY WITH APPLY                      PHYSICAL STANDBY If we got the above output then your database is physical standby which is […]

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 select tablespace_name, file_id, file_name DATA_FILE_NAME, Allocated_MBYTES, High_Water_Mark_MBYTES, FREE_MBYTES, trunc((FREE_MBYTES/Allocated_MBYTES)*100,2) “% Free”, trunc(Allocated_MBYTES-High_Water_Mark_MBYTES,2) Resizeble from ( […]

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. SQL> conn user/password ORA-00257: archiver error. Connect internal only, until freed. SQL> archive log all; ORA-16020: fewer destinations available than specified by LOG_ARCHIVE_MIN_SUCCEED_DEST […]

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