Problem during extending tablespace

[Former Member]

Hi All,

In my system got down because, PSAPSR3701X tablespace is full, when I tried to extend this tablespace using brtools, I am getting the following permission denied error.

BR0253E errno 13: Permission denied

BR0121E Processing of log file /oracle/QAS/sapreorg/sedybakc.tse failed

BR0700E Fatal errors occurred - terminating processing...

BR1008I End of BRSPACE processing: sedybakc.tse 2010-08-20 11.21.34

###############################################################################

BR1001I BRSPACE 7.00 (40)

BR0252E Function fopen() failed for '/oracle/QAS/sapreorg/sedybgqe.tse' at locat

ion main-5

BR0253E errno 13: Permission denied

BR0121E Processing of log file /oracle/QAS/sapreorg/sedybgqe.tse failed

BR0700E Fatal errors occurred - terminating processing...

BR1008I End of BRSPACE processing: sedybgqe.tse 2010-08-20 12.31.48

BR0280I BRSPACE time stamp: 2010-08-20 12.31.48

BR1007I BRSPACE terminated with errors

###############################################################################

It looks similar to the problem posted in Link: [;

I ran ./saproot.sh by user root. Also my sapreorg has ownership orasid and I am able to touch a file in this directory by orasid user. But still no success.

My system is AIX 6.1 with Oracle 10.2.0.4 with SAP ECC6.0 with EHP4.

Please provide your expert suggestions.

Thanks in Advance,

RG//

Ramesh

[Former Member · Accepted solution]

You can manually resize a datafile with sqlplus as a workaround.

SQL> alter database datafile '/oracle/QAS/sapdata1/sr3701x_1/sr3701x.data1' resize <newsize>M;

Did you check if there is still space in the filesystem?

orasid> df -k | grep sapreorg

Cheers Michael

[Former Member]

Hi,

I suppose the user with which u r trying to extend the tablespace does not have the permission to the FS sapreorg.

(BR0252E Function fopen() failed for '/oracle/QAS/sapreorg/sedybgqe.tse' at locat
ion main-5
BR0253E errno 13: Permission denied)

Please make sure that u r trying to extend the tablespace with the users ora<SID> and also make sure that the FS /oracle/QAS/sapreorg has 775 permission set.

Regards,

Varadharajan M

[Former Member]

Thanks to all.

HI Michael,

Your workaround SQL query resolved the problem for time being. But brtools problem still exists.

The space also available in sapreorg file system, almost 99% free out of 2GB.

@Rajesh,

In your suggested note, I didn't find any symtoms regarding my brtools problem. I followed note 113747 suggested for BRTOOLS permissions which suggesting the same permissions as you and Varadhu suggest.

But, I would like to share the origin of this problem is my EHP4 upgrade by EHPi. Because during EHP4 upgrade I created this table space PSAPSR3701X, which is having following log entry in strucQAS.log in my /sapreorg directory.

#BRSRUN... 2010-08-18 13.37.39 sedxrqvz tsc func=tscreate user=qasadm/oraqas

#TSPCRT... 2010-08-18 13.39.49 PSAPSR3701X conts=data assm=auto data=both

#FILEADD.. /oracle/QAS/sapdata4/sr3701x_1/sr3701x.data1 size=30M autoext=yes maxsize=25000M incrsize=20M

#FILEADD.. /oracle/QAS/sapdata4/sr3701x_2/sr3701x.data2 size=30M autoext=yes maxsize=25000M incrsize=20M

#FILEADD.. /oracle/QAS/sapdata4/sr3701x_3/sr3701x.data3 size=30M autoext=yes maxsize=25000M incrsize=20M

I faced following problems after EHP4 upgrade along with above one.

1. database full backup and statics update are not working.

2. saproot.sh and saposcol.exe file is missing in /sapmnt/QAS/exe directory.

I copied the both missing files from Development server, and copied at respective position. After executing saproot.sh I am able resolve backup and db statics update issue.

All this strange problems are arriving after upgrade to EHP4 only.

Any suggestions about this observation?

RG//

Ramesh

[Former Member]

Hi,

Check the permissions of BRTOOLS.

Refer the below note :

[Note 400241 - Problems with ops$ or sapr3 connect to Oracle|https://service.sap.com/sap/support/notes/400241]

Make sure that the permissions are correctly set (4775). Sticky bit permissions might be missing or group membership may be wrong ( should be "sapsys")

Regards.

Rajesh Narkhede