I’ve found that unless I give Codex very detailed instructions on how to talk with the Oracle MCP it generally won’t supply sufficient context to get a reasonable answer back.
Do you have more detailed instructions in your agents.md guiding Codex/others on how to use Oracle? If so, it would be great see what they are!