Showing posts with label oracle. Show all posts
Showing posts with label oracle. Show all posts

Tuesday, April 19, 2016

ggsci: error while loading shared libraries: /u01/app/oracle/ggqp/libclntsh.so.10.1: cannot restore segment prot after reloc: Permission denied

[ggsadmin@qpdb200 ggqp]$ ./ggsci

./ggsci: error while loading shared libraries: /u01/app/oracle/ggqp/libclntsh.so.10.1: cannot restore segment prot after reloc: Permission denied

Solution in my case :
 
set selinux off

Monday, April 18, 2016

Install pre 12c version of Goldengate Software


**************************************************************************************************************
PREVIOUSLY VERSION PRE 11.2 WE HAD TAR FILE WHICH WE HAVE TO UNTAR:
**************************************************************************************************************

$ unzip V18159-01.zip
Archive: V18159-01.zip
inflating: ggs_redhatAS50_x64_ora11g_64bit_v10.4.0.19_002.tar

$tar -xvof ggs_redhatAS50_x64_ora11g_64bit_v10.4.0.19_002.tar

$ export PATH=$PATH:/u01/oracle/ggs
$ export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/u01/oracle/ggs

$ ggsci
Oracle GoldenGate Command Interpreter for Oracle
Version 10.4.0.19 Build 002
Linux, x64, 64bit (optimized), Oracle 11 on Sep 17 2009 23:51:28
Copyright (C) 1995, 2009, Oracle and/or its affiliates. All rights reserved.

GGSCI (redhat346.localdomain) 1>

Install GoldenGate Software - STEP-3


I Have already downloaded GoldenGate software and copied ot GGHOME Directory

 [gguser@Linux03 GGHOME]$ echo $GGHOME
/u01/app/GGHOME
[gguser@Linux03 GGHOME]$ cd $GGHOME
[gguser@Linux03 GGHOME]$ pwd
/u01/app/GGHOME

UNZIPING OGG SOFTWARE:

[gguser@Linux03 GGHOME]$ ls -al
total 464476
drwxrwxr-x. 2 gguser gguser        4096 Apr 13 14:44 .
drwxrwxr-x. 7 oracle oinstall      4096 Apr 13 14:40 ..
-rw-rw-r--. 1 gguser gguser   475611228 Apr 13 14:44 fbo_ggs_Linux_x64_shiphome.zip
[gguser@Linux03 GGHOME]$ unzip fbo_ggs_Linux_x64_shiphome.zip
Archive:  fbo_ggs_Linux_x64_shiphome.zip
   creating: fbo_ggs_Linux_x64_shiphome/
   creating: fbo_ggs_Linux_x64_shiphome/Disk1/
   .
   .
   .
[gguser@Linux03 GGHOME]$ ls
fbo_ggs_Linux_x64_shiphome  fbo_ggs_Linux_x64_shiphome.zip  OGG-12.2.0.1.1-ReleaseNotes.pdf  OGG-12.2.0.1-README.txt

Previous versions of GG use to be cmd line installation. But now we can use GUI for this. If you want to to do silent Installation follow this link GG-Silent-instalaltion

Once the Software is unzipped you can change directory to runInstaller and invoke installer.

 invoke by calling ./runInstaller

 



Software Location : This will be the location where you want to install oracle Golden Gate Binaries.
Database Location : This will the Oracle Home  directory of Source Database
manager port :7809 by default (you can also select a diff port but I would suggest to leave it as is)




Make sure the locations are correct and click Install.











Once the GG software is installed you will see the GG related files in GG HOME directory.  





Thursday, April 14, 2016

Encrypt password value for GoldenGate using blowfish algorithm

 

Encrypt password value for Golden Gate using Blow fish algorithm


GGSOURCE IS THE PASSWORD FOR USER GGSOURCE (DB USER)

Login as ggsci user:


GGSCI (Linux03 as GGSOURCE@orcl/PDBORCL) 14> ENCRYPT PASSWORD 
GGSOURCE,ENCRYPTKEY DEFAULT

Using Blowfish encryption with DEFAULT key.
Encrypted password:  AACAAAAAAAAAAALAXCJHZHLEZAKGMFABMBWBEJLFHCRHABJGYI  --> This is encrypted value
Algorithm used:  BLOWFISH

[gguser@Linux03 OGGHOME]$ mkdir dirinc
[gguser@Linux03 OGGHOME]$ vi ./dirinc/ggtarget.inc



We can create a  include file to use it for our future references.

GoldenGate Trainer (to All - Entire Audience): vi ./dirinc/ggtarget.inc
USERID ggtarget, PASSWORD AACAAAAAAAAAAALAXCJHZHLEZAKGMFABMBWBEJLFHCRHABJGYI, ENCRYPTKEY DEFAULT

  
we can use new hash value for our ggsci future dblogins  like this

GGSCI (Linux03 as GGSOURCE@orcl/PDBORCL) 15> DBLOGIN USERID GGSOURCE@PDBORCL,PASSWORD AACAAAAAAAAAAALAXCZHLEZAKGMFABMBWBEJLFHCRHABJGYI ,ENCRYPTKEY DEFAULT


While PDBORCL is the DB NAME


Successfully logged into database PDBORCL

Wednesday, April 13, 2016

You do not have sufficient permissions to access the inventory '/u01/app/oraInventory'

[gguser@Linux03 Disk1]$ ./runInstaller

You do not have sufficient permissions to access the inventory '/u01/app/oraInventory'. Installation cannot continue. It is required that the primary group of the install user is same as the inventory owner group. Make sure that the install user is part of the inventory owner group and restart the installer.: Permission denied

[gguser@Linux03 Disk1]$ ls -ll /u01/app/oraInventory
ls: cannot open directory /u01/app/oraInventory: Permission denied

CHECKING THE GROUPS ON oraInventory:


[root@Linux03 Desktop]# ls -all /u01/app/oraInventory
total 28
drwxrwx---. 5 oracle oracle   4096 Feb 29 15:24 .
drwxrwxr-x. 7 oracle oinstall 4096 Apr 13 14:40 ..
drwxrwx---. 2 oracle oracle   4096 Feb 29 15:24 ContentsXML
drwxrwx---. 2 oracle oracle   4096 Feb 29 15:21 logs
-rw-rw----. 1 oracle oracle     54 Feb 29 15:24 oraInst.loc
-rwxrwx---. 1 oracle oracle   1612 Feb 29 15:24 orainstRoot.sh
drwxrwx---. 2 oracle oracle   4096 Feb 29 15:21 oui

Solution :

CHANGED GGUSER primary Group to oracle which is the primary group for oracle user. In my case oraInventory was under oracle group.