Re: 9.0.1 Install errors - Help?

Well, I've at least identified the problem. I realized that on the WinXP installation that worked (but was just a "play with" installation), I chose "Data Warehouse" as the database template in DB Config Assistant. On the Win2000 installations that have been failing, I have been choosing "general use". So, I just went back and chose data warehouse on the Win2000 instance, and it worked fine. Thus, I must assume that the general use template that gets installed with Oracle 9.0.1 is hosed. I don't know enough about the differences at this point to know where to look, so I guess I'll just go with this for now.

Glad to hear any thoughts about why the general use template fails...

Thanks.

Mark

"Mark Brandyberry" <mdbrandy_at_insightbb.com> wrote in message news:KkXG9.213274$WL3.75164_at_rwcrnsc54...
> 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:
>
> ORA-01503: CREATE CONTROLFILE failed.
>
> Then, I get:
>
> ORA-01565: error in identifying file

'e:\oracle\oradata\homeDB\UNDOTBS01.DBF
>
> But, that file IS there. However, next I get:
>
> ORA-27046: file size is not a multiple of logical block size
>
> and,
>
> ORA-00210: cannot open the specified controlfile
>
> obviously, since it wasn't created.
>
> There are a few other errors, and if I ignore them all, the database
starts
> fine, but won't mount since there are no control files. I'm installing a
> vanilla database, and I didn't change any of the configuration parameters,
> didn't unselect any of the default options to install, and I've tried
using
> several different DB names, SIDs, etc. Same errors every time. On an
WinXP
> Pro machine, I installed it all fine. Is there something I need to know
> about installing on Win2000? Note that I am using 9.0.1 because our
> university has a site license, and this is the version that is available
so
> far. Note that I tried running the Database config assistant by itself
> after the install was done - deleted the database that it had made, and
> tried to make another. Same errors again. Any Oracle gurus (or novices
for
> that matter) have any ideas? FYI, the CloneDBCreation.log file output is
> copied in below, in case it helps. I'm not experienced enough to see
> anything from it. Also, the UNDOTBS01.DBF file is 209,719,291 bytes,
since
> this seems to be what it doesn't like. How would I control this?
>
> Thanks.
>
> Mark
>
> ****************************************************************
>
> ORACLE instance started.
> Total System Global Area 118255568 bytes
> Fixed Size 282576 bytes
> Variable Size 83886080 bytes
> Database Buffers 33554432 bytes
> Redo Buffers 532480 bytes
> Create controlfile reuse set database homeDB
> *
> ERROR at line 1:
> ORA-01503: CREATE CONTROLFILE failed
> ORA-01565: error in identifying file
> 'e:\oracle\oradata\homeDB\UNDOTBS01.DBF'
> ORA-27046: file size is not a multiple of logical block size
> OSD-04012: file size mismatch (OS 209719291)
>
>
> BEGIN dbms_backup_restore.zerodbid(0); END;
>
> *
> ERROR at line 1:
> ORA-00210: cannot open the specified controlfile
> ORA-06512: at "SYS.X$DBMS_BACKUP_RESTORE", line 2950
> ORA-06512: at line 1
>
>
> ORA-01507: database not mounted
>
>
> ORACLE instance shut down.
> ORACLE instance started.
> Total System Global Area 118255568 bytes
> Fixed Size 282576 bytes
> Variable Size 83886080 bytes
> Database Buffers 33554432 bytes
> Redo Buffers 532480 bytes
> Create controlfile reuse set database homeDB
> *
> ERROR at line 1:
> ORA-01503: CREATE CONTROLFILE failed
> ORA-01565: error in identifying file
> 'e:\oracle\oradata\homeDB\UNDOTBS01.DBF'
> ORA-27046: file size is not a multiple of logical block size
> OSD-04012: file size mismatch (OS 209719291)
>
>
> alter database homeDB open resetlogs
> *
> ERROR at line 1:
> ORA-01507: database not mounted
>
>
> alter database rename global_name to homeDB.brandyberry.net
> *
> ERROR at line 1:
> ORA-01109: database not open
>
>
> ALTER TABLESPACE TEMP ADD TEMPFILE 'e:\oracle\oradata\homeDB\TEMP01.DBF'
> REUSE
> *
> ERROR at line 1:
> ORA-01109: database not open
>
>
> Connected.
>
>
Received on Tue Dec 03 2002 - 11:47:57 CST