Home » Server Options » RAC & Failsafe » migrate 9i RAC to 10g (merged)
migrate 9i RAC to 10g (merged) [message #261171] Wed, 22 August 2007 01:42 Go to next message
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 #261182 is a reply to message #261171] Wed, 22 August 2007 01:59 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Export full, create a new database with tablespaces on your file system, import full.

Regards
Michel
Re: migrate 9i RAC to 10g [message #261197 is a reply to message #261182] Wed, 22 August 2007 02:22 Go to previous messageGo to next message
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 #261213 is a reply to message #261197] Wed, 22 August 2007 03:02 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I don't use DBCA, I only use scripts.
Create an empty database with dbca with just system, sysaux and undo tablespace then add your tablespaces and import.

Regards
Michel

Re: migrate 9i RAC to 10g [message #261224 is a reply to message #261213] Wed, 22 August 2007 03:15 Go to previous messageGo to next message
dirish
Messages: 232
Registered: November 2006
Senior Member
Ok Sir,

I will just try it and let you know.

Thx
Re: migrate 9i RAC to 10g [message #261241 is a reply to message #261213] Wed, 22 August 2007 03:47 Go to previous messageGo to next message
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

Re: migrate 9i RAC to 10g [message #261246 is a reply to message #261241] Wed, 22 August 2007 03:49 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You missed one step:
Quote:
add your tablespaces

Regards
Michel
Re: migrate 9i RAC to 10g [message #261249 is a reply to message #261246] Wed, 22 August 2007 03:52 Go to previous messageGo to next message
dirish
Messages: 232
Registered: November 2006
Senior Member
you mean that I should create all tablespaces
Re: migrate 9i RAC to 10g [message #261280 is a reply to message #261249] Wed, 22 August 2007 04:48 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes, all custom ones.

Regards
Michel
Re: migrate 9i RAC to 10g [message #261337 is a reply to message #261280] Wed, 22 August 2007 06:10 Go to previous messageGo to next message
dirish
Messages: 232
Registered: November 2006
Senior Member
Sir,

I have aroud 25-30 tablespace, this will take a lot of time. Dnt you have another solution.

Thx
Re: migrate 9i RAC to 10g [message #261355 is a reply to message #261337] Wed, 22 August 2007 06:40 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No.
Anyway you do it, you finally have to create the tablespaces.

Regards
Michel

[Updated on: Wed, 22 August 2007 06:40]

Report message to a moderator

Importing 9i Data into Oracle 10g DB [message #261364 is a reply to message #261171] Wed, 22 August 2007 07:03 Go to previous messageGo to next message
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: Importing 9i Data into Oracle 10g DB [message #261375 is a reply to message #261364] Wed, 22 August 2007 07:22 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Same as http://www.orafaq.com/forum/t/87870/102589/.
Will merge it.

Regards
Michel

[Edit: done]

[Updated on: Wed, 22 August 2007 07:23]

Report message to a moderator

Re: migrate 9i RAC to 10g [message #261456 is a reply to message #261337] Wed, 22 August 2007 11:51 Go to previous messageGo to next message
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 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
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 Go to previous messageGo to next message
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 #263587 is a reply to message #263558] Thu, 30 August 2007 08:06 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Same answer as above.

Regards
Michel
Re: migrate 9i RAC to 10g [message #263754 is a reply to message #263587] Thu, 30 August 2007 23:51 Go to previous messageGo to next message
dirish
Messages: 232
Registered: November 2006
Senior Member
Hi Michel,

can you please help me how to do the above.


Thx,
Dirish
Re: migrate 9i RAC to 10g [message #263784 is a reply to message #263754] Fri, 31 August 2007 00:52 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
add "ignore=yes" on your import if you don't want to see the messages but these one don't prevent you from importing the rest of the dump. See them as warnings.

Regards
Michel

[Updated on: Fri, 31 August 2007 00:54]

Report message to a moderator

Re: migrate 9i RAC to 10g [message #263794 is a reply to message #263784] Fri, 31 August 2007 01:30 Go to previous messageGo to next message
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 #263813 is a reply to message #263794] Fri, 31 August 2007 01:54 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Same answer as above: precreate your tablespaces.

Regards
Michel
Re: migrate 9i RAC to 10g [message #263821 is a reply to message #263813] Fri, 31 August 2007 02:11 Go to previous messageGo to next message
dirish
Messages: 232
Registered: November 2006
Senior Member
i already created all the tablespaces
Re: migrate 9i RAC to 10g [message #263855 is a reply to message #263821] Fri, 31 August 2007 03:29 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Not with the message you have.
It would help if you also posted the statement before the error.

Regards
Michel
Re: migrate 9i RAC to 10g [message #263881 is a reply to message #263855] Fri, 31 August 2007 03:59 Go to previous messageGo to next message
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 "
Re: migrate 9i RAC to 10g [message #263883 is a reply to message #263881] Fri, 31 August 2007 04:02 Go to previous message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
So this tablespace was not there else it would raise the error you previously had: "IMP-00015: following statement failed because the object already exists"

Regards
Michel

[Updated on: Fri, 31 August 2007 04:02]

Report message to a moderator

Previous Topic: RAC TNSNAMES
Next Topic: Undo Tablespace in RAC
Goto Forum:
  


Current Time: Thu Mar 28 10:49:50 CDT 2024