11gR2 Clusterware tips

Grid home consists of the Oracle Clusterware and ASM. But Grid Infra and RAC DB must be install different home.

First install clusterware then install RAC

If you want to use ASM and Oracle Restart GI can be installed in single server mode .

Grid infra run alone. You can use application like other clusterware

Voting file backed automaticly(configuration change).You can restore crsctl.

SCAN VIP three ip. one vip for each node register DNS or Grid Naming Service

Connect node then Start and Stop CRS crsctl start crs crsctl stop crs

crsctl start cluster start all nodes

RAC Tuning Tips

- Tuning single instance first

- SQL Tuning is most beneficial

- Buffer cache size is very important

- Use sequence cache

- Use partition table

- Reduce long full table scan (OLTP)

- Use selective,correct index

- Use automatic segment space management

- Private Network/Interconnect 1/10 Gbit Ethernet Infiniband

Oracle Grid Infra / ASM Files and RMAN

RMAN> BACKUP AS COPY
DATAFILE "+DATA/rdbms/datafile/tbs_1.252.234234"
FORMAT "+DATA";

RMAN>Backup as copy database format "+DATA";

Rman canbe used to migrate database into ASM

you can access ASM files using XMLDB

Access via PLSQL,FTP and HTTP.

You can access under /sys/asm, the folder hierarchy is defined by the structure of an ASM

You can run $ORACLE_HOME/rdbms/admin/catxdbdbca.sql or use Oracle enterprise manager

Also you can use DBMS_FILE_TRANSFER

SQL> CREATE DIRECTORY deneme AS '+DATA/files';

SQL> CREATE DIRECTORY osden AS '/u01/app/oracle/oradata/orcl';

SQL> BEGIN

DBMS_FILE_TRANSFER.COPY_FILE('osden','user.dbf','deneme','user.dbf');

END;

/

DBMS_FILE_TRANSFER supports all combination. ASM to O/S files or O/S files to ASM

You can use ASMCMD like

grid@zek ~]$ asmcmd

ASMCMD> cd +DATA/orcl/DATAFILE

ASMCMD> ls -l

ASMCMD> cd ..

ASMCMD> pwd

+DATA/orcl/DATAFILE

TROUG Turkish Oracle User Group / Oracle DAY 4 KASIM

4 Kasım Oracle Day'de Haliç salonundayız.

14:00 – 14:40 Konu: Oracle 11g DBA ler için yeni özellikler

Konuşmacı:Zekeriya Besiroglu

14:45 – 15:30 Konu:Oracle 11g Database Developerlar için yeni özelikler

Konuşmacı:H.Tonguc Yılmaz

15:30 – 16:00 Ara

16:00 – 16:40 Konu: Oracle 11g çok büyük databaseler için yeni özellikler ve Exadata
Konuşmacı:Husnu Sensoy

16:45 – 17:30 Panel:TROUG Round Table

H.Tonguc Yılmaz moderatörlüğünde Hüsnü Sensoy , Zekeriya Besiroglu , Orhan Bıyıklıoglu, Ferhat Sengonul panelist olarak katılıp izleyici sorularına cevap verecekler.

TROUG Turkey Oracle User Group

TURKEY ORACLE USER GROUP


4 Kasım Oracle Day Haliç salonu saat 14.00-1730 arasında
11g Yeni özellikler seminerleri ve Uzmanlara soru sorabileceğiniz özel panelimize hepinizi bekleriz.

Ayrıca 4 Kasımda Standımızı ziyaret eden ve panele katılan arkadaşlarımız hediye TROUG termos bardağı kazanacaklar.

Turkey Oracle User Group Uye olmak icin
http://www.troug.org/ adresindeki kayıt formunu doldurabilirsiniz.

Oracle Grid Infrastructure 11g: Manage Clusterware and ASM Release 2

I delivered below mention course two weeks ago. I recommend this course who want to know Oracle ASM, Oracle Grid infrastructure, Oracle Clusterware.

This course is based on Oracle Database 11g Release 2. Learn To:

• Describe the Oracle Database 11g Grid Infrastructure
• Configure and manage ASM and ACFS
• Install and configure Grid Infrastructure
• Use Oracle Clusterware to make applications highly available
• Describe Grid Plug and Play
• Troubleshooting Grid Infrastructure

course topics

Grid Infrastructure Concepts

• What is a Cluster
• Grid Foundation Components
• Oracle Clusterware Architecture
• Oracle Clusterware Software and Storage
• Describe ASM Architecture
• Creating and Managing ASM Disk Groups
• Creating and Managing ASM Cluster File systems
• Job Role Separation

Grid Infrastructure Installation and Configuration

• Hardware Requirements
• Network Requirements
• DNS and DHCP Configuration
• Grid Plug and Play Considerations
• Single Client Access Names
• Post installation tasks

Administering Oracle Clusterware

• Managing Clusterware with Enterprise Manager
• Determining the Location of the Oracle Clusterware Configuration Files
• Backing Up and Recovering the Voting Disk
• Adding, Deleting, or Migrating Voting Disks
• Locating the OCR Automatic Backups
• Oracle Local Registry
• Migrating OCR Locations to ASM
• Managing Network Settings

Managing Oracle Clusterware

• Prerequisite Steps for Extending a Cluster
• Using addNode.sh to Add a Node to a Cluster
• Rolling Patches, And Rolling Upgrades
• Comparing Software Versions With the Active Version
• Installing A Patchset With the OUI Utility
• Installing A Patch With The opatch Utility

Oracle Clusterware High Availability

• Oracle Clusterware high availability components
• Contrasting policy-managed and administration managed databases
• Server pool functionality
• The Generic and Free Server Pools
• Application placement policies
• Application Virtual IPs
• Managing application resources
• High availability events

Troubleshooting Oracle Clusterware

• Oracle Clusterware Log Files
• Gathering Log Files Using diagcollection.pl
• Resource Debugging
• Component-level Debugging
• Tracing For Java-based Tools
• Troubleshooting the Oracle Cluster Registry

Administering ASM Instances

• ASM Initialization Parameters
• Adjusting ASM Instance Parameters in SPFILEs
• Starting and Stopping ASM Instances Using srvctl
• Starting and Stopping ASM Instances Using ASMCA and ASMCMD
• Starting and Stopping ASM Instances Containing Cluster Files
• Starting and Stopping the ASM Listener

Administering ASM Disk Groups

• Creating And Deleting ASM Disk Groups
• ASM Disk Group Attributes
• ASM Disk Group Maintenance Tasks
• Preferred Read Failure Groups
• Viewing ASM Disk Statistics
• Performance And Scalability Considerations For ASM Disk Groups

ASM Files, Directories, and Templates

• Using Different Client Tools to Access ASM Files
• Fully Qualified ASM File Name Format
• Creating and Managing ASM files, Directories and Aliases
• Managing Disk Group Templates
• Managing ASM ACL With Command Line Utilities
• Managing ASM ACL with Enterprise Manager

Administering ASM Cluster File Systems

• ASM Dynamic Volume Manager
• Managing ASM Volumes
• Implementing ASM Cluster File System
• Managing ASM Cluster File System (ACFS)
• ACFS Snapshots
• Using Command Line Tools To Manage ACFS

if you want to register this course

oracle SYS_CONTEXT Examples;

Connect system /oracle@orcl

SET SERVEROUTPUT ON

SQL> EXEC dbms_output.put_line(sys_context('USERENV', 'CURRENT_USER'));
SYSTEM

SQL> EXEC dbms_output.put_line(sys_context('USERENV', 'SESSION_USER'));
SYSTEM

SQL> EXEC dbms_output.put_line(sys_context('USERENV', 'IP_ADDRESS'));
192.168.1.2

SQL> SELECT sys_context('USERENV', 'IP_ADDRESS') FROM DUAL;
192.168.1.2

SQL> EXEC dbms_output.put_line(sys_context('USERENV', 'NETWORK_PROTOCOL'));
tcp

SQL> EXEC dbms_output.put_line(sys_context('USERENV', 'AUTHENTICATION_TYPE')); DATABASE

SQL> SELECT sys_context('USERENV', 'AUTHENTICATION_TYPE') FROM DUAL;
DATABASE

SQL> SELECT sys_context('USERENV', 'CURRENT_USER') FROM DUAL;
SYSTEM

SQL> SELECT sys_context('USERENV', 'NETWORK_PROTOCOL') FROM DUAL;
TCP