on 08-20-2010 8:53 AM
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
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
pwd
/oracle/OI2/sapreorg
#
Rgds
DK
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.