Portal Home > Knowledgebase > Articles Database > oracle issue
oracle issue
| Posted by ashley5, 06-11-2007, 01:57 PM |
| Hello,
I get an error while importing the backup file of oracle database. It's giving me some header file verification failed. Can anybody guide me about what it could be???
|
| Posted by FirmbIT, 06-11-2007, 02:15 PM |
| What is the full error message?
|
| Posted by dkitchen, 06-11-2007, 06:03 PM |
| Sounds like your backup is corrupt, what format is the backup?
Dan
|
| Posted by ashley5, 06-12-2007, 02:36 AM |
| It's stating
|
| Posted by ashley5, 06-12-2007, 02:38 AM |
| the backup file is backup.dmp
|
| Posted by sehe, 06-12-2007, 05:16 AM |
| what oracle version are you using?
how did you create the export file?
how does your import parfile / command line look like?
what's the full error message?
something like "IMP-00010: not a valid export file, header failed verification" ?
|
| Posted by ashley5, 06-12-2007, 05:45 AM |
| Oracle version is 10g
Export file has been given by my customer. Don't know how did he create it.
We use a script to import it. It looks like $ ./imp system/user@database file=/abc.dmp full=yes
Error message is the same as given by you.
Do you have any solution or work around for the same?
|
| Posted by ashley5, 06-13-2007, 12:26 AM |
| anybody here to help me on this? I thought I am near to solution by posting it in WHT. I know it's not an oracle forum but I trust the techies over here.
|
| Posted by ashley5, 06-13-2007, 12:31 AM |
| SORRY... posted something wrong by mistake.
Last edited by ashley5; 06-13-2007 at 12:32 AM.
Reason: SORRY... posted something wrong by mistake.
|
| Posted by sehe, 06-13-2007, 05:38 PM |
| Oracle version is 10g
10.1 or 10.2 ?
can you find out with which oracle version the export was made?
ask or try
look for e.g. EXPORT:V10.02.01
|
| Posted by ashley5, 06-14-2007, 02:17 AM |
| The current version is 10.1.0.3.0
The oracle version from which the export was made is EXPORT:V10.02.01.
|
| Posted by ashley5, 06-14-2007, 08:08 AM |
| Is this an answer? Different versions are making an issue? Is there any workaround for this if this is the issue?
|
| Posted by sehe, 06-14-2007, 03:18 PM |
| i dont have a 10.1 to test with but check metalink note 132904.1
i quote some parts
I suggest to do the export with your target db version (10.1.0.3.0) export utility
|
| Posted by ashley5, 06-14-2007, 11:19 PM |
| Thanks, this may help me. I will try to check and will update you.
|
| Posted by ashley5, 06-15-2007, 03:15 AM |
| I think the problem is that the version in which the database was exported is different from the version in which we are trying to import. We actually no longer have the server through which the database was exported. However, I also the DBF files from the old server. Is there any option to restore the DBF files in the Oracle server like we do in MS SQL 2000?
|
| Posted by sehe, 06-15-2007, 03:50 PM |
| too bad cause it would have been useful
you could get oracle 10g r2, setup a temporary database and import your dump, then export it with exp client from 10g r1
where do you want to use the dbf files in? your current 10g r1?
dont think you can get 10g r2 datafiles into 10g r1
and pure datafiles are pretty useless too
think those can be moved between databases only by using transportable tablespaces = dbf files _and_ little export file "describing them"
|
| Posted by ashley5, 07-06-2007, 04:13 AM |
| After thinking that it is possibly version issue, as per the suggestions provided by sehe, I upgraded the version. Currently version is oracle 10.2.0.1. But still
it is giving error in importing the database. Now there is some different error.
With importer utility, I am getting the following error:
This is the command output for Can I get the guidance further to resolve the problem?
|
| Posted by mwatkins, 07-06-2007, 11:07 AM |
| If you get that running the importer utility, your Oracle configuration is not quite right - its unable to make a connection to the database server. Solve that problem and then retry.
Either the listener isn't running, or you have a configuration problem. Check the listener with lsnrctl status on the server.
If its configuration related, check the contents of tnsnames.ora / listener.ora.
Last edited by mwatkins; 07-06-2007 at 11:10 AM.
|
| Posted by millsy54, 07-06-2007, 12:12 PM |
| thanks, this helped resolve an issue i was having
|
| Posted by ashley5, 07-06-2007, 12:32 PM |
| Here is the result for LSNRCTL
result for tnsnames
result for listener.ora
I would thank everyone in advance to help me in resolving the issue.
|
| Posted by ashley5, 07-06-2007, 12:35 PM |
| Can you please let me know how did it help you?
|
| Posted by ashley5, 07-06-2007, 01:30 PM |
| I managed to start the listner.. The problem was with ORACLE_HOME path. But still I am not able to import the database. Now I get the following error.
|
| Posted by sehe, 07-06-2007, 03:40 PM |
| export done with exp
did you try to import it with impdp?
i assume you use
"imp system/password@listener_name file=..." ?
does "tnsping listener_name" work?
|
| Posted by ashley5, 07-06-2007, 03:51 PM |
| Yes. tnsping listner_name works for me.
I tried the command you gave and saw a lil change. But no success.
Any idea where should I look into?
|
| Posted by sehe, 07-06-2007, 04:02 PM |
| if i am not wrong the export was done with "exp" and not "expdp", so you need to use "imp" and not "impdp" to import it
try "imp user/pass@listner_name file=/path/to/dmp/file.dmp"
|
| Posted by ashley5, 07-06-2007, 04:15 PM |
| Ok. imp started importimg but with some user not exist errors.. may be i need to create same users in oracle first... will try that and update here.
|
| Posted by ashley5, 07-09-2007, 04:34 AM |
| Ok. I created the users and Import worked like a charm..
Thanks for all your support.
|
Add to Favourites 
Print this Article
Also Read
FDC Servers? (Views: 824)