1.11.2010
Datawarehouse Turkiye
26.10.2010
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
25.10.2010
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.
23.10.2010
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
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
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