Saturday, August 10, 2013

Security Key is Invalid or Unavailable in DAC

I have encountered this error in my work recently.We can resolve this by following these steps.There is dac repository table called W_ETL_REPO,in this table we have a record for key validation.

Just remove that record carefully,and remove a record from W_ETL_USER because we will get below error.After this step it will ask you to create a new key.





Posted by at

4 comments:

  1. venkat charySeptember 26, 2014 at 6:33 AM

    Thanks very much Ravi...since so long time i was facing this issue..and couldn't resolve...Your post helped in fixing this issue.

    Regards,
    Venkat

    http://tricksfororacle.blogspot.com

    ReplyDelete
    Replies
    1. Abhisek DashAugust 22, 2016 at 4:38 AM

      Man, saw this today. Was helpful to me as well. :-)

      Delete
  2. Ashish TiwariDecember 23, 2015 at 4:24 AM

    thanks buddy..it worked

    ReplyDelete
  3. userexpFebruary 2, 2017 at 2:27 PM

    I followed the steps but now I don't see the'KeyValidation' row being created in my W_ETL_REPOS table. Any idea why?

    ReplyDelete

Subscribe to: Post Comments (Atom)