• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
  • Skip to footer navigation

The Geek Diary

  • OS
    • Linux
    • CentOS/RHEL
    • Solaris
    • Oracle Linux
    • VCS
  • Interview Questions
  • Database
    • oracle
    • oracle 12c
    • ASM
    • mysql
    • MariaDB
  • DevOps
    • Docker
    • Shell Scripting
  • Big Data
    • Hadoop
    • Cloudera
    • Hortonworks HDP

How to change static parameters through SPFILE parameter file in Oracle Database

by admin

Question: We need to change a static parameter value in the SPFILE used at instance startup, but we get the following error message:

SQL> alter system set audit_trail=DB scope=both; 
                 * 
ERROR at line 1: 
ORA-02095: specified initialization parameter cannot be modified

According to the definition of a static parameter, it cannot be modified during instance life, but only in the init or spfile parameter file. SCOPE=BOTH applies the modification at the instance level and in the spfile used at startup. Use the value that applies the modification in the spfile only, provided that the spfile was used at startup:

SQL> alter system set audit_trail=DB scope=spfile;
System altered.

If no spfile was used at startup, you would get another error message such as:

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

Filed Under: oracle

Some more articles you might also be interested in …

  1. How to Convert RAC One Node Database to RAC (and Oracle RAC One Node to RAC database)
  2. How to find daily and hourly archive log generation in Oracle Database
  3. How to drop and recreate TEMP Tablespace in Oracle
  4. ORA-01031 When Compiling A Synonym
  5. How to use dbms_metadata.get_ddl to get Complete DDL for database objects
  6. Oracle Database: How to catalog tape backup pieces
  7. What are the implications of rebuilding indexes in Oracle Database
  8. Oracle Database 19c: RMAN-06012: channel: d1 not allocated
  9. How to get datafile information when PDB is Mounted/Read-Write/Restricted Mode
  10. Declaring PL/SQL Variables

You May Also Like

Primary Sidebar

Recent Posts

  • vgextend Command Examples in Linux
  • setpci command – configure PCI device
  • db_load command – generate db database
  • bsdtar command – Read and write tape archive files

© 2022 · The Geek Diary

  • Archives
  • Contact Us
  • Copyright