Thursday, April 14, 2016

ODI 12c Demo SUPERVISOR account expired

On starting the ODI ,Clicked on Connect to Repository

1) After providing the wallet password "welcome1"
2) Got the message SUPERVISOR account was expired, contact Administrator
3)To reset the password, Connected to Oracle , through oracle sql developer.

  ODI repository user - prod_odi_repo / password: oracle
  SID: ORCL
4) updated the expiry date to sysdate +100 for SUPERVISOR account.

update snp_user set user_expiracy_date=sysdate + 100 where i_wuser=4;


No comments:

Post a Comment