Articles Comments

AskDba.org Weblog » Author Archive

ORA-01426 After Upgrade to 10g

July 2nd, 2008 | Add a Comment

Oracle seems to have a tendency to make small changes to database code which impacts application in a big way. Sad part is, these changes are not always documented properly. One of these cases is what I encountered. A simple PL/SQL code errors out as below: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production With the Partitioning, OLAP and Data Mining options SQL> declare 2 v_code NUMBER(20); 3 BEGIN 4 v_code := 990 * 10000000; 5 END; 6 / declare * ERROR at line 1: ORA-01426: numeric overflow ORA-06512: at line 4 Same block works fine in any previous versions like 9i and 8i. As per Oracle this is “Expected Behavior”. Oracle used to perform number arithmetic. In 10g integer arithmetic is being used. Any application using such code would require to undergo change as follows: SQL> ed Wrote file afiedt.buf 1 declare 2 v_v1 number :=990; 3 … Read entire article »

Filed under: database, oracle

ORA-00600 [12333]

May 20th, 2008 | Add a Comment

ORA-00600 with [12333] is an error that I have encountered on multiple occasions. This post is to shed some light on what this error is all about. To start with let us try to understand when does oracle report ora-00600 error. An ora-00600 error is raised in the exception handler section of Oracle’s c-program code. i.e. Coders have forseen certain exceptional situation that are potential threats to data integrity or memory integrity and written appropriate exceptional handlers to report a ora-00600 error with appropriate information about the exception condition. Details like [12333] indicate or provide hints as to what caused the exception. ora-00600 [12333] is reported when the server recieves data from a client and the server cannot recognize the data format. This error mostly is because of issues with network and … Read entire article »

Filed under: database, oracle

CPU (Critical Patch Update) and N-apply

May 4th, 2008 | Add a Comment

OVERVIEW Oracle has been regularly releasing security fixes for all it’s products to take care of any security vulnerability. Since 2005 Oracle formulated a policy that it will release CPU patch ( bundle of security fixes) every quarter (January, April, July, and October). CPU includes fixes for various Oracle products including Database. Initially Oracle decided to include security fixes, fixes that conflict with security fix and fixes for bugs that affect wide range of users. With each CPU Oracle provides a brief overview of fixes included, but does not elaborate on the vulnerabilities as this information could be misused. CPU patches are applied using Opatch utility. CONFLICTS – SUPER SET – SUBSET Before moving any further let us understand what a patch conflict is. As we all know, Oracle is bunch of c-programs. Any … Read entire article »

Filed under: database, oracle

Understanding of Oracle 11g Automatic Diagnostic Repository – Part 1

May 4th, 2008 | Add a Comment

Understanding of Oracle 11g Automatic Diagnostic Repository – Part 1

INTRODUCTION In an endeavour to move towards self managed database and provide better support solutions, Oracle 11g introduces another new feature in 11g called the Automatic Diagnostic Repository or ADR. As the name implies ADR is a automatically managed file based repository of diagnostic information such as trace files, core dumps, alert log, etc… ADR is like a mini database managing traces of multiple instances and multiple prouducts (database, ASM, CRS, etc…) with metadata of … Read entire article »

Filed under: database, oracle