The file naming conventions as default: init $ORACLE_SID.ora (Unix environment) init%ORACLE_SID%.ora (Windows environment) default to put it in the following directory $ORACLE_HOME / DBS (Unix)%ORACLE_HOME% / DATABASE (Windows) in the parameter file does not have to be placed at the specified location.
Start an instance when the start command using the pfile = filename option to set the location.But the document has two shortcomings: 1,Monster Beats Studio, the parameter file must be placed in the start database on the client machine,Dr Dre Headphones, causes the parameter file of large area “ &rdquo reproduction;, not easy to maintain; 2, to permanently modify a parameter, light with the alter system command to modify the parameters can not,Beats By Dr Dre, must also ensure that to start the database of all parameter files have been manually update; so Oracle introduced a server parameter file (Server parameter file, SPFILE), the file must be placed in service in the host itself, can be used as the sole source of information database parameters.
In addition alter system command can write values SPFILE,Coach Outlet Online, do not need to manually locate and maintain all parameter file.So do not have to consider these issues,Dr Dre Headphones, using SPFILE to set up your database.
Related articles：
没有评论:
发表评论