Oracle Database Discussions

Database: 11.2.0 Windows 32-bit (on WindowsXP SP3)

ORACLE_HOME = D:\Oracle\Product\11.2.0\dbhome
GATEWAY_HOME = D:\Oracle\Product\11.2.0\tg

odbc : sqlserver (working... i can import table's data in MS Excel) its ok...

D:\Oracle\Product\11.2.0\dbhome\hs\admin\initsqlserver.ora

# This is a sample agent init file that contains the HS parameters that are
# needed for the Database Gateway for ODBC

#
# HS init parameters
#
HS_FDS_CONNECT_INFO = sqlserver
HS_FDS_TRACE_LEVEL = 0
#
# Environment variables required for the non-Oracle system
#
#set <envvar>=<value>

D:\Oracle\Product\11.2.0\dbhome\NETWORK\ADMIN\listener.ora

# listener.ora Network Configuration File: D:\Oracle\Product\11.2.0\dbhome\network\admin\listener.ora
# Generated by Oracle configuration tools.


SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = orcl)
(ORACLE_HOME = D:\Oracle\Product\11.2.0\dbhome)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:D:\Oracle\Product\11.2.0\dbhome\bin\oraclr11.dll")
)
(SID_DESC=
(SID_NAME=sqlserver)
(ORACLE_HOME = D:\Oracle\Product\11.2.0\dbhome)
(PROGRAM = dg4odbc)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.20.0.32)(PORT = 1521))
)
)

ADR_BASE_LISTENER = D:\Oracle\Product\11.2.0\dbhome



Listener Status

LSNRCTL> status
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=172.20.0.32)(PORT=1521))
)
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 11.2.0.1.0 - Produ
ction
Start Date 30-SEP-2011 11:13:53
Uptime 0 days 0 hr. 0 min. 24 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File D:\Oracle\Product\11.2.0\dbhome\network\admin\listener
.ora
Listener Log File d:\oracle\product\11.2.0\dbhome\diag\tnslsnr\stylo-dba
\listener\alert\log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=172.20.0.32)(PORT=1521)))
Services Summary...
Service "orcl" has 1 instance(s).
Instance "orcl", status UNKNOWN, has 1 handler(s) for this service...
Service "sqlserver" has 1 instance(s).
Instance "sqlserver", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
LSNRCTL>


D:\Oracle\Product\11.2.0\dbhome\NETWORK\ADMIN\tnsnames.ora

# tnsnames.ora Network Configuration File: D:\Oracle\Product\11.2.0\dbhome\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)


ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.20.0.32)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)


sqlserver =
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST=172.20.0.32)(PORT=1521))
(CONNECT_DATA =
(SID=sqlserver))
(HS = OK)
)

TNS PING Restult

C:\Documents and Settings\Administrator>tnsping sqlserver

TNS Ping Utility for 32-bit Windows: Version 11.2.0.1.0 - Production on 30-SEP-2
011 11:15:47

Copyright (c) 1997, 2010, Oracle. All rights reserved.

Used parameter files:
D:\Oracle\Product\11.2.0\dbhome\network\admin\sqlnet.ora

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=172.20.0.32)(PO
RT=1521)) (CONNECT_DATA = (SID=sqlserver)) (HS = OK))
OK (50 msec)

C:\Documents and Settings\Administrator>






Database Link

create database link sqlserver connect to uoracle identified by uoracle using 'sqlserver';


SQL>
SQL> select from sysobjects@sqlserver*
ERROR:
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 DG4ODBC


SQL>


Waiting for help. What thing im missing.....