Patchset Oracle 11.2.0.2' title='Patchset Oracle 11.2.0.2' />Oracle Enterprise Linux letim Sisteminde Standalone Single Instance Oracle 1. R2 Veritaban Kurulumu. Bu makalemizde Oracle Veritaban Kurulumunu Grid Infrastructure olmadan inceleyeceiz. Veritabanmz dosya sistemine File System ASM olmadan kuracaz. 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. Oracle Enterprise Linux letim Sistemi Kurulumu makalemizde anlatld gibi kuruyoruz. Sunucumuzda Yerel isim zmleme dosyasna sunucumuzun adresini ve ismini giriyoruz. IP address lt fully qualified machine name lt machine name rnek. Bununla beraber kurulumda eer NTP servisi kullanacaksak 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 bozulduundazaman geri ya da ileri almak yerine bekletecektir. Bu ekilde senkronizasyonun bozulmasn engelleyecektir. Otomatik paketlerin ve ayarlarn kurulumu iin aadaki komutu root kullanc ile altryoruz. Bu paket Oracle veritaban iin gerekli olan kernel parametreleri, limit parametreleri, kullanc ve gruplar gerekli paketler vb. Eer parametreleri elle ayarlayacaksak bu adm gemeliyiz. SQLID andor PLANHASHVALUE are used almost globally across Oracle database to identify query. This is not a case for SPM mechanism using different. Author Marcin Przepiorowskihttp hIDSERP,5307. ORA00020 maximum number of processes s exceededBlogs Oracle database grid technology ASM, RAC, Enterprise Manager, virtualization, cloud computing and linux. Profiling trace files with preprocessor external tables in 11g. External tables were introduced in Oracle 9i but have had several new features added through the major. In this note were using the English descriptions of common error messagescaused by an Oracle Database Gateway. To compare your message with the messagebelow, you can. Bu makalemizde Oracle Grid Infrastructure ile Single Instance Standalone Veritaban Kurulumunu inceleyeceiz. Kurulum Oracle Enterprise Linux 6. Oracle. Hi experts, this week I participated the DSAG Technologietage German speaking user group technology days in Hamburg, Germany. There was one session which. Hello Friends,first I have updated a sandbox from oracle 11. But now I have installed patchset 11. Tabi Oracle Enterprise Linux 6. Kurulum ncesi aadaki parametrelerle zerinden geebiliriz. R2 preinstall. 5. Ayarlarmz elle kendimiz yapmak iin aadaki admlar izlememiz gerekiyor. Kernel Parametre dosyasnda gerekli dzenlemeyi yapyoruz. Patchset Oracle 11.2.0.2' title='Patchset Oracle 11.2.0.2' />Dosyasna aadaki parametreleri giriyoruz. Oracle Database Kernel Parametersfs. Bu parametreleri girdikten sonra deiikliklerin uygulanabilmesi iin sbinsysctl pkomutunu altryoruz. Limitlerin belirlendii dosyada gerekli dzenlemeyi yapyoruz. Dosyasna aadaki parametreleri giriyoruz. Oracle Database Limit Parametersoracle soft nofile 1. 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. This note is about known issues with Oracle software installation release 11. Within this note ltoui denotes the program name of the Oracle Universal Installer. Purpose This article will show you how to check the supported Oracle upgrade paths under SAP environment. Overview You are planning to upgrade your Oracle source. Patchset Oracle 11.2.0.2' title='Patchset Oracle 11.2.0.2' />Bir ok paketin mevcut olduunu syleyecek ve olmayan bir ka paketi sisteme kuracaktr. Sunucumuz nternete kyorsa paketleri direk yum installkomutu ile kurabiliriz. Sunucumuz internete kmyorsa paketlerin kurulmas iinsunucumuzdaki Kurulum DVDsini takarak paketleri kuruyoruz. Oracle Linux 6 DVD cd mediacdromServerPackagesrpm 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 cd eject. Oracle iin kullanclar ve kullanc gruplarn yaratyoruz. G dba,oper oracle. Burada database, asm vb. Bu bizim sistem. politikamza gre deiebilir. Oracle n gereksinim paketi kullanmadan elle kurulum yapmak iin gerekli ilemlerin neler olduunu ve yapmamz gereken ayarlar inceledik. Oracle Enterprise Linux 6. Oracle n gereksinim 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. New password Retype new password passwd all authentication tokens updated successfully. 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 atayacamzdeer aadaki gibi olmaldr. Fazla atanmas sorun deildir. Deiiklii hemen devreye almak iin mount devshmkomutunu altryoruz. Eer kurulum bitiminde Secure Linux ve Firewall zelliini kapatmamsak bunlar kapatyoruz. SELINUXdisabled Parametresini yukardaki gibi kapal duruma getiriyoruz. Firewall Servisini kapatmak iin aadaki komutlar altryoruz. Oracle kurulumlarn yapabilmek, kurulum ve patch dosyalarmz koyabilmek iin gerekli olan dizinleri yaratp haklar atyoruz. R oracle oinstall u. R 7. 75 u. 01. Oracle 1. Yani mevcut oracle dizinleriharicinde bir dizine kurulum yaplarak mevcut dizinleri bozmadanykseltme imkanmz oluyor bu yzden dizinler oluturulurkenu. Oracle Veritaban iin deikenlerimizi. Oracle kullancsna gei yapyoruz. Dosyasna aadaki deikenleri giriyoruz. Oracle bashprofile Environment Settings. TMPtmp export TMPTMPDIRTMP export TMPDIRORACLEHOSTNAMEkoraykey ol. ORACLEHOSTNAMEORACLEUNQNAMEorcl export ORACLEUNQNAMEORACLEBASEu. ORACLEBASEDBHOMEORACLEBASEproduct1. DBHOMEORACLEHOMEDBHOME export ORACLEHOMEORACLESIDorcl export ORACLESID. ORACLEHOMELISTNERORACLEHOME export ORACLEHOMELISTNER. ORACLETERMxterm export ORACLETERMBASEPATHusrsbin PATH export BASEPATHPATHORACLEHOMEbin PATH ORACLEHOMEOPatch BASEPATH export PATHLDLIBRARYPATHORACLEHOMElib lib usrlib export LDLIBRARYPATHCLASSPATHORACLEHOMEJRE ORACLEHOMEjlib ORACLEHOMErdbmsjlib export CLASSPATHif USER oracle then if SHELL binksh then ulimit p 1. Kuruluma geebilmemiz iin ftp yada baka bir yntem ile kurulum dosyalarmz oluturduumuz u. Eer sunucumuzda ftp server zellii aktif edilmemise Linux letim Sistemlerinde HTTP ve FTP Server Yaplandrmas makalemizden faydalanarak gerekli ayarlar yapabiliriz. Oracle kullancs ile kopyalama ilemimiz bittiinde kurulum dosyalarmz kontrol ediyoruz. Linux x. 86 6. 41of. Linux x. 86 6. 42of. Dosyalar zerinde gerekli haklar veriyoruz. Oracle Database kurulumu iin ilk 2. Bu kurulum dosyalarmz OTN veya MOS hesaplarmz ile indirebiliriz. Eer son versiyon kurulumu yapabilmek istiyorsak 1. MOS dediimiz Oracle Support yeliimizin olmas gerekmektedir. Eer buna sahip deilsek o zaman OTN hesabmz ile km olan ilk versiyonu 1. Linux x. 86 6. 41of. Linux x. 86 6. 42of. Ayklama ilemi tamamlandnda yer kaplamamas iin istersek. Applying CPU patch on Data. Guard Physical Standby Configuration. Applying CPU Patch in a Data. Guard Physical Standby Database Configuration. Adding Hulu To Hisense more. I seen lot of questions in OTN on patching of Data. Guard, Recently I have applied CPU Patch on production database, I like to give step by step procedure how to apply CPUJAN2. Standby is in MAXIMUM PERFORMANCE Mode with Data Broker Enabled. When managing with broker, there are some steps which we need to manage with Broker instead of SQL. Which is highly recommended, If not there may be issues in Broker configuration. In Primary disable log shipping to the standby Stop MRP on standby 2. Shutdown Standby Database Listener 3. Install CPU patch on Standby 4. Shutdown Primary database Listener. Apply Patch on Primary Run Post installation Scriptscatbundle. Re enable Log shipping on Primary 7. Monitor the redo apply from Primary to Standby. Environment SQL select from vversion. Oracle Database 1. Enterprise Edition Release 1. Production. PLSQL Release 1. Production. CORE    1. Production. TNS for Linux Version 1. Production. NLSRTL Version 1. Production. SQL oracleprimary  file binlsbinls ELF 6. LSB executable, AMD x. SYSV, for GNULinux 2. GNULinux 2. 6. 9, stripped. Opatch Version. To apply CPUJan. OPatch utility version 1. Oracle recommends that you usethe latest released OPatch 1. My Oracle Support patch 6. PATHu. 00apporacleproduct1. OPatch PATH. oracle ckpt. Invoking OPatch 1. Oracle Interim Patch Installer version 1. Copyright c 2. 00. Oracle Corporation. All rights reserved. Oracle Home       u. Central Inventory u. Inventory. from           etcora. Inst. loc. OPatch version    1. OUI version       1. OUI location      u. Log file location u. AM. log. Patch history file u. Lsinventory Output file location u. AM. txt. 1 In Primary disable log shipping to the standby Stop MRP on standbyoracleprimary dgmgrl. DGMGRL for Linux Version 1. Production. Copyright c 2. Oracle. All rights reserved. Welcome to DGMGRL, type help for information. DGMGRL edit database PSPRIM set stateLOG TRANSPORT OFF. DGMGRL Check the remote destination Status oracleprimary sqlplus as sysdba. SQLlus Release 1. Production on Sat Apr 2. Copyright c 1. 98. Oracle.   All rights reserved. Oracle Database 1. Enterprise Edition Release 1. Production. With the Partitioning, OLAP, Data Mining and Real Application Testing options. SQL show parameter deststate2. NAME                     TYPE     VALUE. RESETCheck the Archive Log status  ID STATUS    DBMODE         TYPE RECOVERYMODE       PROTECTIONMODE     SRLs ACTIVE      ARCHIVEDSEQ. VALID     OPEN          ARCH IDLE            MAXIMUM PERFORMANCE   0      0     0. DEFERRED  MOUNTED STANDBY LGWR MANAGED REAL TIME APPLY MAXIMUM PERFORMANCE   1. Shutdown Standby Database Listener oraclestandby ps efgrep pmon. Take Backup of ORACLEHOME Inventory on Standbyoraclestandby tar zcpvf  1. HomeInventoryBackupdate Ymd. Inventory. u. 00apporacleproduct1. Inventory. u. 00appora. Inventoryora. Installer. Inventoryinstall. Inventoryorainst. Root. sh. u. 00appora. Inventoryoui. u. Inventoryouisrcs. Inventorylogs. u. InventorylogsOPatch. PM. log. u. 00appora. Inventorylogsora. Install. 20. 11 0. AM. out. u. 00appora. Inventorylogsinstall. Actions. 20. 11 0. AM. log. u. 00appora. Inventorylogsora. Install. 20. 11 0. AM. err. u. 00appora. Inventoryora. Inst. InventoryContents. XML. u. 00appora. InventoryContents. XMLcomps. xml. u. InventoryContents. XMLlibs. xml. u. InventoryContents. XMLinventory. xml. Install CPU patch on Standbyoraclestandby opatch napply skipsubset skipduplicate. Invoking OPatch 1. Oracle Interim Patch Installer version 1. Copyright c 2. 00. Oracle Corporation. All rights reserved. Oracle Home       u. Central Inventory u. Inventory. from           etcora. Inst. loc. OPatch version    1. OUI version       1. OUI location      u. Log file location u. PM. log. Patch history file u. Install Cracked Ipod Click Wheel Games'>Install Cracked Ipod Click Wheel Games. Invoking utility napply. Checking conflict among patches. Checking if Oracle Home has components required by patches. Checking skipduplicate. Checking skipsubset. Checking conflicts against Oracle Home. OPatch continues with these patches   1. Do you want to proceed User Responded with Y. Running prerequisite checks. OPatch detected non cluster Oracle Home from the inventory and will patch the local system only. Please shutdown Oracle instances running out of this ORACLEHOME on the local system. Oracle Home u. Is the local system ready for patching User Responded with Y. Backing up files affected by the patch NApply for restore. This might take a while. Applying patch 1. Apply. Session applying interim patch 1. OH u. 00apporacleproduct1. Backing up files affected by the patch 1. This might take a while. Verifying the update. Inventory check OK Patch ID 1. Oracle Home inventory with proper meta data. Files check OK Files from Patch ID 1. Oracle Home. Applying patch 1. Apply. Session applying interim patch 1. OH u. 00apporacleproduct1. Apply. Session Optional components oracle. Oracle Home or a higher version is found. Backing up files affected by the patch 1. This might take a while. Patching component oracle. Updating archive file u. Patching component oracle. Apply. Session adding interim patch 1. Verifying the update. Inventory check OK Patch ID 1. Oracle Home inventory with proper meta data. Files check OK Files from Patch ID 1. Oracle Home. Applying patch 1. Apply. Session applying interim patch 1. OH u. 00apporacleproduct1. Backing up files affected by the patch 1. This might take a while. Verifying the update. Inventory check OK Patch ID 1. Oracle Home inventory with proper meta data. Files check OK Files from Patch ID 1. Oracle Home. Running make for target clientsharedlib. Running make for target clientsharedlib. Running make for target ioracle. The local system has been patched and can be restarted. Util. Session N Apply done. OPatch succeeded. Start Standby database in mount status. SQL startup mount. Total System Global Area 3. E1. 0 bytes. Fixed Size            2. Variable Size         2. E1. 0 bytes. Database Buffers     9. Redo Buffers           5. Database mounted. SQL Data. Guard Broker enabled, So MRP will be started automatically, No need to start MRP manually. Shutdown Primary database Listener. Smart Notebook 10 Activation more. Take Backup of ORACLEHOME Inventory on PrimaryoraclePrimary tar zcpvf  1. HomeInventoryBackupdate Ymd. Inventory. u. 00apporacleproduct1. Inventory. u. 00appora. Inventoryora. Installer. Inventoryinstall. Inventoryorainst. Root. sh. u. 00appora. Inventoryoui. u. Inventoryouisrcs. Inventorylogs. u. InventorylogsOPatch. PM. log. u. 00appora. Inventorylogsora. Install. 20. 11 0. AM. out. u. 00appora. Inventorylogsinstall. Actions. 20. 11 0. AM. log. u. 00appora. Inventorylogsora. Install. 20. 11 0. AM. err. u. 00appora. Inventoryora. Inst. InventoryContents. XML. u. 00appora. InventoryContents. XMLcomps. xml. u. InventoryContents. XMLlibs. xml. u. InventoryContents. XMLinventory. xml. Apply Patch on Primary Run Post installation Scriptscatbundle. PATHORACLEHOMEOPatch PATH. ORACLEHOME. Patches 1.