This discussion is archived
1 2 Previous Next 18 Replies Latest reply: Feb 19, 2013 1:21 PM by jgarry RSS

Unable so start 11G instance

967473 Newbie
Currently Being Moderated
Hi all,
I just installed Oracle version 11.1.0.6 on an older CentOS server (kernel 2.6.9-78.0.1.ELsmp). I made it through the install with no problems, but was unable to start the instance. I received the error:

SQL>startup mount
ORA-00845: MEMORY_TARGET not supported on this system

Hmm, weird I was able to install with no memory errors..

So I created a pfile from the spfile:
strings spfile > pfile.ora

Edited the newpfile to lower the MEMORY_TARGET parameter, and now:

SQL> create spfile from pfile='/usr/local/oracle/product/11.1.0.6/db_1/dbs/pfile.ora';
create spfile from pfile='/usr/local/oracle/product/11.1.0.6/db_1/dbs/pfile.ora'
*
ERROR at line 1:
ORA-01078: failure in processing system parameters
ORA-32003: error occured processing parameter 'processes'

My spfile is now gone!!

Any ideas would be greatly appreciated.
  • 1. Re: Unable so start 11G instance
    rp0428 Guru
    Currently Being Moderated
    >
    SQL>startup mount
    ORA-00845: MEMORY_TARGET not supported on this system

    Hmm, weird I was able to install with no memory errors..

    So I created a pfile from the spfile:
    strings spfile > pfile.ora

    Edited the newpfile to lower the MEMORY_TARGET parameter, and now:

    SQL> create spfile from pfile='/usr/local/oracle/product/11.1.0.6/db_1/dbs/pfile.ora';
    create spfile from pfile='/usr/local/oracle/product/11.1.0.6/db_1/dbs/pfile.ora'
    *
    ERROR at line 1:
    ORA-01078: failure in processing system parameters
    ORA-32003: error occured processing parameter 'processes'

    My spfile is now gone!!

    Any ideas would be greatly appreciated.
    >
    For starters stop doing things when you don't know what the result is going to be.

    The exception says 'MEMORY_TARGET not supported'. It doesn't say the value is too large. So why did you 'lower the MEMORY_TARGET parameter'?

    And if you have a PFILE why didn't you just try starting up the DB by using it? Why did you 'create spfile from pfile . . .'?

    What is the point of creating an SPFILE from a PFILE if the PFILE is invalid?

    You need to do things one step at a time. Where is your backup of the SPFILE? The first thing you should do after an install is take a backup and make a PFILE copy and a copy of the control files.

    What type of memory management did you configure? What other configuration options did you choose?
  • 2. Re: Unable so start 11G instance
    sb92075 Guru
    Currently Being Moderated
    964470 wrote:
    Hi all,
    I just installed Oracle version 11.1.0.6 on an older CentOS server (kernel 2.6.9-78.0.1.ELsmp). I made it through the install with no problems, but was unable to start the instance. I received the error:

    SQL>startup mount
    ORA-00845: MEMORY_TARGET not supported on this system

    Hmm, weird I was able to install with no memory errors..

    So I created a pfile from the spfile:
    strings spfile > pfile.ora

    Edited the newpfile to lower the MEMORY_TARGET parameter, and now:

    SQL> create spfile from pfile='/usr/local/oracle/product/11.1.0.6/db_1/dbs/pfile.ora';
    create spfile from pfile='/usr/local/oracle/product/11.1.0.6/db_1/dbs/pfile.ora'
    *
    ERROR at line 1:
    ORA-01078: failure in processing system parameters
    ORA-32003: error occured processing parameter 'processes'

    My spfile is now gone!!

    Any ideas would be greatly appreciated.
    post results from OS command below

    ls -ltr /usr/local/oracle/product/11.1.0.6/db_1/dbs/
  • 3. Re: Unable so start 11G instance
    967473 Newbie
    Currently Being Moderated
    -rw-r--r-- 1 oracle oinstall 8385 Sep 11 1998 init.ora
    -rw-r--r-- 1 oracle oinstall 12920 May 3 2001 initdw.ora
    -rw-rw---- 1 oracle oinstall 1552 Feb 18 16:14 hc_triton.dat
    -rw-r----- 1 oracle oinstall 24 Feb 18 16:15 lkTRITON
    -rw-r----- 1 oracle oinstall 1536 Feb 18 16:17 orapwtriton
    -rw-r--r-- 1 oracle oinstall 1033 Feb 18 16:35 pfile.ora
  • 4. Re: Unable so start 11G instance
    sb92075 Guru
    Currently Being Moderated
    964470 wrote:
    -rw-r--r-- 1 oracle oinstall 8385 Sep 11 1998 init.ora
    -rw-r--r-- 1 oracle oinstall 12920 May 3 2001 initdw.ora
    -rw-rw---- 1 oracle oinstall 1552 Feb 18 16:14 hc_triton.dat
    -rw-r----- 1 oracle oinstall 24 Feb 18 16:15 lkTRITON
    -rw-r----- 1 oracle oinstall 1536 Feb 18 16:17 orapwtriton
    -rw-r--r-- 1 oracle oinstall 1033 Feb 18 16:35 pfile.ora
    INTERESTING!

    on *NIX the ORACLE_SID is CaseSenSitive; "TRITON" does not equal "triton"

    what is the correct value for ORACLE_SID?

    post content from "pfile.ora" from above.

    post excerpt from alert logfile that shows from last successful startup to the present


    Handle:     964470
    Status Level:     Newbie
    Registered:     Oct 10, 2012
    Total Posts:     16
    Total Questions:     3 (3 unresolved)

    why so many unanswered questions?
  • 5. Re: Unable so start 11G instance
    967473 Newbie
    Currently Being Moderated
    I adjusted the MEMORY_TAREGT based on this:
    "duplicate definition"
    (And the size of /dev/shm needs to be greater than MEMORY_TARGET or MEMMORY_MAX_TARGET.)

    df -h:
    3.9G 2.4G 1.6G 61% /dev/shm

    MEMORY_TARGET in spfile = 4177526784
  • 6. Re: Unable so start 11G instance
    967473 Newbie
    Currently Being Moderated
    Pfile:

    triton.__db_cache_size=1946157056
    triton.__java_pool_size=16777216
    triton.__large_pool_size=16777216
    triton.__oracle_base='/usr/local/oracle'#ORACLE_BASE set from environment
    triton.__pga_aggregate_target=1677721600
    triton.__sga_target=2499805184
    triton.__shared_io_pool_size=0
    triton.__shared_pool_size=503316480
    triton.__streams_pool_size=0
    *.audit_file_dest='/usr/local/oracle/admin/triton/adump'
    *.audit_trail='db'
    *.compatible='11.1.0.0.0'
    *.control_files='/usr/local/oracle/oradata/
    triton/control01.ctl','/usr/local/oracle/oradata/triton/control02.ctl','/usr/local/oracle/oradata/triton/control03.ctl'
    *.db_block_size=8192
    *.db_domain='i-centrix'
    *.db_name='triton'
    *.db_recovery_file_dest='/usr/local/oracle/flash_recovery_area'
    *.db_recovery_file_dest_size=2147483648
    *.diagnostic_dest='/usr/local/oracle'
    *.dispatchers='(PROTOCOL=TCP) (SERVICE=tritonXDB)'
    *.local_listener='LISTENER_TRITON'
    *.memory_target=3177526784
    *.open_cursors=300
    *.processes=150
    *.remote_login
    _passwordfile='EXCLUSIVE'
    *.undo_tablespace='UNDOTBS1'

    echo $ORACLE_SID
    triton

    There has been no succesful startup.
  • 7. Re: Unable so start 11G instance
    rp0428 Guru
    Currently Being Moderated
    That thread has NOTHING to do with the question in this thread.
  • 8. Re: Unable so start 11G instance
    967473 Newbie
    Currently Being Moderated
    MEMORY_TARGET not supported on this system

    The last '5' was LEFT OFF.
  • 9. Re: Unable so start 11G instance
    sb92075 Guru
    Currently Being Moderated
    964470 wrote:
    Hi all,
    I just installed Oracle version 11.1.0.6 on an older CentOS server (kernel 2.6.9-78.0.1.ELsmp). I made it through the install with no problems, but was unable to start the instance. I received the error:
    you need to clarify the events above.
    If all you did was to install the Oracle software, then no database exists for you to STARTUP.
  • 10. Re: Unable so start 11G instance
    967473 Newbie
    Currently Being Moderated
    Advanced installation creates the DB, correct?
  • 11. Re: Unable so start 11G instance
    sb92075 Guru
    Currently Being Moderated
    964470 wrote:
    Advanced installation creates the DB, correct?
    post results from LONG RUNNING OS command below

    find / -name system01.dbf -ls 2>/dev/null
  • 12. Re: Unable so start 11G instance
    967473 Newbie
    Currently Being Moderated
    Is this what we are looking for:

    [oracle@triton triton]$ ls -ltr /usr/local/oracle/oradata/triton/system01.dbf
    -rw-r----- 1 oracle oinstall 723525632 Feb 18 19:03 /usr/local/oracle/oradata/triton/system01.dbf

    ?
  • 13. Re: Unable so start 11G instance
    sb92075 Guru
    Currently Being Moderated
    964470 wrote:
    Pfile:

    triton.__db_cache_size=1946157056
    triton.__java_pool_size=16777216
    triton.__large_pool_size=16777216
    triton.__oracle_base='/usr/local/oracle'#ORACLE_BASE set from environment
    triton.__pga_aggregate_target=1677721600
    triton.__sga_target=2499805184
    triton.__shared_io_pool_size=0
    triton.__shared_pool_size=503316480
    triton.__streams_pool_size=0
    *.audit_file_dest='/usr/local/oracle/admin/triton/adump'
    *.audit_trail='db'
    *.compatible='11.1.0.0.0'
    *.control_files='/usr/local/oracle/oradata/
    triton/control01.ctl','/usr/local/oracle/oradata/triton/control02.ctl','/usr/local/oracle/oradata/triton/control03.ctl'
    *.db_block_size=8192
    *.db_domain='i-centrix'
    *.db_name='triton'
    *.db_recovery_file_dest='/usr/local/oracle/flash_recovery_area'
    *.db_recovery_file_dest_size=2147483648
    *.diagnostic_dest='/usr/local/oracle'
    *.dispatchers='(PROTOCOL=TCP) (SERVICE=tritonXDB)'
    remove the 2 lines below
    *.local_listener='LISTENER_TRITON'
    *.memory_target=3177526784
    remove the 2 lines above
    *.open_cursors=300
    *.processes=150
    *.remote_login
    _passwordfile='EXCLUSIVE'
    *.undo_tablespace='UNDOTBS1'
    STARTUP PFILE='{revised_file_2lines_smaller}'
  • 14. Re: Unable so start 11G instance
    967473 Newbie
    Currently Being Moderated
    My new pfile (that works!):

    triton.__db_cache_size=1946157056
    triton.__java_pool_size=16777216
    triton.__large_pool_size=16777216
    triton.__oracle_base='/usr/local/oracle'#ORACLE_BASE set from environment
    triton.__pga_aggregate_target=1677721600
    triton.__sga_target=2499805184
    triton.__shared_io_pool_size=0
    triton.__shared_pool_size=503316480
    triton.__streams_pool_size=0
    *.audit_file_dest='/usr/local/oracle/admin/triton/adump'
    *.audit_trail='db'
    *.compatible='11.1.0.0.0'
    *.control_files='/usr/local/oracle/oradata/
    triton/control01.ctl','/usr/local/oracle/oradata/triton/control02.ctl','/usr/local/oracle/oradata/triton/control03.ctl'
    *.db_block_size=8192
    *.db_domain='i-centrix'
    *.db_name='triton'
    *.db_recovery_file_dest='/usr/local/oracle/flash_recovery_area'
    *.db_recovery_file_dest_size=2147483648
    *.diagnostic_dest='/usr/local/oracle'
    *.dispatchers='(PROTOCOL=TCP) (SERVICE=tritonXDB)'
    *.local_listener='LISTENER_TRITON'
    *.memory_target=3177526784
    *.open_cursors=300
    *.processes=150
    *.undo_tablespace='UNDOTBS1'

    I would like to create the spfile so I do not have to pass the pfile='pfile location':

    SQL> create spfile from pfile='/usr/local/oracle/product/11.1.0.6/db_1/dbs/pfile.ora';
    create spfile from pfile='/usr/local/oracle/product/11.1.0.6/db_1/dbs/pfile.ora'
    *
    ERROR at line 1:
    ORA-32002: cannot create SPFILE already being used by the instance

    Thank you very much.
1 2 Previous Next

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points