BRSPACE Log File Generated with Wrong User.

[former_member71614]

Hi,

I am trying to drop the tablespace in our BW development system, which has zero objects in it to gain some space for DB.

While dropping the tablespace I am experiencing the following error.

BR0280I BRSPACE time stamp: 2010-08-04 14.37.38

BR0370I Directory /oracle/GBW/sapreorg/seduzpnw created

BR0280I BRSPACE time stamp: 2010-08-04 14.37.38

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

'/* BRSPACE */ ALTER DATABASE BACKUP CONTROLFILE TO '/oracle/GBW/sapreorg/seduzpnw/cntrlGBW.old''

ORA-01580: error creating control backup file /oracle/GBW/sapreorg/seduzpnw/cntrlGBW.old

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

HPUX-ia64 Error: 13: Permission denied

BR0320E Copying of control file to /oracle/GBW/sapreorg/seduzpnw/cntrlGBW.old failed

BR0280I BRSPACE time stamp: 2010-08-04 14.37.38

BR0700E Fatal errors occurred - terminating processing...

BR1020I Number of tablespaces processed: 0

BR1004E BRSPACE function 'tsdrop' failed

BR1008I End of BRSPACE processing: seduzpnw.tsd 2010-08-04 14.37.38

After checking the error, I have checked and observed that the BRTOOLS is creating new directory under /oracle/<sid>/sapreorg (/oracle/GBW/sapreorg) directory.

This new directory is owned by the user gbwadm and not by oragbw. For example,

drwxr-xr-x 2 gbwadm sapsys 96 Aug 4 14:38 seduzpnw

To check this problem, I have also checked the permission of the BRTOOLS files in the kernel directory and permissions are as follows and I think those are correct.

-rwsrwxr-x 1 oragbw sapsys 12551128 Apr 9 2009 brarchive

-rwsrwxr-x 1 oragbw sapsys 12982464 Apr 9 2009 brbackup

-rwsrwxr-x 1 oragbw sapsys 16001264 Apr 9 2009 brconnect

-rwxr-xr-x 1 gbwadm sapsys 13360792 Apr 9 2009 brrecover

-rwxr-xr-x 1 gbwadm sapsys 3724792 Apr 9 2009 brrestore

-rwxr-xr-x 1 gbwadm sapsys 16456192 Apr 9 2009 brspace

-rwsrwxr-x 1 gbwadm sapsys 5587248 Apr 9 2009 brtools

Not able to find-out the cause of the wrong owner. Hence, any help will be greatly appreciated.

Thanks,

Best regards,

Nishchal Nagre.

[peter_dzurov]

Hello,

check Note 113747 - Permissions for DBA tools BR*Tools and SAPDBA.

brtools should have permissions 755 and started as ora<sid>.

Try again afterwards.

[Former Member]

Hi,

Please make sure that you have the following permissions set for the br* files as per the note 113747.

Files : brarchive, brbackup, and brconnect

Permission: 4775

Owner: ora<sid>

Group: sapsys ...

The brarchive, brbackup, and brconnect can be started by the ora<sid> or the <sid>adm OS user.

Files : brrestore, brrecover, brspace and brtools

Permission: 755

Owner: <sid>adm

Group: sapsys

The brrestore, brrecover, brspace and brtools should only be started by the ora<sid> OS user.

Regards,

Varadharajan M