DBA Tips Archive for Oracle. Michael New, Michael. Newearthlink. net, Gradation LLC. Contents. Introduction. Introduced with Oracle ASM 1. Release 2, Oracle ASM Cluster File System Oracle ACFS is a. POSIX compliant cluster file system implemented as part of Oracle Automatic Storage Management. Oracle ASM. Being POSIX compliant, all operating system utilities we use with ext. Oracle ACFS given it belongs to the same family of related standards. Oracle ACFS extends the Oracle ASM architecture and is used to support many types of files which are. Oracle database. For example Oracle ACFS can be used to store. BFILEs, database trace files, executables, report files and even general purpose files like image. In addition, Oracle ACFS can be used as a shared file system for. Oracle home binaries. The features included with Oracle ACFS allow users to create, mount, and manage ACFS using. Linux commands. Oracle ACFS provides support for snapshots and the ability. Oracle ASM Dynamic Volume Manager ADVM. Oracle ACFS leverages Oracle ASM functionality that enables. Oracle ACFS dynamic file system resizing Maximized performance through direct access to Oracle ASM disk group storage Balanced distribution of Oracle ACFS across Oracle ASM disk group storage for increased IO parallelism Data reliability through Oracle ASM mirroring protection mechanisms. While Oracle ACFS is useful for storing general purpose files, there are certain files that it is not. For example, Oracle ASM traditional disk groups is still the preferred storage manager for all database files because. Oracle ACFS does not support direct. IO for file read and write operations in 1. Release 2 1. 1. 2. Oracle ASM was specifically designed and optimized to provide the best performance for database file types. In addition to Oracle database files, Oracle ACFS does not support files for the Oracle Grid Infrastructure home. Finally, Oracle ACFS does not support any Oracle files that can be directly stored in Oracle ASM. For example, SPFILE, flashback log files, control files, archived redo log files, the Grid Infrastructure OCR. Oracle ASM disk groups. The key point to remember is that. Oracle ACFS is the preferred file manager for non database files and is optimized for general purpose customer. Oracle database. This article describes three ways to create an Oracle ASM Cluster File System in an Oracle 1. Release 2 RAC database. Linux operating environment. There is actually a fourth method that can be employed to create an Oracle ASM Cluster File System which is. ASMCMD command line interface. Throughout this guide, Ill demonstrate how to use the. ASMCMD command line interface in place of SQL where appropriate. The Linux distribution used in this guide is Cent. OS 5. 5. Cent. OS is a free. Enterprise class Linux Distribution derived from the Red Hat Enterprise Linux RHEL. Although Centos 5 is equivalent to RHEL 5. Cent. OS operating system is not supported by Oracle ASM Cluster File System. Refer to the workaround documented in the. Cent. OS or a similar Red Hat clone. It is assumed that an Oracle RAC database is already installed, configured, and running. Windows7VersionScreen.png' alt='How To Install Dbconsole In Oracle 11G Free' title='How To Install Dbconsole In Oracle 11G Free' />Open File Dailog box example using Webutil CLIENTGETFILENAME Forms 10g. I was given the task of comparing the new 12c to our older 10. I come from a MS Sql env. I could do in MS. We are using Oracle Enterprise Manager on an Oracle 11g database to identify bottlenecks in the execution of queries. We have a query that can take as long. FSUUMVB17oM/UjAGP3dd2KI/AAAAAAAAAk4/88YEGExcAFY/s1600/unixdba1.png' alt='How To Install Dbconsole In Oracle 11G Free' title='How To Install Dbconsole In Oracle 11G Free' />Refer to. Oracle RAC 1. 1g Release 2 database on Linux. ACFS Components. Before diving into the details on how to create and manage Oracle ASM Cluster File System. Bu makalemizde Oracle Grid Infrastructure ile Single Instance Standalone Veritaban Kurulumunu inceleyeceiz. Kurulum Oracle Enterprise Linux 6. Oracle. This is a 16 step Oracle 11g installation guide that covers a typical installation scenario with screenshots. Note Since there are several screenshots of. Fix DGMGRL Error ORA16698 LOGARCHIVEDESTn parameter set for object to be added Golden Gate ggsci start manager ERROR Parameter file mgr. Oracle Technology Network provides services and resources to help developers, DBAs, and architects build, deploy, manage, and optimize applications using Oracle. Figure 1 shows the various components. Oracle ACFS and provides an illustration of the example configuration that will be. Figure 1 Oracle ASM Cluster File System Components. Everything starts with an Oracle ASM disk group. An Oracle ASM disk group is made up. DOCSDG1. The next component is an Oracle ASM volume which is created. It is assumed that an Oracle RAC database is already installed, configured, and running. Refer to this guide for instructions on how to build an inexpensive. Burleson Consulting is an altruistic company and we believe in sharing our Oracle extensive knowledge through publishing Oracle books and Oracle articles, video. Oracle ASM disk group. The example configuration illustrated above shows. DOCSDG1. Finally, we will. With Oracle ACFS, as long as there exists free space within the ASM disk group. As I will demonstrate later in this article. Oracle ASM Dynamic Volume Manager ADVM. Besides an Oracle ASM disk group, another key component to Oracle ACFS. Oracle ASM Dynamic Volume Manager ADVM. ADVM provides volume. ACFS, ext. 3, ext. OCFS2, etc. The ADVM services include functionality to create, resize, delete, enable, and disable dynamic volumes. An ASM dynamic volume is constructed out of an ASM file with an ASMVOL. ASM file types. i. DATAFILE, TEMPFILE, ONLINELOG, etc. ASM File Name Volume Name Device Name Bytes File Type. CRSracnode clusterASMPARAMETERFILEREGISTRY. ASMPARAMETERFILE. CRSracnode clusterOCRFILEREGISTRY. OCRFILE. DOCSDG1 DOCSVOL1 devasmdocsvol. ASMVOL. DOCSDG1 DOCSVOL2 devasmdocsvol. ASMVOL. DOCSDG1 DOCSVOL3 devasmdocsvol. ASMVOL. FRARACDBARCHIVELOG2. ARCHIVELOG. FRARACDBARCHIVELOG2. ARCHIVELOG. FRARACDBONLINELOGgroup3. ONLINELOG. FRARACDBONLINELOGgroup4. ONLINELOG. RACDBDATARACDBCONTROLFILECurrent. CONTROLFILE. RACDBDATARACDBDATAFILEEXAMPLE. DATAFILE. RACDBDATARACDBDATAFILESYSAUX. DATAFILE. RACDBDATARACDBDATAFILESYSTEM. DATAFILE. RACDBDATARACDBDATAFILEUNDOTBS1. DATAFILE. RACDBDATARACDBDATAFILEUNDOTBS2. DATAFILE. RACDBDATARACDBDATAFILEUSERS. DATAFILE. RACDBDATARACDBONLINELOGgroup1. ONLINELOG. RACDBDATARACDBONLINELOGgroup2. ONLINELOG. RACDBDATARACDBONLINELOGgroup3. ONLINELOG. RACDBDATARACDBONLINELOGgroup4. ONLINELOG. RACDBDATARACDBPARAMETERFILEspfile. PARAMETERFILE. RACDBDATARACDBTEMPFILETEMP. TEMPFILE. RACDBDATARACDBspfileracdb. PARAMETERFILE. Oracle ACFS and other supported 3rd party file systems. Oracle ADVM as a volume management platform to create. Oracle ASM features. A volume may be created in its own Oracle ASM. Any number of volumes can be created in an ASM disk group. Creating a new volume in an Oracle ASM disk group can be performed using the. ASM Configuration Assistant ASMCA. Oracle Enterprise Manager OEM. ASMCMD. For example. G docsdg. 1 s 2. G docsvol. Once a new volume is created in Linux, the ADVM device driver. OS that is used. by clients to access the volume. These volumes may be used as block. OCFS2 or. Oracle ACFS may used as described in this guide in which case the. IO to the file system. On the Linux platform, Oracle ADVM volume devices are created. Oracle ASM disk group. Do not use raw 8 to map. Oracle ADVM volume block devices into raw volume devices. Under Linux, all volume devices are externalized to the OS and appear. In this guide, we will use this OS volume device to create an Oracle ACFS. Nov 2. 8 1. 3 4. Nov 2. Nov 2. 8 1. 3 5. DOCSVOL3. Oracle ADVM implements its own extent and striping algorithm to ensure the highest. An ADVM volume is four columns of. MB extents and 1. KB stripe width by default. ADVM writes data in 1. KB stripes. in a Round Robin fashion to each column before starting on the next four column extents. ADVM uses Dirty Region Logging DRL for mirror recovery after a node or instance. This DRL scheme requires a DRL file in the ASM disk group to be associated. ASM dynamic volume. ACFS Prerequisites. Install Oracle Grid Infrastructure. Oracle Grid Infrastructure 1. Release 2 1. 1. 2. Oracle ACFS. Oracle Grid Infrastructure includes Oracle Clusterware, Oracle ASM, Oracle ACFS. Oracle ADVM, and driver resources software components, which are installed into the. Grid Infrastructure Home using the Oracle Universal Installation OUI tool. Refer to this guide. Oracle Grid Infrastructure as part of an. Oracle RAC 1. 1g Release 2 database install on Linux. Oracle Grid Infrastructure ile Single Instance Standalone 1. R2 Veritaban Kurulumu. Bu makalemizde Oracle Grid Infrastructure ile Single Instance Standalone Veritaban Kurulumunu inceleyeceiz. Kurulum Oracle Enterprise Linux 6. Oracle Database Enterprise Edition 1. Patchset Update 1. Aadaki kurulum parametrelerinin doruluu ya da gncellii Oracle Tahiti sitesinden kontrol edilmelidir. Bu makale hazrlandktan sonra kurulum parametrelerinde bir gncelleme yada deiiklik olmu olabilir. Sistemimizi Oracle Enterprise Linux 6. Kurulumu makalemizde anlatld gibi kuruyoruz. Sunucumuz internete kyor ise Oracle veritaban kurulumu iin gerekli olan n gereksinimler paketini kurabilir ve gerekli paketlerle ayarlarn otomatik ekilde yaplanmasn salayabiliriz. Eer iimiz rahat etmezse aadaki admlar da izleyerek ayarlar kontrol edebiliriz. Yada kendimiz elle yaplandrabiliriz. Otomatik paketlerin ve ayarlarn kurulumu iin aadaki komutu root kullanc ile altryoruz. R2 preinstall. Ayarlarmz elle kendimiz yapmak iin aadaki admlar izlememiz gerekiyor. Kernel Parametre dosyasnda gerekli dzenlemeyi yapyoruz. Dosyasna aadaki parametreleri giriyoruz. Oracle Database Kernel Parameters. Bu parametreleri girdikten sonra deiikliklerin uygulanabilmesi iin. Limitlerin belirlendii dosyada gerekli dzenlemeyi yapyoruz. Dosyasna aadaki parametreleri giriyoruz. Oracle Database Limit Parameters. Veritaban kurulumu iin gereken paket gruplar ve paketleri kuruyoruz. Sistemimizde mevcut olan paketler varsa kurma isteimizde Nothing to do uyars alacaz. Bu uyary alyorsak paket zaten sistemimizde kurulu demektedir. Bir ok paketin mevcut olduunu syleyecek ve olmayan bir ka paketi sisteme kuracaktr. Sunucumuz nternete kyorsa paketleri direk yum install komutu ile kurabiliriz. Sunucumuz internete kmyorsa paketlerin kurulmas iin sunucumuzdaki. DVDsini takarak paketleri kuruyoruz. Oracle Linux 6 DVD. ServerPackages. rpm Uvh binutils 2x. Uvh glibc 2. 866. Uvh glibc 2. 68. Uvh compat libstdc 3. Uvh glibc common 2. Uvh glibc devel 2. Uvh glibc devel 2. Uvh glibc headers 2. Uvh elfutils libelf 0. Uvh elfutils libelf devel 0. Uvh gcc 4. 866. Uvh gcc c 4. Uvh ksh. 866. Uvh libaio 0. Uvh libaio devel 0. Uvh libaio 0. 68. Uvh libaio devel 0. Uvh libgcc 4. 866. Uvh libgcc 4. 68. Uvh libstdc 4. Uvh libstdc 4. Uvh libstdc devel 4. Uvh make 3. 8. 1. Uvh numactl devel 2. Uvh sysstat 9. Uvh compat libstdc 3. Uvh compat libcap Oracle iin kullanclar ve kullanc gruplarn yaratyoruz. G dba,asmdba,oper oracle. Burada database, asm vb. Bu bizim sistem. politikamza gre deiebilir. Oracle ngereksinim paketi kullanmadan elle kurulum yapmak iin gerekli ilemlerin neler olduunu ve yapmamz gereken ayarlar inceledik. Oracle Enterprise Linux 6. Oracle ngereksinim paketi otomatik olarak kurulu geliyor bu paketle birlikte gerekli olan parametre ayarlar, kullanc gruplar ve kullanclar otomatik olarak ayarlanm ve yaratlm olarak geliyor. Oracle Kullancs iin parola belirliyoruz. Changing password for user oracle. Retype new password. Yerel isim zmleme dosyasna sunucumuzun adresini ve ismini giriyoruz. IP address lt fully qualified machine name lt machine name. Bununla beraber kurulum eer NTP servisi kullanyorsak onuda ayarlamamzda fayda olacaktr. Kurulum aamasnda onunla ilgili ayarlar yaplmadnda hata verebiliyor. Dosyasnda bulunan parametre aadaki gibi dzenlenmelidir. OPTIONS x u ntp ntp p varrunntpd. Ardndan da servis yeniden balatlmaldr. Bu ayar cluster ortamlarnda zaman senkronizasyonu bozulduunda. Bu ekilde senkronizasyonun bozulmasn engelleyecektir. Microsoft Sql Server 2005 Management Studio Manuals. Yine kurulum aamasnda veya yksek miktarda memorytarget parametresi atandnda ORA 0. MEMORYTARGET hatas almaktayz bu sorunu engellemek iin aadaki shmfs parametresi ayarlanmaldr. Bu dosyada yaplan deiiklikler bir sonraki yeniden balatma srasnda geerli olacaktr. Hemen devreye almak iin aadaki mount komutu altrlmaldr. Dosyasnda tmpfs satrnn altna aadaki gibi bir satr eklenmelidir. Burada belirtilen size1. GB olacaksa burada atayacamz. Fazla atanmas sorun deildir. Deiiklii hemen devreye almak iin. Eer kurulum bitiminde Secure Linux ve Firewall zelliini kapatmamsak bunlar kapatyoruz. Dosyasnda bulunan. SELINUXdisabled. Parametresini yukardaki gibi kapal duruma getiriyoruz. Firewall Servisini kapatmak iin aadaki komutlar altryoruz. Grafik arayzden bu ilemi yapmak istiyorsak Oracle Enterprise Linux 6. Kurulumu makalemizdeki 5. Oracle kurulumlarn yapabilmek, kurulum ve patch dosyalarmz koyabilmek iin gerekli olan dizinleri yaratp haklar atyoruz. R oracle oinstall u. R 7. 75 u. 01. u. Grid Infrastructure kurulum dizini. Oracle Database kurulum dizini. Oracle kurulum dosyalarn atacamz dizin. Dikkat etmemiz gereken nemli noktalardan biri Grid dizininin. Oracle Base dizininden farkl bir. Aksi takdirde kurulum aamasnda uyar verecektir. Oracle 1. 1. 2. 0. Yani mevcut oracle dizinleri. Root kullancs ile oracle kullancsnn ekran grntsn kendi bilgisayarmza aktarabilmek iin ncelikle aadaki komutu altryoruz. Oracle Veritaban iin deikenlerimizi. Oracle kullancsna gei yapyoruz. Dosyasna aadaki deikenleri giriyoruz. Oracle bashprofile Environment Settings. TMPtmp export TMP. TMPDIRTMP export TMPDIR. ORACLEHOSTNAMEkoraykey db. ORACLEHOSTNAME. ORACLEUNQNAMEorcl export ORACLEUNQNAME. ORACLEBASEu. 01apporacle export ORACLEBASE. GRIDHOMEu. 01app1. GRIDHOME. DBHOMEORACLEBASEproduct1. DBHOME. ORACLEHOMEDBHOME export ORACLEHOME. ORACLESIDorcl export ORACLESID. ORACLEHOMELISTNERORACLEHOME export ORACLEHOMELISTNER. ORACLETERMxterm export ORACLETERM. BASEPATHusrsbin PATH export BASEPATH. PATHORACLEHOMEbin BASEPATH export PATH. LDLIBRARYPATHORACLEHOMElib lib usrlib export LDLIBRARYPATH. CLASSPATHORACLEHOMEJRE ORACLEHOMEjlib ORACLEHOMErdbmsjlib export CLASSPATH. USER oracle then. SHELL binksh then. Daha sonra grid ve db deikenleri arasnda gei yapabilmek iin. Dosyasna aadaki deikenleri giriyoruz. Oracle grid Environment Settings. ORACLESIDASM export ORACLESID. ORACLEHOMEGRIDHOME export ORACLEHOME. PATHORACLEHOMEbin BASEPATH export PATH. LDLIBRARYPATHORACLEHOMElib lib usrlib export LDLIBRARYPATH. CLASSPATHORACLEHOMEJRE ORACLEHOMEjlib ORACLEHOMErdbmsjlib export CLASSPATH. Dosyasna aadaki deikenleri giriyoruz. Oracle db Environment Settings. ORACLESIDorcl export ORACLESID. ORACLEHOMEDBHOME export ORACLEHOME. PATHORACLEHOMEbin BASEPATH export PATH. LDLIBRARYPATHORACLEHOMElib lib usrlib export LDLIBRARYPATH. CLASSPATHORACLEHOMEJRE ORACLEHOMEjlib ORACLEHOMErdbmsjlib export CLASSPATH1. ASM iin atayacamz disklerimizi yaplandracaz. ASM ortamna atayacamz diskleri iki yntem ile yaplandrabiliriz.