• 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. Understanding Dynamic Oracle Net Server Tracing
  2. Oracle Dataguard 12c: How to perform Switchover using DGMGRL
  3. How to install and configure Oracle ASMLIB on Native Linux multipath mapper devices
  4. What is a FACTLESS FACT TABLE? Where we use Factless Fact
  5. Oracle Database : What Is The Search Order For The LDAP.ORA File
  6. RMAN ‘Duplicate From Active Database’ Feature in Oracle 11g
  7. IN and EXISTS SQL Operator
  8. List of Operating System Processes Started by the OMS
  9. Script to monitor RMAN Backup and Restore Operations
  10. Cron Script does not Execute as Expected from crontab – Troubleshoot

You May Also Like

Primary Sidebar

Recent Posts

  • qm Command Examples in Linux
  • qm wait Command Examples in Linux
  • qm start Command Examples in Linux
  • qm snapshot Command Examples in Linux

© 2023 · The Geek Diary

  • Archives
  • Contact Us
  • Copyright