Oracle Performance Tuning : Best Practices by Agile Support Team | May 16, 2013 Introduction and Background Information Oracle has been designed to be a portable database. It is available on every platform from Windows to UNIX to mainframes. Oracle architecture is adequately generalized that you can get a good understanding of how it works …
ORACLE INSTALLATION 11gR2 ON FEDORA : ===================================== Guidance ini juga bisa digunakan untuk instalasi Oracle 10g atau 11g di Operating Sistem Linux Redhat, Fedora, Centos, Mandriva 1. Ekstrak file Oracle unzip linux.x64_11gR2_database_1of2.zip unzip linux.x64_11gR2_database_2of2.zip 2. Rubah File /etc/hosts <IP-address> <fully-qualified-machine-name> <machine-name> 3. /sbin/sysctl -a Rubah di = “/etc/sysctl.conf” fs.aio-max-nr = 1048576 fs.file-max = 6815744 …
Step by Step Cara Instalasi Database Oracle 10g atau 11g di Linux Red Hat atau Fedora Read More »
Everybody who has the experience in ORACLE PL/SQL must have fall in love with TOAD. Unfortunately there is no TOAD in MAC OS. But wait… Right now, there is! You can do some TOAD from Eclipse Plugin and it has all the functionalities like TOAD in Windows. It can connect directly to ORACLE and also …
Using Quest TOAD for ORACLE and PostgreSQL in MAC OS X Read More »
Berikut ini adalah tahapan yang pernah saya lakukan dulu (waktu masih jaman 9i ke 10g, sekarang 11gR2 loh…) untuk melakukan Proses migrasi Oracle9i ke Oracle10g ke server yang berbeda dengan ZERO downtime di salah satu environment yang saya gunakan. Harap disesuaikan jika akan digunakan sebagai panduan untuk melakukan migrasi di tempat anda. Asumsi kondisi yang …
Mekanisme Migrasi dan Upgrade ORACLE ke Server lain dengan ZERO Downtime Read More »
