9i startup nomount

[ocp2b]

I am in the process of "evaluating" 9i. In other words, I am seeing where my 8i scripts will break due to server manager and internal/manager going away. While in the process of doing this, I noticed that the startup nomount command in 9i is taking an unusually long time to complete. Does anyone know what would cause startup nomount to take a long time. By a long time, I mean 5 to 7 minutes where as under 8i it would take about 1 minute. Here is some background:

Win2000 machine, p3, 1.1Ghz, 326 meg memory, standalone machine. I cleaned the machine of 8i, rebooted, installed 9i from the CD's and now I am trying to create a database.
Below is a copy of my init.ora file.

Thanks for any help you can provide.



*** INIT FILE ****


DB_BLOCK_SIZE = 4096
OPEN_CURSORS=300
NLS_DATE_FORMAT='MM/DD/YYYY'

DB_FILE_MULTIBLOCK_READ_COUNT = 32 DB_BLOCK_BUFFERS = 4000

SHARED_POOL_SIZE = 20000000 SHARED_POOL_RESERVED_SIZE = 2000000
LOG_CHECKPOINT_INTERVAL = 5000000 LOG_CHECKPOINT_TIMEOUT = 1800
PROCESSES = 224 DML_LOCKS = 96

DB_NAME = SENDERO9

CONTROL_FILES = (C:\SV-ora92\SENDERO\ADM\SENDCTL.ORA,
C:\SV-ora92\MIRROR\ADM\SENDCTL.ORA)

REMOTE_LOGIN_PASSWORDFILE = SHARED

GLOBAL_NAMES = TRUE

COMPATIBLE = 9.1.0

MAX_DUMP_FILE_SIZE = 10240

BACKGROUND_DUMP_DEST=%SVORANT%\Oracle9\Ora91\RDBMS\TRACE

USER_DUMP_DEST=%SVORANT%\Oracle9\Ora91\RDBMS\TRACE

SORT_AREA_SIZE = 1024000
SORT_AREA_RETAINED_SIZE = 512000

OPTIMIZER_MODE=RULE
PRE_PAGE_SGA=YES

LOG_CHECKPOINTS_TO_ALERT=YES
LOG_BUFFER=256000

INSTANCE_NAME=SEND9
SERVICE_NAMES=SEND9

[mike2000]

where is your undo ts????

[ocp2b]

At this point in time, I haven't created a database yet. This is the command I use to create a database:

CONNECT / as sysdba;

startup nomount pfile=c:\sv-ora92\scripts\inittemp9.ora;

Create database testdb9 ....

(the initemp9.ora is what I pasted in my previous entry).

The startup nomount command is what is taking a long time.

[sambavan]

My suggestion to you would be that to invoke the database configuration assistant (dbca) and put in your parameters and then save that to a file and then when you start the database, point the start up to that file. Remember 9i uses another file call spfile.

Sam