HELP: imp error

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • tracy
    #1

    HELP: imp error

    hi, guys,
    I really need ur guidance.I just installed oracle db in my backup
    server(os is linux) and intent to import an .dmp file to it. I had
    created tablespace, datafiles, users( inclide abc).

    Then, i wanna to export an dmp file named test.dmp.so, here is my
    command:
    [root@icemsdb root]# su - oracle
    bash-2.05$
    bash-2.05$ imp fromuser=abc touser=abc file=test.dmp

    Import: Release 9.2.0.2.0 - Production on Tue May 18 15:10:08 2004

    Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

    Username: system
    Password:

    IMP-00058: ORACLE error 1033 encountered
    ORA-01033: ORACLE initialization or shutdown in progressUsernam e:

    what's wrong? Pls help me .

    TQ!

    regards,
    tracy
    Tags: None
    • Frank van Bortel
      #2
      Re: HELP: imp error

      tracy wrote:
      hi, guys,
      I really need ur guidance.I just installed oracle db in my backup
      server(os is linux) and intent to import an .dmp file to it. I had
      created tablespace, datafiles, users( inclide abc).
      >
      Then, i wanna to export an dmp file named test.dmp.so, here is my
      command:
      [root@icemsdb root]# su - oracle
      bash-2.05$
      bash-2.05$ imp fromuser=abc touser=abc file=test.dmp
      >
      Import: Release 9.2.0.2.0 - Production on Tue May 18 15:10:08 2004
      >
      Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
      >
      Username: system
      Password:
      >
      IMP-00058: ORACLE error 1033 encountered
      ORA-01033: ORACLE initialization or shutdown in progressUsernam e:
      >
      what's wrong? Pls help me .
      >
      TQ!
      >
      regards,
      tracy
      Nothing, oracle is shutting downm or still starting up.
      Be patient, or -if it takes longer than a couple of
      minutes- look in the oracle log files (alert_{SID}.lo g)
      what's going on.
      You did *create* the database, did you?
      --

      Regards,
      Frank van Bortel

        Comment

        • tracy
          #3
          Re: HELP: imp error

          Frank van Bortel <fvanbortel@net scape.netwrote in message news:<c8ge3p$a8 8$1@news1.tilbu 1.nb.home.nl>.. .
          Nothing, oracle is shutting downm or still starting up.
          Be patient, or -if it takes longer than a couple of
          minutes- look in the oracle log files (alert_{SID}.lo g)
          what's going on.
          You did *create* the database, did you?
          -- wat i try to do is bring import the dmp file to the db. Here is my alert.log:
          Tue May 18 14:22:01 2004
          ALTER DATABASE MOUNT
          Tue May 18 14:22:01 2004
          scumnt: failed to lock /ora92/oradata/OraHome//dbs/lkabc exclusive
          Tue May 18 14:22:01 2004
          ORA-09968: scumnt: unable to lock file
          Linux-ia64 Error: 11: Resource temporarily unavailable
          Additional information: 9296
          Tue May 18 14:22:01 2004
          ORA-1102 signalled during: ALTER DATABASE MOUNT...
          Tue May 18 14:22:49 2004
          Restarting dead background process QMN0
          QMN0 started with pid=9

            Comment

            • Frank van Bortel
              #4
              Re: HELP: imp error

              tracy wrote:
              Frank van Bortel <fvanbortel@net scape.netwrote in message news:<c8ge3p$a8 8$1@news1.tilbu 1.nb.home.nl>.. .
              >
              >>Nothing, oracle is shutting downm or still starting up.
              >>Be patient, or -if it takes longer than a couple of
              >>minutes- look in the oracle log files (alert_{SID}.lo g)
              >>what's going on.
              >>You did *create* the database, did you?
              >
              >
              -- wat i try to do is bring import the dmp file to the db. Here is my alert.log:
              Tue May 18 14:22:01 2004
              ALTER DATABASE MOUNT
              Tue May 18 14:22:01 2004
              scumnt: failed to lock /ora92/oradata/OraHome//dbs/lkabc exclusive
              Tue May 18 14:22:01 2004
              ORA-09968: scumnt: unable to lock file
              Linux-ia64 Error: 11: Resource temporarily unavailable
              Additional information: 9296
              Tue May 18 14:22:01 2004
              ORA-1102 signalled during: ALTER DATABASE MOUNT...
              Tue May 18 14:22:49 2004
              Restarting dead background process QMN0
              QMN0 started with pid=9
              Who owns /ora92/oradata/OraHome//dbs/lkabc?
              Assuming your instance is called abc, your environment
              should contain:
              ORACLE_SID=abc
              ORACLE_BASE=/ora92/???
              PATH=/usr/local/bin:/bin:/usr/bin:/usr/X11R6/bin:.:/ora92/????/bin
              PWD=/opt/oracle/920/dbs
              LANG=en_US.UTF-8
              ORACLE_TERM=xte rm
              LD_ASSUME_KERNE L=2.4.1
              ORA_NLS33=/ora92/????/ocommon/nls/admin/data
              ORACLE_HOME=/ora92/??????

              My lk file is owned by the owner of the oracle process, oinstall.
              You could try a shutdown, and startup again, or shutdown, delete
              the abclk file, and startup.
              What I find strange is the double // - doubt if it harms, though
              --

              Regards,
              Frank van Bortel

                Comment

                Previous template Next
                Working...