Oracle Database Discussions

Hello,

I'm trying comunicate Foxpro database with Oracle XE 11 and for details, the configurated listener.ora, tnsnames.ora and initsid.ora is listed on bottom topic.

Well I guess I did a correct configuration, because I got some selects from empty tables. My problem is when I select any filled table...


I'm receiving this error ... so I guess that error is somenthing about character returned from Oracle to Driver FOxPro but I'm not sure....

I saw a lot of threads to check oracle_home/hs/log files, but it doesn't exist ! I tried create it but no one file is created there !

I tried created on server... I tried created in client oracle... and i'm being crazy !

Please, someone can give me a way to see this errors (logs)...




ORA-28500: conexão do ORACLE com um sistema não Oracle retornou esta mensagem:
[Microsoft][ODBC Driver Manager] Tipo de descritor fora do intervalo {HY091}
ORA-02063: precedendo 2 lines a partir de DBMATRIZ



They are :


listener.ora

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oraclexe\app\oracle\product\11.2.0\server)
(PROGRAM = extproc)
)
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = C:\oraclexe\app\oracle\product\11.2.0\server)
(PROGRAM = extproc)
)

(SID_DESC =
(PROGRAM = dg4odbc)
(SID_NAME = fpmatriz)
(ORACLE_HOME = C:\oraclexe\app\oracle\product\11.2.0\server)
)

)




LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = WIN-ESRA2A7742K)(PORT = 1521))
)
)



DEFAULT_SERVICE_LISTENER = (XE)



tsnnames.ora

XE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = WIN-ESRA2A7742K)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XE)
)
)
fpmatriz =
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=WIN-ESRA2A7742K)(PORT=1521))
(CONNECT_DATA=(SID=fpmatriz))
(HS=OK)
)

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)

ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)




initfpmatriz.ora
HS_FDS_CONNECT_INFO = fpmatriz
HS_FDS_TRACE_LEVEL = debug
HS_FDS_QUOTE_IDENTIFIER=FALSE