migrate 9i RAC to 10g (merged) [message #261171] |
Wed, 22 August 2007 01:42 |
dirish
Messages: 232 Registered: November 2006
|
Senior Member |
|
|
Actually,
I have an oracle 9i RAC database running (raw disks) and would like to move it to a single 10g database (file system)
Can some1 help me.
Thx,
Dirish
|
|
|
|
Re: migrate 9i RAC to 10g [message #261197 is a reply to message #261182] |
Wed, 22 August 2007 02:22 |
dirish
Messages: 232 Registered: November 2006
|
Senior Member |
|
|
Hi,
I have used DBCA to create a template from the 9iRAC, that's ok, but when I use this template to create a database, I can't.
If in DBCA, I select to create a database using the default template (general purpose) to create a database and then do a full export/import will that work?
Thank you,
Dirish
|
|
|
|
|
Re: migrate 9i RAC to 10g [message #261241 is a reply to message #261213] |
Wed, 22 August 2007 03:47 |
dirish
Messages: 232 Registered: November 2006
|
Senior Member |
|
|
Hi,
I just created a database with 3 control files : CONTROL01.CTL, CONTROL02.CTL, CONTROL03.CTL
and
SYSAUX01.DBF, SYSTEM01.DBF, TEMP01.DBF, UNDOTBS01.DBF, USERS01.DBF
and
REDO01, REDO02, REDO03
ok.
I did an exp from another db and imported it in the newly created db, it's unsuccessful with these errors :
IMP-00015: following statement failed because the object already exists
IMP-00003: ORACLE error 1119 encountered
ORA-01119: error in creating database file '/data/oradata/webcms/cmstest.dbf'
ORA-27040: file create error, unable to create file
OSD-04002: unable to open file
O/S-Error: (OS 3) The system cannot find the path specified.
IMP-00003: ORACLE error 1917 encountered
ORA-01917: user or role 'TESTCMS' does not exist
IMP-00017: following statement failed with ORACLE error 1917:
ORA-01435: user does not exist
I think that the users should be created on the target database.
Thx
|
|
|
|
|
|
|
|
Importing 9i Data into Oracle 10g DB [message #261364 is a reply to message #261171] |
Wed, 22 August 2007 07:03 |
ShaShalini
Messages: 59 Registered: January 2007
|
Member |
|
|
Hi All
Can anyone suggest how to proceed.
I have my Database in Oracle 9i RAC. I want to imoprt all the data from Oracle 9i to Oracle 10g .. My Oracle 10g is not on Cluster
Can anyone tell me how I can do this
Thanks
|
|
|
|
Re: migrate 9i RAC to 10g [message #261456 is a reply to message #261337] |
Wed, 22 August 2007 11:51 |
DreamzZ
Messages: 1666 Registered: May 2007 Location: Dreamzland
|
Senior Member |
|
|
dirish wrote on Wed, 22 August 2007 05:10 | Sir,
I have aroud 25-30 tablespace, this will take a lot of time. Dnt you have another solution.
Thx
|
SQL> ;
1 select 'CREATE TABLESPACE '||TABLESPACE_NAME||'
2* DATAFILE '''||FILE_NAME||''' SIZE '||ROUND(BYTES)/1048576||'M ;' FROM DBA_DATA_FILES
SQL>
now its will take only 1 minute to create script of your all tablespaces.
|
|
|
Re: migrate 9i RAC to 10g [message #261471 is a reply to message #261456] |
Wed, 22 August 2007 12:19 |
|
Michel Cadot
Messages: 68718 Registered: March 2007 Location: Saint-Maur, France, https...
|
Senior Member Account Moderator |
|
|
He can't do this as he comes from a raw device database to a file system one and so all files are different.
Maybe if he defined a rule between old file names and new ones he can do it in SQL.
Regards
Michel
[Updated on: Wed, 22 August 2007 12:19] Report message to a moderator
|
|
|
Re: migrate 9i RAC to 10g [message #263558 is a reply to message #261471] |
Thu, 30 August 2007 06:12 |
dirish
Messages: 232 Registered: November 2006
|
Senior Member |
|
|
Hi,
I created the tablespaces/datafiles.
I did a full export and did a full import and I have these errors:
"
IMP-00015: following statement failed because the object already exists:
"CREATE TABLESPACE "USERS" BLOCKSIZE 8192 DATAFILE '/dev/vx/rdsk/rac-dg/sun"
"_raw_users' SIZE 334495744 EXTENT MANAGEMENT LOCAL AUTOALLOCATE ONL"
"INE PERMANENT NOLOGGING SEGMENT SPACE MANAGEMENT AUTO"
"
Thank you,
Dirish
|
|
|
|
|
|
Re: migrate 9i RAC to 10g [message #263794 is a reply to message #263784] |
Fri, 31 August 2007 01:30 |
dirish
Messages: 232 Registered: November 2006
|
Senior Member |
|
|
Hello,
i used these commands:
exp system/xxx FULL=y FILE=export.dmp LOG=export.log (file system)
&
imp system/xxx FULL=y FILE=export.dmp ignore=yes LOG=import.log (windows xp)
The import is not successful due to these errors from the import.log
IMP-00003: ORACLE error 1119 encountered
ORA-01119: error in creating database file '/dev/vx/rdsk/rac-dg/sun_raw_cms'
ORA-27040: file create error, unable to create file
OSD-04002: unable to open file
O/S-Error: (OS 3) The system cannot find the path specified.
Thank you,
Dirish
|
|
|
|
|
|
Re: migrate 9i RAC to 10g [message #263881 is a reply to message #263855] |
Fri, 31 August 2007 03:59 |
dirish
Messages: 232 Registered: November 2006
|
Senior Member |
|
|
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
Export file created by EXPORT:V09.02.00 via conventional path
import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
export client uses UTF8 character set (possible charset conversion)
export server uses UTF8 NCHAR character set (possible ncharset conversion)
. importing SYSTEM's objects into SYSTEM
IMP-00017: following statement failed with ORACLE error 1119:
"CREATE TABLESPACE "CNP" BLOCKSIZE 8192 DATAFILE '/dev/vx/rdsk/rac-dg/sun_r"
"aw_cnp' SIZE 17999M EXTENT MANAGEMENT LOCAL AUTOALLOCATE ONLINE PER"
"MANENT NOLOGGING"
IMP-00003: ORACLE error 1119 encountered
ORA-01119: error in creating database file '/dev/vx/rdsk/rac-dg/sun_raw_cnp'
ORA-27040: file create error, unable to create file
OSD-04002: unable to open file
O/S-Error: (OS 3) The system cannot find the path specified.
IMP-00017: following statement failed with ORACLE error 1119:
"CREATE TABLESPACE "CMSTRN" BLOCKSIZE 8192 DATAFILE '/dev/vx/rdsk/rac-dg/su"
"n_raw_cms' SIZE 519045120 EXTENT MANAGEMENT LOCAL AUTOALLOCATE ONLI"
"NE PERMANENT "
|
|
|
|