Startup Fails w/ ora-27123

After shutdown, 1st attempt to startup errors, 2nd always starts the database up.

There's lots of memory on that machine (5 gb). Any ideas what this problem might be?

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.

SQL> startup
ORA-27123: unable to attach to shared memory segment
Linux Error: 22: Invalid argument
Additional information: 1
Additional information: 1507331

SQL> startup
ORACLE instance started.

Total System Global Area 219746960 bytes
Fixed Size 451216 bytes
Variable Size 201326592 bytes
Database Buffers 16777216 bytes
Redo Buffers 1191936 bytes
Database mounted.
Database opened.

Additional Info:
SuSE SLE8 Linux
9.2.0.3

Don't do the 1st attempt, do the 2nd attemp first :)

Any way how much time(interval) between shutdown and first startup. May even after shutdown it takes some time to release the shared memory that was allocated to the Instance. Not so sure...

Also check this...

http://metalink.oracle.com/metalink/...&p_id=115753.1

Quote:

---

Originally posted by adewri
Don't do the 1st attempt, do the 2nd attemp first :)

---

ROTFL ! ! !

The machine has 5 gigabytes and no other instances or applications running on it. This shouldn't be a problem with releasing memory.

Here's something interesting. If I issue a "startup force" it'll startup right after a shutdown.

The plot thickens...