Recover from unusable dictionary indexes in 10g using 11g


Some time ago was contacted by a company where someone had generated a script to move tables to another tablespace. Unfortunately, they had made an error and included sys and system tables.
Luckely, Oracle does not allow you to move base dictionary tables, throwing an ORA-00701 error.

ERROR at line 1:
ORA-00701: object necessary for warmstarting database cannot be altered

Anyway, some tables were moved out of the system tablespace and this left a trail of unusable dictionary indexes.
This resulted in a database throwing various errors and when the database was restarted, it just gave up.

SQL*Plus: Release 10. (more...)

FRM-92095: Oracle Jnitiator version too low – patch fix for Forms 10.1.2.3

It seems pigs can fly.

 

I must admit I had a few doubts if there would ever be a patch that would fix the FRM-92095 on Forms 10g when running Java plugin 1.7.x.

But here we are - almost a year later and there is a patch for Forms 10g. It seems the patch is already available since November 21 2012. I only picked up on it because of this blogpost by Steve Chan stating Forms 10.1.2.3.2 bundle patch 2 is now certified with EBS12. 

Bundle patch 2 is patch number 14825718 (more...)

ORA600 Oracle News Aggregator decommissioned

I've decided today to decommission my oracle news aggregator.

I started it a couple of years ago when orablogs.com stopped its RSS aggregation. I was a big of orablogs but I was too late in offering the owner a price for the domain. Otherwise I would have continued orablogs.com.

As it happened - I was too late and some other guy swept up the domain to make a quick buck. If I remember correctly, he was asking around 6000$ for the domain.

So - I decided to start my own RSS aggregator under the ora600 site.

I only (more...)

FRM-92095: Oracle Jnitiator version too low – please install version 1.1.8.2 or higher

A customer of mine who deploys Oracle Forms 10g  on the wild wild web, ran into a little problem.
They don't have control over the java plugin being installed on the client machine and with the latest java 1.7 update
they encountered the following forms error :

FRM-92095: Oracle Jnitiator version too low - please install version 1.1.8.2 or higher

Doh - we're running java 1.7 - not Oracle's obscure Jnitiator.

This seems to be a know issue on metalink see 
FRM-92095 Error When Running Forms Using JRE 7 (JRE 1.7) [ID 1348436.1]

Oracle ASS – one time it will save yours !


For those who don't know Oracle ASS - it's an awk script that is hidden in Oracle's LTOM (aka Lite Onboard Monitoring).
You can download it from metalink - see note ID 352363.1.

It's an awk script that formats system state dumps. I now and then use it to format massive trace files to something I can actually use.

A couple of months ago I had to investigate why a 2 node RAC on windows kept on crashing.
The dba managing it didn't really bother to check the system state dump - instead they just open a call with (more...)