-
Urgent: IMP-00003: ORACLE error 3114 encountered
Dear all,
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 9.2.0.6.
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
Or
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.
Thanks,
Unna
-
make sure you have you environment path set:
on windows do:
export ORACLE_SID=BLUH
on linux do:
export ORACLE_SID=bluh
-
Thanks, but I already have ORACLE_HOME and ORACLE_SID set in environment parameters.
I can get the data imported if I set the the owner=user; however, we have so many schemas, I don't want to import all these schemas one at a time. Now my problem is there is no connection to the database, since somewhere along the import my password got changed.
-
Change The Sys Password By Using Orapwd
-
Thank you all for your help. Using orapwd doesn't prevent the database from disconnecting. However, I found the solution from metalink:
1. Login as sys in the SQLPLUS and run the following sqls
$OH/rdbms/admin/dbmsread.sql
$OH/rdbms/admin/prvtread.plb
2. Retry the import.
Thanks!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|