Slashdot Mirror


Oracle 9i Makes it to Mac OS X

mcockerill writes "Oracle just posted a development version of their latest RDBMS (Oracle 9i release 2) for Mac OS X (300+megs of it). It requires Jaguar to run. No fancy installation wizards or GUI config apps as yet; the whole thing is command line only for now. But still, this is a major development as far as serious use of Mac OS X in a server environment is concerned. It's long been rumored to be on the way -- after all, Ellison is on Apple's Board -- but frankly I never thought I'd see the day."

50 comments

  1. Saw this comming... by Quicksilver31337 · · Score: 4, Informative

    If you have the a dev release of 10.2 there is a ODBC control app in the utilities folder, likey implemented with this in mind.

    However as of now it seems to lack any drivers.

    --
    _______
    Death wish, n.:

    The only wish that always comes true, whether or not one wishes it t
  2. Jaguar? by zmalone · · Score: 1
    Interesting that it only supports X.2. I would expect it to support older versions, as I was under the impression that X.2 mostly did stuff to the UI, but if there is no backwards compatibility for a CLI application, maybe that did some other things.

    Anyone tried installing on an older X system?

    1. Re:Jaguar? by Anonymous Coward · · Score: 0

      the used a new BSD kernel and updated GCC. I am assuming it compiles using GCC, so they probably made it compatible with 3.1 .

    2. Re:Jaguar? by tyrione · · Score: 1

      They don't use a new BSD Kernel. They've updated the Mach Microkernel and BSD Filesystem Layers along with the GCC 3.1, amongst many other changes.

    3. Re:Jaguar? by Anonymous Coward · · Score: 0

      The ENTIRE BSD system was updated. It used to be composed of FreeBSD 3.2, NetBSDx.x, and of course, Apples own changes which is known as Darwin. MacOS X 10.2 is now 'roughly' FreeBSD 4.4. It is amazing that so little code has broken between 10.1 and 10.2.

    4. Re:Jaguar? by alispguru · · Score: 2

      I was under the impression that X.2 mostly did stuff to the UI, ...

      Mostly, but a fair amount of stuff is also happening at the Darwin/BSD level. One thing I know about in particular is that BSD-style signal handling is supposed to be in 10.2, which might allow porting of CMUCL (a kick-ass free-as-in-beer Common Lisp) with minimal pain and suffering.
      --

      To a Lisp hacker, XML is S-expressions in drag.
    5. Re:Jaguar? by Fished · · Score: 1

      For what it's worth, I've noticed a considerable improvement in filesystem speed from X.1 to X.2. Pop-pop used to take about 5-10 seconds to load up it's data files on my TiBook, now loads in about 2.

      --
      "He who would learn astronomy, and other recondite arts, let him go elsewhere. " -- John Calvin, commenting on Genesis 1
    6. Re:Jaguar? by AndyAMPohl · · Score: 0

      The recently released MATLAB also has problems but instead the other way around. Mathworks says it works on 10.1.4 but not 10.2 yet and says to wait to upgrade to Jaguar until late Sept when a patch is available (depending on how important MATLAB is to you personally versus Jaguar, of course).

    7. Re:Jaguar? by Max+Webster · · Score: 1

      If you install on 10.1.5, it gives an error about a missing symbol _localtime_r the first time it runs sqlplus (which is fairly early during database creation). Also the shell scripts use bash by default, although syntactically they seem to do OK when run under sh.

    8. Re:Jaguar? by Anonymous Coward · · Score: 0

      It works only with latest Jaguar release. It won't
      work with 10.1.x release. BTW, Oracle has a
      new discussion forum on their OTN site specifically to discuss Oracle on Apple issue.
      http://otn.oracle.com/forums/.

  3. Database Hardware by Null_Packet · · Score: 2

    Beyond the argument of XServer speed, there will soon be the requirement for SCSI drives for the XServe. IDE just doesn't cut it under decent loads. If I were to build an Oracle 9i server today on an OSX Server, I'd add a RAID card and an external storage array. I personally would love to see Apple offer this equipment, but surely sales #'s will have to go up for the XServe.

    My question is, I wonder who Apple/Oracle think the target market is for the combo?

    1. Re:Database Hardware by foobar104 · · Score: 5, Informative

      Beyond the argument of XServer speed, there will soon be the requirement for SCSI drives for the XServe. IDE just doesn't cut it under decent loads.

      There's zero reason to put SCSI drives inside an Xserve. You're not doing any IO-bound tasks on the root drive anyway. If you need IO performance, you use an external Fibre Channel JBOD or RAID. (Internal RAID card? What's the point? Software RAID costs less and performs the same. If you really need performance, you use a hardware RAID controller.)

      I personally would love to see Apple offer this equipment, but surely sales #'s will have to go up for the XServe..

      Like, oh I don't know, Xserve RAID, maybe?

      (Can't find a picture of Xserve RAID on Apple's site, since it hasn't been released yet. But if you saw or attended the Xserve roll-out, you've seen it. It's a 2 Gb storage system with dual RAID controllers and 1.6 TB of capacity per disk chassis.)

    2. Re:Database Hardware by fieldmouse · · Score: 1

      My question is, I wonder who Apple/Oracle think the target market is for the combo?

      I think they're targeting the sciences and education markets where Apple already has a market presence. (Dare I say "decent market presence"?)

    3. Re:Database Hardware by jbolden · · Score: 1

      I have no particular insight so YMMV:

      To get stuff Oracle Developer Suite to work you need a native version of the database that can run in personal mode. Its almost no more work to create the server version (though not the enteprise version) than the personal version.

      Lots of developers are talking about how much they like the Mac environment; and Oracle wants them using Developer Suite. Given the fact that Oracle already supports lots of Unixs its not really that hard to get the server version to run on OSX. At least on their Windows version the whole interface is Javaish anyway so it doesn't look a tough port.

      So IMHO they are creating Oracle Server as a first step to Oracle Personal (which will get used) as a step towards Developer Suite.

    4. Re:Database Hardware by Anonymous Coward · · Score: 0

      Do you mean 2*TB* Array and not 2GB? 2Gigs is nothing these days.

    5. Re:Database Hardware by Masque · · Score: 1

      Two Gb bandwidth, 1.6TB storage. Please note the 'b' versus 'B'.

    6. Re:Database Hardware by drsmithy · · Score: 2, Interesting
      There's zero reason to put SCSI drives inside an Xserve. You're not doing any IO-bound tasks on the root drive anyway.

      I would propose to you that a significant number of customers could and would be performing some serious I/O on the ca. 150GB you could fit inside an Xserve with SCSI drives. Why spend extra on an external RAID chassis just to serve up some files to a few hundred users ?

      Software RAID costs less and performs the same.

      Unfortunately OS X's software RAID is pretty dismal. Unless it's improved markedly in 10.2.

      If you really need performance, you use a hardware RAID controller.

      Which is why they should have put an IDE RAID controller into the Xserve. Shit, it's not like a 4-channel 3ware card is particularly expensive, so an OEM on-the-board equivalent should have been par for the course.
      It's just another example of Apple only going halfway towards a great solution. Killing the floppy with the iMac was another (great that they killed it - absolutely stupid that they didn't *replace* it).

    7. Re:Database Hardware by foobar104 · · Score: 2

      Killing the floppy with the iMac was another (great that they killed it - absolutely stupid that they didn't *replace* it).

      You mean with a CDRW standard in all Macs? Yeah. Sucks that they didn't add that feature....

    8. Re:Database Hardware by King+Babar · · Score: 2
      Killing the floppy with the iMac was another (great that they killed it - absolutely stupid that they didn't *replace* it).

      You mean with a CDRW standard in all Macs? Yeah. Sucks that they didn't add that feature....

      What sucks is that it took them 3 years for writable CD media of any kind to be standard on all Macs. Seriously, the iMac dates from 1998, and I don't think CD-R(W) was stock on everything until last year. Actually, Jobs famously had to say "we screwed up on that" when analysts asked him what took them so long in getting writable optical media into their product lines. I've got an (otherwise quite nice) iMac DV SE that has a DVD-ROM drive...but no built-in CD burner. It really was a bizarre screw-up.

      To be frank, they really should stop shipping anything less than a combo drive (CD-RW/DVD) any minute now, and stop shipping anything less than a super drive (CD-RW/DVD-R(W?)) by next year.

      --

      Babar

    9. Re:Database Hardware by qnonsense · · Score: 0, Flamebait
      Two Gb bandwidth, 1.6TB storage. Please note the 'b' versus 'B'.
      • Gb is not a measurement of bandwidth. Gb/s is. Please note the 's' versus 'I'm an idiot.'
      --
      There comes a time in every man's life when he must say, "No mother! I do not want any more Jell-O!"
    10. Re:Database Hardware by maggard · · Score: 2
      Killing the floppy with the iMac was another (great that they killed it - absolutely stupid that they didn't *replace* it).

      They did replace the floppy - with networking. The iMac shipped with fast & easy networking built in, either via ethernet or dial-up. Thus between reading CD's and networking it's trvial to get material on & off of an iMac. Later iDisk was rolled out to make it even easier. Now that iMacs ship with CD burners standard it's plain trivial.

      For those that really have a burning need for a floppy drive then they either shouldn't get an iMac or need to budget for an external floppy drive/superdrive/whatever. However for the target iMac audience that wasn't an issue: Few of them had any collection of must-read floppies and those with knew what they were buying. Saddling the rest of us with a dusty drive port wasn't needed and yeah, lots of us never missed it.

      ps. I've a styrofoam cooler of Mac floppies in the basement, never needed to read any of them on the iMac. Ok, looked longingly at the "After Dark: Star Trek Edition" one once but then recalled how buggy AD was, didn't look back.

      --
      I don't read ACs: If a post isn't worth so much as a nom de plume to its author then I wont bother either.
    11. Re:Database Hardware by drsmithy · · Score: 1
      They did replace the floppy - with networking. The iMac shipped with fast & easy networking built in, either via ethernet or dial-up. Thus between reading CD's and networking it's trvial to get material on & off of an iMac. Later iDisk was rolled out to make it even easier.

      Not very useful for getting that assignment to school to print. Not everyone has broadband. Hell, not every has 'net connectivity and neither does every school (for the Americans, school in this instance means K-12). This is even assuming you have somewhere useful to network *to*, and not taking into account wanting to backup important things.

      For those that really have a burning need for a floppy drive then they either shouldn't get an iMac or need to budget for an external floppy drive/superdrive/whatever.

      I didn't wan't a floppy drive in the iMac, I wanted a CDRW. Killing the floppy was a great idea. Not replacing it was dumb. Network != removable media.

    12. Re:Database Hardware by maggard · · Score: 2
      Whine whine whine.

      Right - iMac didn't come with a floppy. Or other removable media. If you wanted that you had to buy it seperately.

      Was that a bad thing? Well the iMac was the best selling PC for several years running so apparently not.

      BTW - If someone's gonna cough up a grand or more US$ for an iMac they can budget in the external media or printer or whatever, and apparently they did.

      --
      I don't read ACs: If a post isn't worth so much as a nom de plume to its author then I wont bother either.
  4. CLI Undesirable? by Xunker · · Score: 3, Funny

    "the whole thing is command line only for now."

    This is bad? Come on! We're been waiting for a real command line on a Mac for, like, 20 years, and now we need a lickable interface for a database engine?

    Some of us dream in CLI, you know? :)

    --
    Hilary Rosen's speech was about her love of money and her desire to roll around naked in a pile of money.
    1. Re:CLI Undesirable? by Anonymous Coward · · Score: 0

      Some of us dream in CLI, you know? :)

      Well considering most of us dream about girls at night, maybe you should consider switching over to something more lickable from your ascii porn.

    2. Re:CLI Undesirable? by rthille · · Score: 1

      Thank god it's CLI only. The java/X gui to install Oracle 9i on Solaris is a shit-hole dog! :-)

      --
      Awesome furniture, accessories and cabinetry in Santa Rosa, CA: http://humanity-home.com/
    3. Re:CLI Undesirable? by Anonymous Coward · · Score: 0

      did you run it on a SPARCstation 2 or something?

    4. Re:CLI Undesirable? by Anonymous Coward · · Score: 0

      Blade 100.

      Machine costs about $1000 and its slower than a ghetto cheap PC I can get for $300.

      Cracking it open, it has the same parts as said ghetto PC, with a slow ass USII in place of an intel whatever.

    5. Re:CLI Undesirable? by Anonymous Coward · · Score: 0

      why would you want to run oracle on a uniprocessor system? if you want performance use DB2 or MySQL

  5. Client side tools needed! by d3xt3r · · Score: 3, Interesting
    Glad to see Oracle is finally making a public release of 9i for OS X, but what I really want are the development tools.

    Oracle has given us a cross-platform version of Enterprise Manager, but it still sucks on anything other than Windows. The OEM included with 9i, Release 2 for Linux constantly locks up, or takes too long to conduct simple operations.

    I think that OS X represents a great OS to finally replace MS Windows as the developement platform of choice. What we need are things like OEM for OS X, not just the database.

    I hope these tools come soon.

    1. Re:Client side tools needed! by Anonymous Coward · · Score: 0

      I just picked up my first Mac in years. Jaguar proved too tempting to ignore. While digging around, I found the developers tools for X (Project Builder, Interface Builder, etc...).

      Aren't these the tools we are looking for? From my limited knowledge of the "X" system, it seems that one would use these tools in conjunction with the Adapter system they have for connecting to databases on other platforms (Oracle, Sybase).

      It just so happens that Oracle is now a first class citizen on X - which is very good news.

      Graphical management tools - I guess - would be next. Although I am partial to the command line.

    2. Re:Client side tools needed! by droleary · · Score: 3, Insightful

      Glad to see Oracle is finally making a public release of 9i for OS X, but what I really want are the development tools.

      Then what you really should be doing is asking Apple to move WebObjects out the the Java ghetto they stuck it in and divorce EOF from WOF. EOF was amazingly adept at database-independent development, so getting it back would get you access to not only Oracle, but most other databases that came to the OS X platform. Pitty Apple got so entranced by the Java/Web angle, and has yet to make corrections after the Internet bubble burst. You can still scrounge up a copy of WebObjects 4.5.1, but I don't know if it'll be (or needs to be) update to work with 10.2; again, bug Apple.

    3. Re:Client side tools needed! by dparnell · · Score: 1

      I managed to get TOra to compile and kind of run under 10.1 using the old 8.1.7 oracle drivers and the X11 version of Qt.

      It does a few funny things, and locks up randomly from time to time, but it kind of works

      --
      There is no spoon
    4. Re:Client side tools needed! by mcockerill · · Score: 1

      Since JDeveloper is 100% pure Java, it actually already can be made to work on OS X. Oracle don't currently tell you how, but there are details of how to get it up and running here:

      http://www.mactelligence.com/info/Java/

  6. DBD::Oracle by hondo77 · · Score: 3, Interesting

    When do I get to put DBD::Oracle on my Mac? That's what this Perl guy wants to know.

    --
    I live ze unknown. I love ze unknown. I am ze unknown.
    1. Re:DBD::Oracle by EricWright · · Score: 2

      You took the words right out of my mouth! I'm sure there are lot's of us out there...

    2. Re:DBD::Oracle by jbolden · · Score: 1

      Now I think. From what I heard 10.2's ODBC supports Oracle. At the very worst wait for Perl 5.8.2.

  7. Things that make you go "Hmm..." by big_oaf · · Score: 1

    Anyone else notice that the 9 in 9i and 9 in Mac OS 9 are identical? I guess it's a good thing that Jobs and Ellison are buddy-buddy or somebody's lawyers would be whacking someone else's lawyers over their heads with giant salamis.

    --
    -- My hovercraft is full of eels.
    1. Re:Things that make you go "Hmm..." by jbolden · · Score: 1

      Is any end customer likely to get the two products confused? That's one of the requirements for having that kind of a suit. Apple tire company relasing their new OSX (overdrive support ten) would probably win a defensive suit against Apple computer :-)

  8. Not the first time by Anonymous+Codger · · Score: 1

    Way back in the day, when Apple was selling a 68K-based Unix server running A/UX, Oracle provided a full version of its DBMS that ran on that OS. I think it was Oracle 6, but I don't remember. We had one in our shop for awhile. It's good to see Oracle on Mac again.

    --
    No sig? Sigh...
    1. Re:Not the first time by Anonymous Coward · · Score: 0

      It was Oracle 7 I still have it :) It ran pretty well, all this considered. It was the real deal. Before, that there was an Oracle 6 (non-enteprrise) available for Mac OS 6 & 7.

  9. No, no, no by BoomerSooner · · Score: 0

    OEM == Oracle Enterprise Manager.
    It's a set of tools to allow working
    with the *actual* database in a GUI app.

    1. Re:No, no, no by Anonymous Coward · · Score: 0

      Gotcha.

      So Oracle would have to port/re-write OEM - probably as a Cocoa app.

  10. Off-again, on-again... Fickle companies by Anonymous Coward · · Score: 0

    Oracle had a Mac version back in the early nineties.

    I just hate companies that put out Mac versions, then drop them, then put them out again... If they didn't support the Mac before, will they CONTINUE to support it now? Or will they drop it the next time the wind shifts?

    1. Re:Off-again, on-again... Fickle companies by dadragon · · Score: 1

      Oracle had a Mac version back in the early nineties.

      Apple had a Unix in the early nineties.

      --
      God save our Queen, and Heaven bless The Maple Leaf Forever!
  11. WoW - Best Oracle Beta I've seen in a long time... by dirkx · · Score: 1
    Ok, some Sparc Binaries and Libs crept in - but all and all - following the release notes; you'll have apache, tomcat, jdbc and a full Oracle 9i up and running inside the hour.

    Best oracle Beta I've seen in a long time.

    It just works !