Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
How To Create a Server Parameter File
How To Create a Server Parameter File? - Oracle DBA FAQ - Creating New Database Instance Manually
✍: FYIcenter.com
This is Step 5. The initialization parameter file is good to get an Oracle database instance started. But it is not ideal run an instance as production. You need to convert the initialization parameter file into a Server Parameter File (SPFile) using the CREATE SPFILE statement. The script below shows you how do this:
SQL> CREATE SPFILE=$ORACLE_HOME/dbs/SPFILEFYI.ora 2 FROM PFILE=$ORACLE_HOME/database/initFYI_ini.ora; File created.
Note that $ORACLE_HOME should be replaced by the real path name where your Oracle server is intalled.
The SPFile should be located in the expected directory and named as SPFILE($SID).ora.
2007-04-23, 4774👍, 0💬
Popular Posts:
What is CMM and different levels? explain? The Capability Maturity Model (CMM) is a process capabili...
Can one change the mouse pointer in Forms? The SET_APPLICATION_PROPERTY build-in in Oracle Forms all...
Can you explain different software development life cycles -part II? Water Fall Model This is the ol...
Can a variable be both const and volatile? Yes. The const modifier means that this code cannot chang...
What is difference between SITP and UTP in testing ? UTP (Unit Test Plan) are done at smallest unit ...