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)]
Posted by Mir Sayeed Hassan on October 26th, 2019
Upgrade Oracle Database 11gR2 (11.2.0.4) to 12c (12.2.0.1) using DBUA
DB Environment:
Hostname : testdb
Database Name : testdb.com
Source DB Version : 11.2.0.4.0
Source DB home location : /u01/app/oracle/product/11.2.0/dbhome_1/
Target...
Read more..
Posted in UPGRADATION | Comments Off on Upgrade Oracle Database 11gR2 (11.2.0.4) to 12c (12.2.0.1) using DBUA
Posted by Mir Sayeed Hassan on October 26th, 2019
How to Install the Oracle 12C software only on Oracle Linux 6.7
Download the Oracle Linux 12c software & extract it on Oracle 12c home directory (/u01/app/oracle/product/12.2.0.1/dbhome_1/) & Install the software only.
Fallow the below step by step process to install the oracle 12c software only
Transfer the software...
Read more..
Posted in DB Install & Create | Comments Off on How to Install the Oracle 12C software only on Oracle Linux 6.7
Posted by Mir Sayeed Hassan on October 21st, 2019
Upgrade Oracle Database 11gR2 (11.2.0.4) to 12c (12.2.0.1) using MANUAL
Server Environment
Hostname : testdb
Database Name : testdb.localdomain
Source DB Version : 11.2.0.4.0
Source DB home location : /u01/app/oracle/product/11.2.0/dbhome_1/
Target...
Read more..
Posted in UPGRADATION | Comments Off on Upgrade Oracle Database 11gR2 (11.2.0.4) to 12c (12.2.0.1) using MANUAL
Posted by Mir Sayeed Hassan on October 20th, 2019
How to Recover Loss of data without a Backup in Oracle database 11gR2 (11.2.0.4)
This scenario is considering as we don’t have any of database backup like RMAN, Restore point, Flashback, Recyclebin, Therefore we can recover only the DML Operation data loss
In our case the user is accidentally deleted the records from table & committed, but we...
Read more..
Posted in DBA Administration | Comments Off on How to Recover Loss of data without a Backup in Oracle database 11gR2 (11.2.0.4)
