Thread: off-topic: (sorta) freebsd -> oracle, lightweight
i need to query some oracle tables from a freebsd system. is there a lightweight method to do this, or do i have no choice but to put in the Oracle Linux stuff and use their API's? -- [ Jim Mercer jim@reptiles.org +1 416 410-5633 ] [ Reptilian Research -- Longer Life through Colder Blood ] [ Don't be fooled by cheap Finnish imitations; BSD is the One True Code. ]
I think it's against the Oracle license to run it under any kind of emulation (which is what you would have to do with FreeBSD, run it under Linux emulation).. All that's void if they support FreeBSD natively now (which I don't think they do).. Wouldn't this be a better question for an Oracle list since this has nothing to do with PostgreSQL? (Just a friendly suggestion) :-) Good luck!! -Mitch ----- Original Message ----- From: "Jim Mercer" <jim@reptiles.org> To: <hackers@postgresql.org> Sent: Monday, October 02, 2000 12:43 PM Subject: [HACKERS] off-topic: (sorta) freebsd -> oracle, lightweight > > i need to query some oracle tables from a freebsd system. > > is there a lightweight method to do this, or do i have no choice but to > put in the Oracle Linux stuff and use their API's? > > -- > [ Jim Mercer jim@reptiles.org +1 416 410-5633 ] > [ Reptilian Research -- Longer Life through Colder ] > [ Don't be fooled by cheap Finnish imitations; BSD is the One True ode. ] >
I have absolutely no idea how well it works, but I think Perl/DBI has a "pass thru" module that can do this sort of thing... not sure if that helps much... -philip On Mon, 2 Oct 2000, Jim Mercer wrote: > > i need to query some oracle tables from a freebsd system. > > is there a lightweight method to do this, or do i have no choice but to > put in the Oracle Linux stuff and use their API's? > > -- > [ Jim Mercer jim@reptiles.org +1 416 410-5633 ] > [ Reptilian Research -- Longer Life through Colder Blood ] > [ Don't be fooled by cheap Finnish imitations; BSD is the One True Code. ] >
At 03:43 PM 10/2/00 -0400, Jim Mercer wrote: > >i need to query some oracle tables from a freebsd system. > >is there a lightweight method to do this, or do i have no choice but to >put in the Oracle Linux stuff and use their API's? Oracle knows ODBC, no? - Don Baccus, Portland OR <dhogaza@pacifier.com> Nature photos, on-line guides, Pacific Northwest Rare Bird Alert Serviceand other goodies at http://donb.photo.net.
He can use DBD::Proxy over DBI as he can use ODBC through network; but at the end, he still has to have a box where he can install oracle drivers (which are binaries, and requier you to launch oracle java installer, as if you were going to install the whole beast, then to choose to only install a client machine). Well, Jim, you've got plenty of choices: NT, Linux, Solaris, AIX, Sco... maybe a few others. But the only free OS seems to be Linux. Maybe you should take a cheap intel PC and install linux + oracle client library on it. Regards Fabrice Scemama Philip Hallstrom wrote: > > I have absolutely no idea how well it works, but I think Perl/DBI has a > "pass thru" module that can do this sort of thing... > > not sure if that helps much... > > -philip > > On Mon, 2 Oct 2000, Jim Mercer wrote: > > > > > i need to query some oracle tables from a freebsd system. > > > > is there a lightweight method to do this, or do i have no choice but to > > put in the Oracle Linux stuff and use their API's? > > > > -- > > [ Jim Mercer jim@reptiles.org +1 416 410-5633 ] > > [ Reptilian Research -- Longer Life through Colder Blood ] > > [ Don't be fooled by cheap Finnish imitations; BSD is the One True Code. ] > > -- "La veritable et sincere amitie' verbale profondement superficielle est celle sur laquelle on peut absolument compter quand on n'a strictement besoin de rien." -- Pierre Dac
The linux version of Oracle works pretty good on FreeBSD (not suggested if it's going to be a heavy hit database box), then again, I don't suggest the Linux version of Oracle for that anyway. Linux compat from -stable is required. Send your emails off to Oracle requesting the FreeBSD native version (I understand theres one in creation) and in a few months (year?) we'll all be happy. Problem (or solution) is that by that time Postgres will fill all my requirements so I probably wouldn't switch until load or brand name becomes a serious concern. Fabrice Scemama wrote: > > He can use DBD::Proxy over DBI as he can use ODBC through > network; but at the end, he still has to have a box where > he can install oracle drivers (which are binaries, and > requier you to launch oracle java installer, as if you > were going to install the whole beast, then to choose > to only install a client machine). > > Well, Jim, you've got plenty of choices: NT, Linux, > Solaris, AIX, Sco... maybe a few others. But the only > free OS seems to be Linux. Maybe you should take a > cheap intel PC and install linux + oracle client library > on it. > > Regards > Fabrice Scemama > > Philip Hallstrom wrote: > > > > I have absolutely no idea how well it works, but I think Perl/DBI has a > > "pass thru" module that can do this sort of thing... > > > > not sure if that helps much... > > > > -philip > > > > On Mon, 2 Oct 2000, Jim Mercer wrote: > > > > > > > > i need to query some oracle tables from a freebsd system. > > > > > > is there a lightweight method to do this, or do i have no choice but to > > > put in the Oracle Linux stuff and use their API's? > > > > > > -- > > > [ Jim Mercer jim@reptiles.org +1 416 410-5633 ] > > > [ Reptilian Research -- Longer Life through Colder Blood ] > > > [ Don't be fooled by cheap Finnish imitations; BSD is the One True Code. ] > > > > > -- > "La veritable et sincere amitie' verbale profondement superficielle > est celle sur laquelle on peut absolument compter quand on n'a > strictement besoin de rien." -- Pierre Dac -- Rod Taylor "People get annoyed when you try to debug them." -- Larry Wall, 2nd State of the Onion. "A + B + C = Success if, A = Hard Work, B = Hard Play, C = Keeping your mouth shut." -- Albert Einstein --