Install Oracle Restart 12.2 on single node

This is how I installed Oracle Grid Infrastructure 12.2.0.1 on a single node without ASM to enable Oracle Restart for single database instances. Oracle Database 12.1.0.2 is already installed which means most required Linux packages and settings are already in place. Operatingsystem: RedHat Linux Enterprise 7 ORACLE_BASE: /u01/app/oracle ORACLE_DB_HOME: /u01/app/oracle/product/12.1.0/dbhome1 Step1: Download Oracle Grid Infrastructure … More Install Oracle Restart 12.2 on single node

Setup Oracle Streams Replication using dbms_streams_adm.maintain_tables with different table rules

I want to setup an Oracle Streams Replication for a selected set of tables in one or more schemas. I also want to have different DML rules assigned like excluding DELETE statements from replication on some tables to keep them as historical tables of the source while other tables are being continuously synchronized 1:1. My setup … More Setup Oracle Streams Replication using dbms_streams_adm.maintain_tables with different table rules

Oracle Advanced Security

A very nice product from Oracle that I have came across far too seldom. Maybe Oracle’s pricing model is the issue? Advanced Security is only available for Enterprise edition as a separate licensed option. Here is a list of all separate licensed options: http://download.oracle.com/docs/cd/E11882_01/license.112/e10594/options.htm#CIHDDBCG A new feature as of Oracle 11gR1 is TABLESPACE ENCRYPTION taking … More Oracle Advanced Security

Rebuild Oracle11g Clusterware Configuration

If you are unable to recreate RAC cluster services using srvctl only ending up with unrecoverable errors, you might want to consider rebuilding your cluster configuration from scratch. This post is how to do this by removing your current configuration and create it using your install scripts “root.sh”. In this example I’m using 2 clusternodes … More Rebuild Oracle11g Clusterware Configuration