Saturday, June 30, 2018

DB network Encryption & Data Integrity

select NETWORK_SERVICE_BANNER from V$SESSION_CONNECT_INFO;


              DB network Encryption











======================================================================
 DB network Data Integrity








Friday, June 1, 2018

Avamar Client installation for Oracle 12cR2 RAC database

Step 1 : Install Avamar Client RPM

AvamarClient-linux-sles11-x86_64-7.5XXXXXX.rpm

Step 2 : Install Avamar Rman RPM
AvamarRMAN-linux-sles11-x86_64-7.5XXXXXXXX.rpm


Step 3: Client configuration for RAC Node1


cd /usr/local/avamar/bin/
[root@Hostname1 bin]# ./rac_config
Enter the path of Oracle Clusterware Home : /XXXX/XXXXX/product/12.2.0/grid
Using ORACLE_HOME : /XXXX/XXXXX/product/12.2.0/grid
Setting PATH set for Oracle commands
Oracle cluster version 12cR2
Do you want to configure on a cluster shared filesystem? [y/n] [y]: n
Enter the full path of var directory location[]: /usr/local/avamar/bin/var
Using /usr/local/avamar/bin/var as var directory location
Enter the cluster scan name [scanXXXX]:
Using scanXXXX as hostname
Now adding resource EMCagent.
The resource EMCagent is added successfully.
Follow the folowing steps to finish the whole configuration:
1. Run rac_config with the same var directory on the following nodes in cluster cluXXXX if you haven't done so:
Hostname2
2. Run /usr/local/avamar/ora_rac/bin/avregister to register and activate this client with the Administrator server
3. Copy /usr/local/avamar/ora_rac/var/cid.bin and /usr/local/avamar/ora_rac/var/avagent.cfg from Hostname1 to the following nodes in cluster cluXXXX:
Hostname2


Step 4: Client configuration for RAC Node2 (same like above)

Step 5 : Register client to Server

[root@Hostname1 bin]# /usr/local/avamar/ora_rac/bin/avregister

=== Client Registration and Activation
This script will register and activate the client with the Administrator server.


Enter the Administrator server address (DNS text name or numeric IP address, DNS name preferred): Backup server name/IP

Enter the Avamar server domain [clients]:
avagent.d Info: Client Agent not running.                  [PASSED]
avagent Info <5008>: Logging to /usr/local/avamar/ora_rac/var/avagent.log
avagent Info <5174>: - Reading /usr/local/avamar/ora_rac/var/avagent.cmd
avagent.d Info: Client activated successfully.             [ OK ]
avagent Info <5008>: Logging to /usr/local/avamar/ora_rac/var/avagent.log
avagent Info <5174>: - Reading /usr/local/avamar/ora_rac/var/avagent.cmd
avagent Info <5417>: daemonized as process id 25161
avagent.d Info: Client Agent started.                      [ OK ]
avagent.d Info: Stopping Avamar Client Agent (avagent)...
avagent.d Info: Client Agent stopped.                      [ OK ]
CRS-2672: Attempting to start 'EMCagent' on 'Hostname1'
CRS-2676: Start of 'EMCagent' on 'Hostname1' succeeded
Registration Complete.

Step 6 : Transfer configuration file to another node.

Copy /usr/local/avamar/ora_rac/var/cid.bin and /usr/local/avamar/ora_rac/var/avagent.cfg from Hostname1 to the following nodes in cluster cluXXXX:
Hostname2