devnumbertwo - $h!t for developers

View Original

update or reset the dac admin password for the dac client

how to reset the dac admin password for the oracle dac client:

  1. Log into the DAC repository database (using sql)

  2. Locate the table W_ETL_USER and delete all records

  3. Log on DAC client with default user/password as Administrator/Administrator

Re-create the dac admin user again by performing the following:

  1. modifying the existing connection by clicking on Configure in the dac client login screen

  2. Modify Connection -> Test Connection (just to test to see if you need to change the table owner login)

  3. Go back to the dac client login screen, login as the table owner

  4. Confirm the login on the Creating default Administrator account… screen

  5. Create the dac admin account on the next screen