| DBLINK Between oracle ans sql server 2005 [message #422176] |
Mon, 14 September 2009 23:33  |
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)
)
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
