MySQL Enterprise Manager Installation on RHEL/OEL/CentOS 6.X


Assalamu'alaikum ..I want to share my experience about installation MySQL Enterprise Manager on Linux, actually Oracle Enterprise Linux 6.5, ya it is similar with Redhat and CentOS on same version. If you used to Oracle DB, of course you are familiar with Oracle Enterprise Manager cloud control, express, and dbconsole. Ya this MySQL Enterprise Manager… Continue reading MySQL Enterprise Manager Installation on RHEL/OEL/CentOS 6.X

Advertisements

Increase /dev/shm tmpfs on RHEL/CentOS/OEL 7


Assalamu'alaikum Wr. Wb. Oracle database uses /dev/shm for its memory target allocation. So, if space of /dev/shm is running out to allocate memory_target, Oracle will failed to startup and shown ORA-00845: MEMORY_TARGET not supported on this system. By default, CentOS 7.4.1708 as my Oracle DB platform allocate only 1.4GB /dev/shm. So I have to increase… Continue reading Increase /dev/shm tmpfs on RHEL/CentOS/OEL 7

scsi_id Not Shown Any Output on VMWare 12.5.X

It Works

Assalamu'alaikum Wr. Wb. My machine running CentOS Linux release 7.4.1708 (Core) on VMWare Workstation 12.5.3 Ubuntu. When I tried to create Oracle ASM disk with udev, no scsi_id output on everydisk. So, how could I create ASM disk? Let's solve scsi_id first. Okay, I tried for /dev/sda: /usr/lib/udev/scsi_id -g -u -d /dev/sda and no output.… Continue reading scsi_id Not Shown Any Output on VMWare 12.5.X

Migration Oracle ASM to File System Different Host


Assalamu'alaikum .. How to migration Oracle Database 11G ASM to other machine in file system? Source: Oracle Database Enterprise 11.2.0.4 64-bit Linux (ASM) Target: Oracle Database Enterprise 11.2.0.4 64-bit Linux (File System). Step 1: Backup source database using RMAN Step 2: Create pfile from Source DB SQL> CREATE PFILE='/home/orekel/rmanBackup/initasem.ora' from spfile'; Note: The target has… Continue reading Migration Oracle ASM to File System Different Host

Increase memory_target on Oracle DB 12c Linux ORA-00845: MEMORY_TARGET not supported on this system


Increase memory_target on Oracle DB 12c Linux ORA-00845: MEMORY_TARGET not supported on this system Aziz Prastyo Wibowo Assalamu'alaikum Wr. Wb. In this moment I will share how to resolve error ORA-00845: MEMORY_TARGET not supported on this system when I tried to increase memory target on Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit under… Continue reading Increase memory_target on Oracle DB 12c Linux ORA-00845: MEMORY_TARGET not supported on this system