Credentials change for oracle db hangs

Credentials change for Oracle db hangs (until session timeout) on "applying modified settings" when save changes is executed.  (Agent 5.7.5.30)

There is no error or other message/feedback at all.  The credentials are verified on the target.

Is an upgrade or patch required?

  • Hello John,

    Please open the DB admin dashboard for the problematic agent and set the new DB credentials there (Connection Details part). Once you changed it, please verify/test the connection.

    The agent should work properly again afterwards.

    Regards
    Nicola
  • In reply to Nicola.Flucke:

    not finding a password set option for the target in the agents gui
  • In reply to John.R.Walker:

    Hi John,

     

    On the Databases dashboard, select the instance, click Settings, Administration:

    Then Connection Details, Set Credentials, update the password, Hit Set (should be step 4), then you can Test the connection (4 in the image), and finally make sure to save changes (button in lower right, #6).

     

    Hope that helps.

    -Darren

  • In reply to Darren.Mallette:

    Darren, Thank you for the reply.
    We are full circle. When I hit the SAVE button, it hangs for eternity.
    Sometimes, I get lucky and it takes the entry, most of the time not.

    The issue behind changing user is the db Foglight user keeps getting locked.
    We are attempting to move away from the Foglight user and put system in to be functional again.
    The drill down says cant connect Foglight as sysdba. We have granted dba to Foglight without success in the gui.

    We know the credentials for Foglight user are good as we log into the sqlplus without any issue (not as sysdba).

    For clarity, if you have a script showing all the grants to Foglight user, that would be very helpful.

    Regards,
    John Walker
  • In reply to John.R.Walker:

    How to escalate this to a ticket? we cant have our systems un-monitored this long?
  • In reply to John.R.Walker:

    Hi John,

    You can enter a service request here: support.quest.com/create-service-request
  • In reply to John.R.Walker:

    Please take no offence and i am grateful for the screenshots with explanation. I've been working on this off an on and its just got to be done asap. Ticket is submitted. Will be happy to share the fix when it's done.
  • In reply to John.R.Walker:

    The script is found here: dashboards-administration-cartridges-components for download
  • In reply to John.R.Walker:

    Change credentials via the Agent: Dashboards-administration-agents-agentStatus