Bom dia Danusa,

Já fiz vários testes sem aspas e com aspas.

Sempre retorna o mesmo erro.

select * from pedido@CacheDB;   

select * from dw.pedido@CacheDB;   

select * from "pedido"@CacheDB;   

select * from "dw"."pedido"@CacheDB;   

select * from "dw.pedido"@CacheDB;

Boa tarde,

Eu não tenho acesso ao servidor do cache para verificar os logs.

Os arquivos odba.ini e odbcinst.ini estão configurado desta forma:

/etc/odbc.ini
[cachedb]
Driver          = /usr/local/lib/odbc/libcacheodbc35.so
Description     = Cache ODBC driver
Host            = 192.168.1.10
Namespace       = DW
UID             = dw
Password        = **********************
Port            = 1972
Protocol        = TCP
Query Timeout   = 1
Static Cursors  = 0
Trace           = Yes
TraceFile       = /tmp/iodbctrace.log
Authentication Method   = 0
Security Level  = 2
Service Principal Name = cache/localhost.domain.com

/etc/odbcinst.ini

# Driver from InterSystems Cache
# Setup manually to access the database Consystem
[cachedb]
Description=InterSystems Caché ODBC Driver
Driver=/usr/local/lib/odbc/libcacheodbc35.so
Setup=/usr/local/lib/odbc/libcacheodbc35.so
Driver64=/usr/local/lib/odbc/libcacheodbc35.so
Setup64=/usr/local/lib/odbc/libcacheodbc35.so
Trace           = Yes
TraceFile       = /tmp/iodbctrace.log
FileUsage=1
 

No oracle configurei os arquivos:
-  tnsnames.ora

CACHEDB =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    (CONNECT_DATA =
      (SID = cachedb)
    )
    (HS=OK)
  )

- listener.ora

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = cachedb)
      (ORACLE_HOME = /opt/oracle/product/21c/dbhomeXE)
      (PROGRAM = dg4odbc)
    )
  )
 

- initcachedb.ora
HS_FDS_CONNECT_INFO = cachedb
HS_FDS_SHAREABLE_NAME = /usr/local/lib/odbc/libcacheodbc35.so
HS_LANGUAGE=AMERICAN_AMERICA.WE8ISO8859P15
HS_FDS_TRACE_LEVEL = DEBUG
HS_FDS_TRACE_FILE_NAME = /tmp/CacheD-dblink.trc
set ODBCINI=/etc/odbc.ini

Criado o dblink:

CREATE DATABASE LINK cachedb CONNECT TO "dw" IDENTIFIED BY "**********************" USING 'cachedb';

Ao executar o select esta retornando o erro.