Re: Connecting Oracle 19 to SQL Server Issue

Hi.

I know you've already figured it out, but as a general rule, whenever I have a problem with this, I've always forgotten something, or screwed something up. I step through the setup steps, find my mistake, and it just works.

I was a little confused by the mention of an SQL Server driver. I just use a straight ODBC on on Linux.

https://oracle-base.com/articles/linux/create-an-odbc-dsn-on-linux

I'm wondering whether your comment relates to you being on Windows maybe?

Cheers

Tim...

On Tue, Aug 13, 2019 at 3:28 PM Scott Canaan <srcdco_at_rit.edu> wrote:

> Ok, one of my co-workers figured this out. Apparently, dbua removed an
> entry from the tnsnames.ora file that specified the port to listen on for
> the ODBC connections. Once that was restored, all is working as it should.
>
>
>
> *Scott Canaan ‘88*
>
> *Sr Database Administrator *Information & Technology Services
> Finance & Administration
>
>
> *Rochester Institute of Technology *o: (585) 475-7886 | f: (585) 475-7520
>
> *srcdco_at_rit.edu <srcdco_at_rit.edu>* | c: (585) 339-8659
>
> *CONFIDENTIALITY NOTE*: The information transmitted, including
> attachments, is intended only for the person(s) or entity to which it is
> addressed and may contain confidential and/or privileged material. Any
> review, retransmission, dissemination or other use of, or taking of any
> action in reliance upon this information by persons or entities other than
> the intended recipient is prohibited. If you received this in error, please
> contact the sender and destroy any copies of this information.
>
>
>
> *From:* oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> *On
> Behalf Of *Scott Canaan
> *Sent:* Tuesday, August 13, 2019 9:06 AM
> *To:* 'oracle-l_at_freelists.org' <oracle-l_at_freelists.org>
> *Subject:* Connecting Oracle 19 to SQL Server Issue
>
>
>
> I just upgraded an Oracle database from 12.1.0.2 to 19. Now the
> connections via the heterogeneous connections don’t work. I’ve copied all
> of the .ora files into the new $ORACLE_HOME/hs/admin directory. I’ve
> updated the listener.ora file to use the new 19c Oracle home and restarted
> the listener.
>
>
>
> I did not have a new SQL Server ODBC driver installed. From what I can
> see that hasn’t changed, the most recent one is “ODBC Driver 17 for SQL
> Server”. If there’s a newer one, I can’t find it.
>
>
>
> When I do a tnsping, I get “TNS-12541: TNS: no listener”, but there is a
> listener. I can see the entries when I do a status.
>
>
>
> What have I missed? Obviously there’s something.
>
>
>
> *Scott Canaan ‘88*
>
> *Sr Database Administrator *Information & Technology Services
> Finance & Administration
>
>
> *Rochester Institute of Technology *o: (585) 475-7886 | f: (585) 475-7520
>
> *srcdco_at_rit.edu <srcdco_at_rit.edu>* | c: (585) 339-8659
>
> *CONFIDENTIALITY NOTE*: The information transmitted, including
> attachments, is intended only for the person(s) or entity to which it is
> addressed and may contain confidential and/or privileged material. Any
> review, retransmission, dissemination or other use of, or taking of any
> action in reliance upon this information by persons or entities other than
> the intended recipient is prohibited. If you received this in error, please
> contact the sender and destroy any copies of this information.
>
>
>

--
http://www.freelists.org/webpage/oracle-l