Posted by Mir Sayeed Hassan on 1st January 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 28th December 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 13th May 2019
Oracle RAC Database fails to start with error ORA-12547/ORA-17503/CRS-5017/CRS-2674 The below error occur while startup of the RAC Database [oracle(rac_1)@trac1:/u01/app/oracle]$ srvctl start instance -d rac -i rac_1 PRCR-1013 : Failed to start resource ora.rac.db PRCR-1064 : Failed… Read more..
Posted in ORA-Error | Comments Off on Oracle RAC Database fails to start with error ORA-12547/ORA-17503/CRS-5017/CRS-2674
Posted by Mir Sayeed Hassan on 13th February 2019
RMAN-04015: error setting target database character set to US7ASCII & ORA-06553 Database Status sys@TESTDB>select instance_name,status,version from v$instance; INSTANCE_NAME STATUS VERSION —————- ———— —————– testdb OPEN 11.2.0.4.0 Error… Read more..
Posted in ORA-Error | Comments Off on RMAN-04015: error setting target database character set to US7ASCII & ORA-06553
Posted by Mir Sayeed Hassan on 12th January 2019
ORA-04063: package body “SYS.KUPW$WORKER” has errors The above error occurs while performing the expdp of the full database in Oracle 11gR2. Error Log: [oracle@testdb new_dump]$ cat fulldbrec.log ;;; Export: Release 11.2.0.4.0 – Production on Sat Jan 12 15:43:42 2019 Copyright (c) 1982, 2011, Oracle and/or its affiliates…. Read more..
Posted in ORA-Error | Comments Off on ORA-04063: package body “SYS.KUPW$WORKER” has errors
Posted by Mir Sayeed Hassan on 15th September 2018
ORA-16139: media recovery required in Oracle Database 11gR2 The Ora-16139 error occur while performing the physical standby database during switchover from physical standby database to primary database in Oracle database 11gR2(11.2.0.4) Check the status of standby db SQL> select switchover_status from v$database; SWITCHOVER_STATUS … Read more..
Posted in ORA-Error | Comments Off on ORA-16139: media recovery required in Oracle Database 11gR2
