All,
My environment is the following :
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64) Apr 2 2010 15:48:46 Copyright (c) Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7600: ) (Hypervisor)
The Oracle runs on RedHat 6 x86 64 and SQL Server on Windows Server 2003 R2.
My configuration is the following :
initdg4msql.ora :
HS_FDS_CONNECT_INFO=192.168.21.176//ALARM
# alternate connect format is hostname/serverinstance/databasename
HS_FDS_TRACE_LEVEL=255
HS_FDS_RECOVERY_ACCOUNT=RECOVER
HS_FDS_RECOVERY_PWD=RECOVER
tnsnames.ora :
dg4msql =
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=DL370-11.200)(PORT=1521))
(CONNECT_DATA=(SID=dg4msql))
(HS=OK)
)
listener.ora
SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(SID_NAME=dg4msql)
(ORACLE_HOME=/opt/oracle/product/11.2.0/dbhome)
(PROGRAM=dg4msql)
)
)
The error I get is the following when trying to connect to SQL Server :
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[Oracle][ODBC SQL Server Driver][libssclient24]General network error. Check your network documentation. {08001,NativeErr = 11}[Oracle][ODBC SQL Server Driver][libssclient24]ConnectionOpen (192.168.21.176()). {01000,NativeErr = 11}[Oracle][ODBC SQL Server Driver]Invalid connection string attribute {01S00}[Oracle][ODBC SQL Server Driver]The requested instance is either invalid or not running {HY000}
ORA-02063: preceding 2 lines from DBLINK
28500. 00000 - "connection from ORACLE to a non-Oracle system returned this message:"
*Cause: The cause is explained in the forwarded message.
*Action: See the non-Oracle system's documentation of the forwarded
message.
Error at Line: 3 Column: 20
The command : telnet 192.168.21.176 executed on my Linux box is successfull.
Does anyone have an idea of what's going on ? Any bad configuration ?
Thanks
Patrick