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

[Former Member]

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

[Former Member]

no solution

[Former Member]

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

[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

[Former Member]

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