using the BR*tools in portal

[Former Member]

Hi all,

I am trying to use the BR*tools from a oracle database but having trouble setting the environment variables for the tool. I'm on a windows platform. Do I change these variables in the system part of the control panel?

Thanks,

Jin Bae

[Former Member]

How do you know if you have set the right path to Oracle_Home? Currently I have it set to <i><drive></i>\orant.

Is this right?

Jin Bae

[Former Member]

Talk to your DBA. Most of the time it should end up with number 920_64 or 817_64.

If you are DBA, you know it any way.

[Former Member]

Hi guys,

look at notes: 134592, 668604

It could be that you have to add the DBA role to the OPS$ users. Of course you have to execute the sapdba_role.sql en sap_additional.sql as mentioned in the notes.

the sql command to add the DBA role:

grant dba to ops$ora<sid>

grant dba to ops$<sid>adm

good luck

[Former Member]

All,

I get this error in the cmd prompt:

BR0651I BRTOOLS 6.40 (15)

BR0152E Environment variable ORACLE_HOME is not set

BR0280I BRTOOLS time stamp: 2005-05-02 12.13.57

BR0654I BRTOOLS terminated with errors

[Former Member]

Make sure to login with oracle user to run the BRTOOLS. This makes it easy.

Please check your environment parameter for ORACLE_HOME. If this is not set, BR tools can not talk to ORACLE.

BR TOOLS also works even if you login with SID id, if and only if the SID ID is part of DBA group.

This can be verified with the owner & group of the BR Tools from kernel directory.

Let me know the status.

[Former Member]

Yes. You make thsi aprt of the SYstem variable whihc is global. Logoff and log backin. Go to command prompt and enter set. This should display all the environment parameters.

You can also try SQL plus and check every thing is OK.