BR*Tool Studio

[Former Member]

Hi,

I tried to install BR*Tool Studio, during installation it is asking me keystore path.

So i created a keystore using keytool & is under /oracle/<SID>/.

Now installation is completed.

But i'm not able to access https://host:port/studio.

So i changed the configuration in https-web-site.xml to "FALSE". Now i'm able to access the webpage

http://host:port/studio

but not able to login by Administrator user & passwd specified during installation.

can any one please throw some lite

Thanks in advance

[markus_maurer]

Helmut, Kobby,

please be aware that due to a recent issue with BR*Tools Studio synchronizing to a RAC

instance we cannot support RAC with the Studio for the time being. If you run the Studio

on a regular instance, though, please consider opening an SAP OSS call to allow SAP

support to help you with this issue. -- Thank you,

Best Regards,

Markus Maurer

[Former Member]

not resolved

[Former Member]

also is there any further information regharding this tool besides what is extracted in the setup?

i defined a dedicated but all lights are red.

[Former Member]

can anyone get to note 1224432 as documented in the setup.html?

[stefan_koehler]

Hello Kobby,

i had the same problem.. you can read my blog howto unsecure the BR*Tools Studio (run it with HTTP).

Regards

Stefan

[Former Member]

Hi,

Thanks,I tried that.

Now i'm able to get http://host:port/studio page

But not able to login using user "Administrator" & passwd speicified during installation.

It says Logon failed: Invalid instance, user or password.

I unistalled it specified passwd correctly, even then same issue.

Thanks in advance

Edited by: Kobby bryant on Nov 6, 2008 2:42 PM

[Former Member]

Hi,

I'm facing the same problem not able to login using the administrator user , any updates?

Thanks

SE.

Edited by: Sherif Eid on Nov 6, 2008 3:15 PM

[markus_maurer]

Hello All,

this logon issue is currently under investigation. We'll keep you posted.

Regards,

Markus

Edit: We have located a bug in the installer now which corrupts the administrator password in the password repository during installation. We will address this bug in the upcoming patch. In the meantime, you can work around this issue by re-installing the Studio from scratch. Repeat installing until you can logon. I expect the installation to succeed after three times at most. &mdash; Sorry for this trouble.

Edited by: Markus Maurer on Nov 6, 2008 5:27 PM

[Former Member]

http://www.sapforum.at/viewtopic.php?p=40#p40

its german, but i could translate if necessary.

[Former Member]

Markus,

That worked. But once i created the instance i'm not able to view tablespaces, files etc...i'm using database user SYSTEM.

I even restarted server & i'm still not able to view them.

Thanks in advance

[Former Member]

Hi,

check this out.

• server.sync.database=1200

in file

studio/data/server-000000.properties

or try to restart the server.

[Former Member]

Could it be, that its still a little bit buggy?

/usr/sap/SID/SYS/exe/run/brconnect -confirm force -language E -user / -function stats -table "missing" -parallel 4 -force

Thats how it is called out of the Studio

Result:

BR0825E Table/Index '"MISSING"' not found in database

BR0182E Checking parameter/option 'stats_table/-t' failed

Same when i enter "ALL"

Running the command 1:1 on OS Level, then its working.

Edit: I also startet the Java with java -jar -Xms256m -Xmx256m

I got Out of memory Messages before.

And i think its a little bit faster now

Edited by: Christian Hummel on Nov 7, 2008 9:21 AM

[markus_maurer]

Christian,

you have indeed hit a new bug in the Studio. I suppose that you run against a local instance

from a dedicated Studio server. The quotation marks are required for execution through a shell,

but in dedicated server mode no shell is being used. As a work-around you might want to switch

into advanced mode after entering the parameters, and remove the quotes. Right now we are also

evaluating in how far you could simply enter a local shell call like "sh" or "cmd /C" in the instance

remote call to pipe the BR*Tools call through a shell.

Best Regards,

Markus

[Former Member]

Hi

i have tried to install it 3 time but still not able to logon.

could you help.

also i'm getting the following error when starting the server

///////////////////////////////

08/11/07 18:43:47 Invalid jsp taglib location: C:\BRTools1\config\..\jsp\lib\tag

lib does not exist or is not a directory

08/11/07 18:43:57 Oracle Application Server Containers for J2EE 10g (9.0.4.0.0)

initialized

//////////////////////

for your information the server i have installed the BRTools studio doesn't have oracle installeon it.

Thanks

SE..

[markus_maurer]

Sherif,

we still need to check this out, but maybe we have an issue with OC4J 9.0.4.0

here. As a quick work-around please link to, or copy the contents of the oc4j

folder of an ORACLE_HOME of yours to the oc4j folder of the Studio (OC4J is

OS independent). The version coming with Oracle is a 9.0.4.1.

Regards,

Markus

[Former Member]

ok, thanks

[Former Member]

Hi Markus,

I added the following environment variable ORACLE_HOME=C:\BRTools1\web-app-server

where oc4j is a sub-folder from web-app-server.

and till now still facing the same issues

1- not able to logon using the Administrator

2- Invalid jsp taglib location: C:\BRTools1\config\..\jsp\lib\tag

lib does not exist or is not a directory

Oracle Application Server Containers for J2EE 10g (9.0.4.0.0)

initialized.

when starting the server.

Thanks

SE..

[Former Member]

Hi Sherif,

I also faced the same problem but now its ok it seems that username is case senstive use

username as Administrator

password as you provide

Hope it will work..

Regarding the one morepost here who is not able to tablespace info for that you need to configure instance for sap user schema only so commonly you need to configure studio using SPASR3

So after that you can view all the tablespaces and other info related to SAP DB.

Hope it Will Also help you.

Please Update US...

Regards,

Gagan Deep Kaushal

[Former Member]

Hi,

I'm still not able to view tablespaces, files, etc for dedicated server mode. I restarted the server couple of times, still same.

Thanks

[Former Member]

Hi,

i often get some Errors from java.

Sometimes the Server crashes and want start any more.

My Error..

1. OutOfMemory

2. 500 Internal Server Error

java.lang.NullPointerException at frames._28_000_29_._wizard._maintenance._check._database._complete._frame_2d_000._jspService(_frame_2d_000.java:53) [SRC:/frames/(000)/wizard/maintenance/check/database/complete/frame-000.jsp:13] at com.orionserver[Oracle Application Server Containers for J2EE 10g (9.0.4.1.0)].http.OrionHttpJspPage.service(OrionHttpJspPage.java:56) at oracle.jsp.runtimev2.JspPageTable.compileAndServe(JspPageTable.java:569) at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:304) at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:509) at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:413) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at com.evermind[Oracle Application Server Containers for J2EE 10g (9.0.4.1.0)].server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:765) at com.evermind[Oracle Application Server Containers for J2EE 10g (9.0.4.1.0)].server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:317) at com.evermind[Oracle Application Server Containers for J2EE 10g (9.0.4.1.0)].server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:793) at com.evermind[Oracle Application Server Containers for J2EE 10g (9.0.4.1.0)].server.http.HttpRequestHandler.run(HttpRequestHandler.java:270) at com.evermind[Oracle Application Server Containers for J2EE 10g (9.0.4.1.0)].server.http.HttpRequestHandler.run(HttpRequestHandler.java:112) at com.evermind[Oracle Application Server Containers for J2EE 10g (9.0.4.1.0)].util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:192) at java.lang.Thread.run(Thread.java:595)

Tried with Java 1.4.2_16 and 1.5.0_16 on an Linux Redhat Enterprise.

For me it looks like a BETA Version

[Former Member]

maybe also interessting..

After an Update Statistics run (advanced -f stats -t all -f collect -p 4), when i want to view the log..

28548 orasid 16 0 1170m 227m 14m S 100 6.2 0:58.86 java

java is working and uses one core of the CPU to 100%..

think i waited more then 30 minutes. then i restartet (killed java) and tried again.

same situation

Java version 1.5.0_16

This Java Application costs a lot of Resources.

Like the WEB AS Java

Edited by: Christian Hummel on Nov 11, 2008 11:20 AM

Edited by: Christian Hummel on Nov 11, 2008 11:21 AM

[Former Member]

Hi,

Can you please let us know the procedure of Creating the Keystore for BR TOOLS STUDIO Installation..

Note:

Set up the keystore file on the BRTools Studio host for incoming client calls*

[Former Member]

http://www.sapforum.at/viewtopic.php?p=40#p40

German, but i think easy to understand

[Former Member]

Hi Kicha,

to make the keystore

<JAVA_HOME>/bin/keytool -keygen -alias <alias> -keystore /oracle/<SID>/sap/brtools/config/.keystore

it will ask for password and some input.

to disable the HTTPS and use HTTP after installation just do the following

after you finish the installation go to /oracle/<SID>/sap/brtools/config and edit https-web-site.xml with any editor

and change the value of secure="true" to secure="false"

now you can access using http://<hostname>:8888/studio

thanks

Sherif

[edwin_slee]

Hi,

The username is case sensitive so the user is Administrator,

I was able to login with the password I supply during install.

Hope it helps.

Kind regards, Edwin

[edwin_slee]

Hi,

I used tyhe command

[edwin_slee]

I used the command

keytool -genkey -alias tomcat -keyalg RSA -keystore /oracle/studio/key.key

The password I supplied was 7 characters long contained a punctuation mark and a capital.

keytool u2013v u2013list

didnu2019t work <strange> but the installation of BR*Tools Studio gave no errors and afterwards the server started without errors.

Regards, Edwin

[Former Member]

hi Markus,

We are able to install Brstudio and able to add local instance and able to view the instance status.

1.But we are not able to view the information like (Owners | Tablespaces | Tables | Indices | Data Files | Control Files | Redolog Files)

2. How to add/manage a remote instance.

Please suggest on the above 2 Issues.

Edited by: Sushma Myla on Nov 24, 2008 11:04 AM

[rajeev_das]

Hi,

I have manged to install the BR*Tools Studio but I get to see only theLandscape tab and not the Wizard or Administration tab.

Is there abything not done correctly?

Regards,

Rajeev

[Former Member]

Hi

I have just installed Br*Tool Studio in a Windows Enviroment. In Unix I can use ssh, rsh to connect to another database server, on Windows anyone know what remote commands are support?

Thanks,

Darrell

[Former Member]

Hi

In Unix I can use ssh, rsh to connect to another database server, on Windows can we use the SAP gateway to start the SAPXPG program?

If so, what are the remote command I should use? //remotehost/sapxpg ?

Thanks,

Darrell.

[Former Member]

Hi,

I'm still not able to view tablespaces, files, etc for Multi-Instance Server Mode. Have you any idea?

Status etc. works fine.

Greetings Helmut

[Former Member]

Not able to view tablespaces, tables, owners,...used SAPSR3 user to connect to database.

Any suggestions.

[former_member500797]

Hi everyone:

I had the same problem of sherif, but when install the oc4j recomended in the installation guide that provides in setup.html, the error changes to:

******************

09/02/05 20:31:33 Could not read web-site config file: {{http(s)-web-site.xml}}

09/02/05 20:31:33 Oracle Application Server Containers for J2EE 10g (9.0.4.0.0)

******************

And I think its could be that because I'm not install it in the %oracle_home%...., however, I need uninstall de br*studio, but I can't.

well, I'm need enough help you can bring me earliest.

Regards.

[former_member500797]

Hi again:

I repair the error changin the path of the studio, and now its already installed in %oracle_home%...

And now the error is:

**************************************************************************************************

09/02/06 13:53:48 Warning: Error reading transaction-log file (/E:/oracle/AZD/92

0/brtools/studio/persistence/transaction.state) for recovery: premature end of f

ile

09/02/06 13:53:48 Forced or abrupt (crash etc) server shutdown detected, startin

g recovery process...

09/02/06 13:53:48 Recovery completed, 0 connections committed and 0 rolled back.

..

09/02/06 13:53:48 Error starting HTTP-Server: Unable to intialize SSLServerSocke

tFactory 'com.evermind.ssl.JSSESSLServerSocketFactory': Address already in use:

JVM_Bind

09/02/06 13:53:48 Oracle Application Server Containers for J2EE 10g (9.0.4.0.0)

initialized

**************************************************************************************************

Its maybe are a oc4j error?

Please help me too earliest as possible.

Thanks.

[Former Member]

Knobby,

.keystore should exist at the following location, /oracle/<SID>/sap/brtools/studio/config, when you start brstudio server using >csh server.csh, it will give you an error and prompt you for the location it looks for .keystore file.

I am able to setup instances using br*studio, but it crashes regularly with following error:

500 Internal Server Error,

java.lang.NullPointerException at frames.server.__2b_._console._frame_2d_000._jspService(_frame_2d_000.java:59) [SRC:/frames/server/+/console/frame-000.jsp:19] at com.orionserver[Oracle Application Server Containers for J2EE 10g (9.0.4.1.0)].http.OrionHttpJspPage.service(OrionHttpJspPage.java:56) at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:349) at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:509) at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:413) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at com.evermind[Oracle Application Server Containers for J2EE 10g (9.0.4.1.0)].server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:765) at com.evermind[Oracle Application Server Containers for J2EE 10g (9.0.4.1.0)].server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:317) at com.evermind[Oracle Application Server Containers for J2EE 10g (9.0.4.1.0)].server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:793) at com.evermind[Oracle Application Server Containers for J2EE 10g (9.0.4.1.0)].server.http.HttpRequestHandler.run(HttpRequestHandler.java:270) at com.evermind[Oracle Application Server Containers for J2EE 10g (9.0.4.1.0)].server.http.HttpRequestHandler.run(HttpRequestHandler.java:112) at com.evermind[Oracle Application Server Containers for J2EE 10g (9.0.4.1.0)].util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:192) at java.lang.Thread.run(Thread.java:534)

Cheers,

Nisch

[Former Member]

can you please let me know the process how you created keystore file.

I created using keytool on os side;

keytool -genkey

and entered the details. It created a .keystore file in home directory of user.

I gave the location of file during installation.

Also i copied manually the .keystore file to /oracle/<SID>/sap/brtoools/studio/config/.

Now when i run csch server.csh

it gives me error

Error starting HTTP-Server: Unable to intialize SSLServerSocketFactory 'com.evermind.ssl.JSSESSLServerSocketFactory': Unrecoverable key error: Cannot recover key

08/11/05 17:04:27 Oracle Application Server Containers for J2EE 10g (9.0.4.1.0) initialized

[Former Member]

I used the same method to create .keystore file and it worked. You can do it again and try it, just delete the old .keystore file first.