Oracle Database 12c Password File

Posted on by Ahmed Abdel Fattah

Introduction: I (and we) used to see the oracle database password file under $ORACLE_HOME/dbs for both single instance and RAC databases. Example for RAC database: On node1 /u01/app/oracle/product/11.2.0/dbhome_1/dbs/orapwPROD1 On node2 /u01/app/oracle/product/11.2.0/dbhome_1/dbs/orapwPROD2 If one password file was changed in one node, then you have to copy it to all other nodes in the cluster. What is … Continue reading Oracle Database 12c Password File

Installing Oracle Apex 5.1.4 on Oracle Database 12c R2

Posted on by Ahmed Abdel Fattah

This is a quick post on how to install Oracle Apex version 5.1.4 on Oracle Database 12.2 on Windows platform. 12cR2 Update: From Oracle Database 12c Release 2 (12.2) onward APEX is not installed by default, so you no longer need to worry about uninstalling APEX before creating PDBs. The software is still shipped with … Continue reading Installing Oracle Apex 5.1.4 on Oracle Database 12c R2

Oracle Database 12c R2 Partitioning New Features – Automatic List Partitioning

Posted on by Ahmed Abdel Fattah

Oracle Database 12.2 introduces new nice and powerful partitioning features. This post will introduce one of them “Automatic List Partitioning”. We may talk about other features in future posts. Before 12.2, if you have a list partitioned table in specific discrete values, and there is a need to add a new list value, then you … Continue reading Oracle Database 12c R2 Partitioning New Features – Automatic List Partitioning