This question assumes importance if a customer wants to get a one-off for resolving a newly discovered bug. This in turns requires identifying the one-offs present in the current environment so that the code fixes in the new one-offs take into account the existing one-offs. Another reason is, the customer may want to create an identical environment (with respect to binaries only) and downloading the SharePlex build may not be enough as it needs to be updated with the one-off binaries, if they are present in the existing environment. Yet another reason may be, the customer has encountered a bug and we need to identify the current one-offs that are supposed to have addressed the bug but there are other manifestations of the bug which are not addressed in the present one-off. There can be many other reasons. The script sp-bininfo located in /proddir/.app-modules (where proddir refers to Product Directory of SharePlex) is run to get the details of the binaries present in one’s environment and these details also include the one-offs.
The script gives details of each of the binaries present in the SharePlex instance. Such details include the version and build #, the Oracle and OS versions as well as the CR # (change request #), if any, associated with each of the binaries. Any binary having a CR associated with it is a one-off. This is how the one-offs are identified in the environment. The following is a sample output generated by running the script sp-bininfo in an environment where one-offs are present. The one-offs in this environment are:
sp_ocap:
build 66 of SharePlex_Oracle (CR112367-oracle110) 8.6.4 for sun-11-sparc by builder
sp_desvr:
build 66 of SharePlex_Oracle (CR112367-CR111353-CR112369a-oracle110) 8.6.4 for sun-11-sparc by builder
Note that some of the one-offs (but not all) also have the original binaries listed as:
(9) sp_ocap.before_patch:
build 66 of SharePlex_Oracle (oracle110) 8.6.4 for sun-11-sparc by builder
Here is the complete output. It can be lengthy. However, it has been provided in its entirety to illustrate the above points:
--------------------------------------------------------------------------------------------------------
$ ./sp-bininfo (where $ denotes the OS prompt at /proddir/.app-modules directory)
(1) clear_reclaim:
build 66 of SharePlex_Oracle (oracle110) 8.6.4 for sun-11-sparc by builder
Shareplex shared lib(s):
libsporacle.so.8.6.4.19
libspshareplex.so.8.6.4.19
libspspo.uname.so.8.6.4.19
libspdb.so.8.6.4.19
libspspo.shim.so.8.6.4.19
libspspymdb.so.8.6.4.19
(2) ppas_setup:
build 66 of SharePlex_Oracle (oracle110) 8.6.4 for sun-11-sparc by builder
Shareplex shared lib(s):
libspshareplex.so.8.6.4.19
libspspo.uname.so.8.6.4.19
libspspo.shim.so.8.6.4.19
libspspymdb.so.8.6.4.19
libspspo.cnc.so.8.6.4.19
(3) dumpfile:
build 66 of SharePlex_Oracle (oracle110) 8.6.4 for sun-11-sparc by builder
Shareplex shared lib(s):
libsporacle.so.8.6.4.19
libspshareplex.so.8.6.4.19
libspspo.uname.so.8.6.4.19
libspdb.so.8.6.4.19
libspspo.shim.so.8.6.4.19
(4) sp_ctrl:
build 66 of SharePlex_Oracle (oracle110) 8.6.4 for sun-11-sparc by builder
Shareplex shared lib(s):
libspshareplex.so.8.6.4.19
libspspo.uname.so.8.6.4.19
(5) sp_wallet:
build 66 of SharePlex_Oracle (oracle110) 8.6.4 for sun-11-sparc by builder
Shareplex shared lib(s):
libsporacle.so.8.6.4.19
libsporalog.so.8.6.4.19
libspshareplex.so.8.6.4.19
libspspo.uname.so.8.6.4.19
libspspo.shim.so.8.6.4.19
libspspymdb.so.8.6.4.19
(6) splexkeys:
build 66 of SharePlex_Oracle (oracle110) 8.6.4 for sun-11-sparc by builder
Shareplex shared lib(s):
libsporacle.so.8.6.4.19
libspshareplex.so.8.6.4.19
libspspo.uname.so.8.6.4.19
libspdb.so.8.6.4.19
libspspo.shim.so.8.6.4.19
libspspymdb.so.8.6.4.19
(7) diff-cache:
build 66 of SharePlex_Oracle (oracle110) 8.6.4 for sun-11-sparc by builder
Shareplex shared lib(s):
libsporacle.so.8.6.4.19
libspshareplex.so.8.6.4.19
libspspo.uname.so.8.6.4.19
libspspo.shim.so.8.6.4.19
(8) adminize:
build 66 of SharePlex_Oracle (oracle110) 8.6.4 for sun-11-sparc by builder
(9) sp_ocap.before_patch:
build 66 of SharePlex_Oracle (oracle110) 8.6.4 for sun-11-sparc by builder
Shareplex shared lib(s):
libspwildcard.so.8.6.4.19
libsporacle.so.8.6.4.19
libsporalog.so.8.6.4.19
libspshareplex.so.8.6.4.19
libspspo.uname.so.8.6.4.19
libspdb.so.8.6.4.19
libspodb.so.8.6.4.19
libspspo.typecheck.so.8.6.4.19
libspcore.so.8.6.4.19
libspext.so.8.6.4.19
libspspo.memory.impl.so.8.6.4.19
libumem.so.1
libspspo.shim.so.8.6.4.19
libspspymdb.so.8.6.4.19
(10) sp_desvr:
build 66 of SharePlex_Oracle (CR112367-CR111353-CR112369a-oracle110) 8.6.4 for sun-11-sparc by builder
Shareplex shared lib(s):
libsporacle.so.8.6.4.19
libspshareplex.so.8.6.4.19
libspspo.uname.so.8.6.4.19
libspdb.so.8.6.4.19
libspconfig.bundle.so.8.6.4.19
libspodb.so.8.6.4.19
libspspymdb.so.8.6.4.19
libspspo.shim.so.8.6.4.19
(11) sp_ordr:
build 66 of SharePlex_Oracle (oracle110) 8.6.4 for sun-11-sparc by builder
Shareplex shared lib(s):
libspwildcard.so.8.6.4.19
libsporacle.so.8.6.4.19
libspshareplex.so.8.6.4.19
libspspo.uname.so.8.6.4.19
libspdb.so.8.6.4.19
libspodb.so.8.6.4.19
libspspo.shim.so.8.6.4.19
libspspymdb.so.8.6.4.19
(12) eventgrep:
build 66 of SharePlex_Oracle (oracle110) 8.6.4 for sun-11-sparc by builder
(13) sp_mport:
build 66 of SharePlex_Oracle (oracle110) 8.6.4 for sun-11-sparc by builder
Shareplex shared lib(s):
libspshareplex.so.8.6.4.19
libspspo.uname.so.8.6.4.19
libspspymdb.so.8.6.4.19
(14) splex_add_key:
build 66 of SharePlex_Oracle (oracle110) 8.6.4 for sun-11-sparc by builder
Shareplex shared lib(s):
libspshareplex.so.8.6.4.19
libspspo.uname.so.8.6.4.19
(15) sp_sync_svr:
build 66 of SharePlex_Oracle (oracle110) 8.6.4 for sun-11-sparc by builder
Shareplex shared lib(s):
libspspo.uname.so.8.6.4.19
libspshareplex.so.8.6.4.19
libspspo.shim.so.8.6.4.19
(16) sp_pbcnc:
build 66 of SharePlex_Oracle (oracle110) 8.6.4 for sun-11-sparc by builder
Oracle client library: /u01/app/oracle/product/11.2.0.4/dbhome_2/lib//libclntsh.so.11.1
Shareplex shared lib(s):
libsporacle.so.8.6.4.19
libsporalog.so.8.6.4.19
libspshareplex.so.8.6.4.19
libspspo.uname.so.8.6.4.19
libspdb.so.8.6.4.19
libspconfig.bundle.so.8.6.4.19
libspodb.so.8.6.4.19
libspspo.shim.so.8.6.4.19
libspspo.cnc.so.8.6.4.19
libspspymdb.so.8.6.4.19
libspenvironment.so.8.6.4.19
(17) splex_get_key:
build 66 of SharePlex_Oracle (oracle110) 8.6.4 for sun-11-sparc by builder
Shareplex shared lib(s):
libspshareplex.so.8.6.4.19
libspspo.uname.so.8.6.4.19
(18) sp_xport:
build 66 of SharePlex_Oracle (oracle110) 8.6.4 for sun-11-sparc by builder
Shareplex shared lib(s):
libspshareplex.so.8.6.4.19
libspspo.uname.so.8.6.4.19
libspspymdb.so.8.6.4.19
(19) print-cache:
build 66 of SharePlex_Oracle (oracle110) 8.6.4 for sun-11-sparc by builder
Shareplex shared lib(s):
libsporacle.so.8.6.4.19
libspshareplex.so.8.6.4.19
libspspo.uname.so.8.6.4.19
libspspo.shim.so.8.6.4.19
(20) sp_desvr_20160907:
build 66 of SharePlex_Oracle (oracle110) 8.6.4 for sun-11-sparc by builder
Shareplex shared lib(s):
libsporacle.so.8.6.4.19
libspshareplex.so.8.6.4.19
libspspo.uname.so.8.6.4.19
libspdb.so.8.6.4.19
libspconfig.bundle.so.8.6.4.19
libspodb.so.8.6.4.19
libspspymdb.so.8.6.4.19
libspspo.shim.so.8.6.4.19
(21) sp_opst_mt:
build 66 of SharePlex_Oracle (oracle110) 8.6.4 for sun-11-sparc by builder
Shareplex shared lib(s):
libspcore.so.8.6.4.19
libspext.so.8.6.4.19
libsporacle.so.8.6.4.19
libspshareplex.so.8.6.4.19
libspspo.uname.so.8.6.4.19
libspopstcom.so.8.6.4.19
libspspo.securefile.so.8.6.4.19
libspspo.shim.so.8.6.4.19
libspspymdb.so.8.6.4.19
(22) splex_uname:
build 66 of SharePlex_Oracle (oracle110) 8.6.4 for sun-11-sparc by builder
Shareplex shared lib(s):
libspshareplex.so.8.6.4.19
libspspo.uname.so.8.6.4.19
(23) sp_declt:
build 66 of SharePlex_Oracle (oracle110) 8.6.4 for sun-11-sparc by builder
Shareplex shared lib(s):
libsporacle.so.8.6.4.19
libspshareplex.so.8.6.4.19
libspspo.uname.so.8.6.4.19
libspdb.so.8.6.4.19
libspspymdb.so.8.6.4.19
libspspo.shim.so.8.6.4.19
(24) sp_analyze:
build 66 of SharePlex_Oracle (oracle110) 8.6.4 for sun-11-sparc by builder
Shareplex shared lib(s):
libsporacle.so.8.6.4.19
libspshareplex.so.8.6.4.19
libspspo.uname.so.8.6.4.19
libspspo.ora.so.8.6.4.19
libspspo.shim.so.8.6.4.19
libspspymdb.so.8.6.4.19
(25) ora_chpwd:
build 66 of SharePlex_Oracle (oracle110) 8.6.4 for sun-11-sparc by builder
Shareplex shared lib(s):
libsporacle.so.8.6.4.19
libsporalog.so.8.6.4.19
libspshareplex.so.8.6.4.19
libspspo.uname.so.8.6.4.19
libspspo.shim.so.8.6.4.19
libspspymdb.so.8.6.4.19
libspspo.cnc.so.8.6.4.19
(26) sp_oreconcile:
build 66 of SharePlex_Oracle (oracle110) 8.6.4 for sun-11-sparc by builder
Shareplex shared lib(s):
libsporacle.so.8.6.4.19
libsporalog.so.8.6.4.19
libspshareplex.so.8.6.4.19
libspspo.uname.so.8.6.4.19
libspspo.shim.so.8.6.4.19
libspspymdb.so.8.6.4.19
(27) socket_test:
build 66 of SharePlex_Oracle (oracle110) 8.6.4 for sun-11-sparc by builder
Shareplex shared lib(s):
libsporacle.so.8.6.4.19
libspshareplex.so.8.6.4.19
libspspo.uname.so.8.6.4.19
libspdb.so.8.6.4.19
libspspo.shim.so.8.6.4.19
libspspymdb.so.8.6.4.19
(28) sp_sync_clt:
build 66 of SharePlex_Oracle (oracle110) 8.6.4 for sun-11-sparc by builder
Shareplex shared lib(s):
libspspo.uname.so.8.6.4.19
libspshareplex.so.8.6.4.19
libspspo.shim.so.8.6.4.19
(29) sp_cop:
build 66 of SharePlex_Oracle (oracle110) 8.6.4 for sun-11-sparc by builder
Shareplex shared lib(s):
libspshareplex.so.8.6.4.19
libspspo.uname.so.8.6.4.19
libspspymdb.so.8.6.4.19
libspenvironment.so.8.6.4.19
(30) sp_xpst:
build 66 of SharePlex_Oracle (oracle110) 8.6.4 for sun-11-sparc by builder
Shareplex shared lib(s):
libspshareplex.so.8.6.4.19
libspspo.uname.so.8.6.4.19
libsporacle.so.8.6.4.19
libspspymdb.so.8.6.4.19
libspspo.securefile.so.8.6.4.19
libspspo.shim.so.8.6.4.19
libspcore.so.8.6.4.19
libspext.so.8.6.4.19
(31) sp_ocap:
build 66 of SharePlex_Oracle (CR112367-oracle110) 8.6.4 for sun-11-sparc by builder
Shareplex shared lib(s):
libspwildcard.so.8.6.4.19
libsporacle.so.8.6.4.19
libsporalog.so.8.6.4.19
libspshareplex.so.8.6.4.19
libspspo.uname.so.8.6.4.19
libspdb.so.8.6.4.19
libspodb.so.8.6.4.19
libspspo.typecheck.so.8.6.4.19
libspcore.so.8.6.4.19
libspext.so.8.6.4.19
libspspo.memory.impl.so.8.6.4.19
libumem.so.1
libspspo.shim.so.8.6.4.19
libspspymdb.so.8.6.4.19
(32) sp_sync_launcher:
build 66 of SharePlex_Oracle (oracle110) 8.6.4 for sun-11-sparc by builder
Shareplex shared lib(s):
libspspo.uname.so.8.6.4.19
libspspo.shim.so.8.6.4.19
(33) sp_tconf:
build 66 of SharePlex_Oracle (oracle110) 8.6.4 for sun-11-sparc by builder
Shareplex shared lib(s):
libspwildcard.so.8.6.4.19
libsporacle.so.8.6.4.19
libspshareplex.so.8.6.4.19
libspspo.uname.so.8.6.4.19
libspdb.so.8.6.4.19
libspconfig.bundle.so.8.6.4.19
libspodb.so.8.6.4.19
libspspo.typecheck.so.8.6.4.19
libspspo.shim.so.8.6.4.19
libspspymdb.so.8.6.4.19
(34) sp_cnc:
build 66 of SharePlex_Oracle (oracle110) 8.6.4 for sun-11-sparc by builder
Shareplex shared lib(s):
libsporacle.so.8.6.4.19
libsporalog.so.8.6.4.19
libspshareplex.so.8.6.4.19
libspspo.uname.so.8.6.4.19
libspdb.so.8.6.4.19
libspconfig.bundle.so.8.6.4.19
libspcnc-convert.so.8.6.4.19
libspodb.so.8.6.4.19
libspspo.typecheck.so.8.6.4.19
libspspo.shim.so.8.6.4.19
libspspymdb.so.8.6.4.19
libspenvironment.so.8.6.4.19
libspspo.cnc.so.8.6.4.19
(35) config_parser:
build 66 of SharePlex_Oracle (oracle110) 8.6.4 for sun-11-sparc by builder
Oracle client library: /u01/app/oracle/product/11.2.0.4/dbhome_2/lib//libclntsh.so.11.1
Shareplex shared lib(s):
libsporacle.so.8.6.4.19
libspshareplex.so.8.6.4.19
libspspo.uname.so.8.6.4.19
libspdb.so.8.6.4.19
libspconfig.bundle.so.8.6.4.19
libspodb.so.8.6.4.19
(36) td_cleansp:
build 66 of SharePlex_Oracle (oracle110) 8.6.4 for sun-11-sparc by builder
(37) dumpque:
build 66 of SharePlex_Oracle (oracle110) 8.6.4 for sun-11-sparc by builder
Shareplex shared lib(s):
libsporacle.so.8.6.4.19
libspshareplex.so.8.6.4.19
libspspo.uname.so.8.6.4.19
libspspo.shim.so.8.6.4.19
(38) pb_ctrl:
build 66 of SharePlex_Oracle (oracle110) 8.6.4 for sun-11-sparc by builder
Shareplex shared lib(s):
libspshareplex.so.8.6.4.19
libspspo.uname.so.8.6.4.19
libspspo.cnc.so.8.6.4.19
(39) provision:
build 66 of SharePlex_Oracle (oracle110) 8.6.4 for sun-11-sparc by builder
Shareplex shared lib(s):
libspshareplex.so.8.6.4.19
libspspo.uname.so.8.6.4.19
(40) ora_setup:
build 66 of SharePlex_Oracle (oracle110) 8.6.4 for sun-11-sparc by builder
Shareplex shared lib(s):
libsporacle.so.8.6.4.19
libsporalog.so.8.6.4.19
libspshareplex.so.8.6.4.19
libspspo.uname.so.8.6.4.19
libspspo.shim.so.8.6.4.19
libspspymdb.so.8.6.4.19
libspspo.cnc.so.8.6.4.19
(41) sa_ocap:
build 66 of SharePlex_Oracle (oracle110) 8.6.4 for sun-11-sparc by builder
Shareplex shared lib(s):
libspwildcard.so.8.6.4.19
libsporacle.so.8.6.4.19
libsporalog.so.8.6.4.19
libspshareplex.so.8.6.4.19
libspspo.uname.so.8.6.4.19
libspdb.so.8.6.4.19
libspodb.so.8.6.4.19
libspspo.typecheck.so.8.6.4.19
libspcore.so.8.6.4.19
libspext.so.8.6.4.19
libspspo.memory.impl.so.8.6.4.19
libumem.so.1
libspspo.shim.so.8.6.4.19
libspspymdb.so.8.6.4.19
(42) hana_setup:
build 66 of SharePlex_Oracle (oracle110) 8.6.4 for sun-11-sparc by builder
Shareplex shared lib(s):
libspshareplex.so.8.6.4.19
libspspo.uname.so.8.6.4.19
libspspo.shim.so.8.6.4.19
libspspymdb.so.8.6.4.19
libspspo.cnc.so.8.6.4.19
(43) ppas_cleansp:
build 66 of SharePlex_Oracle (oracle110) 8.6.4 for sun-11-sparc by builder
(44) td_setup:
build 66 of SharePlex_Oracle (oracle110) 8.6.4 for sun-11-sparc by builder
Shareplex shared lib(s):
libspshareplex.so.8.6.4.19
libspspo.uname.so.8.6.4.19
libspspo.shim.so.8.6.4.19
libspspymdb.so.8.6.4.19
libspspo.cnc.so.8.6.4.19
(45) hana_cleansp:
build 66 of SharePlex_Oracle (oracle110) 8.6.4 for sun-11-sparc by builder
(46) splexrpt:
build 66 of SharePlex_Oracle (oracle110) 8.6.4 for sun-11-sparc by builder
Shareplex shared lib(s):
libsporacle.so.8.6.4.19
libspshareplex.so.8.6.4.19
libspspo.uname.so.8.6.4.19
libspdb.so.8.6.4.19
libspspo.shim.so.8.6.4.19
libspspymdb.so.8.6.4.19
(47) upgrade_to_64bit:
build 66 of SharePlex_Oracle (oracle110) 8.6.4 for sun-11-sparc by builder
Shareplex shared lib(s):
libsporacle.so.8.6.4.19
libspshareplex.so.8.6.4.19
libspspo.uname.so.8.6.4.19
libspspo.shim.so.8.6.4.19
