ORDIM – Oracle Multimedia – Invalid after upgrade

Posted Leave a commentPosted in Oracle

ORDIM – The Oracle Multimedia component might be in INVALID state after the database upgrade to 12c. While I was testing the upgrade on test server, received below errors after the catctl.pl completion. Serial Phase #:69 Files: 1 Use of uninitialized value $gsRTInclusion in concatenation (.) or string at catctl.pl line 1500. Time: 49s —————————————————— […]

12c Upgrade – It can be slow!!!!

Posted Leave a commentPosted in 12c, Oracle, SYSAUX, Upgrade

This post is for some of you who are planning to upgrade to 12c.I worked on upgrading single instance database from 11.2.0.3.13 to 12.1.2.0.3, so thought to share my experience. From 12c catupgrade.sql has been deprecated and Oracle has introduced catctl.pl script for upgrade. With catctl.pl script Oracle tries to perform as much work as […]

ORA-00600 [kqlidchg0] | ORA-00001: unique constraint (SYS.I_PLSCOPE_SIG_IDENTIFIER$) violated

Posted Leave a commentPosted in I_PLSCOPE_SIG_IDENTIFIER$, Invalid, ORA-00001: unique constraint, ORA-00600, ORA-00600 [kqlidchg0], Oracle, PLSCOPE_IDENTIFIER$

Recently after upgrading the dev database to 12c, I ran utlrp to compile the invalid objects and it failed with the below error SQL> @utlrp SQL> SELECT dbms_registry_sys.time_stamp(‘utlrp_bgn’) as timestamp from dual; TIMESTAMP ——————————————————————————– COMP_TIMESTAMP UTLRP_BGN 2015-06-30 03:50:27 SQL> DECLARE 2 threads pls_integer := &&1; 3 BEGIN 4 utl_recomp.recomp_parallel(threads); 5 END; 6 / DECLARE * […]

Exchange Partition – Exchanging Table Partitions

Posted 1 CommentPosted in Oracle, Partitions

Recently I came across a requirement of moving table to new tablespace. The table had 12 range based partitions and each partition had ~8K list subpartitions and was storing historic data. After few discussion, it was decided to use exchange partition instead of dbms_redefinition. As I did not have much practical experience in exchange partition, […]

Groups – OSDBA OSOPER OSASM

Posted 1 CommentPosted in Oracle

This one is quick and short. I have been asked few time, how can we check what value was specified to OSDBA, OSOPER and OSASM,especially during upgrades (to know what was it set to which initial installation) # The DBA_GROUP is the OS group which is to be granted OSDBA privileges. # The OPER_GROUP is […]

ORA-00600: [ktbdchk1: bad dscn]

Posted 6 CommentsPosted in 11gR1, 11gR2, ORa-600, Oracle

Last week I had performed switchover activity of database on version 11.2.0.3 The switchover was performed using dgmgrl “swicthover to standby” command. After sometime we started receiving “ORA-00600: [ktbdchk1: bad dscn]” on the primary database. Tue Dec 16 10:33:26 2014 Errors in file /ora_software/diag/rdbms/db02_dbv/dbv/trace/db02_ora_16271.trc (incident=434103): ORA-00600: internal error code, arguments: [ktbdchk1: bad dscn], [], [], […]