BR0152E Environment variable ORACLE_SID is not set

[Former Member]

Hi,

We are getting the following error when scheduling any task from DB13:

Job started

Step 001 started (program RSDBAJOB, variant &0000000001445, user ID BASIS001)

No application server found on database host - rsh/Gateway will be used

Execute logical command BRCONNECT On host ITECR3PRDDB

Parameters: -u / -jid STATS20090616210200 -c -f stats -t ALL

BR0801I BRCONNECT 7.00 (41)

BR0152E Environment variable ORACLE_SID is not set

BR0806I End of BRCONNECT processing: ceauusal.log2009-06-16 21.02.03

BR0280I BRCONNECT time stamp: 2009-06-16 21.02.03

BR0804I BRCONNECT terminated with errors

External program terminated with exit code 3

BRCONNECT returned error status E

Job finished.

The DB and CI servers on different hosts with windows server.

The SAPXPG_DBDEST_.. is working fine.

The oracle version is 10.2.0.4 and SAP 4.7.

The ORACLE_SID is set properly also in system variables on both hosts.

We have recently upgraded to 64 bit.

Kindly suggest.

Regards,

Rahul.

[JPReyes · Accepted solution]

Did you check under ora<sid> variables in both hosts?...

Regards

Juan

[Former Member]

Hi,

After setting the SAPDATA_HOME=G:\oracle\pte in system variables and after os restart of servers the problem has been resolved now.

Thanks.

Regards,

Rahul.

[Former Member]

Hi Manoj,

The following variable is already set:

SAPDATA_HOME=G:\oracle\pte

Kindly suggest.

Regards,

Rahul.

[Former Member]

Hi,

After Oslevel restart it is giving following error:

Job started

Step 001 started (program RSDBAJOB, variant &0000000001453, user ID BASIS001)

No application server found on database host - rsh/Gateway will be used

Execute logical command BRCONNECT On host ITECR3PRDDB

Parameters: -u / -jid CHECK20090617113118 -c -f check

BR0801I BRCONNECT 7.00 (41)

BR0152E Environment variable SAPDATA_HOME is not set

BR0806I End of BRCONNECT processing: ceauxrem.log2009-06-17 11.31.20

BR0280I BRCONNECT time stamp: 2009-06-17 11.31.20

BR0804I BRCONNECT terminated with errors

External program terminated with exit code 3

BRCONNECT returned error status E

Job finished.

The environment variables are set properly.

Regards,

Rahul.

[Former Member]

BR0152E Environment variable SAPDATA_HOME is not set

Did you check above env varibale?

[http://help.sap.com/saphelp_erp2004/helpdata/en/e7/4fb2a8ee10294dbb23378a23e84e46/content.htm]

[Former Member]

If you are running DB13 under Windows, this will be done as user SAPService<SID>. Check this user's environment!

[Former Member]

Did you login with sidadm via command prompt and try executing brconnect? Also try executing set command to cross check variable is set correctly.

[Former Member]

Hi,

On both with both hosts.

Regards,

Rahul.

[Former Member]

Hi,

Yes using win 2k3 64 bit.

Regards,

Rahul.

[JPReyes]

Are those variables under User or System varibles? They should be under User variables.

Regards

Juan

[Former Member]

Hi,

The following variables set under pteadm:

ORACLE_HOME=D:\oracle\PTE\102

ORACLE_SID=PTE.

Regards,

Rahul.

[JPReyes]

what about ora<sid>? or you are using windows?

regards

Juan