This discussion is archived
1 2 Previous Next 18 Replies Latest reply: Feb 19, 2013 1:21 PM by jgarry Go to original post RSS
  • 15. Re: Unable so start 11G instance
    sb92075 Guru
    Currently Being Moderated
    >
    My new pfile (that works!):
    same content as before?
    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.
    It appears that you & Oracle disagree about reality.
    Good Luck at avoiding future errors!
  • 16. Re: Unable so start 11G instance
    967473 Newbie
    Currently Being Moderated
    These 2 lines were removed:

    *.remote_login
    _passwordfile='EXCLUSIVE'

    Give a newb a break, huh?
  • 17. Re: Unable so start 11G instance
    EdStevens Guru
    Currently Being Moderated
    964470 wrote:
    My new pfile (that works!):
    <snip>
    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
    The solution should be self-evident. Create the spfile while the instance is shut down or is running from the pfile.
    export ORACL_SID=triton
    sqlplus / as sysdba
    sql> shutdown immediate
    sql> create spfile from pfile='the-pfile-you-modified-according-to-previous-instructions'
    sql> startup
    sql> show parameter spfile
    Thank you very much.
  • 18. Re: Unable so start 11G instance
    jgarry Guru
    Currently Being Moderated
    Also your tmpfs may be too small (though I don't really know if it applies to your configuration). See http://www.oracle-base.com/articles/11g/automatic-memory-management-11gr1.php
1 2 Previous Next

Legend

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