cancel
Showing results for 
Search instead for 
Did you mean: 

problem in extending one of the table space. It seems permission problem.

Former Member
0 Kudos

Dear All,

I am facing problem in extending one of the table space. It seems permission problem. But I am not sure how to correct? It will be done from OS or DB or should I execute brtool with ora<sid> / orac11. Detail logs given below:

Options for extension of tablespace PSAPSTABD (1. file)

1 * Last added file name (lastfile) ....... [/oracle/OI2/sapdata1/stabd_3/stabd.data3]

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

3 - New file to be added (file) ........... [/oracle/OI2/sapdata1/stabd_4/stabd.data4]

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

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

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

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

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

9 - SQL command (command) ................. [alter tablespace PSAPSTABD add datafile '/oracle/OI2/sapdata1/stabd_4/stabd.data4' size 1190M autoextend on next 200M maxsize 3600M]

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

BR0662I Enter your choice:

BR0280I BRSPACE time stamp: 2010-08-20 12.04.07

BR0663I Your choice: 'c'

BR0259I Program execution will be continued...

BR0280I BRSPACE time stamp: 2010-08-20 12.04.07

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:

BR0280I BRSPACE time stamp: 2010-08-20 12.04.28

BR0257I Your reply: 'c'

BR0678I The action will be skipped...

BR0259I Program execution will be continued...

BR0280I BRSPACE time stamp: 2010-08-20 12.04.28

BR0370I Directory /oracle/OI2/sapreorg/sedyaquf created

BR0280I BRSPACE time stamp: 2010-08-20 12.04.28

BR0301E SQL error -1580 at location BrCtlCopy-1

ORA-01580: error creating control backup file /oracle/OI2/sapreorg/sedyaquf/cntrlOI2.old

ORA-27040: file create error, unable to create file

SVR4 Error: 13: Permission denied

BR0320E Copying of control file to /oracle/OI2/sapreorg/sedyaquf/cntrlOI2.old failed

BR0280I BRSPACE time stamp: 2010-08-20 12.04.28

BR0700E Fatal errors occurred - terminating processing...

BR1020I Number of tablespaces processed: 0

BR1004E BRSPACE function 'tsextend' failed

BR1008I End of BRSPACE processing: sedyaquf.tse 2010-08-20 12.04.28

BR0280I BRSPACE time stamp: 2010-08-20 12.04.28

BR1007I BRSPACE terminated with errors

Note: where control file is created having following permission

  1. ls -ltr

total 64

-rw-rr 1 oraoi2 dba 194 Oct 26 2007 strucOI2.log

drwxr-xr-x 2 oraoi2 dba 512 Oct 26 2007 sdwlmkmn

drwxr-xr-x 2 oi2adm 101 512 Aug 20 11:59 sedyaqaz

-rw-rr 1 oi2adm 101 20435 Aug 20 11:59 sedyaqaz.tse

drwxr-xr-x 2 oi2adm 101 512 Aug 20 12:04 sedyaquf

-rwxrwxrwx 1 oraoi2 dba 364 Aug 20 12:04 spaceOI2.log

-rw-rr 1 oi2adm 101 6422 Aug 20 12:04 sedyaquf.tse

  1. pwd

/oracle/OI2/sapreorg

#

Rgds

DK

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi,

ORA-01580: error creating control backup file /oracle/OI2/sapreorg

Ensure that the FS sapreorg has 775 permission. Also make sure that u r using ora<SID> user to execute BRTools.

Regards,

Varadharajan M

Former Member
0 Kudos

Hello,

Are you logged on to the OS with the user oraoi2, if not please try to logon with oraoi2 and then run brtools.

Regards,

Rohan.