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 […]
Category: ORA-ERRORS
$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 […]
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 […]
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 […]
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: […]
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 […]
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 ( […]
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 […]
RMAN-04006: error from auxiliary database: ORA-01017: invalid username/password; logon denied
As we are living the world of technology. Each and every second we can find that n number of user name and Password are created by the user. We as best DBA of the Globe. It is our ought too to maintain all credentials in the correct manner. Let’s have look on the steps to […]
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$ […]