Urgent: IMP-00003: ORACLE error 3114 encountered
I am trying to replicate a production database by using import and export utilities. My production database is in Unix HP and the new database is going to be on Windows XP, and both database servers are in Oracle 188.8.131.52.
The export was done successfully; however I got the following errors during importing:
IMP-00003: ORACLE error 3113 encountered
ORA-03113: end-of-file on communication channel
IMP-00003: ORACLE error 3114 encountered
ORA-03114: not connected to ORACLE
The import command is:
C:\> imp system/pwd file=full.dmp full=y log=full.log buffer=64000
C:\> imp / file=full.dmp full=y log=full.log buffer=64000
Prior to the import, I created all the tablespaces; however, none of data from any schema got imported since there was no connection to the database. Also when I tried to login as system, I got invalid password error. I have to alter user in order to login. Can anyone tell me why the system or OS authenticated user password got changed during the import? And how do I prevent from getting the IMP-00003 error?
Any help is appreciated.
Click Here to Expand Forum to Full Width