Oracle Error 32000
Contents |
64 Bit - Single instance/local storage Issue: DB was started using spfile. ora-32000 write to spfile requested When I tried to modify certain parameters with scope=both/spfile clause,
Ora 32000 Asm
the following error message was received. ERROR at line 1: ORA-32000: write to SPFILE requested but SPFILE is not modifiable The description of the error message gave me following information Cause: An ALTER SYSTEM command or an internal self-tuning mechanism requested a write to the SPFILE but the SPFILE was not modifiable. Action :Perform an in-memory parameter update only I wanted to make the update happen in spfile and want the change to be persistent on next bounce. So planned to create pfile from spfile and add the required entries to the text file. Steps: SQL> create pfile from spfile; File created. I viewed the contents of the pfile which was just been created. It had only one line. *.spfile=/u01/app/oracle/product/11.2.0.3.0/database/spfiledev1.ora So I created pfile again by giving the full path as specified above SQL> create pfile from spfile='/u01/app/oracle/product/11.2.0.3.0/database/spfiledev1.ora'; File created. This time the file had all the entries as required by me. I updated the pfile with additional parameters required. SQL> startup nomount pfile='/u01/app/oracle/product/112030/dbs/initdev1.ora'; Verified that the modified parameters are available. Then created spfile again SQL> create spfile from pfile; File created. SQL> shutdown immediate SQL> startup The final startup was with spfile and all the changes I made was available after this. Posted by Satish V Chandran at 4:52 PM Email ThisBlogThis!Share to TwitterShare to FacebookShare to Pinterest No comments: Post a Comment Newer Post Older Post Home Subscribe to: Post Comments (Atom) Translate Google+ Followers Pages Home Search My Blog Total Pageviews Live Traffic Fe
CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have JavaScript enabled. This tool uses JavaScript and much of it will not work correctly without it enabled. Please turn JavaScript back on and reload this page. Please enter a title. You can not post a blank message. Please type your message and try again. More discussions in General Database Discussions All PlacesDatabaseGeneral Database Discussions This discussion is archived 5 Replies Latest reply on Jun 5, 2013 7:52 PM by Sharon ORA-32000: write to SPFILE requested but SPFILE is not modifiable Sharon Jun 4, 2013 8:31 PM Hello, I am not sure which category this question falls into. We are running 11G with ASM. In Enterprise Manager, I want to change the flash recovery area size. When I change the size, http://satishvchandran.blogspot.com/2014/06/ora-32000-write-to-spfile-requested-but.html the following error message is returned: ORA-32000: write to SPFILE requested but SPFILE is not modifiable. Any help would be greatly appreciated! Sharon 695Views Tags: none (add) 11gContent tagged with 11g, asmContent tagged with asm, spfileContent tagged with spfile This content has been marked as final. Show 5 replies 1. Re: ORA-32000: write to SPFILE requested but SPFILE is not modifiable TSharma-Oracle Jun 4, 2013 8:49 PM (in response to Sharon) Please see the MOS note; *ORA-32000 https://community.oracle.com/thread/2547049 not able to modify the rdbms spfile which is there in ASM [ID 1498307.1]* Like Show 0 Likes(0) Actions 2. Re: ORA-32000: write to SPFILE requested but SPFILE is not modifiable sybrand_b Jun 4, 2013 8:49 PM (in response to Sharon) ORA-32000: in Google 8000+ hits. Did you Google before making this request? ---------- Sybrand Bakker Senior Oracle DBA Like Show 0 Likes(0) Actions 3. Re: ORA-32000: write to SPFILE requested but SPFILE is not modifiable Sharon Jun 4, 2013 9:33 PM (in response to TSharma-Oracle) Hello, I am not sure where to find the note you mentioned. I am rather new at this and I am not really sure where to even start so that I can limit the problem down to a reasonable amount to search for. Sharon Like Show 0 Likes(0) Actions 4. Re: ORA-32000: write to SPFILE requested but SPFILE is not modifiable Osama_Mustafa Jun 4, 2013 10:41 PM (in response to Sharon) Sharon wrote: Hello, I am not sure where to find the note you mentioned. I am rather new at this and I am not really sure where to even start so that I can limit the problem down to a reasonable amount to search for. SharonYou can find this document --> https://support.oracle.com Did you read sybrand Reply ? it will solve your issue 1 person found this helpful Like Show 0 Lik
Management) and we want to add controlfile. https://dbacatalog.wordpress.com/2013/02/11/ora-32000-write-to-spfile-requested-but-spfile-is-not-modifiable/ 1) shutdown database with immediate option. shutdown immediate; 2) start database in nomount mode. startup nomount; 3) copy already existed controlfile to another location where you want to will be mirrored controlfile. . oraenv ORACLE_SID = [orcl] ? +ASM The Oracle base for ORACLE_HOME=/u0/app/oracle/grid is /u0/app/oracle -bash-3.2$ oracle error asmcmd ASMCMD> cp +data/orcl/controlfile/Current.260.805917717 +data/orcl/controlfile/control01.ctl ASMCMD> exit 4) change parameter control_files. . oraenv ORACLE_SID = [+ASM] ? orcl The Oracle base for ORACLE_HOME=/u0/app/oracle/product/11.2.0/dbhome_1 is /u0/app/oracle sqlplus / as sysdba SQL*Plus: Release 11.2.0.1.0 Production on Mon Feb 11 16:49:18 2013 Copyright (c) 1982, 2009, Oracle. All rights reserved. oracle error 32000 Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production With the Partitioning, Automatic Storage Management, OLAP, Data Mining and Real Application Testing options SQL> alter system set control_files='+DATA/orcl/controlfile/current.260.805917717', '+DATA/orcl/controlfile/control01.ctl' scope=spfile; alter system set control_files='+DATA/orcl/controlfile/current.260.805917717', '+DATA/orcl/controlfile/control01.ctl' scope=spfile * ERROR at line 1: ORA-32000: write to SPFILE requested but SPFILE is not modifiable There is question, What can we do? first of all check parameter spfile, for this : SQL> show parameter pfile; NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ spfile string /u0/app/oracle/product/11.2.0/ dbhome_1/dbs/spfileorcl.ora Bingo! This is reason! because we have ASM and spfile must use from ASM. 5) shutdown database; shutdown immediate; 6) delete this spfile from filesystem. rm -rf /u0/app/oracle/product/11.2.0/dbhome_1/dbs/spfileorcl.ora 7) Now we have /u0/app/oracle/product/11.2.0/dbhome_1/dbs/initorcl.ora file with content *.SPFILE='+DATA/orcl/spfileorcl.ora' and in ASM is +DATA/orcl/spfileorcl.ora file. 8) now we can change control_files parameter. SQL> startup nomount; ORACLE instance star