| impdp errors when moving database to new server [message #208900] |
Tue, 12 December 2006 08:43  |
bbeers
Messages: 3
Registered: December 2006
|
Junior Member |
|
|
Hi all,
I have two servers both running 10g. I have been tasked with moving an entire database from server 1 to server 2. In going through the manuals, etc. it seems like using the expdp/impdp utility using the full=Y option to be the best solution. I pre-created the database on server 2 (just generic - basically the same ORACLE_SID - I didn't create tables or users or anything mirroring that on server 1), then I exported the database from server 1, ftp'd it over to server 2 and ran the impdp using full=y. However I get a bunch of errors mostly the ora-39112 error, and then it terminates with a fatal error. Here's a snip from the import log:
ORA-39112: Dependent object type TABLE_STATISTICS skipped, base object type TABLE:"WC3_PDAADMIN"."FINPOCS" creation failed
ORA-39112: Dependent object type TABLE_STATISTICS skipped, base object type TABLE:"WC3_PDAADMIN"."LEVELS" creation failed
ORA-39112: Dependent object type TABLE_STATISTICS skipped, base object type TABLE:"WC3_PDAADMIN"."DEPARTMENTS" creation failed
ORA-39112: Dependent object type TABLE_STATISTICS skipped, base object type TABLE:"WC3_PDAADMIN"."USERS" creation failed
It seems like it does this for practically everything. My question is, do I need to have anything else (i.e. tables, users, etc.) pre-created before I do the import? What am I missing?
Any help, suggestions would be greatly appreciated.
Thanks,
Brian
|
|
|
|
|
|
| Re: impdp errors when moving database to new server [message #208909 is a reply to message #208903] |
Tue, 12 December 2006 09:44  |
bbeers
Messages: 3
Registered: December 2006
|
Junior Member |
|
|
Do you mean take everything that is in the oradata/pdaott directory (i.e. control files, redo files, sysauxX.dbf, systemX.dbf, usersX.dbf, etc)? Is that all the files I need or are there more? And where do I put them on the new server?
Thanks,
Brian
|
|
|
|
|
|
| Re: impdp errors when moving database to new server [message #208938 is a reply to message #208921] |
Tue, 12 December 2006 11:39 |
bbeers
Messages: 3
Registered: December 2006
|
Junior Member |
|
|
Thanks Taj. This has been extremely helpful. I just have a couple more questions:
1. What is meant by "create oracle services"? What exactly needs to be created?
2. The directory structure on the new server has to be exactly like on the old server? What if the structure is different? Will this not work?
(obviously I am fairly new to Oracle. As part of my job I inherited the old server and they want me to move it to a new one. Having very little experience with Oracle I just want to make sure that I completely understand all of the steps and what needs to be moved, etc.)
Once again, thanks for your time and assistance.
Brian
|
|
|
|
| Re: impdp errors when moving database to new server [message #209006 is a reply to message #208938] |
Tue, 12 December 2006 22:33 |
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
|
Senior Member |
|
|
hi,
1. What is meant by "create oracle services"? What exactly needs to be created?
Through ORADIM.EXE utility we can create oracle services and start.
like
start---->run----->cmd <<enter>>
C:\>d:\oracle\product\10.1.0\db_2\bin\oradim.exe -new -sid ORCL -startmode manual -spfile
C:\>d:\oracle\product\10.1.0\db_2\bin\oradim.exe -edit -sid ORCL -startmode auto
Note: change ur <sid> for me is ORCL.
The directory structure on the new server has to be exactly like on the old server? What if the structure is different? Will this not work?
Yes it should be some.
of if it different you have problem with database mount stage.
bcoz we using old server controlfiles and controlfile content location of datafiles and redofiles if it is different then file not found error.
hope this helps
Taj
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
