Home » RDBMS Server » Networking and Gateways » connecting Oracle to SQL server (Oracle 8.0.4, Windows NT)
connecting Oracle to SQL server [message #533668] Thu, 01 December 2011 01:35 Go to next message
Arbee
Messages: 3
Registered: November 2011
Junior Member
I'm trying to make a connection to sql server from an ORACLE 8.0.4 (I know, it's ancient) but can't seem to get it to work.
I've read a lot of articles on the internet regarding the Heterogeneous Services but just can't get it to work on my system. Therefor I tried an example on connecting to an Excel workbook I found on another forum (hxxp://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:4406709207206#18830681837358) but that gives me the same problem as with connecting to sql server.

Here is what I've got:
initFRUIT.ora
HS_FDS_CONNECT_INFO = SPONGE
HS_FDS_TRACE_LEVEL = OFF


LISTENER.ORA
STARTUP_WAIT_TIME_LISTENER = 0

LISTENER =
  (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(Host = cbs_server)(Port = 1521))
    (ADDRESS = (PROTOCOL = TCP)(Host = 32.14.137.200)(Port = 1521))
    (ADDRESS = (PROTOCOL = TCP)(Host = cbs_server)(Port = 1526))
    (ADDRESS = (PROTOCOL = TCP)(Host = 127.0.0.1)(Port = 1521))
    (ADDRESS = (PROTOCOL = TCP)(Host = cbs_server)(Port = 1433))
    (ADDRESS = (PROTOCOL=IPC)(KEY=TEST))
  )

CONNECT_TIMEOUT_LISTENER = 10

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = FRUIT)
      (ORACLE_HOME=d:\orant80)
      (PROGRAM=hsodbc)
    )
  )

TRACE_LEVEL_LISTENER = 0


TNSNAMES.ORA
JELLY.WORLD =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(Host = localhost)(Port = 1521))
    (CONNECT_DATA = (SID = FRUIT))
    (HS = OK)
  )


These are results of some tests:

TNSLSNR80 status: FRUIT has 1 service handler(s)
TNSPING80 jelly: OK
When I test the Service Name Connectivity I get this: 'The test did not succeed.
ORA-12500: TNS:listener failed to start a dedicated server process'

Here's an extract from my listener.log
30-NOV-11 13:21:37 * 12502
TNS-12502: TNS:listener received no CONNECT_DATA from client
30-NOV-11 13:24:55 * (CONNECT_DATA=(SID=FRUIT)) * (ADDRESS=(PROTOCOL=tcp)(HOST=128.10.0.8)(PORT=4045)) * establish * FRUIT * 12500
TNS-12500: TNS:listener failed to start a dedicated server process
 TNS-12560: TNS:protocol adapter error
  TNS-00530: Protocol adapter error


One thing I noticed is that I do not have an hsodbc.exe file in my \bin, should it be there?
(I also tried Tgmsql80 in stead of hsodbc as program in Listener, resulting in an extended time of testing the connectivity but with the same result)

Is there any way I can test parts of the connection to limit the location of the problem? (e.g. does the listener get to the TNS)


Re: connecting Oracle to SQL server [message #533672 is a reply to message #533668] Thu, 01 December 2011 01:55 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Check this topic, especially this Maaher's walkthrough.
Re: connecting Oracle to SQL server [message #533781 is a reply to message #533672] Thu, 01 December 2011 05:10 Go to previous messageGo to next message
Arbee
Messages: 3
Registered: November 2011
Junior Member
I've read through the whole topic and links but I can only conclude that I did all the things mentioned the same way. I just can't seem to find what's different/wrong. Problem is that most topics deal with Oracle 9 and up, while there are some differences in syntax between 8, 8i and 9.
Maybe there is something missing on my oracle-server, but have no clue what it may be...
Re: connecting Oracle to SQL server [message #533794 is a reply to message #533781] Thu, 01 December 2011 05:41 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Someone was trying to connect Oracle 8 and SQL Server earlier this year here; perhaps you could contact that person and discuss it?
Re: connecting Oracle to SQL server [message #533806 is a reply to message #533794] Thu, 01 December 2011 06:24 Go to previous message
Arbee
Messages: 3
Registered: November 2011
Junior Member
Thanks for the info, I'll contact him but I doubt that's gonna help me since that topic deals with connecting an SQL server with the Oracle system.
We've got that working here too, it's the other way around that gives me a headache (connecting oracle to sql server).
I need to be able to send all changes in a table on Oracle to the SQL server and it should be online. (e.g. letting SQL server check every hour isn't sufficient)
Previous Topic: Temporary Error ORA-12505/ORA-12521
Next Topic: How to Increase Oracle SQL*Net Performance
Goto Forum:
  


Current Time: Fri Mar 29 09:08:14 CDT 2024