Re: 9.0.1 Install errors - Help?

"Mark Brandyberry" <mdbrandy_at_uiuc.edu> wrote in message news:Ef3H9.1276$Vf3.14957_at_vixen.cso.uiuc.edu...
> I had been installing it under an account I had made that I had added to
the
> local administrator group. Just for grins, this morning I logged in under
> the "administrator" account, and tried making a DB again, using the DB
> Config Assistant. No joy - same error. At the time of the error, there
is
> 2.6 GB left on the drive, so it doesn't seem to be a space problem (the
> entire installed DB is under 1 GB when it's done).

If I remember correctly, you need 2.83GB for an Enterprise Edition install. So I think that space most definitely is the issue.

As to how you resize the datafiles (as you asked in another post)... it's the penultimate screen, just before you see the one where the 'create database' option is ticked. On the left-hand side of the screen, it lists all the controlfiles, datafiles and redo logs it is going to create. Each entry has a little '+' next to it, which if clicked expands the tree so you can see exactly what you're about to get.

If you click on any of the datafiles or redo logs listed there, the right-hand panel displays its size and so on, which you can modify as you like.

However, you can only do such adjustments if you selected to create a 'New Database': if you opted to install one of Oracle's template databases (Data Warehouse, OLTP, or General) then the file sizes are fixed because the install simply clones them from its templates.

I've also mentioned this several times before: don't ever select to create a database as part of the install of Oracle itself. Do a 'Software Only' install, and create the database afterwards as a separate exercise, using the Database Configuration Assistant. The amount of swap needed to do a combined install/create seems to be much bigger than that needed for an install followed by a create.

Regards
HJR
>The installer seems to
> be making the directories of interest with "full control" privileges for
> "everyone", so it doesn't look like a permissions problem with the folder
> that has the .DBF file in question. Hmm. This is frustrating. Maybe I
> should reinstall the entire thing under the administrator account. Don't
> see why that'd work, though, since the account I used to install it is a
> member of the administrator group.
>
> Thanks for any ideas.
>
> Mark
>
> "Norman Dunbar" <Norman.Dunbar_at_lfs.co.uk> wrote in message
> news:E2F6A70FE45242488C865C3BC1245DA702FF2378_at_lnewton.leeds.lfs.co.uk...
> > Mark,
> >
> > a few questions that may help :
> >
> > - are you installing as an administrator user - or local admin, or power
> > user ?
> >
> > - do you have correct privs to the folders in question ? I believe the
> > install manual mentions the correct prive to have on the data file
> > locations and also for the softweare locations.
> >
> > - is there enough disc space available to create the files - the
> > ORA-27046 error indicates that the file has been truncated or partially
> > overwritten. It could also indicate it is only half created - but I'd
> > expect another error about being out of space.
> >
> > I installed 9.2.0 myself on a Win 2000 Professional PC only last week
> > and had no problems - I was logged in as administrator to do it though -
> > because the instructions say so :o) I don't have these problems on my
> > Unix boxes though ....
> >
> > The create controlfile fail is the main problem I'd say - without it,
> > you are usually up that famous creek without a canoe, never mind a
> > paddle. Track down the reason for not being able to create it, and you
> > are well on your way to fixing the rest of the problems - all of which
> > relate back to not having a Control file.
> >
> > Howard may well chip in with more info when Australia wakes up, Morning
> > Howard, because he deals more with Windows that the rest of us :o)
> >
> > This might help, might not - good luck.
> >
> > Cheers,
> > Norman.
> >
> > -------------------------------------
> > Norman Dunbar
> > Database/Unix administrator
> > Lynx Financial Systems Ltd.
> > mailto:Norman.Dunbar_at_LFS.co.uk
> > Tel: 0113 289 6265
> > Fax: 0113 289 3146
> > URL: http://www.Lynx-FS.com
> > -------------------------------------
> >
> >
> >
> >
> >
> > -----Original Message-----
> > From: Mark Brandyberry [mailto:mdbrandy_at_insightbb.com]
> > Posted At: Tuesday, December 03, 2002 5:31 AM
> > Posted To: server
> > Conversation: 9.0.1 Install errors - Help?
> > Subject: 9.0.1 Install errors - Help?
> >
> >
> > OK, I have two separate Win2000 machines that I've tried to install
> > Oracle
> > Enterprise 9.0.1 on now, and I'm getting the same weird errors. One of
> > the
> > machines is Win2000 Pro, and one is Win2000 Advanced Server. I get
> > through
> > the entire installation up to running the Database Configuration
> > Assistant.
> > While it tries to make the database, it gets to the "Creating and
> > starting
> > Oracle instance" stage, and then the errors start. First, I get:
> >
> > SNIP.
> >
>
>
Received on Tue Dec 03 2002 - 13:16:12 CST