Re: why no Oracle on FreeBSD ?
The reality is that Oracle is meant to be a very expensive solution for companies that don't know what to do. This makes Red Hat etc an ideal contender for this situation as it promises full enterprise support. Whether it is the truth or if its even a good solution is completely irreverent to these 2 tech companies because at the end of the day they are just trying to make money and please the stock holders. snip Huh? Last I remember reading, Oracle hasn't put a native version together for FreeBSD because running it through the linuxlator works well enough to justify not spending engineering resources on it. ___ 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: why no Oracle on FreeBSD ?
2009/9/25 Saifi Khan saifi.k...@datasynergy.org: On Thu, 24 Sep 2009, Julian H. Stacey wrote: i noticed that there is no Oracle available for FreeBSD http://www.oracle.com/technology/software/products/database/index.html What could be the reason for that ? Best ask direct of commercial application vendor Oracle. IE wave money under Oracle's nose ask to purchase what you want. If Oracle think there's enough profit in it, there's many BSD consultants eg http://berklix.com/consultants/ willing to work. Cheers, Julian -- i was wondering if there is any technical reason behind this ? Most unlikely. Ask Oracle tell advocacy@ what you find out. I'd bet perceived market share demand as ever, ie Money. Hi Julian: Here is the response on the Oracle forum thread to my posting, FreeBSD is a kernel not used in any extant operating system with the sole exception being Apple's Mac OSX so you are heading, full speed ahead, toward disappointment. And this is where he gives away that he knows nothing about it. In the first sentence, he shows that he thinks that Mac OS X uses the FreeBSD kernel. (Which is wrong, in case you were wondering http://en.wikipedia.org/wiki/Darwin_(operating_system) ) FreeBSD handles many things very differently from the UNIX System 5 standard so you can not just kludge your way into this. What? What fascinates me about your request is why you care. FreeBSD is going nowhere at a staggeringly fast pace. And to the same place as went Oracle Database version 8.0. Obscurity. What? Install Oracle's Enterprise Linux and you will have a real operating system in less time than you've spent monitoring this thead. And as an additional value it will support the Oracle technology stack while you are still young enough to use it. and IF you can match up the system calls, then you can 'make it work'. The relevant links are 1. http://forums.oracle.com/forums/thread.jspa?threadID=952076tstart=0 2. http://forums.oracle.com/forums/thread.jspa?threadID=952076tstart=0 The response seems to suggest that there is some feature used by Oracle which is expected from a UNIX Sys 5 std and perhaps FreeBSD does not support/have the syscall. Given the response, What is your analysis of the situation ? thanks Saifi. This guy replying to your post was a troll, basically. Ignore him, and concentrate on real Oracle employees for sources. Of course, if this was an Oracle employee, then you really should think about using some different software Chris -- A: Because it messes up the order in which people normally read text. Q: Why is top-posting such a bad thing? A: Top-posting. Q: What is the most annoying thing in a mailing list? ___ 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: why no Oracle on FreeBSD ?
On Sun 27 Sep 2009 at 12:25:50 PDT Chris Rees wrote: This guy replying to your post was a troll, basically. Ignore him, and Yep. It shows that some Linux fans are just as prone to creating FUD as their adversaries in the Windows world. I'd like to think the BSD community is better than that. ___ 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: why no Oracle on FreeBSD ?
On 25/09/2009 10:28 PM, Saifi Khan wrote: On Thu, 24 Sep 2009, Julian H. Stacey wrote: i noticed that there is no Oracle available for FreeBSD http://www.oracle.com/technology/software/products/database/index.html What could be the reason for that ? Best ask direct of commercial application vendor Oracle. IE wave money under Oracle's nose ask to purchase what you want. If Oracle think there's enough profit in it, there's many BSD consultants eg http://berklix.com/consultants/ willing to work. Cheers, Julian -- i was wondering if there is any technical reason behind this ? Most unlikely. Ask Oracle tell advocacy@ what you find out. I'd bet perceived market share demand as ever, ie Money. Hi Julian: Here is the response on the Oracle forum thread to my posting, FreeBSD is a kernel not used in any extant operating system with the sole exception being Apple's Mac OSX so you are heading, The reality is that Oracle is meant to be a very expensive solution for companies that don't know what to do. This makes Red Hat etc an ideal contender for this situation as it promises full enterprise support. Whether it is the truth or if its even a good solution is completely irreverent to these 2 tech companies because at the end of the day they are just trying to make money and please the stock holders. We have bought the occasional Dell server with Enterprise Red Hat and found all sorts of weird little problems. My preferred story was the Perl that RHE came with was bleeding edge (for the time of release) which at first looked nice. But when I discovered my FreeBSD laptop could parse a 500meg log file 4 times faster then the quad core RHE Dell server I know something was wrong. It was just the version Perl that RHE decided to package up the distribution with. I ended up having to build a later version into /usr/local and everything was fine. But is this really a good solution? Was this worthy of the word enterprise? absolutely not, I mean its not a big deal to build a second Perl into /usr/local on RHE but FreeBSD ports seems like a far cleaner and professional solution if you ask me, just because its not point and click friendly shouldn't be some kind of excuse, to me its and clean and pure as I could dream. We hired a person directly from Oracle full time to build a new database project on Oracle. After it was all built and been using it for about 2 years I just thought it was a bit of a disgrace. Oracle is brittle, unreliable and expensive. We had FreeBSD+MySQL along side it the whole time and it was just so much more reliable and faster for the same amount of hardware. Oracle by packaged design is meant to encourage a comparatively massive amount of hardware investment compared to what could be achieved with MySQL and FreeBSD. I think it is just as much about masking its crap performance then any other argument. I think Oracle is a about of system of making money out of false beliefs, it takes full advantage of corporate companies conservative beliefs and is probably only the reasonable solution for at best 5% of the companies it lives at, its all a matter of opinion which would be argued more from how much money a set of individuals are making out of it over a better technical solution. Some how Oracle want people to believe that a few 100's thousand dollars for their software is vastly superior to any other DB in the world is just nonsense. There is not any other mass scale pieces of software that most company's need where there is some how a magically vastly superior solution. There is no single/few license $100,000 operating system, no single/few license $100,000 excel, no single/few license $100,000 web server. I guess what I am saying at the end of this is that if you can avoid Oracle that is great, I fully recommend you do. Just because you can buy MySQL Enterprise Server far more cheaply and install/deploy it far more easily on more different platforms isn't something to be suspicious about, its just a better software solution and I recommend you take full advantage of it while you still can. ___ 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: why no Oracle on FreeBSD ?
On Thu, 24 Sep 2009, Julian H. Stacey wrote: i noticed that there is no Oracle available for FreeBSD http://www.oracle.com/technology/software/products/database/index.html What could be the reason for that ? Best ask direct of commercial application vendor Oracle. IE wave money under Oracle's nose ask to purchase what you want. If Oracle think there's enough profit in it, there's many BSD consultants eg http://berklix.com/consultants/ willing to work. Cheers, Julian -- i was wondering if there is any technical reason behind this ? Most unlikely. Ask Oracle tell advocacy@ what you find out. I'd bet perceived market share demand as ever, ie Money. Hi Julian: Here is the response on the Oracle forum thread to my posting, FreeBSD is a kernel not used in any extant operating system with the sole exception being Apple's Mac OSX so you are heading, full speed ahead, toward disappointment. FreeBSD handles many things very differently from the UNIX System 5 standard so you can not just kludge your way into this. What fascinates me about your request is why you care. FreeBSD is going nowhere at a staggeringly fast pace. And to the same place as went Oracle Database version 8.0. Obscurity. Install Oracle's Enterprise Linux and you will have a real operating system in less time than you've spent monitoring this thead. And as an additional value it will support the Oracle technology stack while you are still young enough to use it. and IF you can match up the system calls, then you can 'make it work'. The relevant links are 1. http://forums.oracle.com/forums/thread.jspa?threadID=952076tstart=0 2. http://forums.oracle.com/forums/thread.jspa?threadID=952076tstart=0 The response seems to suggest that there is some feature used by Oracle which is expected from a UNIX Sys 5 std and perhaps FreeBSD does not support/have the syscall. Given the response, What is your analysis of the situation ? thanks Saifi. ___ 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: why no Oracle on FreeBSD ?
2009/9/25 Saifi Khan saifi.k...@datasynergy.org On Thu, 24 Sep 2009, Julian H. Stacey wrote: i noticed that there is no Oracle available for FreeBSD http://www.oracle.com/technology/software/products/database/index.html What could be the reason for that ? Best ask direct of commercial application vendor Oracle. IE wave money under Oracle's nose ask to purchase what you want. If Oracle think there's enough profit in it, there's many BSD consultants eg http://berklix.com/consultants/ willing to work. Cheers, Julian -- i was wondering if there is any technical reason behind this ? Most unlikely. Ask Oracle tell advocacy@ what you find out. I'd bet perceived market share demand as ever, ie Money. Hi Julian: Here is the response on the Oracle forum thread to my posting, FreeBSD is a kernel not used in any extant operating system with the sole exception being Apple's Mac OSX so you are heading, full speed ahead, toward disappointment. FreeBSD handles many things very differently from the UNIX System 5 standard so you can not just kludge your way into this. What fascinates me about your request is why you care. FreeBSD is going nowhere at a staggeringly fast pace. And to the same place as went Oracle Database version 8.0. Obscurity. Install Oracle's Enterprise Linux and you will have a real operating system in less time than you've spent monitoring this thead. And as an additional value it will support the Oracle technology stack while you are still young enough to use it. and IF you can match up the system calls, then you can 'make it work'. The relevant links are 1. http://forums.oracle.com/forums/thread.jspa?threadID=952076tstart=0 2. http://forums.oracle.com/forums/thread.jspa?threadID=952076tstart=0 The response seems to suggest that there is some feature used by Oracle which is expected from a UNIX Sys 5 std and perhaps FreeBSD does not support/have the syscall. Given the response, What is your analysis of the situation ? thanks Saifi. ___ 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 I have seen a guide on howto get oracle to run on bsd, it did use linux compatibility though. I have to say though the reality of the situation is you are probably best running oracle on solaris with a zfs fs underneath it. Forget the wrongs and rights and what should bes, the reality is you will find everything easier from a comercial support point of view with that combination. ___ 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: why no Oracle on FreeBSD ?
Saifi Khan saifi.k...@datasynergy.org writes: The response seems to suggest [...] ...nothing except that whoever wrote it has absolutely no idea what they're talking about. DES -- Dag-Erling Smørgrav - d...@des.no ___ 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: why no Oracle on FreeBSD ?
Saifi Khan wrote: On Thu, 24 Sep 2009, Julian H. Stacey wrote: i noticed that there is no Oracle available for FreeBSD http://www.oracle.com/technology/software/products/database/index.html What could be the reason for that ? Best ask direct of commercial application vendor Oracle. IE wave money under Oracle's nose ask to purchase what you want. If Oracle think there's enough profit in it, there's many BSD consultants eg http://berklix.com/consultants/ willing to work. Cheers, Julian -- i was wondering if there is any technical reason behind this ? Most unlikely. Ask Oracle tell advocacy@ what you find out. I'd bet perceived market share demand as ever, ie Money. Hi Julian: Here is the response on the Oracle forum thread to my posting, FreeBSD is a kernel not used in any extant operating system with the sole exception being Apple's Mac OSX so you are heading, full speed ahead, toward disappointment. FreeBSD handles many things very differently from the UNIX System 5 standard so you can not just kludge your way into this. What fascinates me about your request is why you care. FreeBSD is going nowhere at a staggeringly fast pace. And to the same place as went Oracle Database version 8.0. Obscurity. Install Oracle's Enterprise Linux and you will have a real operating system in less time than you've spent monitoring this thead. And as an additional value it will support the Oracle technology stack while you are still young enough to use it. and IF you can match up the system calls, then you can 'make it work'. The relevant links are 1. http://forums.oracle.com/forums/thread.jspa?threadID=952076tstart=0 2. http://forums.oracle.com/forums/thread.jspa?threadID=952076tstart=0 The response seems to suggest that there is some feature used by Oracle which is expected from a UNIX Sys 5 std and perhaps FreeBSD does not support/have the syscall. Given the response, What is your analysis of the situation ? That whoever wrote that post is very closed minded, has no problem condemning something prior to investigation, and perhaps wears a pair of glasses that only come in one shade. It makes me very proud to be a member of this great community, where the attitude is more 'get the job done with whatever tool suits the task', as opposed to 'if you don't use this, then forget it'. I completely and utterly disagree with the claims made in that post. I've been using FreeBSD for nearly 10 years, and I vouch for the fact that FreeBSD has made huge strides during that time. Not only is the OS mature, but so are the people who write it, maintain it, and advocate it. Was about to add 'defend it' to the last sentence there, but it's not even necessary. FreeBSD's track record, and the fact that it's used in the most critical of infrastructures proves that FreeBSD merrily holds it's own water, without a word ever needing to be spoken. Steve smime.p7s Description: S/MIME Cryptographic Signature
Re: why no Oracle on FreeBSD ?
That whoever wrote that post is very closed minded, has no problem condemning something prior to investigation, and perhaps wears a pair of glasses that only come in one shade. Oracle is an expensive business application that is expected to be VERY reliable. It's expected to have a high end support infrastructure behind it. This is why they limit the number of operating systems to a very specific few, that are backed by companies with a reputation. I'm not vouching for them, but most businesses aren't looking to plunk down $50,000 or $100,000 for a database product for their mission critical application, and run it on something that lacks a commercial support infrastructure behind it. RedHat is the only reason linux has gotten as far as it has in the heavy business and gov't world. I completely and utterly disagree with the claims made in that post. I've been using FreeBSD for nearly 10 years, and I vouch for the fact that FreeBSD has made huge strides during that time. Not only is the OS mature, but so are the people who write it, maintain it, and advocate it. While it has, it's still lagging. I can't even get a decent shell from the FreeBSD install CD or boot CD. If the installer fails at getting the first package, after you re-enter the information to try again, it seems to pick up on package #2, skipping the first, which is probably the kernel. I took a hiatus(sp) from FreeBSD and when I came back after spending a bunch of time in the Linux world, I noticed some pretty sore things. I'm not hating on BSD, I'm still kind of meh about Linux, but I can see why companies do what they do. A small firm webhosting stuff with MySQL is one thing. Large corporations running mission critical databases is another. I assume Oracle goes through heavy lengths to certify their product on the few OSes they officially support. Probably Solaris, Redhat and their own Linux distro. This is a huge deal to them. Think of it as an appliance. If you hate Linux, help Solaris. Run your oracle on your Solaris system, and hit it from your FreeBSD system. I'd be willing to bet there is little to no commercial demand for Oracle on FreeBSD. Heck, look at all the SGI went through with Oracle, and the rumors were that Oracle ran faster than any other platform on IRIX for a while. Oracle wouldn't release it, maybe becuase Ellison and McNealy are BFF or something. ___ 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: why no Oracle on FreeBSD ?
oops. After replying to all, I noticed that this thread is cross-posted to both freebsd-questions and freebsd-advocacy. (Although I removed advocacy from this reply.) fyi ___ 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: why no Oracle on FreeBSD ?
On Fri, Sep 25, 2009 at 9:28 AM, telmn...@757.org wrote: That whoever wrote that post is very closed minded, has no problem condemning something prior to investigation, and perhaps wears a pair of glasses that only come in one shade. Oracle is an expensive business application that is expected to be VERY reliable. It's expected to have a high end support infrastructure behind it. This is why they limit the number of operating systems to a very specific few, that are backed by companies with a reputation. I'm not vouching for them, but most businesses aren't looking to plunk down $50,000 or $100,000 for a database product for their mission critical application, and run it on something that lacks a commercial support infrastructure behind it. RedHat is the only reason linux has gotten as far as it has in the heavy business and gov't world. I completely and utterly disagree with the claims made in that post. I've been using FreeBSD for nearly 10 years, and I vouch for the fact that FreeBSD has made huge strides during that time. Not only is the OS mature, but so are the people who write it, maintain it, and advocate it. While it has, it's still lagging. I can't even get a decent shell from the FreeBSD install CD or boot CD. If the installer fails at getting the first package, after you re-enter the information to try again, it seems to pick up on package #2, skipping the first, which is probably the kernel. I took a hiatus(sp) from FreeBSD and when I came back after spending a bunch of time in the Linux world, I noticed some pretty sore things. I'm not hating on BSD, I'm still kind of meh about Linux, but I can see why companies do what they do. A small firm webhosting stuff with MySQL is one thing. Large corporations running mission critical databases is another. I assume Oracle goes through heavy lengths to certify their product on the few OSes they officially support. Probably Solaris, Redhat and their own Linux distro. This is a huge deal to them. Think of it as an appliance. If you hate Linux, help Solaris. Run your oracle on your Solaris system, and hit it from your FreeBSD system. I'd be willing to bet there is little to no commercial demand for Oracle on FreeBSD. Heck, look at all the SGI went through with Oracle, and the rumors were that Oracle ran faster than any other platform on IRIX for a while. Oracle wouldn't release it, maybe becuase Ellison and McNealy are BFF or something. ...and this, of course, brings us to the purchase of Sun Microsystems by Oracle. Expect Oracle to put a lot of emphasis on Solaris in the future. ___ 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: why no Oracle on FreeBSD ?
Dag-Erling Smørgrav a écrit : Saifi Khan saifi.k...@datasynergy.org writes: The response seems to suggest [...] ...nothing except that whoever wrote it has absolutely no idea what they're talking about. DES I know that the question was about native FreeBSD port but did someone tried / used Oracle on top of Linux binary Emulation? http://www.freebsd.org/doc/en_US.ISO8859-1/books/handbook/linuxemu-oracle.html I was just wondering about limitations and performance issues using that way... ___ 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: why no Oracle on FreeBSD ?
On Fri, Sep 25, 2009 at 10:28:20AM -0400, telmn...@757.org wrote: I'd be willing to bet there is little to no commercial demand for Oracle on FreeBSD. I wonder how much difference Oracle availability on FreeBSD would make, here. -- Chad Perrin [ original content licensed OWL: http://owl.apotheon.org ] pgpgCxfAEQFzK.pgp Description: PGP signature
Client oracle for FreeBSD 5.4!
I need to connect in a server of data base oracle 9i through the FreeBSD. Exists one client oracle for the FreeBSD? How I can make? Thank you! Daniel Bitencourt Cadorin ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: Client oracle for FreeBSD 5.4!
On 30 Aug 2006, at 21:15, Daniel Bitencourt Cadorin wrote: I need to connect in a server of data base oracle 9i through the FreeBSD. Exists one client oracle for the FreeBSD? How I can make? Thank you! Daniel Bitencourt Cadorin Hi Theres some info here you might find useful: http://tomclegg.net/oracle9i-bsd5 Other info about oracle client here aswell. Good luck. Eoghan ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: oracle on freeBSD
On 6 Jan 2006, at 20:40, Ceri Davies wrote: On 4 Jan 2006, at 18:59, eoghan wrote: Hello Im wondering if there is any info on getting oracle running on freeBSD (im using 6.0). I have found this: http://www.scc.nl/~marcel/howto-oracle.html But it seems a little dated. I read oracle doesnt officially support freeBSD and was pointed to a link here of people working with it: http://twister.pp.ru/ora-fbsd I dont speak russian, but is this no longer being continued? Also, by oracle, I mean the database. i realise they have many products... Any info would help... In my opinion, the best online how-to for this by far is the one at http://www.shadowcom.net/freebsd-oracle9i/ - I intend to produce something for the handbook once I get the time, but if you follow the instructions there you will not go far wrong. On metalink yesterday I noticed that Intel FreeBSD appears in the list of operating systems when you raise a TAR (whoops, I mean SR these days), so perhaps they will support it if you pay them enough, I don't know. Ceri HI Ceri Thanks for the link... Im having issues with the install of emulators/ linux_base... doesnt like linux-XFree86-libs-4.3.99.902_4 Not sure if this lib does the same in terms of linux gcc etc? I did read that the 10g install goes a whole lot smoother than the 9i... havent had a chance to really dive into the install yet though... Eoghan ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: oracle on freeBSD
On Sat, Jan 07, 2006 at 06:29:15PM +, eoghan wrote: On 6 Jan 2006, at 20:40, Ceri Davies wrote: On 4 Jan 2006, at 18:59, eoghan wrote: Hello Im wondering if there is any info on getting oracle running on freeBSD (im using 6.0). I have found this: http://www.scc.nl/~marcel/howto-oracle.html But it seems a little dated. I read oracle doesnt officially support freeBSD and was pointed to a link here of people working with it: http://twister.pp.ru/ora-fbsd I dont speak russian, but is this no longer being continued? Also, by oracle, I mean the database. i realise they have many products... Any info would help... In my opinion, the best online how-to for this by far is the one at http://www.shadowcom.net/freebsd-oracle9i/ - I intend to produce something for the handbook once I get the time, but if you follow the instructions there you will not go far wrong. On metalink yesterday I noticed that Intel FreeBSD appears in the list of operating systems when you raise a TAR (whoops, I mean SR these days), so perhaps they will support it if you pay them enough, I don't know. HI Ceri Thanks for the link... Im having issues with the install of emulators/ linux_base... doesnt like linux-XFree86-libs-4.3.99.902_4 Not sure if this lib does the same in terms of linux gcc etc? I did read that the 10g install goes a whole lot smoother than the 9i... havent had a chance to really dive into the install yet though... Hi Eoghan, Try linux_base-8 instead. I think that may be better for more recent FreeBSD's. I haven't tried the 10g install on FreeBSD, but I have done a few installations on Solaris and I can tell you that the major problem with the 10g installer is that it installs 10g, which I'm running into a few problems with. That may well be my fault due to some unfamiliarity with the new version, but since the 9i desupport date has been pushed back to 2010 I'm still using that where I can. Ceri -- Only two things are infinite, the universe and human stupidity, and I'm not sure about the former.-- Einstein (attrib.) pgpW9LEP2vFcF.pgp Description: PGP signature
Re: oracle on freeBSD
On 4 Jan 2006, at 18:59, eoghan wrote: Hello Im wondering if there is any info on getting oracle running on freeBSD (im using 6.0). I have found this: http://www.scc.nl/~marcel/howto-oracle.html But it seems a little dated. I read oracle doesnt officially support freeBSD and was pointed to a link here of people working with it: http://twister.pp.ru/ora-fbsd I dont speak russian, but is this no longer being continued? Also, by oracle, I mean the database. i realise they have many products... Any info would help... In my opinion, the best online how-to for this by far is the one at http://www.shadowcom.net/freebsd-oracle9i/ - I intend to produce something for the handbook once I get the time, but if you follow the instructions there you will not go far wrong. On metalink yesterday I noticed that Intel FreeBSD appears in the list of operating systems when you raise a TAR (whoops, I mean SR these days), so perhaps they will support it if you pay them enough, I don't know. Ceri ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
oracle on freeBSD
Hello Im wondering if there is any info on getting oracle running on freeBSD (im using 6.0). I have found this: http://www.scc.nl/~marcel/howto-oracle.html But it seems a little dated. I read oracle doesnt officially support freeBSD and was pointed to a link here of people working with it: http://twister.pp.ru/ora-fbsd I dont speak russian, but is this no longer being continued? Also, by oracle, I mean the database. i realise they have many products... Any info would help... Thanks Eoghan ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: oracle on freeBSD
Hello eoghan, Wednesday, January 4, 2006, 7:59:44 PM, you wrote: Hello Im wondering if there is any info on getting oracle running on freeBSD (im using 6.0). I have found this: we have a section in handbook about setting up oracle, but it's outdated now, though there are some people reporting it's still possible to get latest versions of oracle running on FreeBSD. check the handbook and try it yourself, you will need to set up a linux compatibility for that. also, if you get it running, could you please write some howto, so we can update the handbook? (doesn't need to be in sgml markup, we will make it by ourselves) http://www.scc.nl/~marcel/howto-oracle.html But it seems a little dated. I read oracle doesnt officially support freeBSD and was pointed to a link here of people working with it: http://twister.pp.ru/ora-fbsd I dont speak russian, but is this no longer being continued? Also, by oracle, I mean the database. i realise they have many products... Any info would help... Thanks Eoghan -- Best regards, Danielmailto:[EMAIL PROTECTED] ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: oracle on freeBSD
On 4 Jan 2006, at 20:09, Daniel Gerzo wrote: Hello eoghan, Wednesday, January 4, 2006, 7:59:44 PM, you wrote: Hello Im wondering if there is any info on getting oracle running on freeBSD (im using 6.0). I have found this: we have a section in handbook about setting up oracle, but it's outdated now, though there are some people reporting it's still possible to get latest versions of oracle running on FreeBSD. check the handbook and try it yourself, you will need to set up a linux compatibility for that. Hi Daniel Yes I actually got that after i sent it although it appears to be the same as the link i sent below. also, if you get it running, could you please write some howto, so we can update the handbook? (doesn't need to be in sgml markup, we will make it by ourselves) I will have a go with it and the latest release. I was going to wait till I upgrade my box. Not sure my system will run it efficiently... Having said that, I will give it a go over the next few days and let you know how it goes. http://www.scc.nl/~marcel/howto-oracle.html But it seems a little dated. I read oracle doesnt officially support freeBSD and was pointed to a link here of people working with it: http://twister.pp.ru/ora-fbsd I dont speak russian, but is this no longer being continued? Also, by oracle, I mean the database. i realise they have many products... Any info would help... Thanks Eoghan -- Best regards, Danielmailto:[EMAIL PROTECTED] ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re[2]: oracle on freeBSD
Hello eoghan, Wednesday, January 4, 2006, 10:16:40 PM, you wrote: On 4 Jan 2006, at 20:09, Daniel Gerzo wrote: Hello eoghan, Wednesday, January 4, 2006, 7:59:44 PM, you wrote: Hello Im wondering if there is any info on getting oracle running on freeBSD (im using 6.0). I have found this: we have a section in handbook about setting up oracle, but it's outdated now, though there are some people reporting it's still possible to get latest versions of oracle running on FreeBSD. check the handbook and try it yourself, you will need to set up a linux compatibility for that. Hi Daniel Yes I actually got that after i sent it although it appears to be the same as the link i sent below. also, if you get it running, could you please write some howto, so we can update the handbook? (doesn't need to be in sgml markup, we will make it by ourselves) I will have a go with it and the latest release. I was going to wait till I upgrade my box. Not sure my system will run it efficiently... Having said that, I will give it a go over the next few days and let you know how it goes. that would be really nice, i wish you luck ;) http://www.scc.nl/~marcel/howto-oracle.html But it seems a little dated. I read oracle doesnt officially support freeBSD and was pointed to a link here of people working with it: http://twister.pp.ru/ora-fbsd I dont speak russian, but is this no longer being continued? Also, by oracle, I mean the database. i realise they have many products... Any info would help... Thanks Eoghan -- Cheers, Danielmailto:[EMAIL PROTECTED] ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
TOra - Toolkit For Oracle on freebsd 5.3
Hi Guys, I need a front end client to access Oracle databases on my network. I came across TOra. There is a linux version but not a bsd one. heh. Ummm, has anyone installed TOra on freebsd? If so, is there a How-to-guide somewhere? Or does anyone know of a good front end client to access Oracle databases from freebsd? Cheers Thanks in advance. ps: im not on the list, may you please cc me. Find local movie times and trailers on Yahoo! Movies. http://au.movies.yahoo.com ___ [EMAIL PROTECTED] mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to [EMAIL PROTECTED]
Re: Oracle on FreeBSD
The most notable of these would be date/time and null handling. Also
parameter binding. One big one you'll hit with Oracle is trying to insert a
string 2000 characters with ODBC into a LONG column.
another i.e.
ORACLE to_date('2003/01/03' '12:05:03 A.M.')
MSSQL 2003/01/03' '12:05:03
MySQL 2003-01-03 00:05:03
Oracle will also run queries with unbound parameters if you forget one and
just return nothing or cause an infinite loop. MSSQL not only won't but let
you mix parameter styles if you bind some of them and not others.
Joing tables you'll also find is different. (+)= vs *= in ORACLE vs MSSQL
Concat tables -- || in Oracle, I forget MSSQL of the top of my head.
Finally, you can't have conncurrent database handle access in I think anything
other then ORACLE.
There is a way to get around all these and thats to wrap all your database
calls in wrappers in addition to the ODBC connect/dissconect calls.
You will have to make multiple passes.
I've been successful with this so that I can reliably run MySQL-4.1 (sub
selects), MSSQL, Oracle 8.1.7 and probably 9i.
Of course you'll never really get the sequences right unless you just use an
Ids table, but that throws away some maybe functionality on MySQL and Oracle
so you need another wrapper for. DBIx::OracleSequencer from CPAN is a good
module... don't get me wrong, but its much easier to just write out select
$seq\.nextval from dual ... Then you don't have to worry about commenting it
out on systems that don't have it or eval(). Just an if around the my $sql
= whatever.
On Tuesday 25 February 2003 19:09, Bill Moran wrote:
The whole ODBC compatiblity thing is (unfortunately) a lie. Nobody has
stood up and constrained the standard enought to make it truely compatible
across all databases.
--
END
--
Philip M. Gollucci [EMAIL PROTECTED] 301.474.9294 301.646.3011 (cell)
Science, Discovery, the Universe (UMCP)
Webmaster Webship Teacher
URL: http://www.sdu.umd.edu
eJournalPress
Database/PERL Programmer System Admin
URL : http://www.ejournalpress.com
Resume : http://p6m7g8.net/Resume
To Unsubscribe: send mail to [EMAIL PROTECTED]
with unsubscribe freebsd-questions in the body of the message
Re: Oracle on FreeBSD
In [EMAIL PROTECTED], Trent Nelson [EMAIL PROTECTED] typed: On Tue, Feb 25, 2003 at 10:12:52AM -0600, Mike Meyer wrote: In [EMAIL PROTECTED], Trent Nelson [EMAIL PROTECTED] typed: I'm interested in seeing how well something like PostgreSQL can be used as a ``drop-in'' replacement for Oracle. If I have clients connecting via ODBC (Rational ClearQuest), I personally couldn't care what the underlying database is. Now *that* is something I'd be interested in seeing a write up for. It's not a drop-in replacement. You have to install the PostgreSQL ODBC drivers on all the clients. Any client-side scripts will have to be changed to use a PostgreSQL wrappers instead of Oracle wrappers. The SQL is probably subtly different as well. SQL may be a standard, but you still get locked into the databases that you can query with it. Perhaps I should have been more specific. I'm interested in how far you can get (i.e. what queries will work, what ones won't) before you reach a complete road-block. That requires in-depth knowledge of both systems, which I try to avoid having. I try to write plain-jane SQL so it will work on anything, or use standardized wrappers that are available for a number of databases. With regards to ODBC, changing the driver being used by the application's '*odbc.ini' configuration fi- le is sufficient for modifying the database being interfaced to, is it not? i.e. the application simply calls standard ODBC functions which the individual database drivers implement. Right. Having to do it on every client means I won't call it a drop-in replacement. Drop-ins should be transparent to the clients. mike -- Mike Meyer [EMAIL PROTECTED] http://www.mired.org/consulting.html Independent WWW/Perforce/FreeBSD/Unix consultant, email for more information. To Unsubscribe: send mail to [EMAIL PROTECTED] with unsubscribe freebsd-questions in the body of the message
Re: Oracle on FreeBSD
On Tue, Feb 25, 2003 at 10:12:52AM -0600, Mike Meyer wrote: In [EMAIL PROTECTED], Trent Nelson [EMAIL PROTECTED] typed: I'm interested in seeing how well something like PostgreSQL can be used as a ``drop-in'' replacement for Oracle. If I have clients connecting via ODBC (Rational ClearQuest), I personally couldn't care what the underlying database is. Now *that* is something I'd be interested in seeing a write up for. It's not a drop-in replacement. You have to install the PostgreSQL ODBC drivers on all the clients. Any client-side scripts will have to be changed to use a PostgreSQL wrappers instead of Oracle wrappers. The SQL is probably subtly different as well. SQL may be a standard, but you still get locked into the databases that you can query with it. Perhaps I should have been more specific. I'm interested in how far you can get (i.e. what queries will work, what ones won't) before you reach a complete road-block. With regards to ODBC, changing the driver being used by the application's '*odbc.ini' configuration fi- le is sufficient for modifying the database being interfaced to, is it not? i.e. the application simply calls standard ODBC functions which the individual database drivers implement. Trent. To Unsubscribe: send mail to [EMAIL PROTECTED] with unsubscribe freebsd-questions in the body of the message
Re: Oracle on FreeBSD
Trent Nelson wrote: On Tue, Feb 25, 2003 at 10:12:52AM -0600, Mike Meyer wrote: In [EMAIL PROTECTED], Trent Nelson [EMAIL PROTECTED] typed: I'm interested in seeing how well something like PostgreSQL can be used as a ``drop-in'' replacement for Oracle. If I have clients connecting via ODBC (Rational ClearQuest), I personally couldn't care what the underlying database is. Now *that* is something I'd be interested in seeing a write up for. It's not a drop-in replacement. You have to install the PostgreSQL ODBC drivers on all the clients. Any client-side scripts will have to be changed to use a PostgreSQL wrappers instead of Oracle wrappers. The SQL is probably subtly different as well. SQL may be a standard, but you still get locked into the databases that you can query with it. Perhaps I should have been more specific. I'm interested in how far you can get (i.e. what queries will work, what ones won't) before you reach a complete road-block. With regards to ODBC, changing the driver being used by the application's '*odbc.ini' configuration fi- le is sufficient for modifying the database being interfaced to, is it not? i.e. the application simply calls standard ODBC functions which the individual database drivers implement. It depends on how the application is written. One of the standard ODBC functions available is an SQL passthru, which basically lets the application talk directly to the SQL server it the SQL server's native dialect of SQL. If the application uses this ability, it probably won't work at all. Additionally, there are different levels of ODBC compatibility, if your application requires a certain level, and the PostgreSQL ODBC driver doesn't support it, you're out of luck again. Not to say that there isn't a possibility that it will work, just that it's not a terribly simple question to answer. The whole ODBC compatiblity thing is (unfortunately) a lie. Nobody has stood up and constrained the standard enought to make it truely compatible across all databases. -- Bill Moran Potential Technologies http://www.potentialtech.com To Unsubscribe: send mail to [EMAIL PROTECTED] with unsubscribe freebsd-questions in the body of the message
Re: Oracle on FreeBSD
In [EMAIL PROTECTED], Trent Nelson [EMAIL PROTECTED] typed: I'm interested in seeing how well something like PostgreSQL can be used as a ``drop-in'' replacement for Oracle. If I have clients connecting via ODBC (Rational ClearQuest), I personally couldn't care what the underlying database is. Now *that* is something I'd be interested in seeing a write up for. It's not a drop-in replacement. You have to install the PostgreSQL ODBC drivers on all the clients. Any client-side scripts will have to be changed to use a PostgreSQL wrappers instead of Oracle wrappers. The SQL is probably subtly different as well. SQL may be a standard, but you still get locked into the databases that you can query with it. mike -- Mike Meyer [EMAIL PROTECTED] http://www.mired.org/consulting.html Independent WWW/Perforce/FreeBSD/Unix consultant, email for more information. To Unsubscribe: send mail to [EMAIL PROTECTED] with unsubscribe freebsd-questions in the body of the message
Oracle on FreeBSD
Can you run Oracle on FreeBSD? So far I've found some information on installing Oracle using Linux emulation but nothing about running it in native mode. Also, if any of you feel that running Oracle on FreeBSD is a bad idea let me know. To Unsubscribe: send mail to [EMAIL PROTECTED] with unsubscribe freebsd-questions in the body of the message
Re: Oracle on FreeBSD
it's not a bad idea, it'd be great if oracle created a port for bsd, but they didn't and most likely won't. you can't run in in native mode, because ... well... it's bsd, not linux. i don't think you'll have issues with emulation mode,. except for performance, which could be pretty big. I suggest just stick with linux for oracle. On Mon, 24 Feb 2003, Damien Hull wrote: Can you run Oracle on FreeBSD? So far I've found some information on installing Oracle using Linux emulation but nothing about running it in native mode. Also, if any of you feel that running Oracle on FreeBSD is a bad idea let me know. To Unsubscribe: send mail to [EMAIL PROTECTED] with unsubscribe freebsd-questions in the body of the message To Unsubscribe: send mail to [EMAIL PROTECTED] with unsubscribe freebsd-questions in the body of the message
Re: Oracle on FreeBSD
At 2003-02-24T23:18:47Z, Damien Hull [EMAIL PROTECTED] writes: Also, if any of you feel that running Oracle on FreeBSD is a bad idea let me know. One question: does Oracle support running on FreeBSD? If not, then it's a bad idea; the first tech support call that ends as soon as they find out you're not running a sanctioned system will easily cost more than the additional effort to administer a Linux box. -- Kirk Strauser In Googlis non est, ergo non est. pgp0.pgp Description: PGP signature
Re: Oracle on FreeBSD
I've also notice that the FAQ on the FreeBSD site is for 3.2 and ORALCE 7 Aren't we on oracle 9i and FreeBSD 5.0 ? Since I have to do this so that I can test things locally, I wouldn't mind doing a web write up for the FreeBSD docs unless someone else is already working on this ? On Tuesday 25 February 2003 04:00, synrat wrote: it's not a bad idea, it'd be great if oracle created a port for bsd, but they didn't and most likely won't. you can't run in in native mode, because ... well... it's bsd, not linux. i don't think you'll have issues with emulation mode,. except for performance, which could be pretty big. I suggest just stick with linux for oracle. On Mon, 24 Feb 2003, Damien Hull wrote: Can you run Oracle on FreeBSD? So far I've found some information on installing Oracle using Linux emulation but nothing about running it in native mode. Also, if any of you feel that running Oracle on FreeBSD is a bad idea let me know. To Unsubscribe: send mail to [EMAIL PROTECTED] with unsubscribe freebsd-questions in the body of the message To Unsubscribe: send mail to [EMAIL PROTECTED] with unsubscribe freebsd-questions in the body of the message -- END -- Philip M. Gollucci [EMAIL PROTECTED] 301.474.9294 301.646.3011 (cell) Science, Discovery, the Universe (UMCP) Webmaster Webship Teacher URL: http://www.sdu.umd.edu eJournalPress Database/PERL Programmer System Admin URL : http://www.ejournalpress.com Resume : http://p6m7g8.net/Resume To Unsubscribe: send mail to [EMAIL PROTECTED] with unsubscribe freebsd-questions in the body of the message
