• ORA-32001: write to SPFILE requested but no SPFILE specified at startup


    SQL> alter system set  sga_max_size=2048M scope=spfile;
    alter system set  sga_max_size=2048M scope=spfile
    *
    ERROR at line 1:
    ORA-32001: write to SPFILE requested but no SPFILE specified at startup

    SQL> show parameter spfile;

    NAME                                 TYPE        VALUE
    ------------------------------------ ----------- ------------------------------
    spfile                               string

    SQL> create spfile from pfile;

    File created.

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

    Total System Global Area 1068937216 bytes
    Fixed Size                  2166536 bytes
    Variable Size             427819256 bytes
    Database Buffers          624951296 bytes
    Redo Buffers               14000128 bytes
    Database mounted.
    Database opened.
    SQL> alter system set sga_max_size=2048M scope=spfile;

    System altered.

    SQL> alter system set sga_target=2048M scope=spfile;

    System altered.

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

    Total System Global Area 2137886720 bytes
    Fixed Size                  2161400 bytes
    Variable Size             469763336 bytes
    Database Buffers         1644167168 bytes
    Redo Buffers               21794816 bytes
    Database mounted.
    Database opened.
    SQL> show parameter sga;

    NAME                                 TYPE        VALUE
    ------------------------------------ ----------- ------------------------------
    lock_sga                             boolean     FALSE
    pre_page_sga                         boolean     FALSE
    sga_max_size                         big integer 2G
    sga_target                           big integer 2G

  • 相关阅读:
    模块和包
    mysql视图、存储过程等
    mysql 索引
    sql语句
    HTTP协议
    Django中的form组件
    数据结构
    一些常用函数
    C/C++中tag和type
    什么是compile-time-constant
  • 原文地址:https://www.cnblogs.com/quanweiru/p/4053316.html
Copyright © 2020-2023  润新知