SAPDATA_HOME

[Former Member]

Hello

I have a question about SAPDATA_HOME and related directories.

We installed SAP:Netweaver7.0 SR1 AS JAVA on windows server.

We selected G drive for following database directories through sapinst and installation was finished successfully.

- saparch

- sapbackup

- sapcheck

- sapreorg

- saptrace

But all directories except saptrace were created both on G drive and H drive.

saptrace was created on G drive only.

I checked environment variables, SAPDATA_HOME is H:\oracle\<SID>.

I also checked init<sid>.sap and saparch, sapbackup directories are also defined H:\oracle\<SID..

(there are no "saptrace" entry in init<sid>.sap)

We don't modify manually init<sid>.sap nor environment variables.

My question is;

Is there any problem when we change SAPDATA_HOME from H:\oracle\<SID>. to G:\oracle\<SID> ?

And also remove directories on H drive?

<environment>

OS：Windows2003Server R2

DB：Oracle10.2.0.5

SAP:Netweaver7.0 SR1 AS JAVA

Takae

[Former Member]

Hello Orkun

Thank you for your reply.

I executed DB check with brconnect command and got following error messages.

BR0253E erro 2:No such file or directory

BR0277E determination of disk volume status for H:\oracle\<SID>\saptrace failed

Directory of saptrace is G drive, so there is no saptrace directory on H drive.

I checked init<sid>.sap but there is no definition of saptrace directory.

Is there any way to correct this situation?

Thank you.

Takae

[Former Member]

Hi Takae,

Check the parameters in SPFILE, below;

background_dump_dest
core_dump_dest
user_dump_dest

Then, set the correct location on SAPTRACE environment variable

Best regards,

Orkun Gedik

[Former Member]

Hi,

If you are not planning to move data files, you don't need to change SAPDATA_HOME variable, as well. So, you can change the other variables without re-creating control files. But, don't forget to check parameters in init<DBSID>.sap and spfile/init<DBSID>.ora

Best regards,

Orkun Gedik

[Former Member]

Hello Orkun,

Thank you for your reply!!!!!

I have one question.

Our oracle datafile directories, such as sapdata1 is located on H drive and it's the correct place.

I don't want to change the drive of datafiles.

But want to change the drive of saprarch etc.

Do I have to re-create control files?

Or only change environment variable ,SAPDATA_HOME ?

Thank you and best regards,

Takae

[Former Member]

Hi Takae,

You can't do this by a simple copy paste operation and chaning environment variable. SAPDATA_HOME contains Oracle datafile paths.

First You should create a new control file by using command, below first.

alter database backup controlfile to trace resetlogs;

This will create a new trace under "usertrace" folder. You should replace old data paths with the ones. Then execute the statement. It will create controlfiles on the system. Before doing this operation , you should stop the system and drop (make a backup of them) control files, first. You can find many information about this operation, on the net.

In short, SAPDATA_HOME environment variable is used by BRTOOLS, not Oracle. But, when you decide to move the datafiles, it will affect the Oracle as well. So, you need to perform the steps, that I've mentioned if you are planning to change the data file path.

You have another option to move datafiles is, to use "alter database rename file" command.

You can choose the most suitable way to change location of your data files

Find the ralted documents, below;

http://www.oracle.com/webfolder/technetwork/tutorials/obe/db/9i/r2/paa/obe-dbf/html/Move_DF.htm

http://www.sap-img.com/oracle-database/cloning-database-from-hot-backup.htm

Best regards,

Orkun Gedik