Skip to Content
Former Member
Former Member
June 2, 2008 1 minute read

SAP BR*Tools Studio for Oracle: Prepare for Lift-Off

Follow RSS feed
0 Likes 66 Views 26 Comments

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.

Assigned tags

Related Blog Posts

    Related Questions

      26 Comments
      You must be Logged on to comment or reply to a post.
      • Former Member
        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

      • 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. 
      • 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

      • Former Member
        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./

      • Former Member
        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

        • Former Member 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

      • 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 

      • 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

      • 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.

      • Former Member
        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

      • Former Member
        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