on 01-24-2012 1:19 PM
Hi,
We are performing a CU&UC from R3 4.7 to ECC 6.0 on AIX 5.3/Oracle 10g.
While we are doing the UC, in the import phase we get the SYSTEM
tablespace full and we are unable to extend it due to the following
error:
BR1001I BRSPACE 7.00 (52)
BR1002I Start of BRSPACE processing: sehstuwg.tse 2012-01-24 08.59.06
BR0484I BRSPACE log file: /oracle/PRO/sapreorg/sehstuwg.tse
BR1304E Checking SAP license failed at location BrLicCheck-102
BR0602E No valid SAP license found - please contact SAP
We have already checked SAP Note 912969, upgraded kernel, brtools,
imported sapdba_role from SAP Note 134592 but nothing seems to work.
Please advice.
Best Regards
Hi Nicolas,
As per the error message your system tablespace is full. You need to add a datafile to extend the tablespace.
During import phase , brtools will not be able to connect to database. Hence you need to use SQL commands to add a datafile.
*SQL> select * from v$datafile;*
It will list down all the details of all the datafile in your oracle database along with path.
Use this information to find out the last sequence number of datafile for tablespace SYSTEM.
*SQL>alter tablespace SYSTEM add datafile '<path of new datafile>' size 2048M;
SQL>commit
Above command is used to add a datafile to tablespace SYSTEM of size 2GB. You can change the size as per your requirement.
Regards,
Deepak Kori
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello,
Many thanks for your supoort. I got the the required answer.
Kind Regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Nicolas,
You can add a data file to the system tablespace using SQL commands.
As you are in the process of import you will not be able to add a datafile using brtools.
Regards,
Ershad Ahmed.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
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.