Category Archives: Articles

ORACLE ADVANCE REPLIKASI

ORACLE ADVANCE REPLIKASI

Seandainya kita memiliki kantor cabang dan diinginkan untuk mengetahui perubahan transaksi yang terjadi di kantor cabang. Selain itu kantor pusat sesekali harus juga mengupdate data kantor cabang sedangkan jaringan yang menghubungkan antara kantor cabang dan pusat terbatas bandwidth dan performancenya (sering putus), maka salah satu solusinya adalah menggunakan Oracle advance replikasi. Berikut acuan untuk prosedur instalasi Oracle 10g advance replikasi, pada contoh di bawah ini 2 site akan memiliki data yang sama pada interval tertentu. Pada pembahasan ini tidak disertakan konfigurasi VPN.

Download Complete File

Setijo Agus

Grid Computing with Oracle Database 11g

Sponsored by: Oracle Corporation

Carl W. Olofson
March 2008


IDC OPINION

The IT world is in the midst of a sea change in how computing resources are
managed. The previously normative models based on program code assigned to
fixed assets are being replaced by models based on flexible code deployment and
resource assignment. A new model has emerged based on a shared infrastructure,
where the underlying physical hardware is abstracted from the application and logical
resources built by aggregating or disaggregating the physical resources that are used
for application deployment. This shared infrastructure, also known as grid computing,
provides many benefits to today’s IT operations. The benefits of grid computing in
general, and Oracle’s exploitation of it in Oracle Database 11g, are:

  • Ending the paralysis that results from having computer and storage systems locked down on specific applications, databases, and files
  • Enabling operations and administrative staff to flexibly assign compute and storage resources as needed, enabling them to avoid locked-down and overprovisioned resources
  • Providing a means for easily assigning and tuning resources to meet the business’ service levels
  • Reducing cost and enhancing business agility by more effective utilization of resources using commodity hardware

Baca lebih lanjut

White Paper – Oracle Grid Computing

Oracle Grid Computing

An Oracle Business White Paper

May 2008

 

Oracle Grid Computing

INITRODUCTION

Enterprise grid computing is an emerging information technology (IT) architecture that delivers more flexible, resilient and lower cost enterprise information systems. With grid computing, groups of independent, modular hardware and software components can be pooled and provisioned on demand to meet the changing needs of businesses. The accelerating adoption of grid technology is in direct response to the challenges that IT organizations face with today’s rapidly changing and unpredictable business cycles. IT departments are under pressure to increase operational agility, to establish and meet IT service levels and to control costs. Using enterprise grid computing technology IT departments can adapt to rapid changes in the business environment while meeting higher service levels. Enterprise grid computing has also revolutionized IT economics by both extending the life of existing systems and exploiting rapid advances in processing power, storage capacity, network bandwidth, as well as energy and space efficiency. Oracle first introduced grid computing capabilities in the Oracle Database and Application Server in the year 2003 and continues to lead the software industry in its commitment to grid computing products and practices. With the current releases of the Oracle Database and Oracle Fusion Middleware products, Oracle has introduced a second generation of grid computing capabilities that build on Oracle’s strong foundation of scalable, fault-tolerant database and middleware clusters, virtualized computing and storage resources, and highly automated endto-end application and business process management.

WHAT IS GRID COMPUTING? Baca lebih lanjut

STANDARD PRACTICE – swingbench

STANDARD PRACTICE

swingbench

 

Oleh              : Setijo Agus

  

I.    Tujuan

Sebagai acuan untuk prosedur pengukuran response time database oracle dengan menggunakan swingbench pada o/s linux Oracle Enterprise Linux 5.

 

II. Cara Pengerjaan

1.     Swingbench adalah free load generator yang ditulis dengan Java oleh Dominic Giles yang bekerja di Oracle UK.

SH – Sales History application based on the Oracle-supplied SH schema. A read-only benchmark.

CC and SOE – OLTP-type applications

Stress Test – basic INSERT/UPDATE/DELETE/SELECT test.

2.     File dapat di download di http://www.dominicgiles.com/downloads.html

3.     Dapatkan swingbench yang terakhir, misalnya : swingbench230376.zip

4.     Extract Swingbench

[oracle@test ~]$ pwd

/home/oracle

[oracle@test ~]$ unzip  /u01/backup/swingbench230376.zip

5.     download juga java, saya menggunakan jre-6u5-linux-i586-rpm.bin

[oracle@test ~]$ su – root

[root@test ~]# chmod a+x jre-6u5-linux-i586-rpm.bin

[root@test ~]# ./jre-6u5-linux-i586-rpm.bin

[root@test ~]# rpm -ivh jre-6u5-linux-i586.rpm

6.       edit environtment Swingbench

[oracle@test ~]$ pwd

/home/oracle

[oracle@test ~]$ cd swingbench

[oracle@test swingbench]$ pwd

/home/oracle/swingbench

[oracle@test swingbench]$ vi swingbench.env

7.       Environtment Swingbench, yang perlu diedit adalah (sesuaikan dengan mesin anda)

export JAVAHOME=/usr/java/jre1.6.0_05

export SWINGHOME=/home/oracle/swingbench

8.      Menyiapkan test, pada kasus ini saya ingin melakukan test order entry, dimana pembuatan tablespace, schema dan user telah disiapkan oleh swingbench.

[oracle@test swingbench]$ cd bin/

[oracle@test bin]$ pwd

/home/oracle/swingbench/bin

[oracle@test bin]$ ./oewizard

Untuk lengkapnya silahkan download : 170-ubs-sp-swingbench_1

 

sqlplus / as sysdba

Secara default pada server oracle database, jika anda connect menggunakan user yang memilki role “SYSDBA”
atau tanpa menggunakna user maupun password seperti berikut:
sqlplus / as sysdba
sqlplus usersembarang/passwordterserah as sysdba
maka akan berhasil terotentikasi.
Hal tersebut karena default SQLNET.AUTHENTICATION_SERVICES adalah NTS
Jika tidak ada entri pada {ORACLE_HOME}/network/admin/sqlnet.ora untuk SQLNET.AUTHENTICATION_SERVICES,
maka yang digunakan adalah default (NTS).
Artinya jika anda telah diotentikasi di level sistem operasi untuk account DBA, maka otomatis telah terotentikasi.
Bagaimana kalau anda ingin merubah metode otentikasi seperti di atas?
Caranya dengan merubah entri pada {ORACLE_HOME}/network/admin/sqlnet.ora menjadi :
SQLNET.AUTHENTICATION_SERVICES=NONE
maka jika anda akan log in sebagai user dengan role sysdba harus menyertakan user dan password yang benar,
jika tidak akan di tolak, sbb.:
SQL> connect /as sysdba
ERROR:
ORA-01031: insufficient privileges
Salam
Bukhari Yahya

ORA-00845: MEMORY_TARGET not supported on this system

tahukah anda :

pada saat mengatur memory di oracle 11g linux khususnya parameter
memory_target misalkan diinginkan memory_target = 2,5 G, saya menemukan
error :
SQL> ORA-00845: MEMORY_TARGET not supported on this system

ternyata hal itu berhubungan dengan /dev/shm, artinya /dev/shm tidak
dikonfigurasi dengan nilai yang cukup untuk mengalokasikan parameter
memory_target.

[root@rac1 ~]# df -h
Filesystem Size Used Avail Use% Mounted on
……… —- —- —– —- ———-
tmpfs 1.8G 1.0G 747M 74% /dev/shm
……… —- —- —– —- ———-

maka langkah yang harus dilakukan adalah :

1. periksa apakah /dev/shm masih ada isisnya ?, jika ya sebaiknya
instance database sudah di shutdown
[root@rac1 ~]# ls /dev/shm
……… —————————
ora_rac1_491529_0 ora_rac1_491529_1 ora_rac1_491529_10
……… —————————

2. umount tmpfs dan buat yang baru
[root@rac1 ~]# umount tmpfs
[root@rac1 ~]# mount -t tmpfs shmfs -o size=2663m /dev/shm
[root@rac1 ~]# df -h
Filesystem Size Used Avail Use% Mounted on
……… —- —- —– —- ———-
shmfs 2.7G 2.0G 622M 77% /dev/shm
……… —- —- —– —- ———-

3. supaya setiap kali reboot dijalankan, biasanya dipasang di
/etc/rc.d/rc.local
#!/bin/sh
#
# This script will be executed *after* all the other init scripts.
# You can put your own initialization stuff in here if you don’t
# want to do the full Sys V style init stuff.

touch /var/lock/subsys/local
umount tmpfs
mount -t tmpfs shmfs -o size=2663m /dev/shm

4. misalkan diinginkan memory_target = 2,5 G
SQL> show parameter memory
NAME TYPE VALUE
————————————————-
hi_shared_memory_address integer 0
memory_max_target big integer 2512M
memory_target big integer 2512M
shared_memory_address integer 0

by Setijo Agus

Oracle 11g mengubah mode Archive

Tahukah anda mengubah mode No Archive Mode menjadi Archive Mode, di RAC ????

Berikut langkah – langkahnya :

1. periksa database dalam mode apa ?
[oracle@rac2 ~]$ sqlplus sys@rac2 as sysdba
SQL*Plus: Release 11.1.0.6.0 – Production on Sat Mar 22 15:53:25 2008
Copyright (c) 1982, 2007, Oracle. All rights reserved.
Enter password:
Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 – Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options

SQL> archive log list;
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination /u01/app/oracle/product/11.1.0/db_1/dbs/arch
Oldest online log sequence 733
Current log sequence 734

2. pada contoh database belum dlm mode archive. Tentukan posisi archive
misal dalam contoh di /u03
SQL> alter system set log_archive_dest_1=’location=/u03′;
System altered.

3. periksa ulang dengan command archive log list
SQL> archive log list;
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination /u03
Oldest online log sequence 733
Current log sequence 734
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release
11.1.0.6.0 – Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options

4. matikan instance database dengan perintah srvctl
[oracle@rac2 ~]$ srvctl stop database -d rac

5. mounting salah satu node, dalam contoh ada 2 node rac1 dan rac2,
dimana rac1 di start sedangkan rac2 tidak dengan option startup mount.
[oracle@rac2 ~]$ srvctl start instance -d rac -i rac1 -o mount

6. ubah database menjadi mode archivelog
[oracle@rac2 ~]$ sqlplus sys@rac1 as sysdba
SQL*Plus: Release 11.1.0.6.0 – Production on Sat Mar 22 16:09:56 2008
Copyright (c) 1982, 2007, Oracle. All rights reserved.
Enter password:
Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 – Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
SQL> alter database archivelog;
Database altered.

7. periksa mode archive
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /u03
Oldest online log sequence 876
Next log sequence to archive 877
Current log sequence 877
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release
11.1.0.6.0 – Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options

8. restart instance database
[oracle@rac2 ~]$ srvctl stop database -d rac
[oracle@rac2 ~]$ srvctl sart database -d rac

by Setijo Agus