====== TDP Oracle installation ======
====== TDP Oracle installation / configuration ======
https://www.ibm.com/support/pages/configuring-data-protection-oracle-when-using-ibm-spectrum-protect-client-v812-new-security-settings
===== Environnement client TDP Oracle =====
==== TDP Oracle installation ====
First step is to install TSM client 8.1.9
[root@srvora01 TSMCLI_LNX]# rpm -Uhv gskcrypt64-8.0.55.9.linux.x86_64.rpm gskssl64-8.0.55.9.linux.x86_64.rpm
Preparing... ########################################### [100%]
package gskcrypt64-8.0-55.9.x86_64 is already installed
package gskssl64-8.0-55.9.x86_64 is already installed
[root@srvora01 TSMCLI_LNX]# rpm -Uhv TIVsm-API64.x86_64.rpm TIVsm-BA.x86_64.rpm
warning: TIVsm-API64.x86_64.rpm: Header V4 RSA/SHA1 Signature, key ID be1d0ddb: NOKEY
Preparing... ########################################### [100%]
1:TIVsm-API64 ########################################### [ 50%]
2:TIVsm-BA ########################################### [100%]
[root@srvora01 TSMCLI_LNX]# rpm -qa | grep -i TIV
TIVsm-API64-8.1.9-0.x86_64
TIVsm-BA-8.1.9-0.x86_64
Second, install TDP Oracle
[root@srvora01 TSMORA_LNX]# ll
-rwxr-xr-x 1 root root 6513191 Oct 3 22:12 TDP-Oracle.x86_64.bin
[root@srvora01 TSMORA_LNX]# cd /software/TSMORA_LNX/
[root@srvora01 TSMORA_LNX]# rpm -qa | grep -i ora
TDP-Oracle-7.1.3-0.x86_64
TDP-Oracle.Utility-7.1.3-0.x86_64
oracle-ofed-release-guest-1.0.0-31.el6.x86_64
oracle-logos-60.0.14-1.0.5.el6.noarch
oraclelinux-release-6Server-9.0.3.x86_64
[root@srvora01 TSMORA_LNX]# ./TDP-Oracle.x86_64.bin
Preparing to install...
Extracting the installation resources from the installer archive...
Configuring the installer for this system's environment...
Launching installer...
Graphical installers are not supported by the VM. The console mode will be used instead...
===============================================================================
Choose Locale...
----------------
1- Deutsch
->2- English
...
6- Português (Brasil)
...
===============================================================================
Installation Complete
---------------------
Congratulations. IBM Spectrum Protect for Databases - Data Protection for
Oracle has been successfully installed to:
/opt/tivoli/tsm/client/oracle
PRESS TO EXIT THE INSTALLER:
[root@srvora01 ~]# rpm -qa | grep -i ora
TDP-Oracle-8.1.9-0.x86_64
TDP-Oracle.Utility-8.1.9-0.x86_64
==== Server Spectrum Protect configuration for Oracle ====
The TDP versions higher than 8.1.2 use now SSL certificates. This is the reason why we use a connection node on TSM, and a node to store the backups. Using GRANT PROXY, we are able to access from muliples nodes the backups
On Spectrum Protect server we create the access node SRVORA01, and one target node for oracle backups ORADB01.
Protect: TSMSRV01>reg node SRVORA01 xxxx dom=oracle maxnummp=20
Protect: TSMSRV01>reg node ORADB01 xxxx dom=oracle backdelete=yes maxnummp=20
Protect: TSMSRV01> GRant PROXynode TArget=ORADB01 agent=SRVORA01
Protect: TSMSRV01>q proxy
Target Node Agent Node
--------------- ---------------------------------------------
ORADB01 SRVORA01 SRVORA02
==== TDP Oracle configuration ====
Config file **dsm.sys** is located into API directory, to prevent managing multiple dsm.sys, we create a symbolic link
[root@srvora01 bin64]# ln -s /opt/tivoli/tsm/client/ba/bin/dsm.sys /opt/tivoli/tsm/client/api/bin64/dsm.sys
[root@srvora01 bin64]# ls -l /opt/tivoli/tsm/client/api/bin64/dsm.sys
lrwxrwxrwx 1 root root 20 May 16 2019 /opt/tivoli/tsm/client/api/bin64/dsm.sys -> ../../ba/bin/dsm.sys
[root@srvora01 bin64]# cat /opt/tivoli/tsm/client/ba/bin/dsm.sys
#####################################
###
### SPECTRUM PROTECT Oracle
###
######################################
Servername ORADB01
COMMMETHOD TCPIP
TCPPort 1500
TCPServeraddress tsmsrv01
TCPBUFFSIZE 32
TCPWINDOWSIZE 64
TCPNODELAY YES
USELARGebuffers YES
COMPRESSION NO
RESOURCEUTIL 20
NODENAME srvora01
ASNODE ORADB01
PASSWORDACCESS generate
passworddir /opt/spectrum/tsm/tdpo
INCLUDE /.../* ORA_TDP
==> ASNODE is the target node where backups are stored
Configuration file for TDP Oracle: **tdpo_xxx.opt** and **dsm_xxx.opt**
[oracle@srvora01:/home/oracle]# cat /oracle/tsm/tdpo/tdpo_TSTDB01.opt
DSMI_ORC_CONFIG /oracle/tsm/opt/dsm_ORADB01.opt
DSMI_LOG /oracle/tsm/log/srvora01
TDPO_FS TSTDB01_rman
TDPO_PSWDPATH /oracle/tsm/password
[oracle@srvora01:/home/oracle]# cat /oracle/tsm/opt/dsm_ORADB01.opt
SERVERNAME ORADB01
SUBDIR YES
==== Password registration on client node ====
Run the tdpoconf password command as the root user or as the Oracle user. The password files are created
in the directory that is specified by the passworddir option in the dsm.sys file for the Data Protection
for Oracle node. If the tdpo_pswdpath option is specified, the files are created in that directory.
If the password files were created by the root user, make sure that they are readable and writable by the Oracle user who runs the backup operations.
Use the password from connection node --> srvora01 (dsm.sys)
[oracle@srvora01:/home/oracle]tdpoconf password -TDPO_OPT=/oracle/tsm/tdpo/tdpo_TSTDB01.opt
IBM Spectrum Protect for Databases:
Data Protection for Oracle
Version 8, Release 1, Level 9.0
(C) Copyright IBM Corporation 1997, 2019. All rights reserved.
***************************************************************
* IBM Spectrum Protect for Databases Utility
* Password file initialization/update program
***************************************************************
Please enter current password:
Check of config
[oracle@srvora01:/home/oracle]tdpoconf SHOWENVironment -TDPO_OPT=/oracle/tsm/tdpo/tdpo_TSTDB01.opt
IBM Spectrum Protect for Databases:
Data Protection for Oracle
Version 8, Release 1, Level 9.0
(C) Copyright IBM Corporation 1997, 2019. All rights reserved.
Data Protection for Oracle Information
Version: 8
Release: 1
Level: 9
Sublevel: 0
Platform: 64bit TDPO Linux86-64
IBM Spectrum Protect Server Information
Server Name: ORADB01
Server Address: tsmsrv01
Server Type: Linux/x86_64
Server Port: 1500
Communication Method: TCP/IP
Session Information
Owner Name:
Node Name: srvora01
Node Type: TDPO Linux86-64
DSMI_DIR: /opt/tivoli/tsm/client/api/bin64
DSMI_ORC_CONFIG: /oracle/tsm/opt/dsm_ORADB01.opt
TDPO_OPTFILE: /oracle/tsm/tdpo/tdpo_TSTDB01.opt
Compression: FALSE
License Information: License file exists and contains valid license data.
==== Check connection on TSM server ====
Check of backup sessions on Spectrum Protect server during a backup
Protect: TSMSRV01>q se
Sess Comm. Sess Wait Bytes Bytes Sess Platform Client Name
Number Method State Time Sent Recvd Type
------- ------ ------ ------ ------- ------- ------- -------- -----------------
117,702 SSL SSLiW 0 S 463 454 Node TDPO SRVORA01
Linux8-
6-64
Protect: TSMSRV01>q se
Sess Comm. Sess Wait Bytes Bytes Sess Platform Client Name
Number Method State Time Sent Recvd Type
------- ------ ------ ------ ------- ------- ------- -------- -----------------
117,702 SSL RecvW 0 S 10.0 K 6.3 G Node ORADB01
(SRVORA01)
Backups are stored on the node ORADB01, with the filespace_name: /TSTDB01_rman => parameter: TDPO_FS TSTDB01_rman (file tdpo_xx.opt)
Protect: TSMSRV01>q occ ORADB01
Node Name Type Filespace FSID Storage Number of Physical Logical
Name Pool Name Files Space Space
Occupied Occupied
(MB) (MB)
---------- ---- ---------- ---- ---------- ----------- ----------- -----------
ORADB01 Bkup /TSTDB02_rman 1 CONTAINER01 962 - 1,739,704.88
ORADB01 Bkup /TSTDB01_rman 3 CONTAINER01 20 - 122,405.01
===== Errors =====
==== ANS1331E (RC927) password error ====
ANS1331E (RC927) Only a IBM Spectrum Protect authorized user can perform this Action.
You have to set into dsm.sys (/opt/tivoli/tsm/client/api/bin64/dsm.sys) the filed:
passworddir /opt/spectrum/tsm/tdpo
And into tdpo.conf file the filed:
TDPO_PSWDPATH /opt/spectrum/tsm/tdpo
Then Test:
tdpoconf SHOWENVironment -TDPO_OPT=/oracle/tsm/tdpo/tdpo_DB1.opt