Unable to import (imp) from 11g to 9i please help
Date: Fri, 13 Nov 2015 11:06:10 +0530
Message-ID: <CACzEWSVD-hN+ruQj1Mhip_-XF6BswT6D6TS9=MxnQmPHmVZn5Q_at_mail.gmail.com>
Hello Guru's,
Hope Everyone is good!!
We have an issue in the imp job.
OS version is : HP-UX cnshda01 B.11.23 U ia64 3900573884 unlimited-user
license
Database version : Oracle 9i ( 9.2.0.6.0)
we have traditional exp dump taken from 11g version of database and we
are trying to import on 9i version DB
we are geting the below error.
IMP-00017: following statement failed with ORACLE error 3113:
"BEGIN
SYS.DBMS_AQ_IMPORT_INTERNAL.AQ_TABLE_DEFN_UPDATE('SYSTEM','DEF$_AQC"
"ALL',2,0,2,0,0,''); END;"
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
we searched the below doc id in metalink
ORA-3113 Importing or Dropping Advanced Queue Objects After Applied a
Patchset (Doc ID 308931.1)
and the steps are like
9.2.0.1.0 to 9.2.0.8.0
shutdown immediate
startup migrate
$ORACLE_HOME/rdbms/admin/catpatch.sql
shutdown immediate
startup
$ORACLE_HOME/rdbms/admin/utlrp.sql
startup
we followed the above steps but we are getting the below error.
SQL>_at_catpatch.sql
SP2-0103: Nothing in SQL buffer to run.
SQL> _at_catpatch.sql
SP2-0734: unknown command beginning "catpatch.s..." - rest of line ignored.
SQL>
If any one have faced similar issues earlier please help.
Any help will be highly appreciated!!
-- Thanks & Regards Nilesh Oracle DBA (sqlplus "/as sysdba" is my world)Received on Fri Nov 13 2015 - 06:36:10 CET
"As our circle of knowledge expands, so does the circumference of darkness
surrounding it."--Einstein
"All men die, few men ever truly live" -- Braveheart
"You can get help from teachers, but you are going to have to learn a lot
by yourself, sitting alone in a room." --Dr. Seuss
"Know me for what I do and for not what I am. Judge me for what I can do
and not for what I have done."-Unknown
"Don't walk in front of me, I may not follow. Don't walk behind me, I may
not lead. Just walk beside me and be my friend."- Albert Camus
"Never argue with an idiot. They drag you down to their level and then beat
you with experience." - Unknown -- http://www.freelists.org/webpage/oracle-l