Author Archive
Generating Datapump Export Dump with Dumpfile name Containing Current Date and Time
Few days back I got a request from development team to generate hourly export dumps of few schemas. Following were the requirements: 1. Dumpfile name should contain current date and timestamp information. 2. The generated dumpfile should be moved to a specific location. 3. [Read More]
SRVCTL fails to start RAC resources:CRS-0215
After upgrading RAC database to 10204 and applying CRS bundle patch-1 for 10204 crs home, srvctl command fails to startup resources on rac nodes. While starting up RAC resources using SRVCTL following error occurs in CRSD.log file: $ srvctl start instance -d rac -i rac2 [Read More]
Grid Control Fails to Start
The link for Grid Control was not Working and it failed to show the login page. In this situation checked the following things: 1. The repository database was up and running 2. The listener was up. 3. OMS server was down. Tried to stratup the OMS server using opmnctl [Read More]
Connections to DataBase Hang Including “/ as sysdba”
Recently I faced one issue where all the connection to database hung and it was also not possible to login to database using “/ as sysdba”. To get access of sqlplus I used the following syntax: $ sqlplus -prelim / as sysdba With “prelim” option we [Read More]
Creating Oracle Extended RAC on Oracle VM
Yesterday, I found one very useful article at OTN “Creating Oracle Extended RAC” on completely virtual environment using Oracle VM. As Virtualization is becoming popular day by day and is very cost effective, one must know how to use this to simulate actual [Read More]
Database Security: Transparent Data Encryption
Data in the database is secured by using authentication, authorization and auditing mechanism, but the information stored in the datafiles can be read using any hex-editor tools or other OS level utilities, which is causing threat to sensitive data. To overcome this [Read More]
How To Recover From Corrupted OCR Disk
It is very common where a DBA is left with corrupted OCR disk without having any good backup. The same situation was experienced by me few days back. One node of RAC database shows the following: NODE1: <span style="font-family: [Read More]
UNKNOWN State Of RAC Resources
While Checking the status of database resources, ASM was shown as UNKNOWN on one node of a two node RAC. $ crs_stat -t <span style="font-family: arial,helvetica,sans-serif;">Name Type Target State Host [Read More]
Verification of CRS Integrity Was Unsuccessful
While going through the routine checks from Grid Control, I found a critical alert stating “clusterware integrity check failed” and by clicking on this message it says that there is problem with some metric collections on RAC environment. To check the node [Read More]
11g New Feature: Database Replay
Database Replay: In critical production systems, before making changes to the environment( Hardware or software related), lots of testing is required in test systems to know the effect of those changes and this usually takes lots of time to test for the stability and [Read More]
Effect of OS Terminal Setting “STTY” on Oracle Database
Few days back, while trying to create a synonym over dblink I experienced following error: SQL> create synonym synonymn_name for dual@DBLINK9i; SP2-0042: unknown command "DBLINK9i" - rest of line ignored Strange error !!! Also while trying to perform a simple [Read More]
Adding new ASM disk to RAC database fails
Many times i came across a common problem in RAC databases where trying to add an asm disk is not possible due to errors like ORA-15075 “disk(s) are not visible cluster-wide” ORA-15020 “discovered duplicate ASM disk “DISK1″ and ORA-15054 [Read More]
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]
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]
