Skip to Content

Have you heard about BR*Tools Studio? See our 3-part technical SAP BR*Tools Studio for Oracle: Features for a thorough introduction to our latest GUI-based addition to BR*Tools, SAP’s tool for Oracle database administration.

Since our last blog on BR*Tools Studio in September 2007 we’ve been busy with the pilot phase, which has given us valuable feedback to tune the new GUI for production use in real customer environments. This will provide you, our customers, with direct benefits in terms of a streamlined and more productive tool for your daily DBA work.

Besides the improvements from the pilot, we’ve also been continually developing the Studio, prompted by your suggestions coming in from around the world after a series of demonstrations that we’ve given. Many thanks to those of you who took the time to contribute ideas and make suggestions!

As a result, here are the two main new developments we’d like to now announce:

Part 4: Auditing and Multi-Instance Server

image

AUDITING

By making small adjustments to the role concept, we’ve been able to give the Studio full audit capability. In short, auditing means that:

  • Only an authorized user can execute an action

  • Each action is assigned to only one user at any one time

  • Users cannot remove their trace from an action

All users of the roles Database Administrator and Database Operator are now automatically subject to full auditing.

MULTI-INSTANCE SERVER

Besides the ability to run a local database in a client-server configuration, BR*Tools Studio now supports an alternative three-tier architecture, in which the Studio server runs on its own middle-tier platform. This frees resources on the database server. In addition, you can now simultaneously administer several database instances from one and the same Studio server. The individual DB instances are connected using a configurable remote connection to the Studio server.

With the resulting star configuration – several clients log on to the central Studio server, which in turn connects to several instances – it’s no longer necessary to install the Studio server on multiple database servers. Using BR*Tools Studio to manage a complex landscape is now possible using a single BR*Tools Studio server. All you have to do is enter the instances to be administered in the instance portfolio of the Studio server.

So, fasten your seatbelts and prepare for lift-off: The first general release of SAP BR*Tools Studio 7.10 will be available by download from SAP on Oracle as of November 3rd, 2008.

To report this post you need to login first.

26 Comments

You must be Logged on to comment or reply to a post.

  1. Nischal Mahakal
    Hi Markus,

    This product sounds quite exciting, I am waiting to get my hands on to it.
    Is there any plan for a beta release soon where one can test it on a playpen system?

    Cheers,
    Nisch

    (0) 
  2. Vince Laurent
    Hope it doesn’t rely on Java.  I already have issues with Java at work with Applictions requiring specific versions of Java to work. 
    (0) 
  3. Michael Watson
    For those of us who are keen to get their hands on this tool, could you please update us with the current status, and an expected release date. Thanks.
    (0) 
    1. Markus Maurer Post author
      Dear Kobby,

      kindly ask you to open an OSS support call on this subject or post your question in the SDN forum ‘SAP on Oracle’ as this blog cannot server as a qualified support channel. — Thank you,

      Best Regards,
      Markus

      (0) 
  4. Rajeev Das
    Hi Markus,

    I have managed to install and login in BR*Tools studio. However, I can’t see the BR*Tools Wizard or Administation Tab. I only get the Landscape tab in my browser.

    Am I missing something?

    Regards,
    Rajeev

    (0) 
  5. Dominique Remy
    Hello,

    I download it and when I try to unzip the package I got the following error

    The Compressed (zip) Folder is Invalid or corrupted

    The package is corrupted or do I need a tools others than winnzip the unpacked ?

    Thanks for your answer

    D./

    (0) 
  6. Daljit Boparai
    Hi,
    BR*studio connects to oracle on unix but how to connect to oracle on windows.
    Short Text    
    BR*TOOLS STUDIO connection to windows server    
    Long Text    
    HI SAP,
    We have some oracle databases on AIX and few on windows 2003 servers.
    BR*TOOLS studio connects fine to AIX systems but How to connect it to
    windows servers.
    I tried to use free utility “psexec”. but then studio log shows following error.

    ERROR 2008/12/02 12:21:13 [Tools] Instance SLB reports
    exception while running job Control Files: CreateProcess: psexec
    \\vmsld2 -u slbadm -p ba5al1te brspace -confirm force -language E –
    user / -function dbshow -class cfinfo -file all_cf error=2

    However if I execute “psexec \\vmsld2 -u slbadm -p ba5al1te brspace –
    confirm force -language E -user / -function dbshow -class dbstate”
    remotely from dbstudio server at command line, it works fine.

    So, Is DB*TOOLS STUDIO only for UNIX systems or can it be used for
    WINDOWS also ? IF yes then How ??

    regards

    (0) 
    1. Markus Maurer Post author
      Hello,

      thank you for using BR*Tools Studio. However, please be aware that this blog is not an appropriate support channel but for information purposes mostly. Hence, I recommend to post your question in the ‘SAP on Oracle’ forum here in SDN, or open an OSS support call. Thank you,

      Best Regards,

      Markus Maurer

      (0) 
  7. Detelin Nedev
    Hello all,

    I downloaded this software three times with different browsers, but when I try to extract the file BRSTUDIO710EN__000.SAR I receive an error:
    processing archive C:\BR\BRSTUDIO710EN__000.SAR…
    format error in header

    Can somebody give me a piece of advise?

    Best regards,
    Detelin 

    (0) 
  8. C. SAP-BASIS
    I’ve a problem with adding systems with ssh

    I installed BRStudio on our solution manger system for testing purpose.
    My configuration scenario Multi instance Server mode, conform the
    reccomendations i unpack the OC4J containers , and all the brtools are at
    level 36. I try to add the instance CBD on snpe

    When I add an instance i use following the command for the remote connection:

    ssh c11adm@hostname “. /home/c12adm/.profile;. /home/c12adm/.dbenv_hostname.sh”

    When I test on the OS prompt with the command below, everthing works fine

    ssh c11adm@hostname “. /home/cbdadm/.profile;. /home/cbdadm/.dbenv_hostname.sh;brtools”

    So I omit the word brtools, and this seems not to work for the remote
    string in brstudio. Because I do not get any connectivity. ( No InstanceConnected, no green light,) When I loggon to that configured system
    everthing is blank as well 🙁

    It seems that my ssh connection string/syntax isn’t conform the specs for brstudio.

    We use
    * HP-UX sia3 B.11.23 U ia64
    * OpenSSH_4.3p2-hpn, OpenSSL 0.9.7i 14 Oct 2005
      HP-UX Secure Shell-A.04.30.015, HP-UX Secure Shell version

    does anybody know what i’m doing wrong?

    thanks Edward Kuit

    (0) 
  9. Vlad aka Skif
    500 Internal Server Error
    OracleJSP:

    JSP Error:
    Request URI:/studio/sockets/index-000.jsp

    Exception:
    java.lang.UnsupportedClassVersionError: _sockets/_index_2d_000 (Unsupported major.minor version 50.0)

    configuration: java 1.4.2_19/linux fc9
    client: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.8.1.19) Gecko/20081204 SeaMonkey/1.1.14
    locale: ru_RU.UTF-8

    Help me, pls.
    Thks.

    (0) 
  10. Diego Hernandez Rollizo
    Hi,

    I have a friend, who write a excellent guide. You can search by “Chabier” to found a PDF file BR*Tools Studio 7.10: Installation, Configuration, and Administration.

    This Afternoon I’m testing my installation an all is OK.

    Regards

    (0) 
  11. Shlomi Ambar
    Hi
    I tried to install on UNIX ( Multi instant server ) and Windows and I get the message : BR*tools studio setup failed.
    I can’t see any trace log .
    Did I miss something ?
    Should be a environment paramters as a pre-installation ?
    Thanks
    (0) 

Leave a Reply