Skip to Content
avatar image
Former Member

How to connect BR*TOOLS STUDIO to oracle on windows server

HI ,

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 ??

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Dec 08, 2008 at 10:06 AM

    Hi,

    Is DBTOOLS STUDIO only for UNIX systems or can it be used for*

    WINDOWS also?

    You can use BR*Tools for both Unix as well as Windows systems.

    IF yes then How ??

    How to use in windows:

    Log on as the operating system user who owns the data files of the database system.The standard Oracle user created during the installation of the SAP System <DBSID>ADM (Windows).

    Logon with that user and start the BRTOOLS.

    Hope it resolves your issue.

    Thanks

    Kishore

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 08, 2008 at 12:23 PM

    Hai,

    Have you followed the below mentioned steps:

    In your BR*Tools Studio home directory, call:

    In UNIX

    csh server.sh

    In Windows

    server.cmd

    This script starts a web application server based on Oracle Containers for Java

    EE (OC4J), which serves as the runtime platform for the web application of

    BR*Tools Studio server.

    You need to run this command whenever you want to start the server for

    BR*Tools Studio in future.

    2. Log on to BR*Tools Studio server through a web browser from any client

    using the following URL:

    https://<host>:<port>/studio

    Note

    (C) SAP AG September 2008 Page 11

    Once BR*Tools Studio server is available, a client logon window appears.

    Make sure that you have enabled pop-ups for this site so that the logon

    window is visible.

    You need to run this command whenever you want to start a client session

    with BR*Tools Studio.

    The client logon window provides you with a list of all instances currently

    maintained for administration with BR*Tools Studio. The only instance

    available directly after installation is the Server instance, with which you can

    maintain the server landscape.

    As far as I know there are some unresolved bugs still existing in BR tools studio which is under process.

    Since you are able to open the studio with AIX you should be able to open in Windows as well.

    Have you checked your Keystore file.

    Regards,

    Yoganand.V

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi ,

      I have it working for AIX without any problems by following documentation but problem is with oracle on windows.

      Also I have no problem running brtools remotely using "psexec" on windows.

      If anyone has used BR*TOOLS STUDIO with windows/oracle database, please let me know the trick.

      regards,

      Daljit

  • avatar image
    Former Member
    Nov 24, 2009 at 10:53 PM

    no solution

    Add comment
    10|10000 characters needed characters exceeded