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

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