Re: Oracle 10 on Solaris 10 - ORA-06553 error
Date: Fri, 15 Jul 2011 09:45:19 -0700 (PDT)
Message-ID: <e0f6a54b-35f2-4227-ab62-cef4b870e5b3_at_a2g2000prf.googlegroups.com>
On Jul 15, 1:09 am, neilsolent <n..._at_solenttechnology.co.uk> wrote:
> On Jun 29, 5:33 pm, John Hurley <hurleyjo..._at_yahoo.com> wrote:
>
> > Neil:
>
> > # The point I am making - life is complicated these days.
>
> > It gets somewhat simpler as you gain experience and get older.
> > Patterns and underlying principles often emerge out of the
> > "complications".
>
> Patterns and underlying principles just don't cut it. Computers tend
> to deal in binary - they tend to expect something precise rather than
> a general ideology or a well-meaning concept.
At the hardware level, it is binary. When you get beyond assembler coding, it gets more complicated. You don't have to go far to get extremely complicated. When you map things to business analysis, you realize thinking in binary terms is counter productive.
Trinary logic comes in with null. Fuzzy logic and others come in along with set theory. What do you do when a states regulations fix loopholes and Amazon decides they shouldn't have to pay taxes like the rest of us, cutting off the cash flow of 70K parasitical associates?
>
>
>
> > # As a developer, you may touch upon a wide variety of technolgies
> > (every piece of software interacting with most of the others). There
> > just isn't the time to be an expert in each.
>
> > Any serious enterprise development effort that does not take the time
> > to understand relevant details about the database platform that it is
> > going to be using "under the covers" is probably going to compromised
> > unless the developers ( or at least senior technical architect ) take
> > the time to do their homework.
>
> That is not what I am saying at all, you misunderstood.
> To start learning an application it would be nice for it to actually
> start up after selecting defaults from the installer.
XE worked like a charm for me, as well as thousands who haven't been doing this for years. You have the problem.
> I assume you weren't fed Oracle documentation as a foetus?
When I was a foetus... http://www.cedmagic.com/history/ibm-305-ramac.html
>
>
>
> > Scaleable high performing applications do not appear just because you
> > use a wide variety of technologies. Realistically the more different
> > technologies you throw into the mix the more likely you start swimming
> > around in circles.
>
> Well, that's how the world is I'm afraid. It's full of complexity.
> I am not throwing more technologies into the mix, far from it - I am
> trying to support the most commonly used applications.
> I would love the whole world to use one database (so long as it's not
> Oracle :-)
>
There is a reason Oracle succeeds in the markets it does, and MS can only aspire to it.
>
>
> > # Sometime you want it to just start up without tuning (whatever that
> > means, wow).
>
> > Is that like start coding before doing a database design?
>
> Did you fully tune your first Oracle database before touching it?
> Do you realise how crazy that sounds?
One thing that has become painfully obvious to so many of us is you need to tune the database design first. One guy even wrote an excellent book about it, Oracle Perfomance by Design (and others have written article with the same name). You might want to read Tom Kyte's books, especially if you are coming from a SS perspective - there are many fairly basic things endemic in that community that are just plain wrong, people only do it that way because "that's how it is done." This winds up translating to a lack of scalability in applications (and many other problems - some people go so far as to say "best practices" are not). That is by no means limited to SS, we see this with java, OO proponents in the Oracle world too. Even now there are performance specialists advocating extreme programming, and they have to say most extreme programmers are doing it wrong to make it palatable to administrators dealing with the problems.
If you want to play, use Access. If you want to be a pro, you need to start from a strong foundation of fundamentals. If you think what John says sounds crazy, you really have a lot to learn, even if you stay completely SS.
You can blame Oracle for Solaris "problems," but remember, they preceded Oracle's involvement. Sun had its own ecosystem with its own basic entry requirements. Great things came out of there, while MS was foisting Windows 3.1 on the world.
jg
-- _at_home.com is bogus http://www.flickr.com/photos/joel_garry/4471965316/Received on Fri Jul 15 2011 - 11:45:19 CDT