Archive for May, 2008
Resolving Shutdown Immediate Hang Situations
Many times Oracle DBA’s are faced with a situation where shutting down the instance with shutdown immediate seems to take infinite time and gives a impression that the session is hung. In most of the cases this is not a hang. Hang can be defined as a scenario when few [Read More]
Solving ORA-1031 while connecting as “/ as sysdba” :
Many times we see an issue like this: SQL> conn / as sysdba ERROR: ORA-01031: insufficient privileges This is a very common and frequent error that can occur after the new oracle software install or due to some permissions changes at OS level. I will dicuss the approach [Read More]
AWE -What is It and How to use it?
32-bit Operating systems provide 4Gb of addressable space to applications. This includes memory for the user application and also for the system. When running Oracle on 32-Bit Windows, we can have total memory limited to 1.7 Gb only. If you allocate memory more then 1.7 GB [Read More]
Recovering from ORA-1578 ORA-8103 (Logical Corruption)
1. For ORA-1578: There are two ways in which we can extract the data from a corrupted table: a) Using DBMS_REPAIR.SKIP_CORRUPT_BLOCKS b) Using Event 10231 a) Connect as sysdba user: execute [Read More]
CRSCTL CheatSheet
You can find below various commands which can be used to administer Oracle Clusterware using crsctl. This is for purpose of easy reference. Start Oracle Clusterware #crsctl start crs Stop Oracle Clusterware #crsctl stop crs Enable Oracle Clusterware #crsctl enable crs It [Read More]
ORA-00600 [12333]
ORA-00600 with 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 [Read More]
Allocation Unit and Extents In ASM
ASM was introduced with Oracle 10g and is used as a Volume Manager and a file system. It provides both mirroring and striping of the database files. To use ASM you need to create a Diskgroup and add disks/raw devices to the Diskgroup.Data is allocated in disks in terms of [Read More]
ORA-15063 – ASM Discovered Insufficient amount of Disks
Looking at the response generated by my earlier post on ASM, I thought of writing one more article. Many of us (Working on ASM) would have encountered following errors during startup of ASM instance ORA-15032: not all alterations performed ORA-15063: ASM discovered an [Read More]
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 [Read More]
Tracing Sessions with Event 10046
10046 Event is used to trace SQL statements (similar to sql_trace=true) with additional details depending on the tracing level which is specified. 10046 EVENT levels: 1 – Enable standard SQL_TRACE functionality (Default) 4 – As Level 1 PLUS trace bind values 8 [Read More]
11G: OCR Manual Backups
OCR is a file that manages cluster and Oracle Real Application Clusters (Oracle RAC) database configuration information. The OCR contains information about the cluster node list, instance-to-node mapping information, and information about Oracle Clusterware resource [Read More]
ORA-07445 [opidsa()+480] – Metalink Alert for 10.2.0.3
Oracle has reported a new Alert for user’s who have upgraded their databases to 10.2.0.3 patchset on windows. User processes dumps core dumps with following errors ORA-07445: exception encountered: core dump or ORA-07445: exception encountered: core dump [Read More]
Significance of LD_LIBRARY_PATH
Few days back, I wanted to remove a instance semaphore as they were not cleared automatically due to abnormal shutdown. As there were few other databases running on the server , so I thought of capturing the semaphore id to remove them manually using “ipcrm” . [Read More]
ASM Disk Discovery
While creating ASM diskgroup or adding new disk to a existing diskgroup, Disk should be visible in V$ASM_DISK. ASM discovers and examines the contents of all of the disks that are in the paths that you designated with values in the ASM_DISKSTRING initialization parameter. [Read More]
CPU (Critical Patch Update) and N-apply
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 [Read More]
