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 p

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