Importing from 9i to 11g - Getting ORA-29339 error because of block size? [message #478030] |
Tue, 05 October 2010 15:01 |
chris32680
Messages: 92 Registered: January 2006 Location: Charlotte
|
Member |
|
|
Good afternoon,
We are working on migrating from 9.2.0.4 to 11.2 and we've set up a test machine so that we could test the install and the import (as well as test additional 11g features that we want to begin using).
So we created the database and created all of the tablespaces beforehand.
Our import command is
$ORACLE_HOME/bin/imp system/manager FULL=Y BUFFER=140000 FILE=/dbexport/Lhtech.exp VOLSIZE=2000M GRANTS=Y INDEXES=Y COMMIT=Y IGNORE=Y
However, when we run the import, we get the errors like so:
Import: Release 11.2.0.1.0 - Production on Tue Oct 5 15:01:19 2010
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Export file created by EXPORT:V09.02.00 via conventional path
import done in US7ASCII character set and UTF8 NCHAR character set
export server uses AL16UTF16 NCHAR character set (possible ncharset conversion)
. importing SYSTEM's objects into SYSTEM
IMP-00017: following statement failed with ORACLE error 29339:
"CREATE TABLESPACE "TS1" BLOCKSIZE 2048 DATAFILE '/data1/oracle/Lhtech/ts1L"
"htech.dbf' SIZE 1953M EXTENT MANAGEMENT DICTIONARY DEFAULT NOCOMPRES"
"S STORAGE(INITIAL 1048576 NEXT 512000 MINEXTENTS 1 MAXEXTENTS 121 PCTINCRE"
"ASE 0) ONLINE PERMANENT NOLOGGING"
IMP-00003: ORACLE error 29339 encountered
ORA-29339: tablespace block size 2048 does not match configured block sizes
IMP-00017: following statement failed with ORACLE error 29339:
"CREATE TABLESPACE "TS2" BLOCKSIZE 2048 DATAFILE '/data2/oracle/Lhtech/ts2L"
"htech.dbf' SIZE 2929M EXTENT MANAGEMENT DICTIONARY DEFAULT NOCOMPRES"
"S STORAGE(INITIAL 1048576 NEXT 512000 MINEXTENTS 1 MAXEXTENTS 121 PCTINCRE"
"ASE 0) ONLINE PERMANENT NOLOGGING"
...snip....
IMP-00000: Import terminated unsuccessfully
Tuesday, October 5, 2010 3:01:40 PM EDT
First of all, the block size in our "newly" created tablespaces is 8192...and these are obviously trying to recreate the tablespaces with a block size of 2048.
2 questions:
1) Why is it not ignoring these create tablespace commands when those tablespaces already exist?
2) how in the world do we get around the block size issue? We've tried nearly everything we could find, but we've still not had any luck.
Any help would be greatly appreciated.
Thanks
|
|
|
|
|
Re: Importing from 9i to 11g - Getting ORA-29339 error because of block size? [message #478034 is a reply to message #478033] |
Tue, 05 October 2010 15:16 |
chris32680
Messages: 92 Registered: January 2006 Location: Charlotte
|
Member |
|
|
16:18:01 >;
1* select tablespace_name, file_name from dba_data_files order by 1,2
16:18:03 >/
TABLESPACE_NAME FILE_NAME
--------------- --------------------------------------------------
SYSAUX /data3/oracle/DEVdms/sysauxDEVdms.dbf
SYSTEM /data2/oracle/DEVdms/systemDEVdms.dbf
TS1 /data1/oracle/DEVdms/ts1DEVdms.dbf
TS2 /data2/oracle/DEVdms/ts2DEVdms.dbf
TS3 /data3/oracle/DEVdms/ts3DEVdms.dbf
TS4 /data3/oracle/DEVdms/ts4DEVdms.dbf
TS5 /data3/oracle/DEVdms/ts5DEVdms.dbf
TSARCH /data1/oracle/DEVdms/tsarchDEVdms.dbf
TSARCHINX /data1/oracle/DEVdms/tsarchinxDEVdms.dbf
TSIDH /data2/oracle/DEVdms/tsidhDEVdms.dbf
TSTEMP /data1/oracle/DEVdms/tstempDEVdms.dbf
TSUNDO /data3/oracle/DEVdms/tsundoDEVdms.dbf
JoyDivision, yeah, that's what's weird. we DID create the tablespaces..and set IGNORE=Y in the import command.
Thanks all for the help.
|
|
|
|
|
Re: Importing from 9i to 11g - Getting ORA-29339 error because of block size? [message #478128 is a reply to message #478030] |
Wed, 06 October 2010 08:30 |
chris32680
Messages: 92 Registered: January 2006 Location: Charlotte
|
Member |
|
|
i believe i've been focusing on the wrong problem here.
While the import is throwing errors on the tablespace creates, it's further down in the import when creating the users that i think is actually causing the problem. (not sure why we got hung up on the block size part)
Back on 9i, we had our temporary tablespace created as permanent tablespace.
And unknowingly, we created the temp TS on the 11g DB as a permanent TS also.
So when it trys to create the schema owner of our data, it's failing because of the temp ts declaration.
I really appreciate both of you guys' time on this.
|
|
|
|
|