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

The Geek Diary

CONCEPTS | BASICS | HOWTO

  • OS
    • Linux
    • CentOS/RHEL
    • Solaris
    • Oracle Linux
    • Linux Services
    • VCS
  • Database
    • oracle
    • oracle 12c
    • ASM
    • mysql
    • MariaDB
    • Data Guard
  • DevOps
    • Docker
    • Shell Scripting
  • Interview Questions
  • 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. Oracle RMAN : Block-Level Media Recovery (Basics and Example)
  2. Threaded_execution=true Prevents OS Login As Sysdba in Oracle Database 12c
  3. Oracle Database : How to set Environment Variables Using Srvctl
  4. Oracle Database Interview Questions : Redo Logs and Archiving
  5. Oracle Database Environment Variables and Their Functions
  6. Oracle Interview Questions – Flash Recovery Area
  7. Oracle Database interview questions – Privileges And Roles
  8. New Connections to the Database lead to ORA-12518 or TNS-12518
  9. Oracleasm Service Fails to Start After Upgrade to oracleasm-support-2.1.11-1 RPM Package
  10. Troubleshooting Common ORA-1157 Errors (cannot identify/lock data file)

You May Also Like

Primary Sidebar

Recent Posts

  • Unable to export realm protected table using data pump
  • Beginners Guide to Oracle Database Vault
  • How to Disable IPv6 on Ubuntu 18.04 Bionic Beaver Linux
  • How to Capture More Logs in /var/log/dmesg for CentOS/RHEL
  • Archives
  • Contact Us
  • Copyright

© 2021 · The Geek Diary