ORACLE DBA

Oracle on Windows vs Unix and Linux: Tips and technical articles of Oracle DBA Find here major differences of Oracle on Unix, Linux and Windows. Nature of Windows, Unix and Linux: Windows is multitasking but doesn't multi user operating system. Unix/Linux is multitasking, multiuser and Multithreading operating system. Installation of Oracle on Windows, Unix and Linux: For installation of Oracle on windows doesn't require any other user creation, we can perform oracle installation using "administrator" superuser of windows. For installation of Oracle on Unix/linux required to creating separate operating system user account. Using super user "root" we doesn't require to perform Oracle installation. For installation of Oracle on windows, if we create separate operating system then it should be group of super user administrator. For installation of...

Manual Switchover without Dataguard in Oracle Tips and technical articles of Oracle DBA Switchover can be done without dataguard. Using switchover operation we can convert physical standby database to primary and primary database to physical standby database in Oracle. Switchover operation can perform without dataguard and with dataguard. Here we can see how to perform switchover operation without dataguard configuration. In following example we assume that our primary database and physical standby database are working properly. Standby database is up with managed recovery mode and there is no archive log gap found in physical standby database. In short we can say that our standby database is synchronize with primary database. Find out step by step switchover operation. This switchover calls as manual switchover. Primary Database: First we should need to check our job queue processes and aq processes paramet...

How to kill session in Oracle on Unix and Windows using command line? Tips and technical articles of Oracle DBA In various critical situations Oracle DBA has to decide to kill existing session or kill the background process of Oracle database. At this moment remote Oracle DBA should need to terminate session/process called as murder of session of any instance. If you want kill or terminate process using only operating system command only.How can you kill process in Unix? Kill Oracle process using command line only: In Unix and Linux using kill command: We can check running processes in Unix and Linux using "ps" command. We are able to get process id from said command. $ps -ef|grep ora_|grep -v grep Now use "kill" command with "-9" syntax to kill process id as given below example.kill command with -9 for ensure not blocking command and surity if executi...

How to kill session in Oracle 11g database with new feature? Tips and technical articles of Oracle 11g DBA In various critical situations Oracle DBA has to decide to kill existing session or kill the background process of Oracle 11g database. At this moment remote Oracle DBA should need to terminate session/process called as murder of session of any instance. Dbametrix explains resolution of this issue. From Oracle 11g database there is new feature introduced to kill session from sqlplus. Alter system disconnect session command is introduced in Oracle 11g database with some extra new scope. New feature in Oracle 11g database to kill session: Using SQL*Plus (alter system with disconnect session command): Now we can kill session after finishing existing transaction to be finished. Means in previous release there was no scope to finish on going transaction. Instead of "alter system kill session" here we...

How to kill session in Oracle using command in sqlplus? Tips and technical articles of Oracle DBA In various critical situations Oracle DBA has to decide to kill existing session or kill the background process of Oracle. At this moment remote Oracle DBA should need to terminate session/process called as murder of session. Which situation kill session or process needed: Then question is raised that in under which type of situation remote dba should need to kill session and process. We are explaining those situations and incidences of database.Some critical situation Oracle DBA should need to take decision to ternminate session. Kill session needed under following typical and critical circumstances. 1. When blocking lock occurs and other sessions are waiting to acquire a lock on same object. But blocker session doesn't end the transaction. At this moment Remote oracle dba should need to identify blocking se...

How we faster the process of converting a non-ASM single-instance database to RAC database with ASM using RCONFIG tool? I have been given with a challenging task to convert one of our critical production databases, which is of 1 TB (Terabyte) in size, to Oracle 10g RAC with ASM storage option. Even though, there are many methods and tools available to perform this activity, I have preferred to use the RCONFIG tool. We prepared an input XML file required for RCONFIG tool, and run the RCONFIG utility as follows: $ cd /oracle/ora102/db_1/assistants/rconfig/sampleXMLs $ rconfig ConverToRAC.xml When we start the RCONFIG tool to convert the database to RAC, the RCONFIG tool initially moves all the non-ASM database files to ASM disk files, for this RCONFIG tool internally invokes RMAN utility to backup the target database to the ASM disk groups, eventually the database is converted to RAC using RCONFIG. The conversion took almost 9 hours to complete the process, because during the c...

Oracle Installation in Linux After Linux Installation, I have installed Oracle10g 2 in Linux machine. I followed steps given at below link. http://www.oracle.com/technology/pub/articles/smiley_10gdb_install.html Check "Part II: Configuring Linux for Oracle"

Linux Installation Installing Linux >Boot from RHEL4 disc1 >press enter for graphical install ** Need at least 512MB RAM / 2.5GB Space ** >Manually partition your hard drive with Disk Druid /tmp = 512MB ext3 fixed size /boot = 128MB ext3 fixed size Swap = 1024MB fixed size(Give the double of RAM Memory Area) / = fill to maximum allowable size

ALTER INDEX indexname REBUILD. What does an ALTER INDEX indexname REBUILD do ? When would it be used ? See this test case : These are my two tables and their indexes : QL> select table_name, blocks, num_rows,sample_size from user_tables 2 where table_name like 'STORES_LIST%'; TABLE_NAME BLOCKS NUM_ROWS SAMPLE_SIZE ------------------------------ ---------- ---------- ----------- STORES_LIST 4930 405884 405884 STORES_LIST_2 4930 405884 405884 SQL> select table_name, index_name, num_rows, leaf_blocks from user_indexes 2 where table_name like 'STORES_LIST%'; TABLE_NAME INDEX_NAME NUM_ROWS LEAF_BLOCKS ------------------------------ ------------------------------ ---------- ----------- STORES_LIST STORES_LIST_CNTRY_STT_NDX 405884 1709 STORES_LIST_2 STORES_LIST_2_CNTRY_STT_N...

http://www.scribd.com/

PURPOSE ------------- This document is to provide additional information on CRS (Cluster Ready Services) in 10g Real Application Clusters. SCOPE & APPLICATION --------------------------------- This document is intended for RAC Database Administrators and Oracle support enginneers. CRS and 10g REAL APPLICATION CLUSTERS ------------------------------------------------------------- CRS (Cluster Ready Services) is a new feature for 10g Real Application Clusters that provides a standard cluster interface on all platforms and performs new high availability operations not available in previous versions.   CRS KEY FACTS ------------- Prior to installing CRS and 10g RAC, there are some key points to remember about CRS and 10g RAC: - CRS is REQUIRED to be installed and running prior to installing 10g RAC. - CRS can either run on top of the vendor clusterware (such as Sun Cluster,   HP Serviceguard, IBM HACMP, TruCluster...