SAP BR tools version and patchs




for some tasks you need to know witch version of brtools and patched applied your brtools has:


unix1:orasap 28> brtools -V
BR0651I BRTOOLS 7.20 (42)

Patch   Date     Info

1  2010-01-26  BR*Tools support for Oracle 11g (note 1430669)
9  2010-10-27  BR*Tools support for eSourcing databases (note 1523205)
18  2011-09-07  BR*Tools support for Oracle ASM and Exadata (note 1627541)
25  2012-06-28  Corrections in BR*Tools 7.20 patch 25 (note 1735811)
26  2012-09-12  Corrections in BR*Tools 7.20 patch 26 (note 1763972)
27  2012-09-12  Support for secure storage in BR*Tools (note 1764043)
28  2012-10-25  Corrections in BR*Tools 7.20 patch 28 (note 1780057)
29  2012-12-03  Corrections in BR*Tools 7.20 patch 29 (note 1795814)
30  2013-01-31  Corrections in BR*Tools 7.20 patch 30 (note 1816874)
31  2013-03-26  Corrections in BR*Tools 7.20 patch 31 (note 1838852)
32  2013-05-28  Corrections in BR*Tools 7.20 patch 32 (note 1865897)
33  2013-07-03  Corrections in BR*Tools 7.20 patch 33 (note 1882181)
34  2013-09-05  Corrections in BR*Tools 7.20 patch 34 (note 1909451)
35  2013-11-14  Corrections in BR*Tools 7.20 patch 35 (note 1940675)
36  2014-02-24  Corrections in BR*Tools 7.20 patch 36 (note 1983045)
37  2014-04-30  Corrections in BR*Tools 7.20 patch 37 (note 2011892)
38  2014-06-25  Corrections in BR*Tools 7.20 patch 38 (note 2034605)
39  2014-08-27  Corrections in BR*Tools 7.20 patch 39 (note 2059497)
40  2014-10-29  Corrections in BR*Tools 7.20 patch 40 (note 2086963)
41  2015-01-28  Corrections in BR*Tools 7.20 patch 41 (note 2123623)
42  2015-03-25  Corrections in BR*Tools 7.20 patch 42 (note 2147658)

release note               1428529
kernel release             720
patch date                 2015-03-25
patch level                42
make platform              hpia64
make codeline              721_EXT_REL
make mode                  OCI_112
make date                  Oct  1 2015

Comments

Post a Comment

Popular posts from this blog

Oracle Historical Session Information with ASH >10g

Image
In Oracle 10.2 and above with ASH is very useful to see the number of sessions active and connected to a database over time: You can use this 2 views to obtain this information: v$sysmetric_history --> This is a sort term view, that contains data of last hour by intervals of minutes dba_hist_sysmetric_summary -->This is a long term view, that contains data of last month by intervals of 1 hour. v$sysmetric_history and dba_hist_sysmetric_summary contains information a lot of different metrics information, so the first thing we need to do is to filter metric type. With this query you can select a list of all metric types: set linesize 190 col METRIC_NAME for a100 select METRIC_ID, METRIC_NAME from v$sysmetric_history group by METRIC_ID, METRIC_NAME ; for example, if you are looking for metrics related with connected sessions to database, you can do: SQL> set linesize 190 col METRIC_NAME for a100 select METRIC_ID, METRIC_NAME from v$sysmetric_history where lo
Read more

Purging and archiving Oracle alert.log and listener.log

As i said in " Purging Oracle traces with ADRCI " ADRCI does not work properly for alert.log and listener.log, so in this article i´m going to study who to do this tasks externally, with unix tools. 1-With logrotate Linux-command. I think this is the best option if you have an Oracle linux because it can be setup easily... Put this lines in a config file but modifing your alert.log and listener.log paths # alert log /oracle/db/diag/rdbms/orcl/orcl/trace/alert_orcl.log { monthly rotate 13 notifempty missingok copytruncate nocreate } # listener log /oracle/db/diag/tnslsnr/wcp12cr2/listener/trace/listener.log { weekly rotate 53 notifempty missingok copytruncate nocreate } i put them into alert_logrotate.conf as you can see: [oracle@wcp12cr2 Documents]$ ls -ltr alert_logrotate.conf -rw-r--r--. 1 oracle oinstall 593 Oct 5 03:08 alert_logrotate.conf [oracle@wcp12cr2 Documents]$ cat alert_logrotate.conf # see "man logrotate" for details # rotate log files
Read more

Check sessions and processes limits in Oracle

Oracle database has a gv$resource_limit view to check if any database resource reach his connection limit: set linesize 190 set pages 200 select * from gv$resource_limit; INST_ID RESOURCE_NAME CURRENT_UTILIZATION MAX_UTILIZATION INITIAL_ALLOCAT LIMIT_VALUE ---------- ------------------------------ ------------------- --------------- --------------- ------------ 1 processes 44 300 300 300 1 sessions 52 215 512 512 1 enqueue_locks 30 295 6480 6480 1 enqueue_resources 24 165 2472 UNLIMITED 1 ges_procs 0 0 0 0 1 ges_ress 0 0
Read more