Oracle Database Discussions

Hi everyone
I'm on oracle 11g 11.1.0.7 (64bit) OEL 5.2 using unixodbc and freetds to connect to SQL Server 2000 following this doc http://www.dbapool.com/articles/06280701.html

I'm stuck at the listener stage here is my error when i try to start the listener
TNS-01150: The address of the specified listener name is incorrect

Listener failed to start. See the error message(s) above...


Here are my config files:

/usr/local/etc/freetds.conf:
# A typical Microsoft server
[NYCSQL1]
host = 999.16.0.99
port = 1433
tds version = 8.0

/etc/odbcinst.ini:
[TDS]
Description = FreeTDS driver
Driver = /usr/local/lib/libtdsodbc.so
Setup = /usr/local/lib/libtdsodbc.so
Trace = Yes
TraceFile = /tmp/freetds.log
FileUsage = 1

/etc/odbc.ini:
[NYCSQL1]
Description = NYCSQL1
Driver = TDS
Servername = NYCSQL1
Server = NYCSQL1
Address = 999.16.0.99
Port = 1433
Database = db1
TDS_Version = 8.0
Language = us_english
TextSize =
Domain = corp.hfmus.com
PacketSize =
Trace = Yes
TraceFile = /tmp/mstest.log

initnycsql1.ora:
# This is a sample agent init file that contains the HS parameters that are
# needed for an ODBC Agent.
#
# HS init parameters
#
HS_FDS_CONNECT_INFO = NYCSQL1
#HS_FDS_TRACE_LEVEL = 4
#HS_FDS_TRACE_FILE_NAME = /tmp/freetds.trc
HS_FDS_SHAREABLE_NAME = /usr/local/lib/libodbc.so

#
# ODBC specific environment variables
#
set ODBCINI=/etc/odbc.ini

#
# Environment variables required for the non-Oracle system
#
#set <envvar>=<value>



listener.ora:
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = myserver)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)
SID_LIST_NYCSQL1 =
(SID_LIST =
(SID_DESC =
(SID_NAME = NYCSQL1)
(ORACLE_HOME = /u01/app/oracle/product/11.1.0/db_1)
(PROGRAM = hsodbc)
)
)

NYCSQL1 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1522))
(ADDRESS=(PROTOCOL=ipc)(KEY=PNPKEY)))
)
)

hsodbc has been changed to dg4odbc in 11g and i've tried different variations and get the same error.

Any help appreciated.
Thank you

Edited by: ALEXSDBA on Mar 26, 2010 12:59 PM

Edited by: ALEXSDBA on Mar 26, 2010 1:13 PM