Re: Can One Query an Oracle 10 Data Base under FreeBSD?
Tyson Boellstorff writes: On Tuesday 02 June 2009 17:07:57 Gary Gatten wrote: Surely there's a native Oracle SQL or ODBC client in the ports collection. Have you checked there? I believe OP is looking for assurances that the oracle 7 and 8 clients listed in ports/databases would work. If he just needs a connection and to run ANSI SQL, it would work just as fine or maybe a little better than ODBC. The problem is that some things are not supported in the 7/8 clients that he may want. In that case, he should be looking at running the linux-based clients for more direct supportability from Oracle. First, my sincere thanks to everybody who answered. I did look in ports first thing and found a bewildering array of possibilities. We are going to be querying a Pinnacle server and I suspect the suggestions to use the linux-based instant clients are going to be what we need. I presently know next to nothing useful about oracle data bases so the suggestions are much appreciated. My understanding of the project we have been asked to do is that we go to the Pinnacle server, query the data base and look for a given flag that something new is here, pull in what is new, massage some headers and then send them to another device. Only the initial retrieval uses the oracle data base, but it is not a data base we control so we get it from the Pinnacle server and we will have to speak in tones it likes.:-) Martin McCormick ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org
Re: Can One Query an Oracle 10 Data Base under FreeBSD?
El miércoles 03 de junio a las 00:41:16 CEST, Michael L. Squires escribió: There is a port of the Oracle instant client which runs under Linux emulation in /usr/ports/databases/linux-oracle-instantclient-basic,sdk,sqlplus This appears to use the 10.2.0.3 Oracle Linux instant client. I used them some time ago to query an Oracle 10g server, but I didn't test them extensively. I use sqlplus with instantclient every day and every hour in my FreeBSD desktop, and works perfectly. I had some issues in FreeBSD 7.0: http://lists.freebsd.org/pipermail/freebsd-emulation/2008-September/005247.html but they were fixed in FreeBSD 7.1. Apart from sqlplus with instantcliente, you can give a try to databases/sqldeveloper. It works with java, which has addvantages and dissanvantages. Regards pgpI5W458I0hp.pgp Description: PGP signature
Re: Can One Query an Oracle 10 Data Base under FreeBSD?
On Tuesday 02 June 2009 17:07:57 Gary Gatten wrote: Surely there's a native Oracle SQL or ODBC client in the ports collection. Have you checked there? I believe OP is looking for assurances that the oracle 7 and 8 clients listed in ports/databases would work. If he just needs a connection and to run ANSI SQL, it would work just as fine or maybe a little better than ODBC. The problem is that some things are not supported in the 7/8 clients that he may want. In that case, he should be looking at running the linux-based clients for more direct supportability from Oracle. IMO, it is a case of using the wrong tool if optimal performance is a requirement. There are plenty of up-to-the-minute databases and clients for FreeBSD that are not Oracle. Otherwise, the older versions are just fine, and I haven't had any truly serious performance problems. ymmv. ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org
Re: Can One Query an Oracle 10 Data Base under FreeBSD?
The Subject is most of the question. We will need to query an Oracle 10 data base and manipulate data. Is this presently possible under FreeBSD? grep -i oracle /usr/ports/INDEX|cut -b 1-75|more ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org
RE: Can One Query an Oracle 10 Data Base under FreeBSD?
Surely there's a native Oracle SQL or ODBC client in the ports collection. Have you checked there? -Original Message- From: owner-freebsd-questi...@freebsd.org [mailto:owner-freebsd-questi...@freebsd.org] On Behalf Of Martin McCormick Sent: Tuesday, June 02, 2009 4:59 PM To: freebsd-questions@freebsd.org Subject: Can One Query an Oracle 10 Data Base under FreeBSD? The Subject is most of the question. We will need to query an Oracle 10 data base and manipulate data. Is this presently possible under FreeBSD? Thank you. Martin McCormick WB5AGZ Stillwater, OK Systems Engineer OSU Information Technology Department Telecommunications Services Group ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org font size=1 div style='border:none;border-bottom:double windowtext 2.25pt;padding:0in 0in 1.0pt 0in' /div This email is intended to be reviewed by only the intended recipient and may contain information that is privileged and/or confidential. If you are not the intended recipient, you are hereby notified that any review, use, dissemination, disclosure or copying of this email and its attachments, if any, is strictly prohibited. If you have received this email in error, please immediately notify the sender by return email and delete this email from your system. /font ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org
RE: Can One Query an Oracle 10 Data Base under FreeBSD?
On Tue, 2 Jun 2009, Gary Gatten wrote: Surely there's a native Oracle SQL or ODBC client in the ports collection. Have you checked there? -Original Message- From: owner-freebsd-questi...@freebsd.org [mailto:owner-freebsd-questi...@freebsd.org] On Behalf Of Martin McCormick Sent: Tuesday, June 02, 2009 4:59 PM To: freebsd-questions@freebsd.org Subject: Can One Query an Oracle 10 Data Base under FreeBSD? The Subject is most of the question. We will need to query an Oracle 10 data base and manipulate data. Is this presently possible under FreeBSD? Thank you. Martin McCormick WB5AGZ Stillwater, OK Systems Engineer OSU Information Technology Department Telecommunications Services Group There is a port of the Oracle instant client which runs under Linux emulation in /usr/ports/databases/linux-oracle-instantclient-basic,sdk,sqlplus This appears to use the 10.2.0.3 Oracle Linux instant client. I used them some time ago to query an Oracle 10g server, but I didn't test them extensively. There are also what appear to be older native clients from the Oracle 7 and 8 days, including an Oracle ODBC client. A search of the freebsd-databases mailing list might turn up something. I've been peeking at Talend's Open Studio which appears to be a very powerful tool for working with databases, including Oracle. This may be trying to shoot a mouse with a 155mm self-propelled gun, however. Talend is open source and there are Linux binaries which may run under FreeBSD Linux emulation. Mike Squires ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to freebsd-questions-unsubscr...@freebsd.org
