0
When an Oracle Instance is started, the characteristics of the Instance are established by parameters specified within the initialization parameter file. These initialization parameters are either stored in a PFILE or SPFILE. SPFILEs are available in Oracle 9i and above. All prior releases of Oracle are using PFILEs. SPFILEs provide the following advantages over PFILEs: * An SPFILE can be backed-up with RMAN (RMAN cannot backup PFILEs) * Reduce human errors. The SPFILE is maintained by the server. Parameters are checked before changes are accepted. * Eliminate configuration problems (no need to have a local PFILE if you want to start Oracle from a remote machine) * Easy to find - stored in a central location What is the difference between a PFILE and SPFILE:A PFILE is a static, client-side text file that must be updated with a standard text editor like "notepad" or "vi". This file normally reside on the server, however, you need a local copy if you want to start Oracle from a remote machine. DBA's commonly refer to this file as the INIT.ORA file. An SPFILE (Server Parameter File), on the other hand, is a persistent server-side binary file that can only be modified with the "ALTER SYSTEM SET" command. This means you no longer need a local copy of the pfile to start the database from a remote machine. Editing an SPFILE will corrupt it, and you will not be able to start your database anymore.
Wiki User
∙ 14y ago
Add your answer:
Earn +20 pts
How do you configure spfile via intora?
Create spfile from pfile with the below command:create spfile from pfile;
What is the use of spfile and init.ora in oracle?
init.ora and SPfile both contain information about DB parameters. The database cannot start without an INIT.ORA but can start without an SPfile. An SPfile cannot be edited directly , but one can be configured via the pfile (init.ora) Init.ora is saved in ascii text format whereas the SPfile is saved in a binary format. If both files exist , the database reads the SPfile first before processing the init.ora. Oracle Guru's step in and correct if necessary .......... :) , Lekarshi
What has the author Karen Fyock written?
Karen Fyock has written: 'Pfile-Dahlem'
What is difference between oracle8i oracle9i?
The major differences are- In 9i merge , insert all, case is introduced . In 9i newdatatype called timestamp In 9i you can moniter index using alter index <index name> monitering usage or u can check user_objects table from system user. In 9i new performance monitering tools called STATPACK . In 9i You can dynamically change init ora parameter using alter system <parameter> scope=/path/ of your spfile/pfile In 9i new concept for undo transaction called UNDO tablespace In 9i by default TEMP tablespace is considering while creating new oracle users In 9i new partition called LIST
What is difference between as on and as at?
difference between as on and as at
What is the perror function used for in C programming?
The perror() function is used to print a user-defined error message to stderr. Consider the following:Example:#include int main (){FILE * pFile;pFile=fopen ("missing.txt","rb");if (pFile==NULL)perror ("missing.txt");elsefclose (pFile);return 0;}Possible Output:missing.txt: No such file or directoryWe can achieve the exact same effect with a more verbose fprintf() statement, such that the following are equivalent:perror ("Error");fprintf (stderr, "Error: %s\n", strerror (errno));The following are also equivalent:perror (NULL);fprintf (stderr, strerror (errno));We typically use fprintf() statement when we need to print messages other than those provided by strerror and/or wish to redirect the output to a device other than stderr. But for all error messages based upon the thread-local errno, perror is more concise and reduces the chances of introducing errors through typos (such as accidently redirecting errors to stdout instead of stderr).
What are the differences between California and Florida?
What is the difference between Florida and California What is the difference between Florida and California
What is the difference between physician and doctor?
what's the difference between physician and doctorwhat's the difference between physician and doctor what's the difference between physician and doctor
What difference between paging?
Difference between paging and what?
What is the difference between an enterprise and association what is the difference between an pvt ltd and ltd.?
difference between enterprise and corporation
What is the difference between an enterprise and association what is the difference between an pvt ltd and ltd?
difference between enterprise and corporation
What is the difference between a samurai and shogun?
The difference between a shogun and a samurai is like the difference between a king and a knight.
