| error in import [message #51584] |
Fri, 31 May 2002 19:35  |
Lakhbir Singh
Messages: 2
Registered: May 2002
|
Junior Member |
|
|
While importing Orcle 7.3 database to same version error encountered,
ORA-03113:end-of-file on communication channel
ORA-01041:internal error. hostdef extension doesn't exist
IMP-00000:Import terminated unsuccessfully
I am trying to recover production database on test system
Kindly help me out.
|
|
|
|
| Re: error in import [message #51617 is a reply to message #51584] |
Mon, 03 June 2002 05:37  |
Grant
Messages: 578
Registered: January 2002
|
Senior Member |
|
|
|
Are you running this from the client. You are importing and it may be the same version but your client binaries also have to match versions. Try the import from the server as the owner of the Oracle binaries (7.3) not from your client.
|
|
|
|
|
|
| Re: error in import [message #51632 is a reply to message #51584] |
Tue, 04 June 2002 03:20 |
Lakhbir Singh
Messages: 2
Registered: May 2002
|
Junior Member |
|
|
We imported the previous day's export on the same machine, it was fine. The original export also ended with no warnings.
I am not able to understand the reason, the export from the same batch file,, one giving error, the other imported succesfully.
Please help me out as it is very dangerous for my production system restore policy.
|
|
|
|
| Re: error in import [message #51639 is a reply to message #51632] |
Tue, 04 June 2002 06:25 |
Grant
Messages: 578
Registered: January 2002
|
Senior Member |
|
|
It sounds like you may have a corrupt file. Can you create a script successfully:
imp system/PASSWORD show=y log=test.log rows=n file=yourdump
See if this command finishes without errors and gives you a good log file. This will just create a log and will do nothing to your database.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
