July 2011

Database - Oracle - DBA - 11g - Administration, Database - Oracle - DBA - 11g - Command

16 Jul 2011

Oracle 11g Release 2: CRSCTL commands

CRSCTL CommandsCheck current Version of Clusterware$crsctl query crs activeversion$crsctl query crs softwareversion [node_name]To Start & Stop Cluster ready service and cluster synchronization service$crsctl start crs$crsctl stop crs#/etc/init.d/init.crs start#/etc/init.d/init.crs stop#/etc/init.d/init.cssd stop#/etc/init.d/init.cssd…

Ingress Team 1 Comment

Database - Oracle - DBA, Database - Oracle - DBA - 11g - Administration, Database - Oracle - DBA - Administration, Database - Oracle - DBA - Internal

16 Jul 2011

Oracle 11g Rel 2: SCAN (Single Client Access Name)

Hi Friends,Sometime back I have configured few Oracle 11g Rel 2 RAC database on Linux 5 operating system and here I would like to share some of the things I…

Ingress Team 1 Comment

Database - Oracle - DBA, Database - Oracle - DBA - Administration, Database - Oracle - DBA - Internal, Database - Oracle - DBA 11g New Feature

16 Jul 2011

Oracle 11g Rel 2: Grid Plug & Play

Grid Plug and play reduces the cost of installing, configuring and managing server nodes by using Grid Naming Service within the cluster to allow each node to perform the below…

Ingress Team No Comments

Database - Oracle - DBA, Database - Oracle - DBA - Administration, Database - Oracle - DBA - Migration

16 Jul 2011

Migrating User Data from One tablespace to another tablespace: Oracle 11g Rel 2

Hi Friends,Recently I have come across a migration of Oracle User's data from one tablespace to another tablespace.Following are the command that you can create with the help of dba_objects, dba_lobs, all_indexes…

Ingress Team No Comments

Database - Oracle - DBA - Administration, Database - Oracle - DBA - Network, Database - Oracle - DBA 11g New Feature

16 Jul 2011

Oracle 11g Release 2: Checking Network Status

Oracle has provided us some of the utility that can help DBA to know how to check the network settings that is currently used by Oracle RAC DatabaseTo list the…

Ingress Team No Comments

Database - Oracle - DBA - Administration, Database - Oracle - DBA - OCR, Database - Oracle - DBA 11g New Feature

16 Jul 2011

Oracle 11g Release 2: OCR Logical Backup/Restore

In Oracle 11g Release 2, we can take a logical backup of OCR and do the restoration as well if needed.Below is the command that will help you out to…

Ingress Team No Comments

Database - Oracle - DBA - OCR, Database - Oracle - DBA 11g New Feature

16 Jul 2011

Oracle 11g Release 2: OCR Backup

Till Oracle 10g, we have a utility dd to backup OCR and voting disk but moving to 11g Release 2 it is done automatically.Oracle software automatically backups up OCR file…

Ingress Team No Comments