Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Connection setup from MSSQL through Oracle 11.2g

TomeoJul 19 2012 — edited Jul 19 2012
Hi folks,

I would like to query some data from MS SQL database through Oracle. In other forum I was pointed to Heterogenous Services, but unfortunatelly I'm having a problem with an initial set up.

Documentation I check:
http://docs.oracle.com/cd/E11882_01/server.112/e11050/admin.htm

http://docs.oracle.com/cd/B19306_01/server.102/b14232/admin.htm

Here is my scenario:
On the same server we are running Oracle database (11g release 11.2) and MS SQL (Microsoft SQL Server Express Edition (64-bit)).

Oracle database:
tnsnames.ora
# tnsnames.ora Network Configuration File: C:\Oracle\product\11.2.0\dbhome_dev\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

DEV =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = SERVER.AGT.local)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = DEV)
    )
  )


HELIOS = 
   (DESCRIPTION=
       (ADDRESS = (PROTOCOL = TCP)(HOST = SERVER.AGT.local)(PORT = 1521))
       (CONNECT_DATA = 
           (SERVICE_NAME = HELIOSDB)
       )
       (HS = OK)
    )
listener.ora
# listener.ora Network Configuration File: C:\Oracle\product\11.2.0\dbhome_dev\network\admin\listener.ora
# Generated by Oracle configuration tools.

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = SERVER.AGT.local)(PORT = 1521))
    )
  )

ADR_BASE_LISTENER = C:\Oracle

SID_LIST_LISTENER=
  (SID_LIST=
      (SID_DESC=
         (SID_NAME=HELIOSDB)
         (ORACLE_HOME=C:\Oracle\product\11.2.0\dbhome_dev)
         (PROGRAM=dg4odbc)
      )
  )
I'm not sure whether a listener part is configured correctly.

Also, what next should be done?
Where is defined a connection to MS SQL database?

Please guide me with this initial configuration if possible.

Kind regards,
Tomas
This post has been answered by Kgronau-Oracle on Jul 19 2012
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 16 2012
Added on Jul 19 2012
17 comments
1,335 views