SAPDATA_HOME

[Former Member]

I executed transaction DB02 to see tablespaces

I saw that the some tablespaces have not enought free space like below

<b>Tablespace Size (kb) Free (kb) Used (%)</b>

<b>PSAPBXP</b> 14.970.880 25.280 99

<b>PSAPBXP640</b> 8.396.800 17.536 99

<b>PSAPBXPDB</b> 1.146.880 1.088 99

I executed brtools to extend spaces that time the message came to screen:

<b>SAPDATA_HOME</b> is not set

SapSID = BXP

Oracle SID = ora

so which path must be set as SAPDATA_HOME?

thanks

[prateek · Accepted solution]

Hi Cemil,

You must set SAPDATA_HOME on the directory under which the standard sapdata directories appear.

SAPDATA_HOME=<drive>:\oracle\<sid>

Refer SAP Note 556232

Search for "SAPDATA_HOME not set" here

Regards,

Prateek

[Former Member]

Hi,

Check this links:

http://help.sap.com/saphelp_nw04s/helpdata/en/0d/d300a94a0c11d182b80000e829fbfe/frameset.htm

/people/sumit.khullar2/blog/2005/12/20/quickest-way-to-change-sid-of-oracle-based-sap-system

[Former Member]

<b>Tablespace Size (kb) Free (kb) Used (%)</b>

<b>PSAPBXP</b> 14.970.880 25.280 <b>99</b>

<b>PSAPBXP640</b> 8.396.800 17.536 <b>99</b>

<b>PSAPBXPDB</b> 1.146.880 1.088 <b>99</b>