Home » RDBMS Server » Networking and Gateways » DBLINK Between oracle ans sql server 2005 (Oracle 10g, 10.2.0.1.0,windows)
DBLINK Between oracle ans sql server 2005 [message #422176] Mon, 14 September 2009 23:33 Go to next message
siddabathuni
Messages: 3
Registered: December 2008
Location: hyderabad
Junior Member
Hi,

I am trying a dblink from oracle to sql sqrver 2005.Here my doubt is my sql server 2005 db is running on the port 1433 and how can i make changers in the listener file and I was unable to start the multiple listners on the same system what changes i want to do .Here is my listener file output and tnsnames.ora file output.


# listener.ora Network Configuration File: E:\oracle\product\10.2.0\db_1\network\admin\listener.ora

# Generated by Oracle configuration tools.

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(SID_NAME = PLSExtProc)

(ORACLE_HOME = E:\oracle\product\10.2.0\db_1)

# (PROGRAM = extproc)

)

(SID_DESC =

(SID_NAME = orcl)

(ORACLE_HOME = E:\oracle\product\10.2.0\db_1)

)

)

LISTENER =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))

(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.4.15)(PORT = 1521))

)

)

#-------------------------------------------------------------------------

LISTENER2 =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))

(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.4.15)(PORT = 1522))

(ADDRESS=(PROTOCOL=ipc)(KEY=PNPKEY)))

)

)

SID_LIST_LISTENER2=

(SID_LIST=

(SID_DESC=

(SID_NAME=CKMREPORTING)

(ORACLE_HOME=E:\oracle\product\10.2.0\db_1)

(PROGRAM=hsodbc)

)

)







.....................................................................................













# tnsnames.ora Network Configuration File: E:\oracle\product\10.2.0\db_1\network\admin\tnsnames.ora

# Generated by Oracle configuration tools.

MAHESH =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.4.15)(PORT = 1521))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = mahesh)

)

)

ORCL =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.4.15)(PORT = 1521))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = orcl)

(UR=A)

)

)

EXTPROC_CONNECTION_DATA =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))

)

(CONNECT_DATA =

(SID = PLSExtProc)

(PRESENTATION = RO)

)

)

QFUND =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.235)(PORT = 1521))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = QFUND)

)

)

POOR =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.85)(PORT = 1521))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = poor)

)

)

CKMREPORTING=

(DESCRIPTION=

(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.2.233)(PORT=1433))

(CONNECT_DATA=(SID=CKMREPORTING))

(HS=ok)

)
Re: DBLINK Between oracle ans sql server 2005 [message #423269 is a reply to message #422176] Wed, 23 September 2009 03:20 Go to previous message
WillIm
Messages: 13
Registered: June 2008
Location: Kyrgyzstan, Bishkek
Junior Member
Hello!
What product are you using HSODBC or DG4ODBC?
Previous Topic: ora-12170: TNS :connect timeout occurred
Next Topic: Databae connection failed
Goto Forum:
  


Current Time: Thu Mar 28 15:12:32 CDT 2024