Archive for May, 2008
Resolving Shutdown Immediate Hang Situations
We Have moved to new site. Please find the content on
Add comment May 26, 2008
Solving ORA-1031 while connecting as “/ as sysdba” :
We have moved to new site. Please find article at
http://askdba.org/weblog/?p=113
Add comment May 24, 2008
AWE -What is It and How to use it?
We have moved to new site. Please find article at
Add comment May 24, 2008
Recovering from ORA-1578 ORA-8103 (Logical Corruption)
We have moved to new site. Please find article at
Add comment May 21, 2008
ORA-00600 [12333]
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 does not indicate any data corruption.
Few Common Causes & Suggestions:
1. An incompatible client software can cause such an internal error. Metalink document 207303.1 explains the supported combinations of clients and Server release.
2. An incompatible NLS settings on Client. Check NLS settings especially ORA_NLS33 for 9i, ORA_NLS10 for 10g.
3. Apart from this, it could be because of network issues, client software, TIMEOUT setting, etc. Try to narrow down the error to a particular client machine/ client software.
4. This can be because of an Oracle bug also. Refer to metalink document 428629.1 for list of known bugs with ora-00600 [12333].
As a last resort you can check this with Oracle Support for any new issues.
We have moved to new site. Please find the article at
Add comment May 20, 2008
Allocation Unit and Extents In ASM
We have moved to new site. Please find article at
Add comment May 20, 2008
ORA-15063 – ASM Discovered Insufficient amount of Disks
We have moved to new site. Please find article at
Add comment May 18, 2008
10.2.0.4 on AIX5L (64-Bit) is Out
As usual Laurent has been first to locate that 10.2.0.4 on AIX5L (64-Bit) is Out.
Patchset size is whopping 1.9G which I believe is the maximum size for Oracle Patchset till date. Looks like 10.2.0.3 on AIX had lot of bugs or it could be that DATABASE REPLAY feature needed more lines of code in AIX 
I am not sure why Oracle has named this feature as DATABASE REPLAY on 10.2.0.4. It should have been named as DATABASE CAPTURE.
Anyways I was trying to be the first person to post release of 10.2.0.4 Patchset , but I guess Laurent has written some Package which sends a SMS that patchset is out I need to start learning PL/SQL.
2 comments May 17, 2008
Tracing Sessions with Event 10046
This article has been moved to our new site. Please find article at
Add comment May 17, 2008
Amit
aaryadba
leosanil