Posted by Mir Sayeed Hassan on April 17th, 2020
One of test database is set with flashback enabled as on, But there are some flashback files are deleted so we are not able to open the database in open mode & got the below ORA-38760 error.
ORA-38760: This database instance failed to turn on flashback database
Check the status of the database
SQL> select status from V$instance;
STATUS
-------
MOUNTED
Posted in ORA-Error | Comments Off on ORA-38760: This database instance failed to turn on flashback database
Posted by Mir Sayeed Hassan on February 25th, 2020
How to Multiplex Control file on RAC DB or ASM in Oracle 11gR2 (11.2.0.4.0)
In RAC Env, If you have newly configure & created the database as 2 node RAC by default there will be single controlfile will be created, But as per the Oracle recommend there should be atleast 2 controlfile to be created.
Please find the step by step procedure to add the...
Read more..
Posted in DBA Administration | Comments Off on How to Multiplex Control file on RAC DB or ASM in Oracle 11gR2 (11.2.0.4.0)
Posted by Mir Sayeed Hassan on January 26th, 2020
ORA-00054: resource busy and acquire with NOWAIT specified
Error occur while creating a table.
SQL> create table MIR.T_TRANSACTION(C_ID VARCHAR2(255 CHAR) not null primary key);
ORA-00054: resource busy and acquire with NOWAIT specified
ORA-00054: resource busy and acquire with NOWAIT specified
9260 views Less than...
Read more..
Posted in ORA-Error | Comments Off on ORA-00054: resource busy and acquire with NOWAIT specified
Posted by Mir Sayeed Hassan on January 4th, 2020
How to Enable & Disable flashback in Oracle database 11gR2(11.2.0.4.0)
Flashback in Oracle Database
It’s a technology in Oracle database to perform restore the database to a particular point in past.
In case if you have lost the data like DML & want to retrieve, you can retrieve the rollback operation through flashback without using...
Read more..
Posted in Flashback | Comments Off on How to Enable & Disable flashback in Oracle database 11gR2(11.2.0.4.0)
Posted by Mir Sayeed Hassan on January 1st, 2020
ORA-01552: cannot use system rollback segment for non-system tablespace ‘TEMP_NEW’
I faced the above error while creating the explain plan for one of the table in database as shown below
Create an explain plan for analysing to create an index duration & size
SQL> explain plan for create index idx_tpay_recon_C_OCCURDATE...
Read more..
Posted in ORA-Error | Comments Off on ORA-01552: cannot use system rollback segment for non-system tablespace ‘TEMP_NEW’
Posted by Mir Sayeed Hassan on December 28th, 2019
Error in OEM 12C – Collection Status: [COLLECTIONS_HALTED (
UPLOAD SYSTEM Threshold (UploadMaxDiskUsedPct: 98) exceeded with 98.00302)]
Check the status of the Agent in Database
[oracle@devtest1 bin]$ ./emctl status agent
Oracle Enterprise Manager Cloud Control 12c Release 5
Copyright (c) 1996,...
Read more..
Posted in ORA-Error | Comments Off on Error in OEM 12C – Collection Status: [COLLECTIONS_HALTED ( UPLOAD SYSTEM Threshold (UploadMaxDiskUsedPct: 98) exceeded with 98.00302)]
