Good day all,
I believe I have followed all of the correct steps to establish connectivity, yet to no avail. Before initiating the "bang-head-against_wall" sequence, I am reaching for assistance.
I appreciate any and all guidance.
Here are the particulars:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
PL/SQL Release 11.2.0.1.0 - Production
CORE 11.2.0.1.0 Production
TNS for 32-bit Windows: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production
Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64)
Apr 2 2010 15:48:46
Copyright (c) Microsoft Corporation
Standard Edition (64-bit) on Windows NT 6.1 <X64>
(Build 7601: Service Pack 1)
(Hypervisor)
Microsoft SQL Server ODBC Driver Version 06.01.7601
Data Source Name: GMEXCH
Data Source Description: GMEXCH
Server: INFWDCSWNSERD01v
Database: mars
Language: (Default)
Translate Character Data: Yes
Log Long Running Queries: No
Log Driver Statistics: No
Use Regional Settings: No
Prepared Statements Option: Drop temporary procedures on disconnect
Use Failover Server: No
Use ANSI Quoted Identifiers: Yes
Use ANSI Null, Paddings and Warnings: Yes
Data Encryption: No
Microsoft SQL Server ODBC Driver Version 06.01.7601
Running connectivity tests...
Attempting connection
Connection established
Verifying option settings
Disconnecting from server
TESTS COMPLETED SUCCESSFULLY!
initGMEXCH.ora
HS_FDS_CONNECT_INFO = GMEXCH
HS_FDS_TRACE_LEVEL = 0
HS_AUTOREGISTER = TRUE
Listener.ora
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME=GMSERV)
(ORACLE_HOME=C:\app\LOGIX\product\11.2.0\dbhome_1)
(PROGRAM = hsodbc)
)
)
tnsnames.ora
GMOTD=
(DESCRIPTION=
(ADDRESS_LIST=
(Address=(PROTOCOL=TCP)
(HOST = 10.94.34.124)
(PORT=1521)))
(CONNECT_DATA=(SID=GMSERV))
(HS=OK)
)
sqlnet.ora
SQLNET.AUTHENTICATION_SERVICES = (NONE)
LSNRCTL> status
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 11.2.0.1.0 - Produ
ction
Start Date 10-FEB-2014 15:40:01
Uptime 0 days 0 hr. 18 min. 39 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File C:\app\LOGIX\product\11.2.0\dbhome_1\network\admin\lis
tener.ora
Listener Log File c:\app\logix\diag\tnslsnr\WVHUNTID0017\listener\alert\
log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=WVHUNTID0017)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=WVHUNTID0017)(PORT=8080))(Presentati
on=HTTP)(Session=RAW))
Services Summary...
Service "GMSERV" has 1 instance(s).
Instance "GMSERV", status UNKNOWN, has 1 handler(s) for this service...
Service "LOGIXFTRXDB" has 1 instance(s).
Instance "logixftr", status READY, has 1 handler(s) for this service...
Service "logixftr" has 1 instance(s).
Instance "logixftr", status READY, has 1 handler(s) for this service...
The command completed successfully
C:\Windows\System32>tnsping GMOTD
TNS Ping Utility for 32-bit Windows: Version 11.2.0.1.0 - Production on 10-FEB-2
014 15:48:25
Copyright (c) 1997, 2010, Oracle. All rights reserved.
Used parameter files:
C:\app\LOGIX\product\11.2.0\dbhome_1\network\admin\sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION= (ADDRESS_LIST= (Address=(PROTOCOL=TCP) (HOST
= 10.94.34.124) (PORT=1521))) (CONNECT_DATA=(SID=GMSERV)) (HS=OK))
OK (20 msec)
SQL> show parameter global_names;
NAME TYPE VALUE
------------------------------------ ----------- -------
global_names boolean FALSE
SQL> create database link GM connect to "agaf_dhdhd" identified by
2 "xhxhxhxh!" using 'GMOTD';
Database link created.
SQL> select * from wirecenters_web@GM;
select * from wirecenters_web@GM
*
ERROR at line 1:
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 GM