This discussion is archived
6 Replies Latest reply: Mar 20, 2013 8:27 PM by EddyLau RSS

DAC - Administrator user authentication failing

747193 Newbie
Currently Being Moderated
Hi,

I have installed DAC for the first time. The intial login is Administrator and same pwd as per documentation.
But still it is not verifying. It cant authenticate the user.
The connection file is is fine and tested successfully.

Do i need to configure the Administrator somewhere else?

Please advise.

TIA.
  • 1. Re: DAC - Administrator user authentication failing
    676254 Journeyer
    Currently Being Moderated
    I Believe that you have created and tested the connection and thats working fine !!

    So the next step would be to use the connection name that you have created and give the username and password of the database instance which you have created to install the dac repository Like DACQA ....

    You need to enter this info to be able to log in !!
  • 2. Re: DAC - Administrator user authentication failing
    747193 Newbie
    Currently Being Moderated
    Hi,

    I tried with the user id/schama that is created 11g. But still i am getting same error "cant authentic user".

    Am is missgin any privilige in database level.

    TIA
  • 3. Re: DAC - Administrator user authentication failing
    676254 Journeyer
    Currently Being Moderated
    Have you been able to create a connection successfully ?

    Have you created the DAC Repository schema ?

    When you log into DAC and connect to a DAC repository for the first time,
    the DAC detects that the DAC schema does not exist in the database and you are asked whether you want to create a repository.

    Please look at the Installation & Configuration Guide under the Getting Started tab - Section 4.8

    http://download.oracle.com/docs/cd/E12127_01/doc/bia.795/e12083/windows_ic.htm#BABIBCAC

    The user for Informatica & DAC both should have the following privileges

    – CONNECT
    – RESOURCE
    – READ
    – WRITE
    – UPDATE
    – DELETE
    – GRANT

    Search for SSE_ROLE for more on privileges !!

    If it helps do mark this as helpful !!
  • 4. Re: DAC - Administrator user authentication failing
    747193 Newbie
    Currently Being Moderated
    Hi,

    it is not asking me to create intial repository creation dialog box. it is establishing the connection, checking the repository,verifying user and then pops up the message "cant authenticate user". i tried with default Administrator user id/pwd and again with schema name and pwd. No Hope.


    DAC was installed in one machine earlier. i installed in another machine and using the same schema name and pwd. some rep tables were already there.
    i dropped pcsf_ tables.

    Do i need to create another schema instead of reusing the existing schema? I checked the the schema i am using is having SSE_ROLE.\

    Thanks
  • 5. Re: DAC - Administrator user authentication failing
    747193 Newbie
    Currently Being Moderated
    Hi.

    This worked. I had to drop all the tables those were present in the earlier installation.

    Thanks Sid for you input.
  • 6. Re: DAC - Administrator user authentication failing
    EddyLau Newbie
    Currently Being Moderated
    hi,

    I encountered the same error, but I still fail to authenticate after dropping the whole database schema for dac. Can you share how you overcome the error ?

    Thanks,
    Eddy

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points