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

Thread: ora 1034

  1. #1
    Join Date
    Jun 2000
    Posts
    315

    ora 1034

    A user name has set up on a unix system and also in the database. I need the import utility. I set ORACLE_HOME and imp in the .cshrc file. But after I type 'imp', and type username and password, I got error message 'IMP-00058: ORACLE error 1034 encountered ...'.

    Could anyone tell me what is the problem?

    Thanks,

    Lisa

  2. #2
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    Is the database started?

    Also is the OS user a member of a group that can access the Oracle instance?

    HTH
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!

  3. #3
    Join Date
    Jun 2000
    Posts
    315
    yes, database is up and running. What group the user has to be to access the instance?

  4. #4
    Join Date
    Jun 2000
    Posts
    315
    Can anybody help me with this? Which group the OS user has to be in to access the import and export utility?

    Thanks,

    Lisa

  5. #5
    Join Date
    Jul 2000
    Posts
    521
    What you need to set is ORACLE_SID and not just ORACLE_HOME. ORACLE_HOME should get derived from ORACLE_SID.

    Or, use uid/pwd@db connection method provided you have configured listener.
    svk

  6. #6
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    Originally posted by lgaorcl
    Can anybody help me with this? Which group the OS user has to be in to access the import and export utility?

    Thanks,

    Lisa
    The user need not be in a particular group in order to use export and import. Make sure that your Oracle environment is set properly. You can copy it from .profile of oracle user.

    HTH
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"

  7. #7
    Join Date
    May 2002
    Posts
    2,645
    Originally posted by svk
    What you need to set is ORACLE_SID and not just ORACLE_HOME. ORACLE_HOME should get derived from ORACLE_SID.
    Maybe I'm misunderstanding what you are trying to say here, but that is baloney. How on earth is ORACLE_HOME derived from ORACLE_SID????

  8. #8
    Join Date
    Nov 2001
    Posts
    335
    Originally posted by stecal
    Maybe I'm misunderstanding what you are trying to say here, but that is baloney. How on earth is ORACLE_HOME derived from ORACLE_SID????

    ORACLE_HOME should be derived from ORACLE_SID via running oraenv script which is using info from oratab file usually located at /etc.
    It is done so you can work with multiple version of Oracle on same server and still being able to have right env for the right database.
    One, who thinks that the other one who thinks that know and does not know, does not know either!

Posting Permissions

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


Click Here to Expand Forum to Full Width