Slashdot Mirror
Oracle 8i Linux port on the scene
fatherdatabase writes "After a slight delay, Oracle finally releases a port of 8.1.5 for Linux. Requires a (free) technet account. Check it out here. " It's a free download, but they do require e-mail address, etc etc. Have fun.
If you want to migrate from Sybase or indeed
from SQLServer 6.5, there is a free migration tool
available on the Oracle Technology Network
http://technet.oracle.com/
Oracle Migration Workbench 1.2.2 , unfortunately
you need access to a windoze nt/98/95 box while
doing the migrate to Oracle 8i on Linux.
Be Free: Free Software Tuition
Following in the wake of the sucessful IBM Viavoice Flexi-licence(tm) Oracle Corp. was pleased to announce the release of Oracle 8i for Linux today, available under the new Flexi-licence system.
:P
"We place the licence in a HTML textarea to be posted when you agree. This innovative new Open Licencesing system allows our coustomers to tailor (or replace) the Oracle 8i licence in whatever way they choose, we signify our agreement by allowing you to download the software, just like users have agree to licences by opening boxes for years!" -- Unnammed Oracle marketdroid.
When asked about the risk of users putting in clauses such as "In case of snow on the north pole, all of oracles assets goto user" the oracle marketdroid replied "Oh that! Well we figure that this licenceing system is just as bogus and non-binding as any normal shrinkwrap licence, so it really doesn't matter.. No one but Microsoft could win that in a court of law".
--------
I just pasted in the GPL and downloaded my GPLed copy of 8i, you all should too.. But where is my source? -gm
Seriously, if a software company can say we agreed to some opressive licence by clicking a button that gives them ZERO feeback, as well as never having negioations with users... How is it any differnt here.. I amended the license, gave it my click of approival, and they obviously agreed: I'm 50% into the download!
Yes, this is definitely possible!
Remember that just like a web server, Oracle will listen on a port.
You don't mention whether you want to install a new server at the same time or use the same box.
If using the same box: install in a different location than customary (so that your O7 stuff isn't disturbed), and use a different port. That way your O7 stuff stays up all the time.
Then, use the various tools to transfer your data, schemas, etc. to O8. When everything is ready, shut down O7, start O8 on the same port and you are ready. Downtime could be as little as a couple minutes in this case.
BUT watch out! You need to check your client libraries on each machine accessing Oracle to make sure whether they will work with O8.
Of course, if you have different boxes it gets easier.
Yes, this is definitely possible!
Remember that just like a web server, Oracle will listen on a port.
You don't mention whether you want to install a new server at the same time or use the same box.
If using the same box: install in a different location than customary (so that your O7 stuff isn't disturbed), and use a different port. That way your O7 stuff stays up all the time.
Then, use the various tools to transfer your data, schemas, etc. to O8. When everything is ready, shut down O7, start O8 on the same port and you are ready. Downtime could be as little as a couple minutes in this case.
BUT watch out! You need to check your client libraries on each machine accessing Oracle to make sure whether they will work with O8.
Of course, if you have different boxes it gets easier.
Cordially
Patrick
a222@redrose.net
What do you do normally when an instance goes away? If your servers must not go down, you must have backup servers of some sort, and you could probably manage an upgrade to them.
---- "If we have to go on with these damned quantum jumps, then I'm sorry that I ever got involved" - Erwin Schrodinger
Huh?
Where do you get the $12000 price tag? What I saw on their web site was that it started at around $1400... That's a little different.
Also, although Oracle runs on lots of hardware, it is not device independent. Otherwise, why would they just be getting it out for Linux? They have done their best to isolate the platform-specific code, but it still has to be ported.
I haven't played with 8i myself, but I had read that it had java web-based config utilities... Is this not true of 8i for Linux?
Unfortunately 2 elphants for a nickel is only worth it if you need 2 elphants and have a nickel.
Oracle provides a 99.9% solution for 100% of the price.
The cognoscenti who are a little familiar with Oracle's web/ftp presences might, like myself, have just skipped going through Oracle's frequently-overloaded technet webserver and just gone straight to Oracle's FTP site and grabbed the stuff from there directly. Higher likelyhood of connection, can get ncftp to hammer if you can't connect first time, and also, it's anonymous!
Weeel,
There is also the locking issues...Sybase at least up until their lates version (You know, the one not avalible for linux) only supports page locking versus oracles row locking. (not counting full table lock etc.)Ask just about any sybase programmer if he/she ever had problem with deadlocks and the answer would be like @#*&^%#!!
That's the "Enterprise" edition. For the "just plain server" it's closer to $2000 for a 10 users/processor license.
Needless to say, none of this is obvious from the website.
As for Oracle on NT: It's more than pretty tools and performance hits. It's also bugs-aplenty. I just finished benchmarking Oracle on Linux and NT and I had to cancel the NT test because it couldn't even do some of the tests. Bulk loading was the killer--for some reason it could create but not populate the reject file (for large (?) data loads).
These tests were with the free downloadable versions, BTW, so YMMV.
---
Put Hemos through English 101!
Linux MAPI Server!
http://www.openone.com/software/MailOne/
(Exchange Migration HOWTO coming soon)
I believe that Sybase is not as good of a choice as it once was. The latest version is still the only version 11.0.3-3
Wondering if they have lost their interest in Linux....
Also comparing some stuff....
there is no tool in Sybase to get a ddl (need 3rd party toy) [dbschema.pl]
there is no way to dump the db to a collection of SQL statements. similar to postgreSQL's pg_dump [a feature that Oracle has in the stock install]
I would love to see Sybase use linux as a means to have Sybase move in on MS-SQL Sewer on the low to mid range. But they don't have the balls/ovaries.
Actually :
if you register as a developer you get a free license. if you want to use it commercially you have to pay but if you want to use it for dev reasons you don't...
I tried for 2 DAYS to download via HTTP but it kept pooping out at 20-30 MB (this was a 100MB download). Finally I wised up and went over to my Linux box to use ncftp.
Of course, then I had to find it. Turns out the 95/98/NT client software is in the Netware directory...
---
Put Hemos through English 101!
Linux MAPI Server!
http://www.openone.com/software/MailOne/
(Exchange Migration HOWTO coming soon)
Wonder if it works under glibc2.1 system e.g. RH6.0?
Yes, I like that it "enables current Linux users to deploy enterprise-class applications", but I'd also like to know what the heck it is. Someone? Or is Oracle like toilet paper and everyone knows what you use it for?
Well I think the very fact that Oracle has a port of it's database is ample proof that the above statement is false.
This is one area that microsoft cannot touch with a 10 foot pole. Basically it comes down to what businesses (besides small businesses) need and that is a way to organize data that is meaningful to them to make them more productive. Wonder what that group of bread companies could do with Oracle.
The death of one man is a tragedy; the death of a million is a statistic --Joseph Stalin
11.9.2 supports row locking. I am using row locking under Solaris... I guess Sybase just needs to support their latest version on Linux.
...lets hear from someone who has actually USED and DEVELOPED Oracle 8.15 under NT.
Firstly, Oracle has become the industry standard RDMS simply because, as a backend database/application server, it is escellent, regardless of whether it runs on NT or a *nix box.
Most DBA's will do their administration tasks from the SQLPlus 3.3 or 8.0 command prompt anyway, not from the various GUI tools provided. Our DBA rarely used the Schema mangaer or Enterprise manager - he and every other Oracle DBA I've worked with, have ALWAYS used the command prompt. Even us developers used it - in the 9 months I worked on my last project, I never saw any kind of GUI manager - I don't even know what it looks like.
As for performance, true, NT is slightly (duh!) behind * nix but Oracle runs equally well under both - a credit to their engineers. We had very few problems and when we did, it was generally NT having the problem, not Oracle (unless you count Designer or Developer 2000 - don't get me started on those sh*tty products). But in the big picture, the problems were rare, even under NT. Thus for most applications, it doesn't really matter - use the OS your used to with Oracle (unless its a mission critical system that has to up and working 24 - 7 then I'd stick to *nix. Most apps aren't this important).
Oracle 8i runs just fine on my NT partition on a PII 350 with 64 megs of ram and 1.5 gigs of hard-drive space - so put the crack pipe down before you spout about terabyte/petabyte databases. Oracle is designed to be scalable - You can use it for a 500 meg database or a 5 terabyte database, as long as the hardware can handle it (my last project was used on a PII 450 box and took up about 1 gig in total storage space).
I'm still waiting for my Oracle 8i for Linux CD to arrive (I too ordered it 3-4 months ago). My NT CD arrived in April. BTW, both of these are the "real deal" - fully functional, non-time limited versions of the Oracle 8.15 database (and not Personal Oracle either - just Oracle 8i ENTERPRISE Edition!). Cost $0 (CDN). I can only use it for personal, non commercial use. If I need to distibute a product based on it, then I buy the licence (or rather, my client does). Sounds fine to me.
I fully agree with you that this news is very good as it will encourage a whole new segment of the IT world to try their thing on Linux - it will make developing and/or porting robust, enterprise level apps to Linux easier, which will increase the user base. Nothing but good can come of this.
But lets not take this news as another mindless opportunity to spread anti-NT FUD, especially from someone who obviously does not now or has never used Oracle under anything, let alone NT. Oracle is a good product which will do fine without you spreading bald-faced lies on it behalf. You making yourself look like a fool.
Moderators -4 Insightful? WTF? Try again...this guy hasn't got a clue enought to be even 2 Interesting
Never by hatred has hatred been appeased, only by kindness - the Buddha
Has anybody used both? How do they compare, feature-wise?
Oracle 8i is 8.1. The "i" is Ellisonspeak for "Internet" and 8i includes several features that make it more internet friendly -- support for new features in Oracle's WebDB product and support for embedded Java procedures most prominently.
The embedded Java support supposedly allows you to store Java objects in the database and activate them there, including using Java for the stored procedure and trigger language. (so you can make programs that run within the database server, or run automagically when the data changes) This supplements Oracle's proprietary PL/SQL scripting language (of course there will be proprietary Java classes instead, but it's closer to a transferrable skill) and will let you hire less specialized talent to develop your apps.
I got my NT version - have yet to receive the Linux version, although a message from Oracle in the Technet discussion group promises that it is ready to ship....
james
Tally-ho, yippety-dip, and zing zang spillip. Looking forward to bullying off for the final chukka?
it's about time! BTW (and off the topic) any have any insight into ms sql server 7? It is supposed to be a complete rewrite and totally a MS product.
Has anyone tried it out yet?
putting the 'B' in LGBTQ+
It's not slower, and it's a bit more stable (and those of us that went to 8.0x are going to have to move up to keep our support).
Oracle's a bit late to the Web party, so it's not surprising that all their web stuff is not a big incentive to buy -- we already have stuff to do all that with the old version of Oracle. I agree with the root poster though, the Linux market may go for these features in a stronger way, provided the Linux market can afford the licensing.
First, I agree that releasing to Linux is a very good idea if you want to target Internet applications.
But, I would like to caution anyone for looking down on 8i for its slow acceptance. Oracle tends to be found in the heart of large, mission critical systems. As a result, admins are always very wary of touching it. Why fix it if it ain't broke. Upgrades are almost always done just for performance or bug fixes.
New technology, such as that found in 8i, is used in new projects (or new versions of existing projects). But with less then 5.5 months until Y2K, etc, IT deptartments have put less emphasis on new projects and more on Y2K.
In the mean time, 8i is out and proving itself. After Y2K comes around and the dust settles, companies will be returning to new projects and in general be more interested in trying new things. Oracle and 8i will be nicely established and ready to serve up.
Even better, Linux may prove itself to be a great platform for Oracle 8i based internet applications and companies will be basing their new projects on Linux.
So... you only pay for the part they're getting wrong? That explains a lot about Microsoft pricing...
As I said "Sybase at least up until their lates version (You know, the one not available for linux)"
How long has 11.9.2 been out and avalible?
We where taking about popularity issues and sybase have just very recently made row locking available.
I didn't say that to pick features in current versions etc. But as a reason to why oracle was popular in enterprize settings.
You can't easily store Java objects in the database. You can do it, but there's no built-in support for it. You can create Java objects from data in the database; there's a lot of support for that. But when you store the Java object you turn it back into RDBMS data. It's no longer an object.
That said, Java in the database is still very useful. One important thing to note is that each connected user gets his/her own VM. This means that instead of having to write your own multi-threaded, multi-user app, you can write a single threaded, single user app and let the Oracle handle the multi-user bit. Oracle provides all sorts of dispatching, load-balancing, and security features, features that are critical for real-life server apps.
Also, to the best of my knowledge, the only visible proprietary classes are the classes that implement JDBC. Everything else is either invisible or is not Oracle proprietary.
Does anybody have any experience, tips, warnings, etc. for XML development with 8i?
Row locking is only an option for user tables; system tables are still page locked, and will be so until 1Q00, or is that 1Q2000? I know of one site that thas horrendous performance problems that Sybase cannot cure.
The previous suggestions were good. It may also be possible to have both databases running side-by-side (not on NT though, the last info I had was NT can only handle one instance of Oracle running at a time). Once you get the new database
set up w/ tables structured etc. you can create a
database link to update all the tables in the Oracle 8 version. Note that you will probably take a performance hit. You can then test (very important to test!) the new database and then switch over when you feel comfortable with the data. If you have not premapped the data, if there are any table changes you will have to do so.
The best thing is to do this incrementally. Migrate data at night (or whenever you have some slack time) incrementally. take the next day or two to test (testing is important!). Then do the next stage. Repeat until migrated. Do some final testing then sign off on the project. Else, reconvert until satisfied with results.
Ideally, you should have 2 servers to do this. But a mainframe or a medium sized UNIX box should suffice.
putting the 'B' in LGBTQ+
Theoretically you might be able to, but practically speaking, I doubt it. I'm familiar with Oracle on HP-UX & Linux. You didn't mention a lot--
Is your database schema changing or just the Oracle release? Are your databases for update or for browse only?
You can keep your O7 databases up if there are no updates being done to them. Otherwise, all updates made during the install process won't make it to the O8 version. Eight days sounds like full exports followed by OS-level backups followed by conversion routines followed by full imports. Even so, either the databases are very big, the engineers are blowing smoke, or something else is going on.
There's too much to consider to fit it all here. If you have Oracle support, USE IT!
A little bird told me that the 30 limit is not
enforced (for personal use). Mr Ellison would love people to learn/use his technology. If you start using it for business, that's different story.
A bit offtopic, but how does a database such as Postgres compare to Oracle, DB2 and Sybase? I'm looking to develop an application requiring high-volume, high-performance database access (primarily information 'look-ups') and I was trying to figure out what would be the best route to go as far as a database-backend was concerned.
It is not that simple...although one would assume
that you could have different versions running
on the same box, if you do, tech support will not
help you. They will require that you remove or
upgrade the older version(or most likely, tell you to upgrade all instances to the latest patch level) for support.
Some times Oracle will get confused and see the
other Oracle instance and some how read the wrong
ORA.INI file...
Skip ------ See the latest from http://www.anArchyFortWorth.com
In case you don't feel like going thru registration hassles, just grab it from /linux/815ship.tgz. It is legal, ain't it?
ftp://ftp.oracle.com/pub/www/otn
Jabber wrote:
:)
:)
>Well, now that 8.1.5 is officially available to >the Linux crowd, maybe Oracle will get around to >sending me that complimentary copy of 8i that I >requested three months ago.
>
>Did anyone get theirs? I know that my NT version >arrived in a couple of weeks, but I've not seen >hide nor hair of the Linux offering.
>
>I certainly hope that this is not indicative of >Oracle's support for Linux. All talk? Since the >update is up for D/L, I guess not, but it would >be nice to run the two side by side to see how >they stack up...
>
>Still waiting for my CD Oracle
I'm awaiting my CD for Linux too - and also IBM's DB2 for Linux.
But... now I have moved to another country and not left any address. So I wonder if they can find me
Anyway - in the meantime I try to do a little Oracle on the 15 Unix servers (with 2 Gb ram each/2 CPU'es) just for warming up
/Bent
mailto:bm@tli.de
If Oracle is more popular than Sybase because of Marketing that means you can fool (at least most-) of ALL the IT Professionals MOST of the time. Not so. The fault dear Brutus...
People who make their living implementing systems don't make decisions based on advertisements.
The Linux port is great because it works the same, including all of the same functionality, as Oracle on every other port.
1) is designed for way more than 100G (my largest until now is 780G) :)
2) installed an hour ago on my 128M laptop, what really hits is jre going up to 110M SZ during install
3) Oracle on NT -- depends on what you use it for
4) see 2) unless you have a character mode JRE
5) the download edition is 815 EE production -- not really beta, my dear friend
As for price, Oracle for Linux should cost ~ as Oracle for NT...
Err... I am an Oracle (and Java) developer and have been one for the past 4 years (Java 1 year). In my shop (a fortune 400 company), we are dying to get the new Oracle 8i in production because we want the new features.
I agree that most database developers do not understand the power that you can get from the features in Oracle 8i. These features are mostly do to the integration of Java. Finally, one can store objects (real objects, not stored procedures or nested tables) in the database. The result is that you can publish your Java database interface to the SQL engine. Then you can do stuff like "select object from database". They [Oracle] have combined the power of objects with the speed and proven robustness of a relational database.
The fact is that most database developers are not trained in object-oriented analysis and design (OOA/OOD). Unlike procedural programming, such as in C, COBOL, BASIC, or Oracle PL-SQL, object-oriented programming is more complex and cannot be mastered in a few years.
IMHO, Oracle has advanced RDBMS technology to a new level. In a couple of years, as database developers are trained in OOA/OOD, you'll find some amazing things happening.
Best of all, you can do it on your Linux box!
"You're gonna need a bigger boat." - Chief Brody
BACK AWAY FROM THE CRACK PIPE!
"You're gonna need a bigger boat." - Chief Brody
I implemented and rolled out a secured Oracle web application with a 5-user concurrent limit ($2000) by choking the number of Apache children down to five.
Real fucking hard. Could we have afforded an unlimited web license? Probably. But for $28K less we got a working install which services everyone who needs it (maybe 500 people, never more than 5 at one instant in time).
Duuuuhhhh...
Henry Ford said something along the lines of "people who don't think ahead never have enough time; people who do, never have too little". Same thing goes for money, licenses, what have you.
In any event, around the release of Postgres 6.6 (currently projected for 5 months or so), a lot of these license questions will be moot -- Postgres should achieve functional parity with Oracle at that point, and you'll have a free alternative.
Remember that what's inside of you doesn't matter because nobody can see it.
I thought it was 2Tb (tera byte)
Can't you just specify /dev/hd-whatever for the file name? </troll>
I think you mean that the Linux version of *Oracle* doesn't support raw access... But even that sounds a bit questionable. Hell, the *286 Xenix* version of Oracle supported raw access. Please clarify your statement.
Seriously, if you're looking for ease-of-use, and are primarily doing home-hacked database apps (personal web counter, etc), /for sure/ stick with mysql. OCI is a pain in the ass, as is Pro*C. The only reason I'm running O8i now is :) /finally/ got 8i installed & OCI figured out sans documentation. (past the point of no return)
1. I've done the mysql thing.
2. I've sworn off Perl
3. I
I prefer the Mysql sqlplus & Mysql SQL extensions (SHOW TABLES!!). Mysql isn't even close to enterprise-caliber, though.
Based on the NT version I installed, I think it means "it'll be in the next version". At least that's the story for iFS and the HTTP Listener - 2 of the things I wanted to try out. The release notes say that they'll be in version 8.1.6.
First off, I hope you have a backup server where you can test migrating your database from 7 to 8. For example, all of our pro*C applications have blown up on recompile under O8, because the developers didn't stick to the Oracle recommendations for the make files.
...etc....
8 days, I hope, includes precautionary backups and/or exports. Otherwise, there is no reason your database needs to be down for 8 days. But your DBA will need stand-alone time to:
1. Run the MIG utility under O7. (MIG wants to startup/shutdown the database.)
2. Modify $ORACLE_HOME
3. Modify init.ora
4. Restart as O8.
startup nomount
alter database convert;
alter database open resetlogs;
We've also had the MIG utility core dump with one of our database instances--the others have converted OK. Hince, the reason you need to do your own testing.
The only way I can think of for you to convert a running database without interruption is if you have implemented Advanced Replication. If so, you will definately need $$$ Oracle consultation on migrating a replicated database.
Also, if your DBA plans to upgrade via export/import instead of using MIG, there are bugs in 8.0.5 related to export/import. Be sure you're running at least 8.0.5.1 or later.
(MIG however REQUIRES that you start with 8.0.5 base, then migrate, then apply the patch update after all instances are migrated.)
8.1.5 = 8i. There was no 8.1.0 release for Linux.
8i is just a version of 8.
The 8i DB can store Java byecodes in the database and execute them within the DB kernel process, as is done with PL/SQL. The JDBC driver implementation makes direct calls into database engine - very fast (PL/SQL is faster, but then it's been tuned for this one purpose for a long time). Java can call PL/SQL the usual way (via JDBC) and static functions of a Java class can be bound to be called as a PL/SQL procedure. In addition, the Java objects can be called via. CORBA bindings, and this is almost the preferred way to do it, since it can better take advantage of the OO aspects of a Java application.
But when you start talking about persistent objects, things start breaking down. Even though there is the new "object-relational" support in the DB (since 8.0), the fit is poor between that and true Java objects (no ploymorphism, for example) - it's not the same thing. Tools are in development (at Oracle and elsewhere) to handle the mapping between run-time object and it persistent representation, but it is still very cutting-edge.
I'm the DBA for several Oracle instances and I asked Oracle $upport that question point blank. Oracle 8.1.5i is simply the "latest" version of the Oracle database engine. True, it has some "internet" related features such as a JVM within the database engine, but I view the "i" as more of a marketing decision (as opposed to the major/minor version numbers which actually mean quite a bit).
This is just my understanding.
11.9.2 is scheduled to be out for Linux within weeks; it's supposed to be priced along the lines of NT and 'workgroup' databases, so you won't have to plunk down $50K just to sit at the table :)
In addition, Sybase SQL Anywhere is currently out for Linux, which is excellent for most applications, particularly where you're installing it on a server for someone else and don't want any upkeep hassles.
(not working for Sybase, just a relatively happy customer)
Chris
M-x auto-bs-mode
Or, you download Oracle for linux, install it on a desktop computer and use it for development, then deploy your application on a Sun or HP, at which point you chip out the big bucks for a production license.
There is no direct (unbuffered) device access in Linux (yet), unlike older Unixen - even though you can create a "character" device with the a name like /dev/rhda1, it will still transfer data through kernel buffers, instead of directly to the userspace buffer referenced by the read() or write() call.
It has been an issue of some contention among the kernal maintainers, I understand, and is evidently not as easy to fix as it sounds (note: I know little of Linux internals - I'm just repeating what I've heard).
Remember, Linux has a from-scratch code base, and raw disk access is a trick normally used only by high-end databases, like Oracle, and file-system maintenance tools like the original fsck. Up until now, it just hasn't been needed, I guess.
--
An esoteric scratched itch:
Homeworld Map Maker Tool
1) Why emulate a broken product? Just program for Sybase (or Oracle, or...)
2) Your example for building a "locks" table won't work on a database that doesn't do locking (like SQL server sometimes fails to do). Occasionally two people will attempt to lock at the same time and since the database doesn't lock properly, they'll both succeed.
3) The API solution is the only solution you present that will work, but again, it has to work for the API as well as the database. Implementation of a proper locking mutex is a solved problem, but its implementation is non-trivial in some environments. I remember Amiga (through the 1500) had a prohibition against using Test-and-set instructions because it threw off the time-multiplexing for memory access, for instance.
We run multiple instances and versions on several NT development servers. I agree it requires tuning to get 'em running right on production servers (where you want to have all possible resources used) but it's possible.
Can anyone tell me the difference between Oracle8.0.5 "Server" and 8.1.5 "i"? That is other than the buzzwords on Oracles Site.
Does it do anything different or is it just a later version with additional features and all the functionality of the earlier? (Has the same price though.)
ROC
Well, now that 8.1.5 is officially available to the Linux crowd, maybe Oracle will get around to sending me that complimentary copy of 8i that I requested three months ago.
Did anyone get theirs? I know that my NT version arrived in a couple of weeks, but I've not seen hide nor hair of the Linux offering.
I certainly hope that this is not indicative of Oracle's support for Linux. All talk? Since the update is up for D/L, I guess not, but it would be nice to run the two side by side to see how they stack up...
Still waiting for my CD Oracle.
-- What you do today will cost you a day of your life.
Just use Sybase instead... Sybase is easier to manage and program, and usually higher performance when tuned properly.
The only reason Oracle is more popular is due to marketting.
Of course, after you download the 120+ MB's you'll discover that it's good for 30 days, then you need to spring for a license (at the same pricey schedule as Oracle on other platforms).
Here are what I see as the advantages of each.
MySQL is REALLY fast and light on resources. I'm able to run MySQL on my personal web server with 24 megs of ram, 300 megs of hard disk and a pentium 63 processor. It runs at a very acceptable speed for the site it manages. However it is hindered by the fact that no database can contain more than two gigs of data. This is a limitation as a result of the linux file system. Also it is lacking some nice stuff like foreign keys, stored procedures, nested selects. In all reality it implements only basic SQL. But is fine for most people.
Oracle to be quite frank, rocks my world. I've installed it numerous times and it is a hefty beast to install (and was a challenge to get working on RH 6.0). Anyway, it supports databases of unlimited size and works much better on large amounts of data. We are currently testing a system with 30 million rows of data in it and oracle flys through this like one of the SGI's through Seti@Home blocks. Its provides much more flexibility in terms of setup of the database. You can spread the files across multiple disk controllers. Also oracles stored procedures are simply awesome.
Oracle also provides a wider range of tools to play with. Loading in 30 million rows of imported data would be hideously slow over Perl/MySQL, but with SQL*Loader and spreading the load across 4 processors oracle can do this in under an hour.
To sum it up, here is my view. If you are developing something enterprise level (millions of rows of data) kiss MySQL goodbye, because it can't handle it. If you need triggers or stored procedures, later MySQL. If you have a low budget, keep on hoping because I could buy my car like 12 times over for the price of this beast.
So, choose what you wish. Also, if you say you are using MySQL some clients balk at that. Say you are using oracle, and they are like "wow, thats pimp!".
Please note, these comments refer to oracle 8.0.5, I haven't had a chance to play with Oracle 8i yet.
My Slashdot account is old enough to drink...
Clever. But I have 3 objections:
1) Why should I have to worry about this? Deadlocking is a very old problem in computers/databases and has been solved already. Why should I have to go through this entire process when the database should be doing it instead? It is one more detail to keep track of and I have allot on my plate as it is.
2) It is too clever. While I like to think that all of us are competent and heads up programmers,
we all know that there are goobers out there who will hose it up. Any solution which requires too much special magik to pull off is a poor engineering design.
3) Deadlocking is a known and solved problem. Any
database engine which does not deal with it well is not worthy of the name "database engine." Any company which sells a db with such a design flaw should NOT be in business. That company will not be taken seriously for mission critical situations unless you deal with these reliability issues. The database will not be considered for air traffic control, nuclear power plants or any other real engineering application until the quality improves.
If we want computers to move into more areas and higher risk areas, shoddy design by databse (or any other software) designer cannot be tolerated as it could kill someone.
Just some thoughts....
putting the 'B' in LGBTQ+
Really, unless you are ready to shell out over 30k for a web server running Oracle for Linux... FORGET doing ANY development on it..
... and that is with a 2 year license... on a ONE - DUAL 400mhy CPU pentium MACHINE - ....
.. my opinion there are a lot better alternatives.
I called Oracle and about crapped my pants when they quoted me 30k
Oracle Sucks... there databases are solid, but unless you have a huge company that is willing to fork out the bux for it...
Use Sybase if you need anything but a Ebay sized solution.
Oracle8i Release Note
Release 8.1.5 for Intel-Linux
A74960-01
8i IS selling well. Adoption of new features and functionality takes time. The article you've noted is FAR more COMPLIMENTARY to 8i than its headline suggests.
Regretably, NT is a far larger market than Linux; that's why 8i came out on NT first. From here on out, though, I don't suspect you'll see a 4 month lag between the Linux and NT ports.
Oracle is well aware of the importance of Linux.
Want some numbers?
- Over 50K developers have downloaded Oracle8 for Linux from the Oracle Tech Network. Already. Let's see how 8i-Linux does over the next month or so. Should be great-
- 20K others have already pre-registered for 8i on Linux. Hope those disks are going out NOW.
Crock! There I've said it. If oracle is confused about which init file it's reading then it's the environment thats hosed, not oracle. I've run multiple versions of software on the same box for years without any trouble. And YES I've gotten support from them. If you've seen problems, then it was a bug, and oracle will definately support you. Unless of course you set up your environment incorrectly which isn't oracle's fault. Try to watch your path/oracle_home/oracle_sid and possibly two_task vars a bit closer. I'll bet this is where your problems were. Pay close attention to OFA (or something as well structured) 'cause this is also an area for concern.
Each oracle instance gets it's own shared memory segment once started, completely independant of any other instance(s) started. Even a listener can be shared between version (same port). You just tell it where it's oracle home is for each instance. I've done it for years with no problems.
Oracle Enterprise Manager 2.0 is (now) Java. You shouldn't have trouble running it on Linux.
WebDB is all HTML; shouldn't have trouble running it on Linux.
Near as I can tell, Oracle is in the process of moving all of its' Development Tools to Java. Good for Linux don't you think?
1 - The idea is not to develop for MS-SQL, but to help people that are already using SQL server, to migrate to Linux/Sybase.
2 - Wrong: it works.
This solution works on any database that has "unique-indexing". It doen't require any locks on the database side.
This is the ideal solution for small databases like "msql" and "mysql".
The general idea is that the database engine will check if a record is already locked and then will lock it, using a single SQL commmand.
When you insert a new row on the "LOCKS" table, the DB engine will check if it's a duplicate value (because of the unique index) and if it's not a duplicate it will insert the new row.
The insert is a "atomic" operation, that cannot be breaked. It works even if the database engine doesn't have any kind of "LOCK" mechanism.
Of course, if you are using Sybase, or other professional database engine, you should use transactions and don't worry about this.
However, if you are using a simple database engine, like "mSQL" or "mySQL", then this is a very good solution.
Deadlocking is a long known problem. Everbody
knows how to solve it.
In this case, Sybase has the problem solved: just use the transaction machanism and you won't have to think about it.
However, there are many persons that have entire
applications already done, that work using
row locking. These people will have to continue
using row/record locking, instead of rewriting the
applications.
I agree with everything your saying -- Did I ever mention that as a DBA I used the OEM and schema manager? Nada. I think I made a comment about those tools as well as the wizards causing one to lose control of the database and run to the Oracle default specs. I.e. the default database on an NT system sets default_tablespace to SYSTEM for all users... I also would argue, just as you say, that the UNIX version is better for mission-critical Oracle applications. I use NT just as much as I use Unixes ... I'm not a raving Linux advocate ... although I have found Oracle to fit neatly like a glove with the Oracle architecture. When you mention the scalability of Oracle ... keep in mind that the product you are using -- 8i Enterprise -- is the top of that scale. Before you get inflamatory and start personally insulting me, perhaps you should re-read my comments and compare them to your own -- you'll find that your fancy wording actually says much the same things as I wrote. My comment about Oracle for NT is that it is basically under the same train of design as NT itself -- sacrifice some performance and stability on the flipside of increased usability and visual representation? It certainly does make corporate sense to have DBA's with a quick-and-dirty MCSE, yesno?
--- ask me about nihilism, I will have nothing to tell you.
Oracle 8i has been out for about 4 months now. But, it is not selling well. The main focus of 8i is new Internet features. It sports a Java VM, new web-based development tools, supports audio and video, and has a new file system.
Most users upgrading to it don't seem to care about these features. They just want to run a newer, faster version of Oracle.
So, why Linux now? Simple. Linux rules the Internet. With such are large percentage of Linux servers running the web, why not realease this Database to a market which might care? This database and its' new features are supposed to be for the web. Linux is the natural OS to release it for.
Of course, as soon as Linux users start bragging about how great 8i is, Windows users will demand it. Guess what? They already have it. This seems to be a backwards way of releasing it. But, Oracle is just now realizing the potential of Linux.
You can see more information about the sluggish adoption of 8i here.
I read the fine print. The 'Free download' only works for 30 days. It needs a normal oracle license to work beyond that. Last time I got a 30 user license for standard edition it was almost 8k. I think I'll keep mySQL.
Is there anyway to migrate from Oracle 7 to 8 without shutting the system down? We're running Oracle 8 on AIX and NT and need to migrate without going offline (this is a hospital; servers must not go down). Engineers report that the migration will take 8 days. That's just not possible. Does anyone know if a migration is possible while keeping the system live? I need info on any platform (AIX, NT, Linux, whatever).
1) for you who don't know what Oracle is: Its a database. Not like mSQL or PostGres or Microsoft SQL server ... it is a device-indendent, SQL based database. Oracle 8 for Linux (retail $12,800 USD, this is a demo version) is designed for 2-100 Gig databases. It is designed to properly operate on any sort of hardware -- AIX, VMS, HP-UX, Linux, NT, SCO, Solaris, etc. on and on and on. 2) If you are excited by oracle 8I and have less than 256 megs of ram on your linux box, don't bother downloading oracle 8i. Its designed with Terabyte and Petabyte databases in mind. 3) Oracle for NT is not even a competing product to Oracle for Unice ... The unix versions of Oracle are stable, efficient system from a decade of testing and development. For server functionality, you can't beat Oracle on a mainframe and Linux in my experience shows the same maturity. I doubt Oracle8i for NT would even run properly i.e. the 100% CPU spike bug. 4) There is one function of Oracle8 for Linux that is lacking -- all of the functions are character mode. There is no motif support (maybe its in 8i, havent downloaded it yet, site is BUSY) ... under NT you get pretty tools like Enterprise Manager, Schema Manager and simplistic install tools. Without these, Oracle is very difficult to learn and understand from a DBA perspective. However, the NT tools make DBA's follow the Oracle-defined idea of performance and installation, which according to O'Reilly's DBA books is the LAST thing you want to do. Since most Oracle installs on NT i've seen are 100% out of the box (the SQL command line is rarely seen) this is another performance hit. For these rambling reasons, Oracle on Linux is a strong presence ... Unfortunately, we must keep in mind that these are beta developer releases and the real meal deal starts at $10,000 USD++++++ Gerg
--- ask me about nihilism, I will have nothing to tell you.
Thanks for the heads-up.
:(
It would have taken about 4 hours to download at the transfer rate I was getting
Glad you saved me the @#$@$@#$@#!!!! swearing-fest that would have followed. I don't want to sell a kidney to run the database more than 30 days.
Cheers Mate !!!
>This is one area that microsoft cannot touch with a 10 foot pole
nah - sql server is actually biting oracle on the ass, in terms of delivering 80% functionality for 20% of the price...
-- your knees hurt, don't they?
But it is very popular, at least for oracle's workgroup server. It seems all the vendors are forcing people to move to NT. What pain.
The drive letters start to really get in the way.
You actually can't have an OFI compliant install under NT because of the drive letters (unless you install everything on the same partition).
OEM is kinda nice but you don't need it. The oracle courses heavily stress the cli tools, even under NT.
support gun control: take guns from cops