Exp/Imp Error
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Exp/Imp Error

  1. #1
    Join Date
    Jan 2003
    Location
    Cašador (SC) - Brazil
    Posts
    56

    Exp/Imp Error

    Good morning All:

    Using Oracle 9i OMS, I exported from a oracle 8.1.7 database and am trying to import in a oracle 9i.
    After I point the export file, and Oracle reads it, and after is be processed, an error occur, and a message saying "wrong oid format:appiName" .

    Can someone say me what is happening and what have I to do to fix it??

    Really thanks!
    Adilsom JosÚ Musskopf
    Live like each of your days was the last.

  2. #2
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    best way to do exp/imp, do it manually... don't use that stupid OMS.

    Pros - you will learn somthing, as using OMS you learn nothing.
    Cons - nothing.

    and to answer your question

    Stop and restart the Intelligent Agent. Then rediscover the node from the EM Console.
    Last edited by adewri; 02-21-2003 at 06:27 AM.
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  3. #3
    Join Date
    Jan 2003
    Location
    Cašador (SC) - Brazil
    Posts
    56
    Thanks, adewri!

    I agree with you, and personaly like to use manual exp/imp, and anything in my database I like to do with my own hands, ┤cause I really thing that is better learn how to, instead to give to computer the rights to work by itself.

    I ask, only to learn one more thing, and know the reason why it happens. Thanke by your counsel, and by your reply!!
    Adilsom JosÚ Musskopf
    Live like each of your days was the last.

  4. #4
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    From the metalink...
    Cause: If SQL*Net configuration changes have been made on the target node without reloading the listener, bouncing the Agent, and refreshing service discovery in the OEM Console, this error will occur. Wrong OID format errors occur when the Intelligent Agent is unable to successfully connect to the database via a listener supplied connection.
    HTH
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  5. #5
    Join Date
    Feb 2003
    Posts
    14
    Also go through

    Metalink 132904.1 [Compatibility Matrix for Export & Import Between Different Oracle
    Versions]

    while using manually exp/imp

    Very basic things, but still feel like posting it.


    Sahil

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