Discoverer Login Fails with ORA-1017

Logging to discoverer url as sysadmin gives the following error.


ORA-1017: Invalid username/password
A connection error.  
– Oracle BI Discoverer is unable to authenticate using the password provided. This can happen due to an invalid password or because the password was lost while using back, forward, or refresh in your browser. Enter the password again to continue.
– Failed to connect to database – Unable to connect to Oracle Applications database (afscpgcs) 


Cause:


APPL_SERVER_ID parameter in .dbc file of Applications MT node(applmgr) and discoverer user is not matched




$diff test1_disco.dbc test1_mt.dbc


4c4
< APPL_SERVER_ID=178***********

> APPL_SERVER_ID=1A***********






Solution:


Copy the <SID>.dbc from $FND_TOP/secure or $FND_SECURE of Applications Middle tier to Disoverer user


Bounce Discoverer Services

8 thoughts on “Discoverer Login Fails with ORA-1017”

  1. Hi there it’s me, I am also visiting this website on a regular basis,
    this site is in fact pleasant and the viewers are actually sharing good thoughts.

    Here is my web-site … nordvpn coupons inspiresensation (easyurl.cc)

  2. Please let me know if you’re looking for a author for your site.

    You have some really good articles and I think I would be a good asset.
    If you ever want to take some of the load off, I’d love
    to write some material for your blog in exchange for a link back to
    mine. Please shoot me an e-mail if interested. Thanks!

    Visit my site – nordvpn coupons inspiresensation (92url.com)

Leave a Reply

Your email address will not be published. Required fields are marked *