Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: DBA Studio will not start

Re: DBA Studio will not start

From: Dusan Bolek <pagesflames_at_usa.net>
Date: 15 Nov 2001 00:53:53 -0800
Message-ID: <1e8276d6.0111150053.59585a9e@posting.google.com>


"Gary Turner" <gary.turner_at_sci.com> wrote in message news:<E5BI7.35354$lV4.4260535_at_e420r-atl1.usenetserver.com>...
> i created a new database and here is the init.ora file it created:
>
> also i have the creatdb.log at the bottom. is the all i need to look at or
> are there other things i need to check???
<Snipped>

You didn't mention the purpose of this database. However, your createdb.log together with init.ora doesn't make a sense to me. If this is just databse for same testing or learning Oracle, then your SGA size is far too big. If this should be a productional database (and I hope not !) then using only one tablespace and not mirroring your redo logs is asking for troubles. Having all control files on one drive is also extremely bad. Running database in NOARCHIVELOG is another usually not suitable solution.
Another thing is parameter "compatible = 8.1.0", if you're using 8.1.0 version then you should upgrade to 8.1.7.2, if you have newer version than 8.1.0, then there is usually no need to downgrade this parameter.

--
_________________________________________

Dusan Bolek, Ing.
Oracle team leader

Note: pagesflames_at_usa.net has been cancelled due to changes (maybe we
can call it an overture to bankruptcy) on that server. I'm still using
this email to prevent SPAM. Maybe one day I will change it and have a
proper mail even for news, but right now I can be reached by this
email.
Received on Thu Nov 15 2001 - 02:53:53 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US