In this tutorial, we shall discuss verifying and testing your oracle database backups. And contain the database initialization parameters. If you already have a commercial license, you should download your software from the oracle software delivery cloud, which is specifically designed for customer fulfillment. Oracle pfile and spfile for parameters life after coffee. Even if we validated the file it would not assure us it would be there during the next startup or that it would even be an spfile you cannot use the 8i client as it is obviously spfile. Oracles traditional method of storing parameters in the init. In the previous blog post, to the question where is the asm spfile i answered by running asmcmd spget. For each modification we need to restart the profile for change replications. The pfile until oracle 8i, we were using a text file called the pfile parameter file for setting the database initialization parameters.
Oracle software configuration files tnsnames,sqlnet etc pre9i, init. This morning, i was wondering how asm instance could be started if the spfile is stored inside asm disk. Database spfile and oracle net configuration file samples. Either, the database uses the pfile or the spfile to determine its initialization. Server parameter files are binary files that exist only on the server and are called from client locations to start up the database. Ora file has given way to a more robust method the server parameter file spfile. Changes which are applied to the instance parameters. I do not see this glitch preventing anything from working. Ora file, but starting from oracle 9i and up, oracle corp. Until oracle 8i, we were using a text file called the pfile parameter file for setting the database initialization parameters.
The starter database contains one database initialization response file. The oracle instance reads the parameter file during startup which are then used. We will be explaining concepts such as what, why and how about database backups and methods to test the backup. Oracles graalvm, a universal virtual machine that runs apps written in java and other languages, has carved out a spot in the. Here is a bit from metalink discussing the differences. I will answer the second part of your question first the difference between spfile and pfile.
Oracles graalvm finds its place in java app ecosystem. A spfile doesnot need a local copy of the pfile to start oracle from a remote machine. By default, a new oracle database will be working on a pfile, so the spfile must be created from the pfile at the sql prompt. But this is available only if the asm instance is started. We are aware of the initialization parameter file also referred as init. If you have corrupted your spfile and its easy to do it you can start with a local pfile and the create spfile from pfile. In his 22 years at oracle, tom kyte started the ask tom question and answer site and was the sites sole proprietor for almost 15 years. Spfile is a binary file and modications to that can only be done through alter system set command. One exciting new feature of oracle is the removal of the init. Converting the spfile to a pfile, editing the pfile and reconverting the corrected pfile to the spfile made oracle happy and me too. Dont get hung up on a laptop for software development, even if you work best from the couch. What is the difference between spfile and pfile in oracle.
The pfile is read at instance startup time to get specific instance characteristics. Inside the pfile are a number of database settings called parameters. This file holds the setup parameters that define the. The tables and file samples in this appendix are included to illustrate the best practices as. The server parameter file spfile is created from the initialization response file, then. Any changes made the pfile would only take effect when the database is restarted. How to move asm spfile from one diskgroup to another diskgroup.
To do that, use the asmcmd utility to remove the file. The oracle spfile is a binary representation of the text0based init. We offer onsite intensive handson oracle database administration with lots of practicals. Pfile is static parameter file and we can edit by using text editor. Creating, copying, and moving an spfile into a disk group. As spfile is a server side binary file, local copy of the pfile is not required to start oracle from a remote machine. Up to oracle 8i, the initialization parameters were stored only in the init. How to startup an oracle database instance using spfile or pfileinit.
Oracle8i configuration parameters and the registry oracle docs. Parameters in pfile can be edited using any text editor. In oracle9i, oracle has also introduced the spfile, which is a binary file stored on the database server. Simple steps to implement rman nanak sawlani jesse crew zlb behring. Asm disk wont be onlinemounted if asm instance isnt started. Parameter file is a text or binary to store the database initialization parameters. Use the create spfile statement to create a server parameter file from a clientside initialization parameter file. Oracle9i introduces the concept of persistent initialization parameters. This clause lets you specify a name for the server parameter file you are creating. The changes cannot be applied to active instance and the database needs to be restarted to take effect the modified parameters. Oracle provides two different types of parameter files that you can use, pfile and spfile. Can i edit my spfile, or should i recreate by spfile from my pfile.
A database spfile and oracle net configuration file samples. Creating a text parameter file is a convenient way to get a listing of the current parameter settings being used by the database, and it lets you edit the file easily in a text editor and then convert it back into a. I changed a parameter in such a bad way, that oracle did not start anymore. Editing an spfile directly will corrupt the file and the start up of the database or instance will not be possible.
While it is possible to edit the spfile, using editors like vi will corrupt the spfile. In his spare time, he also wrote expert oracle database architecture apress, 2005, 2010, 2014 and effective oracle by design oracle press, 2003, among other books. Nationglobe tech oracle training course is the best oracle dba training school in baltimore maryland. At this point you may want to clean up the old spfile within asm. Spfile until oracle 8i dbas have been using a text file called the pfile parameter file to store the database initialization parameters. Learn what truly works in converting and maintaining your parameters without ever having to use an editor again.
The solution is simple heck you found it yourself in the very next part of the question. Instead it can only be altered using the alter system command. Server parameter files let you make persistent changes to individual parameters. The pfile is a static, plain text files which can be altered using a text editor, but it is only read at database startup. Oracle requires an initialization file to define the attributes and characteristics of the starting instance and the connecting sessions there of. As we said, the parameters are stored in either a pfile or an spfile.
In oracle databases through 8i, parameters controling memory, processor usage, control file locations and other key parameters are kept in a pfile short for parameter file. With regard to older oracle version, this parameter file is known as pfile and the dba use to more often call it as init. Changing static parameters requires the spfile option for the scope clause with alter system statement and changes applies to spfile only. The the spfile is really just a flatfile text file, with binary ascii nul character padding at the beginning and end of each line. Use the create pfile statement to export either a binary server parameter file or the current inmemory parameter settings into a text initialization parameter file. So the first thing i did was to confirm that the spfile is in the asm disk. Oracle8i personal edition for windows 98 stores its configuration information in a database the. Oracle recommends that you allow the database to give the spfile the default name and store it in the default location. Spfile should only be modified through alter system set command.
816 828 1261 551 395 228 1112 172 23 1518 494 1096 1473 612 501 1319 1588 452 1367 1003 1260 913 293 710 1476 1500 836 132 107 1468 35 1141 135 1014 616 1112 1362 825 1059 708 867 392 752 477 1212 42 1082