Are you tried of getting below error during creating Oracle OCI Generative AI Agent ? where your agent connection is successful but OCI Generative AI Agent chat window is throwing error, then this is blog post will help you to fix it.

It can be fix with below IAM Polices.

User Error: Failed to execute DB query with Error – NotAuthorizedOrNotFound: Authorization failed or requested resource not found with http status 404

allow any-user to use database-tools-connections in compartment Database where request.principal.type=’genaiagent’
allow any-user to read database-tools-family in compartment Database where request.principal.type=’genaiagent’
allow any-user to read secret-family in compartment Database where request.principal.type=’genaiagent’
allow any-user to manage genai-agent-family in compartment Database