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

Most probably related to this reported problem in Metalink (1019649.102). See that for more details.

Basically, it might be your kernel parameters are not large enough for your init.ora settings. Use ulimit to check or set if necessary.

HTH Alexander Skwar <from_at_alexander.skwar.name> wrote in message news:<1kred6icikho6.dlg_at_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
Received on Mon Jun 21 2004 - 09:43:23 CDT