Posts

Showing posts from October, 2016

Drop/remove Far-Sync Configurations from broker 12.1

Image
Show current overall configuration
DGMGRL> show configuration

Configuration - dr

 Protection Mode: MaxAvailability

 Members:
 PRMRY - Primary database
   FRSNC - Far sync instance
     STNDBY - Physical standby database

Fast-Start Failover: DISABLED

Configuration Status:
SUCCESS   (status updated 49 seconds ago)

Show current Primary redo routes settings
DGMGRL> show database PRMRY RedoRoutes  RedoRoutes = '(LOCAL : FRSNC SYNC)'

Changing to MAXPERFORMANCE to be able  to modify the RedoRoutes

DGMGRL> EDIT CONFIGURATION SET PROTECTION MODE AS MAXPERFORMANCE;
Succeeded.

Replace Primary RedoRoutes to point to Standby instead of Far Sync
DGMGRL> edit database PRMRY set property RedoRoutes='(LOCAL : STNDBY SYNC)';
Property "redoroutes" updated

Show current Standby redo routes settings
DGMGRL> show database STNDBY RedoRoutes
 RedoRoutes = '(LOCAL : FRSNC SYNC)'

Replace Standby RedoRoutes to point to Primary instead of Far Sync
DGMGRL> edit database STNDBY set prop…

Ubuntu Oracle Instant Client

Image
Step by step for installing instant client 12.1

Install RPMs

1. Download Oracle Instant client RPM files from http://www.oracle.com/technetwork/topics/linuxx86-64soft-092277.html
Download "Basic lite", and "SQL*Plus".

2. Convert these .rpm files into .deb packages and install using "alien"
("sudo apt-get install alien" if you don't have it).

alien -i oracle-instantclient12.1-basiclite-12.1.0.2.0-1.x86_64.rpm
alien -i oracle-instantclient12.1-sqlplus-12.1.0.2.0-1.x86_64.rpm
3. Test your Instantclient install by using "sqlplus" to connect to your database:

sqlplus username/password@//dbhost:1521/SID

Integrate Oracle Libraries & ORACLE_HOME

Add the Oracle libraries to the LD_LIBRARY_PATH to the system library list create a new file as follows:

sudo vi /etc/ld.so.conf.d/oracle.conf && sudo chmod o+r /etc/ld.so.conf.d/oracle.conf
and add the oracle library path as the first line:

/usr/lib/oracle/12.1/client64/lib/
Then run ldcon…