Error in Add Data File by using Extend Table Space

[former_member281396]

Hi All,

I am trying to extend tablespace by adding a datafile.

I am using BRTOOLS.

But it is giving the following error:-

BR0301E SQL error -1580 at location BrCtlCopy-1

ORA-01580: error creating control backup file /oracle/<SID>/sapreorg/sdzautpx/cntrlJTD.old

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

IBM AIX RISC System/6000 Error: 13: Permission denied

BR0320E Copying of control file to /oracle/<SID>/sapreorg/sdzautpx/cntrlJTD.old failed

BR0280I BRSPACE time stamp: 2008-10-16 14.11.56

BR0700E Fatal errors occurred - terminating processing...

BR1020I Number of tablespaces processed: 0

BR1004E BRSPACE function 'tsextend' failed

I am using BRTOOLS 7.0 and Patch Lavel 34 on Oracle 9.2 and AIX 5.3.At the time of running BRTOOLS I am using ORA<SID> User and owner is ora<sid> dba.

Please let me know why I am getting this error.Please help me out from this problem.

Regards

Joydeep

[Former Member · Accepted solution]

Make sure directory /oracle/<SID>/sapreorg exists and is writeable for user ora<sid>.

Make sure Oracle instantclient 10g is installed, as per SAP note 849483.

[Former Member]

Go to exe directory as <SIDADM>

check the permissions of br , the owner should be >ORASID<*

or

change the permission of brspace to 775

and check it once

[former_member281396]

ok

[former_member65295]

I have just upgraded ECC6 to EHP4 and amexperiencing the same behavior. I have done all of the aforementioned checks as well. I was able to use ora<sid>to create tablespaces, extend existing tablespaces, prior to the upgrade but not since. I have followed the post installation procedures....saproot.sh, sapdba_role,and verified permissions. Any other suggestions?

[Former Member]

Ownership of sapreorg directory should be ora<sid>:dba

Guessing you can touch a file in sapreorg directory

Then the question would be who owns the brtools executable ??

Pravin

[former_member281396]

Hi all,

I have given 777 permission to sapreorg and also run ./saproot.sh SID from exe directory.But still it shows same error as below.

BR0370I Directory /oracle/JTD/sapreorg/sebgptqk created

BR0280I BRSPACE time stamp: 2009-08-18 09.11.15

BR0301E SQL error -1580 at location BrCtlCopy-1, SQL statement:

'/* BRSPACE */ ALTER DATABASE BACKUP CONTROLFILE TO '/oracle/JTD/sapreorg/sebgptqk/cntrlJTD.old''

ORA-01580: error creating control backup file /oracle/JTD/sapreorg/sebgptqk/cntrlJTD.old

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

IBM AIX RISC System/6000 Error: 13: Permission denied

BR0320E Copying of control file to /oracle/JTD/sapreorg/sebgptqk/cntrlJTD.old failed

Please check and give me some light on this problem.

Thanks & Regards

Joydeep

[Former Member]

I think owner of the folder is orasid:dba . But u told that orasid:sapsys so check with that.

[Former Member]

Did you try executing saproot.sh as suggested above?

Log in as Root. go to /sapmnt/<SID>/exe

>./saproot.sh <SID>

this will change the permissions of br* tools as required.

[former_member281396]

Hi all,

I have checked permission and it shows -rwsrwxr-x and owner <sid>adm :sapsys owner.Please suggest.

Regards

Joydeep

[markus_doehr2]

Execute

./saproot.sh <SID>

in the kernel directory. This script fixes the wrong permissions.

Markus

[ashish_vikas]

Hi,

why dont u try giving 777 to /oracle/<SID>/sapreorg and see with which user id, files are getting created. Also directly run brspace command with orasid user id..it should not give you permission issue.

ashish

[markus_doehr2]

> why dont u try giving 777 to /oracle/<SID>/sapreorg

Because this is a security issue if everyone able to logon to the machine can "rm -rf sapreorg".

Most likely the br*tools were updated and saproot.sh not executed.

Markus

[markus_doehr2]

Another thing to check:

make sure the br*tools have the correct permissions (owner of ora<sid> and s-bit set).

Markus

[Former Member]

IBM AIX RISC System/6000 Error: 13: Permission denied

Check your alert.log file for more details. Looks like some permission issue.

[Former Member]

Hi Nirmal,

Please check if some other process is simultaneously running in the system like archive log backup or any DB releated Job. Also, are u facing the same problem when you are running any jobs in DB13 or taking the backups.

Regards,

Sharath