2 Replies Latest reply: Feb 11, 2014 6:02 AM by GMoney RSS

11g Enterprise Edition Release 11.2.0.1.0 to Microsoft SQL Server 2008 R2 (RTM)

GMoney Newbie
Currently Being Moderated


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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points