on 08-17-2009 10:50 AM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
ok
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi all,
I have checked permission and it shows -rwsrwxr-x and owner <sid>adm :sapsys owner.Please suggest.
Regards
Joydeep
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Another thing to check:
make sure the br*tools have the correct permissions (owner of ora<sid> and s-bit set).
Markus
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
IBM AIX RISC System/6000 Error: 13: Permission denied
Check your alert.log file for more details. Looks like some permission issue.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.