DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: exp error

  1. 10-05-2002, 08:02 AM #1
    steeve123
    steeve123 is offline Senior Member
    Join Date
    Nov 2000
    Posts
    440
    we created an instance on linux with a 9i database.
    We have imported are data and we connect and select the data. But if we want to export, here is the error.


    EXP-00056: ORACLE error 1034 encountered
    ORA-01034: ORACLE not available
    ORA-27101: shared memory realm does not exist
    Compaq Tru64 UNIX Error: 2: No such file or directory
    EXP-00005: all allowable logon attempts failed
    EXP-00000: Export terminated unsuccessfully

    Reply With Quote Reply With Quote
  2. 10-05-2002, 08:21 AM #2
    julian
    julian is offline Senior Advisor
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Originally posted by steeve123
    we created an instance on linux with a 9i database.
    We have imported are data and we connect and select the data. But if we want to export, here is the error.


    EXP-00056: ORACLE error 1034 encountered
    ORA-01034: ORACLE not available
    ORA-27101: shared memory realm does not exist
    Compaq Tru64 UNIX Error: 2: No such file or directory
    EXP-00005: all allowable logon attempts failed
    EXP-00000: Export terminated unsuccessfully

    Perhaps the database is down or more liekly the ORACLE_SID is not set.
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g,12c
    email: ocp_9i@yahoo.com
    Reply With Quote Reply With Quote
  3. 10-05-2002, 09:32 AM #3
    steeve123
    steeve123 is offline Senior Member
    Join Date
    Nov 2000
    Posts
    440
    The oracle_sid is set
    my oracle version is:

    Oracle9i Release 9.0.1.0.0 - Production
    PL/SQL Release 9.0.1.0.0 - Production
    CORE 9.0.1.0.0 Production
    TNS for Compaq Tru64 UNIX: Version 9.0.1.0.0 - Production
    NLSRTL Version 9.0.1.0.0 - Production
    Reply With Quote Reply With Quote
  4. 10-05-2002, 09:40 AM #4
    julian
    julian is offline Senior Advisor
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Originally posted by steeve123
    The oracle_sid is set
    my oracle version is:

    Oracle9i Release 9.0.1.0.0 - Production
    PL/SQL Release 9.0.1.0.0 - Production
    CORE 9.0.1.0.0 Production
    TNS for Compaq Tru64 UNIX: Version 9.0.1.0.0 - Production
    NLSRTL Version 9.0.1.0.0 - Production
    Check the privileges to the Oracle executible in the bin directory. Is the DB up?
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g,12c
    email: ocp_9i@yahoo.com
    Reply With Quote Reply With Quote
  5. 10-05-2002, 09:40 AM #5
    laxman
    laxman is offline Junior Member
    Join Date
    Mar 2002
    Posts
    24
    Hi ,

    Generally u will "ORA-01034: ORACLE not available "
    error when ur database is not up and running..


    ORA-27101: shared memory realm does not exist
    For this check the shared memory viz kernel parameters

    First up the database normally and
    then export..



    Laxman


    Reply With Quote Reply With Quote
  6. 10-06-2002, 04:28 AM #6
    julian
    julian is offline Senior Advisor
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Often this error comes when the ORACLE_SID is not properly set.
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g,12c
    email: ocp_9i@yahoo.com
    Reply With Quote Reply With Quote
  7. 10-07-2002, 12:43 AM #7
    nagarjuna's Avatar
    nagarjuna
    nagarjuna is offline Oracle Apps DBA
    Join Date
    Aug 2002
    Location
    Bangalore, India
    Posts
    405
    I got such an error few times when I try to bounce the database using sqlplus. But, it worked fine with svrmgrl. Donno about 9i.
    -nagarjuna
    Reply With Quote Reply With Quote
  8. 10-07-2002, 10:38 AM #8
    jgmagnus
    jgmagnus is offline Senior Member
    Join Date
    May 2000
    Location
    Portsmouth, NH, USA
    Posts
    378

    would help if you provide your command-line or your parameter file for the export ...

    this JUST happened, or happens all the time (many days)?

    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Click Here to Expand Forum to Full Width