Hi everyone,
I’m trying to install my oracle database and connect it to MySQL, SQL Server and Oracle database. My oracle version is 10.2.0.
I try to install it on Windows Server 2003 64 bit. I read from the forum that I can not use hsodbc in 64 bit server. So I install gw4odbc in folder C:\Oracle_gw_11g.
I tried to follow the instruction on
1104303 but it’s still not working.
This is my init file, listener and tnsnames from C:\oracle\product\10.2.0 folder:
initDJA.ora
HS_FDS_CONNECT_INFO = DJA
HS_FDS_TRACE_LEVEL = 0
initDJPU.ora
HS_FDS_CONNECT_INFO = DJPU
HS_FDS_TRACE_LEVEL = 0
Listener.ora
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = dtpool)
(ORACLE_HOME = C:\oracle\product\10.2.0\db_1)
(SID_NAME = dtpool)
)
(SID_DESC =
(SID_NAME = DJPU)
(ORACLE_HOME = C:\oracle\product\10.2.0\db_1)
(PROGRAM = hsodbc)
)
(SID_DESC =
(SID_NAME = DJA)
(ORACLE_HOME = C:\oracle\product\10.2.0\db_1)
(PROGRAM = hsodbc)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = keu00ee-c58.******.**.**)(PORT = 1521))
)
)
Tnsnames.ora
DJPBN =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.2.24)(PORT = 1521))
)
(CONNECT_DATA =
(SID = QUO1)
(SERVER = DEDICATED)
)
)
DTPOOL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = keu00ee-c58.******.**.**)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = dtpool)
)
)
DJA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(CONNECT_DATA =
(SID = DJA)
)
(HS = OK)
)
DJPU =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(CONNECT_DATA =
(SID = DJPU)
)
(HS = OK)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
This happen when I’m trying to do tnsping
C:\Documents and Settings\teguh>tnsping listener
TNS Ping Utility for 64-bit Windows: Version 11.2.0.1.0 - Production on 02-AUG-2
010 18:56:20
Copyright (c) 1997, 2010, Oracle. All rights reserved.
Used parameter files:
C:\Oracle_gw_11g\product\11.2.0\tg_1\network\admin\sqlnet.ora
TNS-03505: Failed to resolve name
*After I installed gw4odbc, it created another listener.
I tried to copy the init file and change listener.ora
This is init file, listener and tnsnames from C:\Oracle_gw_11g folder:*
initDJA.ora
HS_FDS_CONNECT_INFO = DJA
HS_FDS_TRACE_LEVEL = 0
initDJPU.ora
HS_FDS_CONNECT_INFO = DJPU
HS_FDS_TRACE_LEVEL = 0
Listener.ora
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\Oracle_gw_11g\product\11.2.0\tg_1)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = dtpool)
(ORACLE_HOME = C:\Oracle_gw_11g\product\11.2.0\tg_1)
(SID_NAME = dtpool)
)
(SID_DESC =
(SID_NAME = DJPU)
(ORACLE_HOME = C:\Oracle_gw_11g\product\11.2.0\tg_1)
(PROGRAM = gw4odbc)
)
(SID_DESC =
(SID_NAME = DJA)
(ORACLE_HOME = C:\Oracle_gw_11g\product\11.2.0\tg_1)
(PROGRAM = gw4odbc)
)
)
LISTENER_GW =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = keu00ee-c58.******.**.**)(PORT = 1522))
)
)
Tnsnames.ora
DJPBN =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.2.24)(PORT = 1521))
)
(CONNECT_DATA =
(SID = QUO1)
(SERVER = DEDICATED)
)
)
DJA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = keu00ee-c58.******.**.**)(PORT = 1521))
)
(CONNECT_DATA =
(SID = DJA)
)
(HS = OK)
)
DTPOOL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = keu00ee-c58.******.**.**)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = dtpool)
)
)
DJPU =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = keu00ee-c58.******.**.**)(PORT = 1521))
)
(CONNECT_DATA =
(SID = DJPU)
)
(HS = OK)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
This is what happening when I’m tring to do tnsping
C:\Documents and Settings\teguh>lsnrctl start listener_gw
LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 02-AUG-2010 19:17
:42
Copyright (c) 1991, 2010, Oracle. All rights reserved.
TNS-01106: Listener using listener name LISTENER has already been started
C:\Documents and Settings\teguh>tnsping listener_gw
TNS Ping Utility for 64-bit Windows: Version 11.2.0.1.0 - Production on 02-AUG-2
010 19:18:21
Copyright (c) 1997, 2010, Oracle. All rights reserved.
Used parameter files:
C:\Oracle_gw_11g\product\11.2.0\tg_1\network\admin\sqlnet.ora
TNS-03505: Failed to resolve name
I can create database link, but when I try to test the connection, this error comes up.
ORA-28545: error diagnosed by Net8 when connecting to an agent Unable to retrieve text of NETWORK/NCR message 65535 ORA-02063: preceding 2 lines from DJALINK
Can anyone help me with this problem?
Edited by: user9522057 on Aug 2, 2010 5:27 AM