Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-9070

Access to MariaDB table from Oracle returns ORA-02085: database link <name> connects to HO.WORLD

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Not a Bug
    • 10.0
    • 10.0.20
    • OTHER
    • None
    • Server version: 10.0.20-MariaDB-log MariaDB Server
      Red Hat Linux
      Connecting from Oracle Enterprise Edition 11.2.0.4 with "global_names=true" set.

    Description

      See the following. This is using Oracle Gateway to ODBC to access MariaDB.

      SQL> create public database link ZLX70604.DB.ATT.COM connect to "dblink" identified by "<password>" using 'ZLX70604.DB.ATT.COM';

      Database link created.

       
      SQL> select * from "test1"@ZLX70604.DB.ATT.COM;
      select * from "test1"@ZLX70604.DB.ATT.COM
      *
      ERROR at line 1:
      ORA-02085: database link ZLX70604.DB.ATT.COM connects to HO.WORLD
       
      SQL> alter session set global_names=false;
       
      Session altered.
       
      SQL> select * from "test1"@ZLX70604.DB.ATT.COM;
       
      col       col2
      --- ----------
      B          987   <<< works with global_names=false.

      Attachments

        Activity

          People

            Lawrin Lawrin Novitsky
            aferrett Andy Ferretti
            Votes:
            1 Vote for this issue
            Watchers:
            5 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.