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

Change Hostname on CentOS/RHEL/OEL 7


Assalamu'alaikum Wr. Wb. My machine running CentOS Linux release 7.3.1611 (Core). There are some different between redhat based version under 7 and and above 6, include the commands. In this case, I wanna change the hostname from jeruk.buah.net to rhino.animal.net. At the redhat based version under 7, I can change by /etc/sysconfig/network. So, how about… Continue reading Change Hostname on CentOS/RHEL/OEL 7

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