Re: import from Oracle 9 to 10 hanging

From: Stefan Knecht <knecht.stefan_at_gmail.com>
Date: Fri, 29 Jun 2007 09:52:41 +0200
Message-ID: <486b2b610706290052n63e17407v8a85cfa52ce66229@mail.gmail.com>

Andreas,

You could try enabling event 10046 using a logon trigger and watch what exactly causes the import to hang (could be a dead lock of some sort):

create or replace trigger trace_imp_on_logon after logon on database
begin
if (user='YOUR_IMP_USER') then

execute immediate 'alter session set tracefile_identifier=''IMP_TRACE''';
execute immediate 'alter session set events ''10046 trace name context
forever, level 12''';

end if;
end;
/

Then look in your user_dump_dest for a resulting tracefile, and see what Oracle is waiting for.

BTW Don't forget to remove the trigger after you're done testing ;-)

Stefan

On 6/27/07, Andreas.Haunschmidt_at_voestalpine.com < Andreas.Haunschmidt_at_voestalpine.com> wrote:
>
>
> I did an export from Oracle 9.2.0.7.0. with the imp utility on the Oracle
> 9 server.
> Then I tried to import the dump files into 10.2.0.1.0 with the imp utility
> Oracle 10 server.
>
> The import worked for 4 of the 3 exported users, but while importing the
> 4th user
> the import session hangs on
> SYS.DBMS_EXPORT_EXTENSION.reset_exp_opq_typ_event;
>
> No IO is happening but Oracle uses almost all of the CPU.
>
> I tried the import from version 9 to 10 repeatedly on WinXP and Linux,
> with different export files from the Oracle 9 DB, same effect.
>
> Has anyone experienced the same "behavior"?
> Has anyone got a solution?
>
> Thanks in advance
> Andreas
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
=========================

Stefan P Knecht
Consultant
Infrastructure Managed Services

Trivadis AG
Europa-Strasse 5
CH-8152 Glattbrugg

Phone +41-44-808 70 20
Fax +41-808 70 12
Mobile +41-79-571 36 27
stefan.knecht_at_trivadis.com
http://www.trivadis.com

=========================

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Jun 29 2007 - 02:52:41 CDT