Re: Oracle IMP Hangs

More help is definately needed!
I am (fairly obviously) new to oracle.
[Quoted] [Quoted] The imp process certainly "seems" to hang and has to be killed to recover the terminal.
This is what is in the alert log:

Mon Mar 1 09:07:49 2004
CREATE TABLESPACE "TOOLS" DATAFILE '/u02/oradata/cyrel/tools01.dbf' SIZE 8388608 AUTOEXTEND ON NEXT 327680 MAXSIZE 32767M DEFAULT STORAGE(INITIAL 32768 NEXT 32768 MINEXTENTS 1 MAXEXTENTS 4096 PCTINCREASE 0) ONLINE PERMANENT
Mon Mar 1 09:07:49 2004
ORA-1543 signalled during: CREATE TABLESPACE "TOOLS" DATAFILE '/u02/oradata/...
Mon Mar 1 09:07:49 2004
[Quoted] CREATE TABLESPACE "RBS" DATAFILE '/u02/oradata/cyrel/rbs01.dbf' SIZE 541065216 AUTOEXTEND ON NEXT 5242880 MAXSIZE 32767M DEFAULT STORAGE(INITIAL 524288 NEXT 524288 MINEXTENTS 8 MAXEXTENTS 4096 PCTINCREASE 50) ONLINE PERMANENT
ORA-1543 signalled during: CREATE TABLESPACE "RBS" DATAFILE '/u02/oradata/cy...
Mon Mar 1 09:07:49 2004
CREATE TABLESPACE "TEMP" DATAFILE '/u02/oradata/cyrel/temp01.dbf' SIZE 71303168 AUTOEXTEND ON NEXT 655360 MAXSIZE 32767M DEFAULT STORAGE(INITIAL 65536 NEXT 65536 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0) ONLINE TEMPORARY
ORA-1543 signalled during: CREATE TABLESPACE "TEMP" DATAFILE '/u02/oradata/c...
Mon Mar 1 09:07:49 2004
CREATE TABLESPACE "USERS" DATAFILE '/u02/oradata/cyrel/users01.dbf' SIZE 109051904 AUTOEXTEND ON NEXT 1310720 MAXSIZE 32767M DEFAULT STORAGE(INITIAL 131072 NEXT 131072 MINEXTENTS 1 MAXEXTENTS 4096 PCTINCREASE 0) ONLINE PERMANENT
ORA-1543 signalled during: CREATE TABLESPACE "USERS" DATAFILE '/u02/oradata/...
Mon Mar 1 09:07:49 2004
CREATE TABLESPACE "INDX" DATAFILE '/u02/oradata/cyrel/indx01.dbf' SIZE 56623104 AUTOEXTEND ON NEXT 1310720 MAXSIZE 32767M DEFAULT  STORAGE(INITIAL 131072 NEXT 131072 MINEXTENTS 1 MAXEXTENTS 4096 PCTINCREASE 0) ONLINE PERMANENT
ORA-1543 signalled during: CREATE TABLESPACE "INDX" DATAFILE '/u02/oradata/c...
Mon Mar 1 09:07:51 2004
[Quoted] CREATE PUBLIC ROLLBACK SEGMENT RBS0 STORAGE(INITIAL 524288 NEXT 524288 MINEXTENTS 8 MAXEXTENTS 4096) TABLESPACE "RBS" ORA-1535 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS0 STORAGE(INITIA...
Mon Mar 1 09:07:51 2004
[Quoted] CREATE PUBLIC ROLLBACK SEGMENT RBS1 STORAGE(INITIAL 524288 NEXT 524288 MINEXTENTS 8 MAXEXTENTS 4096) TABLESPACE "RBS" ORA-1535 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS1 STORAGE(INITIA...
Mon Mar 1 09:07:51 2004
CREATE PUBLIC ROLLBACK SEGMENT RBS2 STORAGE(INITIAL 524288 NEXT 524288 MINEXTENTS 8 MAXEXTENTS 4096) TABLESPACE "RBS" ORA-1535 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS2 STORAGE(INITIA...
Mon Mar 1 09:07:51 2004
CREATE PUBLIC ROLLBACK SEGMENT RBS3 STORAGE(INITIAL 524288 NEXT 524288 MINEXTENTS 8 MAXEXTENTS 4096) TABLESPACE "RBS" ORA-1535 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS3 STORAGE(INITIA...
Mon Mar 1 09:07:51 2004
CREATE PUBLIC ROLLBACK SEGMENT RBS4 STORAGE(INITIAL 524288 NEXT 524288 MINEXTENTS 8 MAXEXTENTS 4096) TABLESPACE "RBS" ORA-1535 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS4 STORAGE(INITIA...
Mon Mar 1 09:07:51 2004
CREATE PUBLIC ROLLBACK SEGMENT RBS5 STORAGE(INITIAL 524288 NEXT 524288 MINEXTENTS 8 MAXEXTENTS 4096) TABLESPACE "RBS" ORA-1535 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS5 STORAGE(INITIA...
Mon Mar 1 09:07:51 2004
CREATE PUBLIC ROLLBACK SEGMENT RBS6 STORAGE(INITIAL 524288 NEXT 524288 MINEXTENTS 8 MAXEXTENTS 4096) TABLESPACE "RBS" ORA-1535 signalled during: CREATE PUBLIC ROLLBACK SEGMENT RBS6 STORAGE(INITIA...
Mon Mar 1 09:07:53 2004
[Quoted] [Quoted] ORACLE Instance cyrel - Can not allocate log, archival required Mon Mar 1 09:07:53 2004
ARCH: Connecting to console port...
Thread 1 cannot allocate new log, sequence 441 All online logs needed archiving
  Current log# 2 seq# 440 mem# 0: /u02/oradata/cyrel/redo02.log

[Quoted] What have I done wrong / differently from successful imports????? Mike Morris

"Ron" <support_at_dbainfopower.com> wrote in message news:<ltydnTsNB81-y9zdRVn-jw_at_comcast.com>...
> Hello Mike,
>
> Are you sure it hangs? As a start point - check alert log messages and
> check what top oracle user processes are doing .
>
> Also, you can use imp parameter FEEDBACK=<n_rows> to see if import is
> progressing.
>
> Please, let us know if more help is needed.
>
> Regards,
>
> Ron
> DBA Infopower
> http://www.dbainfopower.com
> Standard disclaimer:
> http://www.dbainfopower.com/dbaip_advice_disclaimer.html
>
>
>
> "Mike Morris" <morrisma_at_ei.dupont.com> wrote in message
> news:3b2c6993.0402270719.258ac282_at_posting.google.com...
> > I am exporting from one 8.1.7.4 solaris 8 box and importing on another
> > similarly configured (but more capable) solaris box. The import starts
> > fine but hangs after a varying number of tables are imported.
> >
> > The command I use:
> > imp name/pwd_at_instance full=y file=xxx.dmp
> >
> > I have the /etc/system set as required for oracle.
> > I have used this technique dozens of times and never had this happen.
> > Any suggestions would be appreciated!
> > Mike Morris
Received on Mon Mar 01 2004 - 15:25:28 CET