Database Backup and Recovery (MOSC)

MOSC Banner

Oracle: ORA-44201: cursor needs to be reparsed

We are facing the below error randomly, while MS Power BI refereshing the samentic model.

Actuall we have primary database 12c (12.2.0.1.0), and physical active standby database (12c (12.2.0.1.0) mode (READ ONLY WITH APPLY).

When we connect the Power BI with PRIMARY we have not facing any error like ORA-44201 abut when Power BI connect with ACTIVE STANDBY DATABASE, this ORA-44201 is occuring randomaly.

Note: My Active standby database is working perfectly, no such error is occuring in alert_lof file.

Kindly share the experience if any faced this ORA-44201 error?

Data source error: {"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"Oracle: ORA-44201: cursor needs to be reparsed"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ErrorCode","detail":{"type":1,"value":"10478"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourceKind","detail":{"type":1,"value":"Oracle"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourcePath","detail":{"type":1,"value":"salesdb"}},{"code":"Microsoft.Data.Mashup.ValueError.ErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.Message","detail":{"type":1,"value":"ORA-44201: cursor needs to be reparsed"}},{"code":"Microsoft.Data.Mashup.ValueError.NativeError","detail":{"type":1,"value":"44201"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error"}}],"exceptionCulprit":1}}}

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center