Errors when adding a datafile

[Former Member]

I am trying to add a datafile in one of my QA environments via brtools.

I keep getting this error msg. This file system does not exist anymore and i am not sure where is brtools reading that info from.

Any help would be appreciated.

Options for extension of tablespace PSAPEP1 (1. file)

1 * Last added file name (lastfile) ....... [/oracle/EQ1/sapdata3/eq1_42/eq1.data42]

2 * Last added file size in MB (lastsize) . [5320]

3 - New file to be added (file) ........... [/oracle/EQ1/sapdata5/eq1_43/eq1.data43]

4 ~ Raw disk / link target (rawlink) ...... []

5 - Size of the new file in MB (size) ..... [5320]

6 - File autoextend mode (autoextend) ..... [yes]

7 - Maximum file size in MB (maxsize) ..... [10000]

8 - File increment size in MB (incrsize) .. [20]

9 - SQL command (command) ................. [alter tablespace PSAPEP1 add datafile '/oracle/EQ1/sapdata5/eq1_43/eq1.data43' size 5320M autoextend on next 20M maxsize 10000M]

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

-

---

BR0662I Enter your choice:

c

BR0280I BRSPACE time stamp: 2008-06-12 14.43.11

BR0663I Your choice: 'c'

BR0259I Program execution will be continued...

BR0280I BRSPACE time stamp: 2008-06-12 14.43.11

BR1091I Next data file can be specified now

BR0675I Do you want to perform this action?

BR0676I Enter 'y[es]' to perform the action, 'n[o]/c[ont]' to skip it, 's[top]' to abort:

n

BR0280I BRSPACE time stamp: 2008-06-12 14.43.18

BR0257I Your reply: 'n'

BR0678I The action will be skipped...

BR0252E Function mkdir() failed for '/eq1_bk/sapreorg/sdydaple' at location BrDirCreate-1

BR0253E errno 2: No such file or directory

BR0280I BRSPACE time stamp: 2008-06-12 14.43.18

BR0700E Fatal errors occurred - terminating processing...

BR1020I Number of tablespaces processed: 0

BR1004E BRSPACE function 'tsextend' failed

BR1008I End of BRSPACE processing: sdydaple.tse 2008-06-12 14.43.18

BR0280I BRSPACE time stamp: 2008-06-12 14.43.18

BR1007I BRSPACE terminated with errors

[markus_doehr2 · Accepted solution]

> BR0280I BRSPACE time stamp: 2008-06-12 14.43.18

> BR0257I Your reply: 'n'

> BR0678I The action will be skipped...

> BR0252E Function mkdir() failed for '/eq1_bk/sapreorg/sdydaple' at location BrDirCreate-1

> BR0253E errno 2: No such file or directory

There are two possibilities for that error:

- the logged in user has no permissions to create a directory

- brtools were updated and "saproot.sh" did not run to adapt the permissions (s-user-bit) for brspace

Markus

[Former Member · Accepted solution]

Yes that was my first thought as well.

However it was not the problem. For some odd reason in initEQ1.sap the parameter had changed which was pointing to this directory. So i had to edit it and it worked.

Thanks for help.