6 Replies Latest reply: Sep 8, 2009 2:43 AM by 721188 RSS

    IMP-00058: ORACLE error 1034 encountered

    721188
      Dear Experts,

      I got an oracle XE 10g on a linux CentOS.

      When i want to import my dump into my instance i got a:
      IMP-00058: ORACLE error 1034 encountered
      ORA-01034: ORACLE not available
      ORA-27101: shared memory realm does not exist
      Linux Error: 2: No such file or directory
      IMP-00005: all allowable logon attempts failed
      IMP-00000: Import terminated unsuccessfully

      here is the command:
      +[oracle@picoracle tmp]$ imp exp_remu_mini.dmp+

      Import: Release 10.2.0.1.0 - Production on Mon Sep 7 14:09:08 2009

      Copyright (c) 1982, 2005, Oracle.  All rights reserved.

      Password:

      I got the same error when using only the imp command:
      +[oracle@picoracle tmp]$ imp+

      Import: Release 10.2.0.1.0 - Production on Mon Sep 7 14:14:39 2009

      Copyright (c) 1982, 2005, Oracle.  All rights reserved.

      Username: remu_mini
      Password:

      IMP-00058: ORACLE error 1034 encountered
      ORA-01034: ORACLE not available
      ORA-27101: shared memory realm does not exist
      Linux Error: 2: No such file or directory
      IMP-00005: all allowable logon attempts failed
      IMP-00000: Import terminated unsuccessfully


      Here are my env variables:
      [oracle@picoracle tmp]$ env |grep ORA
      ORACLE_SID=xe
      ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/


      Any idea ?
      Thanx for ur help
      Nicolas
        • 1. Re: IMP-00058: ORACLE error 1034 encountered
          Toni Lazarin
          user11262188 wrote:
          Dear Experts,
          Any idea ?
          Yes.
          Check this link -->[this link|http://forums.oracle.com/forums/search.jspa?threadID=&q=ORA-27101%3A+shared+memory+realm+does+not+exist&objID=f61&dateRange=all&userID=&numResults=15] and you will enable yourself to find solution on your own.
          good luck.
          Thanx for ur help
          cheers
          • 2. Re: IMP-00058: ORACLE error 1034 encountered
            19426
            ORA-01034: ORACLE not available
            Is the database started? If yes, is ORACLE_SID correctly set?

            Werner
            • 3. Re: IMP-00058: ORACLE error 1034 encountered
              721188
              Thanx .... i hanven't find the solution .... in the 10000 links you send to me :-(

              +[oracle@picoracle tmp]$ ps -ef |grep smon+
              oracle    2102     1  0 13:31 ?        00:00:01 xe_smon_XE
              oracle    3330  2606  0 15:36 pts/1    00:00:00 grep smon


              and the ORACLE_SID is set !
              +[oracle@picoracle tmp]$ env |grep ORACLE+
              ORACLE_SID=xe
              ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/


              May be the ORACLE_HOME should be:+http://wiki.puma.lan/index.php/PGC_D%C3%A9veloppeur_-_Standard+ ???

              !!!!!! Help !!!!!!
              • 4. Re: IMP-00058: ORACLE error 1034 encountered
                721188
                Ooopsss ... sorry:

                May be the ORACLE_HOME should be: /usr/lib/oracle/xe/app/oracle/product/10.2.0/
                • 5. Re: IMP-00058: ORACLE error 1034 encountered
                  Toni Lazarin
                  user11262188 wrote:
                  Ooopsss ... sorry:

                  May be the ORACLE_HOME should be: /usr/lib/oracle/xe/app/oracle/product/10.2.0/
                  ORACLE_HOME have nothing to do with the error you got.
                  As Werner already told you in his post above, check if your ORACLE_SID env variable is correctly set.
                  [oracle@dell ~]$ echo $ORACLE_SID
                  RING10
                  [oracle@dell ~]$
                  [oracle@dell ~]$
                  [oracle@dell ~]$ imp
                  
                  Import: Release 10.2.0.4.0 - Production on Mon Sep 7 15:47:55 2009
                  
                  Copyright (c) 1982, 2007, Oracle.  All rights reserved.
                  
                  Username:
                  Password:
                  
                  IMP-00058: ORACLE error 1017 encountered
                  ORA-01017: invalid username/password; logon deniedUsername:
                  Password:
                  
                  IMP-00058: ORACLE error 1017 encountered
                  ORA-01017: invalid username/password; logon deniedUsername:
                  Password:
                  
                  IMP-00058: ORACLE error 1017 encountered
                  ORA-01017: invalid username/password; logon denied
                  IMP-00005: all allowable logon attempts failed
                  IMP-00000: Import terminated unsuccessfully
                  [oracle@dell ~]$
                  [oracle@dell ~]$
                  [oracle@dell ~]$
                  [oracle@dell ~]$
                  [oracle@dell ~]$
                  [oracle@dell ~]$ export ORACLE_SID=wrong_sid
                  [oracle@dell ~]$
                  [oracle@dell ~]$
                  [oracle@dell ~]$ echo $ORACLE_SID
                  wrong_sid
                  [oracle@dell ~]$
                  [oracle@dell ~]$
                  [oracle@dell ~]$ imp
                  
                  Import: Release 10.2.0.4.0 - Production on Mon Sep 7 15:48:25 2009
                  
                  Copyright (c) 1982, 2007, Oracle.  All rights reserved.
                  
                  Username:
                  Password:
                  
                  IMP-00058: ORACLE error 1034 encountered
                  ORA-01034: ORACLE not available
                  ORA-27101: shared memory realm does not exist
                  Linux Error: 2: No such file or directory
                  IMP-00005: all allowable logon attempts failed
                  IMP-00000: Import terminated unsuccessfully
                  [oracle@dell ~]$
                  • 6. Re: IMP-00058: ORACLE error 1034 encountered
                    721188
                    +[bagside@picoracle ~]$ imp remu_mini/remu_mini@XE+


                    It rules !!!!

                    I have just specified explicitely @XE !

                    Thanx 4 ur help !
                    Nicolas