ORA-02095: specified initialization parameter cannot be modified

After identifying that the registered control files are incorrect (after receiving the ORA-00205: error in identifying control file, check alert log for more info error) though after executing the system set control files, I would receive and ORA-02095: specified initialization parameter cannot be modified error
May 30, 2014
OIM-11gR2-PS2
E_WARNING Error in file posts.php at line 313: fopen(http://www.technicalconfessions.com/images/postimages/postIcons/pp277.png): failed to open stream: HTTP request failed! HTTP/1.1 404 Not Found E_WARNING Error in file posts.php at line 313: fclose() expects parameter 1 to be resource, boolean given
ORA-02095: specified initialization parameter cannot be modified

When trying to initiate the DB instance, I would receive the following error:
June 16, 2014
Oracle-Databases
E_WARNING Error in file posts.php at line 313: fopen(http://www.technicalconfessions.com/images/postimages/postIcons/pp288.png): failed to open stream: HTTP request failed! HTTP/1.1 404 Not Found E_WARNING Error in file posts.php at line 313: fclose() expects parameter 1 to be resource, boolean given

ERROR at line 1: ORA-02095: specified initialization parameter cannot be modified

I would run the 'SQL show parameter control_files

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
control_files string /home/oracle/app/oracle/product/11.2.0/dbhome_1/dbs/ora_control1, /home/oracle/app/oracle/product/11.2.0/dbhome_1/dbs/ora_control2

You can see that the control_files are not pointing to the correct location
Actual locations
/home/oracle/app/oracle/oradata/orcl/control01.ctl
/home/oracle/app/oracle/flash_recovery_area/orcl/control02.ctl

ls -la /home/oracle/app/oracle/product/11.2.0/dbhome_1/dbs/ora_control1
/home/oracle/app/oracle/product/11.2.0/dbhome_1/dbs/ora_control2

So I tried altering the control files...

ALTER SYSTEM SET control_files='/home/oracle/app/oracle/oradata/orcl/control01.ctl','/home/oracle/app/oracle/flash_recovery_area/orcl/control02.ctl'
ALTER SYSTEM SET control_files='/home/oracle/app/oracle/oradata/orcl/control01.ctl'

-- Now i'm getting the following error

SQL ALTER SYSTEM SET control_files='/home/oracle/app/oracle/oradata/orcl/control01.ctl','/home/oracle/app/oracle/flash_recovery_area/orcl/control02.ctl'
2 ;
ALTER SYSTEM SET control_files='/home/oracle/app/oracle/oradata/orcl/control01.ctl','/home/oracle/app/oracle/flash_recovery_area/orcl/control02.ctl'
*
ERROR at line 1:
ORA-02095: specified initialization parameter cannot be modified

So I tried this...

ALTER SYSTEM SET control_files='/home/oracle/app/oracle/oradata/orcl/control01.ctl','/home/oracle/app/oracle/flash_recovery_area/orcl/control02.ctl' scope=spfile;

Then this...

ALTER SYSTEM SET control_files='/home/oracle/app/oracle/oradata/orcl/control01.ctl' scope=spfile;

Still getting..

ERROR at line 1: ORA-02095: specified initialization parameter cannot be modified


SOLUTION

I was able to create a new SPFILE from the PFILE, which allowed me to initiate the startup

CREATE SPFILE FROM PFILE='/home/oracle/app/oracle/product/11.2.0/dbhome_1/dbs/initorcl11gR2.ora';

Then I was able to connect...

[oracle@localhost dbs]$ sqlplus sys/Password1@localhost.localdomain:1521/ORCL as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Thu May 29 11:57:57 2014

Copyright (c) 1982, 2009, Oracle. All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL

About the author

Daniel is a Technical Manager with over 10 years of consulting expertise in the Identity and Access Management space.
Daniel has built from scratch this blog as well as technicalconfessions.com
Follow Daniel on twitter @nervouswiggles

Comments

Other Posts

ForgeRock OpenIDM - InvalidCredentialException: Remote framework key is invalid

ICFIDMOpenIDMOpenICF

November 8, 2017
Created by: Daniel Redfern
In the past, the similar error occurred though for the Oracle Identity Management solution. invalidcredentialexception remote framework key is invalid Because they all share the ICF connector framework, the error/solution would be the same.
Read More...

org.forgerock.script.exception.ScriptCompilationException: missing ; before statement

IDMsync.confforgerockopenidm

November 8, 2017
Created by: Daniel Redfern
org.forgerock.script.exception.ScriptCompilationException: missing ; before statement
Read More...

ForgeRock IDM - org.forgerock.script.exception.ScriptCompilationException: missing ; before statemen

OpenIDMsync.confForgeRock

September 17, 2017
Created by: Daniel Redfern
ForgeRock IDM - org.forgerock.script.exception.ScriptCompilationException: missing ; before statement
Read More...

Caused by: org.forgerock.json.resource.BadRequestException: Target does not support attribute groups

OpenIDMForgeRockICFConnector

September 17, 2017
Created by: Daniel Redfern
When performing the attempt of a reconciliation from ForgeRock IDM to Active Directory, I would get the following error
Read More...

ForgeRock OpenIDM - InvalidCredentialException: Remote framework key is invalid

OpenIDMForgeRockICFConnectorAD

September 17, 2017
Created by: Daniel Redfern
In the past, the similar error occurred though for the Oracle Identity Management solution. invalidcredentialexception remote framework key is invalid Because they all share the ICF connector framework, the error/solution would be the same.
Read More...

ERROR Caused by com.google.api.client.auth.oauth2.TokenResponseException 400 Bad Request - invalid_g

OpenIDMIDMGoogleGoogle-AppsICFreconciliation

September 12, 2017
Created by: Daniel Redfern
During the reconcilation from OpenIDM to the ICF google apps connector, the following error response would occur. ERROR Caused by com.google.api.client.auth.oauth2.TokenResponseException 400 Bad Request - invalid_grant
Read More...

forgerock-openidm-encryptedjwt-error

OpenIDMIDMForgeRockJWTIAM

August 29, 2017
Created by: Daniel Redfern
Received the JWT error
Read More...

Unexpected character ('¾' (code 190)): expected a valid value

ForgeRock-OpenIDMOpenIDMIDMKeystore

June 25, 2017
Created by: Daniel Redfern
Unexpected character occurred when the IP addresses changes and the virtual instance was migrated into a separate network subnet.
Read More...
E_WARNING Error in file posts.php at line 464: fopen(http://www.technicalconfessions.com/images/postimages/postIcons/pp444.png): failed to open stream: HTTP request failed! HTTP/1.1 404 Not Found E_WARNING Error in file posts.php at line 464: fclose() expects parameter 1 to be resource, boolean given

OpenDJ Error - Connect Error Result Code: 91 (Connect Error)

OpenDJLDAPldapsearchForgeRock

June 5, 2017
Created by: Daniel Redfern
When trying to connect, I would then receive the following error "Connect Error Result Code: 91 (Connect Error)"
Read More...

Tomcat NioEndpoint$SocketProcessor.doRun java.lang.NullPointerException error

TomcatJava-8PKICAS

June 5, 2017
Created by: Daniel Redfern
When initiating the Tomcat instance, the cas-stderr log file will log a SEVERE error logging multiple times every few seconds
Read More...