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 -> Cannot "startup nomount" an idle instance (8i)

Cannot "startup nomount" an idle instance (8i)

From: Alexander Skwar <from_at_alexander.skwar.name>
Date: Mon, 21 Jun 2004 12:47:56 +0200
Message-ID: <1kred6icikho6.dlg@a.skwar.digitalprojects.com>


Hello!

On one of "my" Oracle 8i servers running on HP-UX 11.00, I've got the problem that I cannot "startup nomount" an idle instance.

I'm executing the following script:

######################################################################
#!/bin/sh

ORACLE_SID=NewTest
export ORACLE_SID

/u00/opt/oracle/product/8.1.7/bin/sqlplus /nolog @/tmp/mickrig.sql
######################################################################

/tmp/mickrig.sql:
######################################################################
connect SYS/change_on_install as SYSDBA
startup nomount
exit;
######################################################################

initNewTest.ora:
######################################################################

db_name=NewTest
db_files = 80
db_file_multiblock_read_count = 8
db_block_buffers = 100

shared_pool_size = 3500000
log_checkpoint_interval = 10000
processes = 50
parallel_max_servers = 5
log_buffer = 32768
max_dump_file_size = 10240
global_names = TRUE
control_files = (ora_control1, ora_control2)
######################################################################

When I run the shell script, I get:

######################################################################
SQL*Plus: Release 8.1.7.0.0 - Production on Mon Jun 21 12:45:24 2004

(c) Copyright 2000 Oracle Corporation. All rights reserved.

Connected to an idle instance.
ORA-24323: value not allowed
ORA-03113: end-of-file on communication channel Disconnected
######################################################################

What's oracle trying to tell me with ora-24323? Which value is not allowed?

When I run this mini script with the same init.ora on a different 8i server, everything works as expectd - that is, the instance is up in nomount mode.

Any ideas about what's going wrong?

Thanks a lot,

Alexander Skwar

-- 
printk("; corrupted filesystem mounted read/write - your computer 
        will explode within 20 seconds ... but you wanted it so!\n");
        2.4.3 linux/fs/hpfs/super.c
Received on Mon Jun 21 2004 - 05:47:56 CDT

Original text of this message

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