Oracle 11g RAC R2 srvctl commands

Few Oracle 11g RAC R2 srvctl commands:

1.With 11g R2 you can mount the database.This will be very helpful for data guard environments

example :

srvctl start database -d databasename -o mount

2. With 11g R2 its possible to start and stop the listener.

example :

srvctl start listener -l prod_listener

3.With 11g R2 its possible to start multiple service.

example :

srvctl start service -d databasename -s "service1,service_prod"

4. With 11g R2 its possible to start asm diskgroups

example :
srvctl start diskgroup -g "DATA,FRA"

5. With 11g R2 its possible to start RAC asm instance.

example :
srvctl start asm

Oracle 11g Automatic Diagonistic Repository

Oracle 11g Automatic Diagonistic Repository

Automatic Diagnostic Repository (ADR)
ADR is a file-based repository for database diagnostic data such as traces, incident dumps and packages, the alert log, Health Monitor reports, core dumps, and more.


Problems and Incidents:

A problem is a critical error in the database. Problems are tracked in ADR. Each problem is identified by a unique problem ID and has a problem key, which is a set of attributes that describe the problem.

An incident is a single occurrence of a problem. When a problem occurs multiple times, as is often the case, an incident is created for each occurrence.

Automatic Daigonistic Repository Command Line Tool: ADRCI

Few ADRCI commands:

Purge the ADRCI data:

purge -age 10080 -type alert
purge -age 10080 -type incident
purge -age 10080 -type trace
purge -age 10080 -type cdump


Show Commands:
show alert
show base
show home
show homes
show problem
show report
show incident

How to upload diagnostic data to Oracle Support :

First collect the data in an incident package. When you create an incident package, you select one or more problems to add to the incident package.

IPS CREATE PACKAGE INCIDENT:
ips create package incident
example:
ips create package incident 1234132432 in /tmp

IPS CREATE PACKAGE PROBLEM:
ips create package problem

example:
ips create package problem 132432 in /tmp


Trace file location in 11g:

To view the trace files location you can query the database view V$DIAG_INFO
The V$DIAG_INFO view lists all important ADR locations including:
ADR Base: Path of ADR base
ADR Home: Path of ADR home for the current database instance
Diag Trace: Location of the text alert log and background/foreground process trace files
Diag Alert: Location of an XML version of the alert log
Default Trace File: Path to the trace file for your session. SQL Trace files are written here.

11g R2 AWR reports

With oracle 11g R2 AWR reports have lot more information.

--OS related information like CPU's ,CORES,SOCKETS.

Example:
Host CPU (CPUs: 8 Cores: 4 Sockets: 2)

--Memory Statistics details

Example:

Host Mem (MB)
SGA use (MB)
PGA use (MB)
% Host Mem used for SGA+PGA

--Wait Events Statistics new details:

Foreground Wait Class
Foreground Wait Events
Background Wait Evengs
Wait Event Histogram Details

11g CRS commands

My 11g CRS commands reference

$crsctl check cluster

$crsctl stop cluster

$crsctl start cluster

$crsctl stop crs -wait - I like like this command

$crsctl enable crs

$crsctl disable crs

$crsctl check crs

$crsctl check crsd

$crsctl check evmd

$crsctl check cssd

$crsctl query css votedisk

$crsctl add css votedisk

$crsctl delete css votedisk

Patches with 11g

With 11g you can query the cluster ware patch details. This will make patching easier for dba.If you have more than 2 nodes then this will really help :).

$crsctl query crs softwareversion (Node1 or Node8).

Active version:

Active version is the lowest version in your environment. This will help if you have more than 3-4 nodes.

$crsctl query crs activeversion:

Oracle 11g ASM R2 new features

Today I was reading the new features document on Oracle 11g R2. Oracle has introduce lot of cool features like asmcmd enhasments,diskgroup parameters.This week I am planning to test these parameters on my test box.Looks like DBA life with oracle 11g will be very easy and hope it will not have any bugs.

Disk Group parameters:

-au_size Not its possible to set the au size to 1M,2M,4M,8M...64M.

-access control Wow....access control at the ASM level

-compatible.rdbms

-compatible.asm


Force Disk Group Drop:

DROP DISKGROUP DATA01 FORCE INCLUDING CONTENTS;

With 10g we have to format the disks sometimes.

ASMCMD commands:

-Now we can stop, start the asm instance through ASMCMD.

-Disk group creation from ASMCMD

How to Trace Unix System Calls for a Process

The following platforms support a trace utility that can be used to identify what a process is doing:
O/S Version Trace Utility
Sun Solaris 2.x, Unixware 7.0 truss, e.g.:

Unixware 7.0
$ truss -aefo

Solaris
$ truss -rall -wall -p

HP/UX 11 tusc, e.g.:
$ tusc -afpo

IBM AIX 4.x sctrace, e.g.:
$ sctrace -Amo

Linux strace, e.g.:
$ strace -fo

$ strace -p

SGI IRIX 6.x par, e.g.:
$ par -siSSo

Compaq Tru64 Unix trace, e.g.:
$ trace -fo

Sequent Dynix/PTX truss, e.g.:
$ truss -aefo