Question:
Hi all,
We're running BW310 on NT server, Oracle 9i, and we have made a system copy from a server to a new one, during this copy, some problems were solved by some correction proposed by SAP Support, but after the copy, the system is running, but when selection the tablespace information, all the tablespaces are created as a normal setting (not LMTS), so, I don't want to add a new task to create a new TS with LMTS and so on, I've checked the creation script used during the system copy, nothing, and checked for the Kernel version used, so, can you please advise about this issue.
_________________
Best regards,
Jade
Answer:
what copy method are you using? Answer will considerably vary upon your answer.
_________________
SapFans Moderator
NetWeaver ‘04–SAP Web AS for ORACLE certified
Search: /forums/search.php
SAP Notes: http://service.sap.com/notes
SAP Help: http://help.sap.com
Basic Rules: /forums/viewtopic.php?t=222759
Answer:
Hi Snowy,
We have received from SAP a kit, it's simply a installation kit, I've installed Central instance, and Install DB instance by selecting a system copy (instead of a new installation), and after this I've specified the location of the flat files created from a export (from source system using SAP kit ), I hope that it's clear otherwise, I'll give you more details...
_________________
Best regards,
Jade
Answer:
So, You are using SAPINST to export the DB and reimport again with SAPINST?
consider updating all these tools from SAPNET. then try again. If this still fails, I'm pretty sure that you will be able to modify SQL scripts.
what is the main reason for using this method? have you considered using backup/restore method?
_________________
SapFans Moderator
NetWeaver ‘04–SAP Web AS for ORACLE certified
Search: /forums/search.php
SAP Notes: http://service.sap.com/notes
SAP Help: http://help.sap.com
Basic Rules: /forums/viewtopic.php?t=222759
Answer:
Hi Snowy,
Thanks for your response. We are using this procedure because the Source BW system is Windows 32bits and the new server is x64bits (not itanium) and this version support only Oracle 10i and not 9i, for this reason I've used this procedure. We can use, based on SAP note, a sql statments to create new tablespaces LMTS based on current but his step will take time and I've already test it on another server, thanks again...
_________________
Best regards,
Jade
Answer:
Why not consider to upgrade your actual server to Oracle 10 first, then copy database using backup/restore or network copy to your new server?
_________________
SapFans Moderator
NetWeaver ‘04–SAP Web AS for ORACLE certified
Search: /forums/search.php
SAP Notes: http://service.sap.com/notes
SAP Help: http://help.sap.com
Basic Rules: /forums/viewtopic.php?t=222759
Answer:
We can't do this, because of the timing to upgrade from 9i to 10i (one day, one weekend), and the migration afterward. This proposal was made by Sap.
I've checked most of the components to locate where the TS creation is done but can't find it, only in the tablespaces.xml files generated during the installation. With this procedure, specially for BW310, we start a program from source system to generate 2 sql and we have to put those sql into the directory used during the import, and we have to update the file DBSIZE.XML to define the tablespace size PSAP<sid><release>, but for the rest of TS nothing has been changed, and the TS type for all the DB is normal management and not LMTS.
_________________
Best regards,
Jade
Answer:
consider updating SQL commands from DBSIZE.XML such as:
CREATE TABLESPACE "PSAPFACTD"
DATAFILE 'h:\oracle\tbw\sapdata5\factd_1\factd.data1'
SIZE 33554424K REUSE,
'h:\oracle\tbw\sapdata5\factd_2\factd.data2'
SIZE 33554424K REUSE
EXTENT MANAGEMENT LOCAL
SEGMENT SPACE MANAGEMENT AUTO;
_________________
SapFans Moderator
NetWeaver ‘04–SAP Web AS for ORACLE certified
Search: /forums/search.php
SAP Notes: http://service.sap.com/notes
SAP Help: http://help.sap.com
Basic Rules: /forums/viewtopic.php?t=222759
Answer:
Hi Snowy,
Can't update the XML file using your proposal, and to be fixed, there's the content of the file:
<?xml version="1.0" encoding="ISO-8859-1" standalone="no"?>
<!DOCTYPE tables SYSTEM "keydb.dtd" >
<tables>
<tableset srcid="$Id: //bas/640_REL/src/R3ld/R3szchk/R3szdd.c#21 $">
<table name="tORA_DatafilesImport" namespaces="DBMODORA">
<columns>
<column name="tblspName">
</column>
<column name="tblspSize">
</column>
<column name="sapdataDir">
</column>
</columns>
<row>
<fld name="tblspName">
<strval><![CDATA[PSAP@SCHEMAID@USR]]>
</strval>
</fld>
<fld name="tblspSize">
<strval><![CDATA[20]]>
</strval>
</fld>
<fld name="sapdataDir">
<strval><![CDATA[SAPDATA3]]>
</strval>
</fld>
</row>
<row>
<fld name="tblspName">
<strval><![CDATA[PSAP@SCHEMAID@620]]>
</strval>
</fld>
<fld name="tblspSize">
<strval><![CDATA[2000]]>
</strval>
</fld>
<fld name="sapdataDir">
<strval><![CDATA[SAPDATA2]]>
</strval>
</fld>
</row>
<row>
<fld name="tblspName">
<strval><![CDATA[PSAP@SCHEMAID@620]]>
</strval>
</fld>
<fld name="tblspSize">
<strval><![CDATA[2000]]>
</strval>
</fld>
<fld name="sapdataDir">
<strval><![CDATA[SAPDATA2]]>
</strval>
</fld>
</row>
<row>
<fld name="tblspName">
<strval><![CDATA[PSAP@SCHEMAID@620]]>
</strval>
</fld>
<fld name="tblspSize">
<strval><![CDATA[2000]]>
</strval>
</fld>
<fld name="sapdataDir">
<strval><![CDATA[SAPDATA2]]>
</strval>
</fld>
</row>
<row>
<fld name="tblspName">
<strval><![CDATA[PSAP@SCHEMAID@620]]>
</strval>
</fld>
<fld name="tblspSize">
<strval><![CDATA[2000]]>
</strval>
</fld>
<fld name="sapdataDir">
<strval><![CDATA[SAPDATA2]]>
</strval>
</fld>
</row>
<row>
<fld name="tblspName">
<strval><![CDATA[PSAP@SCHEMAID@620]]>
</strval>
</fld>
<fld name="tblspSize">
<strval><![CDATA[2000]]>
</strval>
</fld>
<fld name="sapdataDir">
<strval><![CDATA[SAPDATA2]]>
</strval>
</fld>
</row>
<row>
<fld name="tblspName">
<strval><![CDATA[PSAP@SCHEMAID@]]>
</strval>
</fld>
<fld name="tblspSize">
<strval><![CDATA[10000]]>
</strval>
</fld>
<fld name="sapdataDir">
<strval><![CDATA[SAPDATA2]]>
</strval>
</fld>
</row>
<row>
<fld name="tblspName">
<strval><![CDATA[PSAP@SCHEMAID@]]>
</strval>
</fld>
<fld name="tblspSize">
<strval><![CDATA[10000]]>
</strval>
</fld>
<fld name="sapdataDir">
<strval><![CDATA[SAPDATA2]]>
</strval>
</fld>
</row>
<row>
<fld name="tblspName">
<strval><![CDATA[PSAP@SCHEMAID@]]>
</strval>
</fld>
<fld name="tblspSize">
<strval><![CDATA[10000]]>
</strval>
</fld>
<fld name="sapdataDir">
<strval><![CDATA[SAPDATA2]]>
</strval>
</fld>
</row>
<row>
<fld name="tblspName">
<strval><![CDATA[PSAP@SCHEMAID@]]>
</strval>
</fld>
<fld name="tblspSize">
<strval><![CDATA[10000]]>
</strval>
</fld>
<fld name="sapdataDir">
<strval><![CDATA[SAPDATA2]]>
</strval>
</fld>
</row>
<row>
<fld name="tblspName">
<strval><![CDATA[PSAP@SCHEMAID@]]>
</strval>
</fld>
<fld name="tblspSize">
<strval><![CDATA[10000]]>
</strval>
</fld>
<fld name="sapdataDir">
<strval><![CDATA[SAPDATA2]]>
</strval>
</fld>
</row>
<row>
<fld name="tblspName">
<strval><![CDATA[PSAP@SCHEMAID@]]>
</strval>
</fld>
<fld name="tblspSize">
<strval><![CDATA[10000]]>
</strval>
</fld>
<fld name="sapdataDir">
<strval><![CDATA[SAPDATA2]]>
</strval>
</fld>
</row>
<row>
<fld name="tblspName">
<strval><![CDATA[PSAP@SCHEMAID@]]>
</strval>
</fld>
<fld name="tblspSize">
<strval><![CDATA[10000]]>
</strval>
</fld>
<fld name="sapdataDir">
<strval><![CDATA[SAPDATA2]]>
</strval>
</fld>
</row>
<row>
<fld name="tblspName">
<strval><![CDATA[PSAPTEMP]]>
</strval>
</fld>
<fld name="tblspSize">
<strval><![CDATA[5000]]>
</strval>
</fld>
<fld name="sapdataDir">
<strval><![CDATA[SAPDATA1]]>
</strval>
</fld>
</row>
<row>
<fld name="tblspName">
<strval><![CDATA[PSAPROLL]]>
</strval>
</fld>
<fld name="tblspSize">
<strval><![CDATA[2000]]>
</strval>
</fld>
<fld name="sapdataDir">
<strval><![CDATA[SAPDATA1]]>
</strval>
</fld>
</row>
<row>
<fld name="tblspName">
<strval><![CDATA[PSAPROLL]]>
</strval>
</fld>
<fld name="tblspSize">
<strval><![CDATA[2000]]>
</strval>
</fld>
<fld name="sapdataDir">
<strval><![CDATA[SAPDATA1]]>
</strval>
</fld>
</row>
<row>
<fld name="tblspName">
<strval><![CDATA[PSAPROLL]]>
</strval>
</fld>
<fld name="tblspSize">
<strval><![CDATA[2000]]>
</strval>
</fld>
<fld name="sapdataDir">
<strval><![CDATA[SAPDATA1]]>
</strval>
</fld>
</row>
<row>
<fld name="tblspName">
<strval><![CDATA[PSAPROLL]]>
</strval>
</fld>
<fld name="tblspSize">
<strval><![CDATA[2000]]>
</strval>
</fld>
<fld name="sapdataDir">
<strval><![CDATA[SAPDATA1]]>
</strval>
</fld>
</row>
<row>
<fld name="tblspName">
<strval><![CDATA[PSAPROLL]]>
</strval>
</fld>
<fld name="tblspSize">
<strval><![CDATA[2000]]>
</strval>
</fld>
<fld name="sapdataDir">
<strval><![CDATA[SAPDATA1]]>
</strval>
</fld>
</row>
<row>
<fld name="tblspName">
<strval><![CDATA[SYSTEM]]>
</strval>
</fld>
<fld name="tblspSize">
<strval><![CDATA[1000]]>
</strval>
</fld>
<fld name="sapdataDir">
<strval><![CDATA[SAPDATA1]]>
</strval>
</fld>
</row>
</table>
</tableset>
</tables>
_________________
Best regards,
Jade
Answer:
ok then, consider creating tablespaces manually before... or check other XML files becasue I do not see how SAP instlalation program will decide how bif those datafiles will be created... it must be setup somewhere.
_________________
SapFans Moderator
NetWeaver ‘04–SAP Web AS for ORACLE certified
Search: /forums/search.php
SAP Notes: http://service.sap.com/notes
SAP Help: http://help.sap.com
Basic Rules: /forums/viewtopic.php?t=222759