My work involves Refreshing of DB with latest Data. For this i am using IMPDP command to import the data. But Every time during refresh i will get errors saying like "oracle Generated Errors Oracle Not available".
I don't know what is the reason for getting this error, and that too my db goes down after this error. Again i will startup the db , and i will try my luck to complete the process.
so please tell me what are the actual problems that might cause the IMPDP to be failed.
with one advise , i have stopped my listener and done the importing, Interestingly this time IMPDP works without errors. But this is also not always working.
But i feel that every time starting and stopping the listener is not the correct solution.
so please help me in this regard.
The error i am getting is...
UDI-03113: operation generated ORACLE error 3113
ORA-03113: end-of-file on communication channel
Process ID: 6208
Session ID: 346 Serial number: 298
UDI-03114: operation generated ORACLE error 3114
ORA-03114: not connected to ORACLE
DB version is 220.127.116.11.0
os is.. Red Hat Linux
here is the text from my trace file...
error 471 detected in background process
ORA-00471: DBWR process terminated with error
*** 2012-05-16 12:06:36.566
PMON (ospid: 7605): terminating the instance due to error 471
This is from the trace file. The database also writes these errors to the database alert log file, which usually contains more information that could help troubleshoot. Pl post the contents of the alert log file also
Obviously, DBWR terminating is not a good thing - essentially, your database crashed.