how oracle take effect on the new oracle configuration ?

Hi,

  When I installing MySQL, all configuration saved in a configuration file call my.cnf, but the problem is , whenever there are changes on that file and we need to restart the MySQL in order for change to take effect.

   How about Oracle ? need restart whenever there are changes ? how configuration store ?
LVL 1
marrowyungSenior Technical architecture (Data)Asked:
Who is Participating?
 
SujithConnect With a Mentor Data ArchitectCommented:
Some of the initialization parameters are modifiable while the database is up, some others need a restart, Have a read at -

https://docs.oracle.com/cd/E18283_01/server.112/e17120/create006.htm#i1010047

Have a look at the parameters modifiable at session/system/instance etc level at this link
https://docs.oracle.com/cd/B28359_01/server.111/b28320/dynviews_2085.htm#REFRN30176
0
 
Mark GeerlingsConnect With a Mentor Database AdministratorCommented:
Oracle uses a parameter file to store this information.  In older versions of Oracle this was a plain-text file (called a "pfile") that was stored in the dbs sub-directory of the Oracle_home.  Oracle12 can still use that, but in Oracle11 and 12, the default is an "spfile" that is either in this same location, or in ASM, if you use ASM for your database.  This "spfile" contains some binary characters, so it is not directly editable.  You use "alter system ..." commands with either the "scope=spfile" or "scope=both" options to have Oracle write the new value to the spfile.

And as Sujith indicated, some of these Oracle parameters can be changed dynamically while the database is open.  Others require a database shutdown and restart.

You can use a query like this in Oracle to see which parameters can be changed dynamically, and which ones require a restart:
(Those with "FALSE" in the last column require a database restart.)

select substr(name,1,30) "Parameter", substr(value,1,45) "Value", isdefault,
isses_modifiable "Session", issys_modifiable "System"
from v$parameter
order by name;
0
 
marrowyungSenior Technical architecture (Data)Author Commented:
tks all
0
 
SujithData ArchitectCommented:
You are welcome.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.