none
Linked server test connection failing with Oracle ORA-0xxxx: Message xxxx not found on 1 of sql server 2012 dev server

    Question

  • Hi,

    we've linked servers created in SQL server 2012 and they are working till yesterday. All of sudden test connection failing with below error.

    Cannot initialize data source object "TEST" ....ORA-0xxxx: Message xxxx not found; No message file for product=RDBMS, facility=ORA

    Here few details about oracle client:

    12c 32 & 64 bit oracle client installed

    tns_admin set for 32 bit path and tnsping working fine for oracle database.

     

    Can someone please help why this error getting and which scenario's we'll receive this kind of error.

    Wednesday, July 11, 2018 2:23 PM

All replies

  • Hi,

    on SQL server 2012, we've linked server for oracle 12c database and that linked server is failing with below error and it was working till yesterday . I'm really not sure what is causing issue.

    ORA-0xxxx: Message xxxx not found; No message file for product=RDBMS, facility=ORA

    tnsping working fine from cmd prompt and tns_admin set in environment variables.Also tested in ODBC for both 32bit and 64bit and it is working fine.

    Can someone please help me if anyone come across this situation. Urgent..

    Regards,

    Prathap

    Wednesday, July 11, 2018 2:31 PM
  • ORA-0xxxx: Message xxxx not found

    Please post the complete error number & message.

    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    Wednesday, July 11, 2018 2:43 PM
    Moderator
  • Hi Olaf,

    Thank you for your response.

    I'm getting below error when i try to test linked server. Linked server created for oracle.

    Cannot initialize data source object "TEST".ORA-0xxxx: Message xxxx not found; No message file for product=RDBMS, facility=ORA

    i am not sure exact error message since i've not remember.

    Thanks in advance.

    Regards,

    Prathap

    Wednesday, July 11, 2018 2:52 PM
  • Hi Olaf,

    Thank you for your response.

    I'm getting below error when i try to test linked server. Linked server created for oracle.

    Cannot initialize data source object "TEST".ORA-0xxxx: Message xxxx not found; No message file for product=RDBMS, facility=ORA

    i am not sure exact error message since i've not remember.

    Thanks in advance.

    Regards,

    Prathap

    Did someone mess with Oracle path values lately?

    This suggests it may be issue with Oracle_home env variable setup

    http://www.projectenvision.com/blog/Oracle-ORA-0xxxx-Message--not-found


    Please Mark This As Answer if it solved your issue
    Please Vote This As Helpful if it helps to solve your issue
    Visakh
    ----------------------------
    My Wiki User Page
    My MSDN Page
    My Personal Blog
    My Facebook Page


    • Edited by Visakh16MVP Wednesday, July 11, 2018 3:03 PM
    Wednesday, July 11, 2018 3:02 PM
  • Issue resolved after restart server. restart always works in windows if anything abnormal behaviour:)

    Thanks,

    Prathap

    Thursday, July 12, 2018 2:27 PM