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” [root@oraclehelpdb2 ~]# /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 LOCAL ADD MODE Creating OCR keys for user ‘grid’, privgrp ‘oinstall’.. Operation successful. LOCAL ONLY MODE Successfully accumulated necessary OCR keys. Creating OCR keys for user ‘root’, privgrp […]

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

Oracleasm configure fails with selinux enable

Let’s fix up “Oracleasm configure fails with SELinux enable” with the help  of the following help. [root@ oracledb1~]# /etc/init.d/oracleasm configure Configuring the Oracle ASM library driver. This will configure the on-boot properties of the Oracle ASM library driver. The following questions will determine whether the driver is loaded on boot and what permissions it will have. […]

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-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 select vs.sid, vs.username, vs.osuser, vs.process fg_pid, vp.spid bg_pid from v$session vs, v$process vp where vs.paddr = vp.addr; If you know the user detail you can filter […]

Read More

RMAN Parallel Backup

Let’s have look on the commands are used for “RMAN Parallel Backup”. Run the backup RMAN> run { allocate channel c1 type disk; allocate channel c2 type disk; backup (datafile 1,2,3 channel c1) (archivelog all channel c2); } Create more allocate channel RMAN> run { allocate channel c1 type disk; allocate channel c2 type disk; […]

Read More