Enterprise Manager Error (OC4J is not found)


Masih ditempat klien yang sama salah satu bank terpenting di Indonensia =p, saya sedang coba installasi oracle database 10g di
kemudian pada saat saya akan melakukan startup enteprise manager terdapat error dan tidak mao running (oc4j is not found).
setelah tanya sana sini akhirnya ketemu solusinya hehehe :

– coba cek /etc/hosts pastikan ip dan nama tercantum sesuai dengan hostname pada saat installasi

– cek .bash_profile pastikan ORACLE_SID dan ORACLE_HOME sudah benar

– pastikan kembali dengan menjalankan $ env more

Continue reading

Advertisements

ORA-01078: failure in processing system parameters


Beberapa waktu lalu, saya sedang coba installasi oracle database 10g di salah satu bank terpenting di Indonensia =p
kemudian pada saat saya aka melakukan startup database bertemu dengan error ORA-01078.

[oracle@siddb-drc ~]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.5.0 – Production on Wed Oct 6 15:24:15 2010

Copyright (c) 1982, 2010, Oracle.  All Rights Reserved.

Connected to an idle instance.

Continue reading

Oracle export and import


Oracle export and import This is a featured page
Prerequisites/Requirements :

exp and imp are utilities present in the $ORACLE_HOME/bin directory and are installed when Oracle is installed. Their prime purpose is to move logical objects out of and into the database respectively – for example dumping all of the tables owned by a user to a single file is achieved using the exp utility. It is important to distinguish between dumping data in this manner and backing up the database which is normally achieved using the rman utility.
Starting with Oracle 10g these two utilities are deprecated and the Oracle recommended alternatives are the data pump versions of these utilities which provide a number of new features including the ability to disconnect and reconnect to an interactive session (so a direct logon to the server isn’t required) and improved performance. There are still a number of things that cannot be achieved with the data pump utilities – in particular exporting/importing across a named pipe which is a technique used by database administrators when the export file needs to be compressed on the fly or when one wishes to export directly to an import session.
Continue reading

Requirements Environment For Installing Oracle11gR2 On AIX OS 5L-6.1 64Bit


AIX OS

(32- and 64-bit stands for Oracle not OS)

AIX 5L V5.3 TL 09 SP1 (“5300-09-01”), 64 bit kernel (Part Number E10854-01), AIX 6.1 TL 02 SP5 (“6100-02-05”), 64-bit kernel

AIX Disk Space

6.45G Database
1.6G Software


AIX RAM (Minimum)

4GB

Continue reading

Requirements Environment For Installing Oracle10gR2 On RHEL 5/OEL 5 (x86_64)


1. Hardware Requirements

i) Physical Memory

At least 1GB of physical RAM is required. To determine the physical RAM size, enter the following command

ii) Swap Space

The following table describes the relationship between installed RAM and the configured swap space requirement.

RAM Swap Space
Between 1024 MB and 2048 MB 1.5 times the size of RAM
Between 2049 MB and 8192 MB Equal to the size of RAM
More than 8192 MB 0.75 times the size of RAM

Continue reading

Requirements Environment For Installing Oracle11gR2 On RHEL 5/OEL 5 (x86_64)


Memory Requirements (Swap)

The following are the memory requirements for installing Oracle Database 11g Release 2 (11.2):

  • At least 4 GB of RAM
  • Swap require :
Available RAM Swap Space Required
Between 4 GB and 8 GB 2 times the size of RAM
Between 8 GB and 32 GB 1.5 times the size of RAM
More than 32 GB 32 GB

Disk Space Requirements

The following are the disk space requirements for installing Oracle Database 11g Release 2 (11.2):

  • At least 1 GB of disk space in the /tmp directory
  • The following tables describe the disk space requirements for software files, and data files for each installation type on Linux x86-64:

Continue reading

Kiat Mempersiapkan Diri Jadi DBA Oracle


Banyak yang bertanya pada saya, terutama teman-teman yang mau lulus kuliah, “Gimana kiat-kiat mempersiapkan diri untuk jadi DBA Oracle. Dengan kata lain, Gimana sih caranya menggapai cita-cita jadi DBA Oracle?”

Saran saya:

  1. Belajar sendiri Database Oracle
  2. Ambil Training Database Oracle
  3. Ambil sertifikat Database Oracle
  4. Ikut milis dan forum Oracle di internet

Belajar sendiri Database Oracle

Belajar sendiri juga tidak terlalu susah, bagi yang mau. Untuk guide awalnya, bisa search di blog-blog atau arikel yang menulis Cara Belajar Database Oracle secara Otodidak.

Continue reading