0
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
Wiki User
∙ 16y 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 difference between PFile and SPFile?
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.
What are modules of oracle?
Oracle sells many functional modules which use the Oracle RDBMS as a back-end, notably Oracle Financials, Oracle HRMS, Oracle SCM, Oracle Projects, Oracle CRM, Oracle Procurement.
Use the word oracle bone in a sentence?
The oracle bone was priceless.
What an oracle?
"an oracle"An oracle is a person, such as priestess, through whom a deity is held to respond when consulted. An oracle is a being of great wisdom and insight. One from whom one would seek advice. A special priest guided by the Gods. "Oracle" Oracle Application Express, or Oracle Apex is an application one can use on the Oracle platform. It enables users to build web databases for use. There is no cost associated with the Oracle Apex.
What is the advantage of an oracle?
The advantage of an oracle is its ability to use the centralized management system.
What is an oracle?
"an oracle"An oracle is a person, such as priestess, through whom a deity is held to respond when consulted. An oracle is a being of great wisdom and insight. One from whom one would seek advice. A special priest guided by the Gods. "Oracle" Oracle Application Express, or Oracle Apex is an application one can use on the Oracle platform. It enables users to build web databases for use. There is no cost associated with the Oracle Apex.
Use the word oracle in a sentence?
The wise oracle predicted that I would win the Olympics.
Did the Romans use an oracle?
Yes they did!
What company using oracle?
becoz of the company database is very large and can not easy to handle it use of the company use of the oracle ... and suppose any company member ask to you xyz person data information given ...so use of the oracle so can easy to find the person information and get it....
How to import Data from .txt file to oracle 10g table?
Use SQLLoader utility of Oracle
Where can I find more information on Oracle Financial Services?
Oracle is a multinational company that produces a variety of software for a multitude of applications. Oracle financial servies can be investigated through the use of their website, oracle.
