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

Advertisements

scsi_id Not Shown Any Output on VMWare 12.5.X


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

DISABLING/MENONAKTIFKAN SQLPLUS / AS SYSDBA


HOW TO DISABLING SQLPLUS / AS SYSDBA IN ORACLE DATABASE Assalamu'alaikum Wr. Wb. Saya akan berbagi pengalaman bagaimana cara untuk menonaktifkan sqlplus / as sysdba pada database oracle. Mengapa butuh dinonaktifkan? karena masalah keamanan. Apabila kita masuk ke user OS yang tergabung dalam grup dba atau oinstall, biasanya kita dapat langsung masuk ke user SYS… Continue reading DISABLING/MENONAKTIFKAN SQLPLUS / AS SYSDBA