Forum Discussion

boeschr's avatar
boeschr
Frequent Visitor
3 years ago

ORA-00900: Error with opening a session in a SQL statement for Oracle database

Hi all   Maybe someone can help me.  We have a case where we want to access data from an Oracle DB where we have to open a session before we can execute our query. While this works in other tools,...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi boeschr ,

 

The error message "ORA-00900" indicates that there is a syntax error in the SQL statement. One possible cause of this error is that the Oracle client either isn't installed or isn't configured properly. If it's installed, verify that the tnsnames.ora file is properly configured and you're using the proper net_service_name. You also need to make sure that the net_service_name is the same between the machine that uses Power BI Desktop and the machine that runs the gateway. It is advised that for Oracle configuration errors, the customer should work with their oracle support to understand and configure correctly.

 

   

                                                                                                                                                         

Best Regards,

Stephen Tao

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.           

  • NeilChapdelain's avatar
    NeilChapdelain
    New Member
    3 years ago

    Thanks for the advice, I will check it.

    Spoiler
    Thanks for the advice, I will check it. If you're in need of thesis writing help and came across the website https://studyclerk.com/thesis-writing-help while searching on Google, it's essential to read evaluations and reviews before using their services. Reviews can offer valuable insights into the website's credibility, reliability, and quality of its writing assistance.