Database App Development, Management and Performance

This post is almost a direct copy of my reply to the OBIEE EMG mailing list started by Mark Rittman about Initial Opinions on OBIEE 11g?. I can’t say I’ve had any success installing the software. So far I’ve tried on XP Pro (VM on laptop) and Server 2008 (AWS instance). I’ve chosen the Enterprise [...]

This post is almost a direct copy of my reply to the OBIEE EMG mailing list started by Mark Rittman about Initial Opinions on OBIEE 11g?. I can’t say I’ve had any success installing the software. So far I’ve tried on XP Pro (VM on laptop) and Server 2008 (AWS instance). I’ve chosen the Enterprise [...]

This post is almost a direct copy of my reply to the OBIEE EMG mailing list started by Mark Rittman about Initial Opinions on OBIEE 11g?. I can’t say I’ve had any success installing the software. So far I’ve tried on XP Pro (VM on laptop) and Server 2008 (AWS instance). I’ve chosen the Enterprise [...]

Problem Description While executing dbms_workload_repository package the following error message is reported. sql> exec dbms_workload_repository.modify_snapshot_settings(interval=>0); BEGIN dbms_workload_repository.modify_snapshot_settings(interval=>0); END; ERROR at line 1: ORA-13516: AWR Operation failed: SWRF Schema not initialized ORA-06512: at "SYS.DBMS_WORKLOAD_REPOSITORY", line 85 ORA-

Problem Description The BSLN_MAINTAIN_STATS_JOB doesn’t run anymore. From the trace file we see the following information. ORA-12012: error on auto execute of job 11689 ORA-06502: PL/SQL: numeric or value error ORA-06512: at "DBSNMP.BSLN_INTERNAL", line 2073 Cause of the Problem Table DBSNMP.BSLN_BASELINES contains inconsistent information. In this case, after database cloning, existing

Problem Description While doing datapump export or import operation it fails with following error messages: ORA-31626: job does not exist ORA-31633: unable to create master table "ARJU.SYS_EXPORT_TABLE_05" ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95 ORA-06512: at "SYS.KUPV$FT", line 863 ORA-00955: name is already used by an existing object Cause of the Problem Error is caused by a [...]

ORA-06512 is a common error faced by Oracle DBA, programmers as well as end users. ORA-06512 does not identify the root cause of the problem, rather it only prints the line number where the errors or exception happened. So just before ORA-06512 there will be additional error which we may need to investigate. If the [...]

Anonymous Pro is a fixed-width font developed specifically for developers by Mark Simonson. Best of all – it’s free under the Open Font License. From it’s home page:  “Characters that could be mistaken for one another (O, 0, I, l, 1, etc.) have distinct shapes to make them easier to tell apart in the context of source [...]

A common initial resolution to reporting requirements without a reporting database is to utilize materialized views.  Unfortunately, the cost to refresh these views can be extremely expensive on a database, especially if it’s an OLTP that rarely has a lull in activity. A lesser known feature of Oracle’s is the Change Data Capture, (a.k.a CDChttp://download.oracle.com/docs/cd/B10500_01/server.920/a96520/cdc.htm )The [...]

This is more for me since I seem to install it quite regularly. I’ve been snagging the SQL from OBIEE query logs (nqquery.log), which doesn’t come out too pretty. So that I don’t have to manually format 400 lines of SQL, I created a formatting template. Ctl – F7 and voila! I do go back [...]