Oracle Grid and Rac startup&configuration scripts

Two important Command . Crsctl and Srvctl. Crsctl commands. Manage clusterware related operations start-stop cluster Srvctl commands. manage Oracle related operations. start-stop instances and services Start or stop Oracle Clusterware on a specific node: crsctl start cluster crsctl stop cluster Determine the overall health on a specific node: crsctl check crs CRS-4638: Oracle High Availability … Continue reading Oracle Grid and Rac startup&configuration scripts

Grid Infrastructure ve ASM semineri

Grid Infrastructure ve ASM semineri Seminer konulari Oracle 11g r2 yeni ozelliklerinden olan Grid infra ve asm yapisi Asm diskgroup yapisi , asm ve file sistem arasindaki baglantilar Asm volume manager yapilandirmasi ACFS nedir ACFS snapshot ozelligi ve faydalari. YER: Bilginc IT Academy http://www.bilginc.com Katilim Ucretsiz Tarih ve Saat 29 Mart Sali saat 1600-1730 sinirli … Continue reading Grid Infrastructure ve ASM semineri

SCAN – SINGLE CLIENT ACCESS NAME

11g r2 grid infranın en onemli ozeliklerinden biride SCAN. bu ozellik sayesinde cluster node eklerken ve cikarirken her defasinda tnsnames.orayı modifiye etmek zorunda kalmiyoruz. Artik cluster son derece kolay kurulabilen ve ozellikle cluster baglanan sunucu sayisi gunden gune artan bir yapida dusunuluyor. O yuzdende node eklemek problemli bir is olmaktan cikarılması gerekiyor. Grid plug and … Continue reading SCAN – SINGLE CLIENT ACCESS NAME

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 COPYDATAFILE "+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 XMLDBAccess via PLSQL,FTP and HTTP.You can access under /sys/asm, the folder hierarchy is defined by the structure of an ASMYou can run $ORACLE_HOME/rdbms/admin/catxdbdbca.sql or use Oracle enterprise managerAlso you can use … Continue reading Oracle Grid Infra / ASM Files and RMAN

Real Application Cluster Yazı Dizisi

Bu gunden itibaren Oraclenın grid mimarisindeki en onemli nokteyı olusturan RAC konusunda bir yazı dizisi olusturacagim.Oncelikle konuya soye baslamak istiyorum RAC demek grid mimarisinin temelidir örnek vermek gerekirsebir firma kendisinin is ihtiyaclari icin 8 cpu 16 gb ramli bir makina almak istiyor diyelim.Bu makinanin maliyeti lisans maliyeti operating sistem maliyeti dusunulurse buyuk fiyatlara cikar.Yani toplam … Continue reading Real Application Cluster Yazı Dizisi