In order to upgrade or apply a patch to shareplex a tpm file needs to be run see below for an example of how this file is run.
to upgrade / apply patch to shareplex
How to install a Shareplex for oracle [SPO] patch. This example is upgrading to the same version but the results would be the same if upgrading or applying a SPO patch.
Environmental varialbles set in the installed version
PORT 8606
proddir /u01/shareplex/proddir/bin
SP_SYS_VARDIR /u01/shareplex/vardir
[STARTR COP]
$ pwd
/u01/shareplex/proddir/bin
$ /u01/shareplex/proddir/bin/sp_cop -u8606 &
[1] 23848
$
*******************************************************
* SharePlex for Oracle Startup
* © 2010 Quest Software, Inc.
* ALL RIGHTS RESERVED.
* Protected by U.S. Patents: 7,461,103 and 7,065,538
* Version: 7.6.1.28-m64-oracle110
* VarDir : /u01/shareplex/vardir
* Port : 8606
*******************************************************
[START SP_CTRL GET VERSION]
$ sp_ctrl
*******************************************************
* SharePlex for Oracle Command Utility
* © 2010 Quest Software, Inc.
* ALL RIGHTS RESERVED.
* Protected by U.S. Patents: 7,461,103 and 7,065,538
*******************************************************
sp_ctrl (fulqasu02:8606)> version full
SharePlex Version = 7.6.1-b28 (m64, oracle110)
sp_ctrl (fulqasu02:8606)> shutdown
[1] + Done /u01/shareplex/proddir/bin/sp_cop -u8606 &
[MAKE SURE SHAREPLEX IS NOT RUNNING]
$ps -ef | grep sp_ | grep -v grep
$
$ pwd
/u01/shareplex/proddir/bin
$ env | grep SP_SYS
SP_SYS_VARDIR=/u01/shareplex/vardir
$ cd /u01/shareplex
$ ls
proddir vardir
SharePlex-7.6.1-b28-oracle110-sun-9-sparc-m64.tar
[UNTAR THE TPM FILE]
$ tar xvf SharePlex-7.6.1-b28-oracle110-sun-9-sparc-m64.tar
[RUN THE INSTALL FILE]
x SharePlex-7.6.1-b28-oracle110-sun-9-sparc-m64.tpm, 26633182 bytes, 52018 tape blocks
$ ./SharePlex-7.6.1-b28-oracle110-sun-9-sparc-m64.tpm
Unpacking ..................................................................
..........................................................................
..........................................................................
..........................................................................
..........................................................................
.................
SharePlex for Oracle installation program:
SharePlex Version: 7.6.1
Supported Oracle Version: 11gR1, 11gR2
Build platform: sun-9-sparc
Target platform: sun-10-sparc
[SELECT DEFAULT LOCATION IF UPGRADING YOU CAN NOT CHANGE THE PRODDIR]
Please specify the product directory location (select a number):
1. [/u01/shareplex/proddir is version 7.6.1 (Oracle 11g)]
2. <New installation ...>
?
Please specify the SharePlex Admin group (select a number):
1. [current => kdba]
2. staff
3. mail
?
Please wait while the installer obtains Oracle information ..
Please enter the ORACLE_SID that corresponds to this installation? [stock]
Please enter the ORACLE_HOME directory that corresponds to this ORACLE_SID? [/u00/oracle/product/110]
[VERIFY THAT DIRECTORIES, SID, USER ARE CORRECT]
Preparing to upgrade SharePlex for Oracle v. 7.6.1:
User: korcl
Admin Group: kdba
Product Directory: /u01/shareplex/proddir
ORACLE_SID: stock
ORACLE_HOME: /u00/oracle/product/110
Proceed with upgrade? [yes]
Upgrading .................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.......
Setting file ownerships ...................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.......................
Setting file permissions ..................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
.........................................................................
........................
[UPDATE LICENSE YES/NO]
Current license information:
Customer Name: <Customer name>
License Key: <SHAREPLEX FOR ORACLE - LICENSE>
Product Name: SharePlex for Oracle - RAC
License Key Type: "Trial Key"
Expires: at Midnight of Dec 27, 2011
Do you want to update the license? [no]
Installation log saved to: /home/korcl/.shareplex/INSTALL-SharePlex-7.6.1-1201310046.log
SharePlex for Oracle v. 7.6.1 upgrade successful.
$ cd $PBIN
$ cd $SPBIN
$ pwd
/u01/shareplex/proddir/bin
[RESTART COP AT THIS POINT UPGRADE PATCHING IS DONE]
$ /u01/shareplex/proddir/bin/sp_cop -u8606 &
[1] 24332
$
*******************************************************
* SharePlex for Oracle Startup
* © 2010 Quest Software, Inc.
* ALL RIGHTS RESERVED.
* Protected by U.S. Patents: 7,461,103 and 7,065,538
* Version: 7.6.1.28-m64-oracle110
* VarDir : /u01/shareplex/vardir
* Port : 8606
*******************************************************
$ ./sp_ctrl
*******************************************************
* SharePlex for Oracle Command Utility
* © 2010 Quest Software, Inc.
* ALL RIGHTS RESERVED.
* Protected by U.S. Patents: 7,461,103 and 7,065,538
*******************************************************
sp_ctrl (fulqasu02:8606)> version full
SharePlex Version = 7.6.1-b28 (m64, oracle110)
sp_ctrl (fulqasu02:8606)> show
Process Source Target State PID
---------- ------------------------ ------------ -------------------- ------
Capture o.stock Running 24333
Read o.stock Running 24335
Import fulqasu02 fulqasu02 Running
MTPost o.stock-fulqasu02 o.stock Running 24334
sp_ctrl (fulqasu02:8606)>
how to apply tpm file for upgrade.
