Startup Fails w/ ora-27123
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Startup Fails w/ ora-27123

  1. #1
    Join Date
    Mar 2002
    Location
    Mesa, Arizona
    Posts
    1,204

    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
    "I do not fear computers. I fear the lack of them." Isaac Asimov
    Oracle Scirpts DBA's need

  2. #2
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    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...
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  3. #3
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  4. #4
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    Originally posted by adewri
    Don't do the 1st attempt, do the 2nd attemp first
    ROTFL ! ! !

  5. #5
    Join Date
    Mar 2002
    Location
    Mesa, Arizona
    Posts
    1,204
    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...
    "I do not fear computers. I fear the lack of them." Isaac Asimov
    Oracle Scirpts DBA's need

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width