Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Fwd: [Builder.com] Create an SPFILE in 9i

Fwd: [Builder.com] Create an SPFILE in 9i

From: Ron Rogers <RROGERS_at_galottery.org>
Date: Fri, 12 Jul 2002 04:33:23 -0800
Message-ID: <F001.00496305.20020712043323@fatcity.com>


List,
 Just by coincidence this came in the mail today. Ron
ROR mm

>>> "Oracle Tips at Builder.com"

<Online#3.19866.d6-D0zL_C4LWVLh4dRR.1_at_newsletter.online.com> 07/12/02 03:05AM >>>
Builder
http://builder.com.com

Presents your
ORACLE E-NEWSLETTER for July 12, 2002

<---------------Advertisement--------------->

THE DATA STORAGE INFO YOU NEED BEFORE YOU BUY Selecting the appropriate data storage solution is vital to your organization's future. When the choice rests on your shoulders, you need
the unbiased expert advice you can only get from TechRepublic - so make
an informed decision with IT Professional's Guide to Enterprise Storage
book and CD-ROM. Don't wait to hit critical mass! Get the insights and articles to help you through the maze of features, benefits, and limitations of a wide range of data storage solutions. http://clickthru.online.com/Click?q=ec-MHyXQVy2A7t5Hez1D55FiEbDabZR

<------------------------------------------->

CREATE AN SPFILE IN ORACLE9i

An exciting new feature of Oracle9i is the removal of the init.ora file.
Oracle has replaced the init.ora file because you can now change all parameters dynamically with the ALTER SYSTEM commands.

With Oracle9
i, you can manage initialization parameters using a binary server parameter file (SPFILE). By default, a new Oracle9i database will be working on
a PFILE, so you must create the SPFILE from the PFILE at the SQL prompt.
You can create the SPFILE using the CREATE SPFILE statement, which requires connecting as SYSDBA.

Connect system/manager as sysdba;
CREATE SPFILE FROM PFILE; This command creates an SPFILE in a nondefault location ($ORACLE_HOME/database). However, you can fully qualify the path name in the CREATE
SPFILE statement.

CREATE SPFILE='/u01/admin/prod/pfile/file_mydb.ora' FROM
PFILE=/u01/admin/prod/pfile/initprod.ora';

After creating an SPFILE, you may encounter an error when you bounce the
database. To work around this, you have to reconnect as SYSDBA and use the STARTUP command.

The addition of the SPFILE has changed the search path for the Oracle startup deck. In Oracle9i, follow these steps to search for the SPFILE:

  1. Search for the spfile$ORACLE_SID.ora file in the default location.
  2. Look for the spfile.ora.
  3. Search for the PFILE by name: init$ORACLE_SID.ora.

SPECIFYING SCOPE Once you have an SPFILE, you can change any initialization parameter with the ALTER SYSTEM command. However, there's an important SCOPE parameter
that you need to understand.

The SCOPE parameter has three values: SPFILE, MEMORY, and BOTH. Let's look at an example of each.

Alter system set db_2k_cache_size=100m SCOPE=SPFILE;

If you want to make a change to a parameter in the SPFILE without affecting the current instance, you can do so using the SCOPE=SPFILE option of
the ALTER SYSTEM statement. This is useful when you want to make a change
starting from the next startup and not for the current instance.

Alter system set db_2k_cache_size=100m SCOPE=MEMORY;

In the example above, the SCOPE=MEMORY option tells Oracle9i to make the
change for the life of the instance and to change it back to the default
value the next time the database is bounced.

Alter system set db_2k_cache_size=100m SCOPE=BOTH;

When you specify SCOPE=BOTH, Oracle makes the change immediately, and Oracle will also make the change permanent, even after the database is bounced.

Donald Burleson has been a database administrator for 23 years and has written 14 database books and over 100 articles. He is editor in chief of
Oracle Internals and runs Burleson Oracle Consulting.


READ MORE ABOUT DEVELOPMENT AN INSIDER'S GUIDE TO ORACLE CERTIFICATION Is an OCP certification your ticket to becoming an Oracle DBA, or is it
just one of several important criteria? Check out this article for one expert's opinion.
http://clickthru.online.com/Click?q=01-9oXDI2jHgIU_QeWv hPwP4lpp69RR

WRITING READABLE CODE
Following these simple naming conventions and documentation standards simplifies team code maintenance. Try these techniques on your next project
and see if they work for you.
http://clickthru.online.com/Click?q=16-T_cjI4cFVqlgbfmDYe9uS3KuRhcR

CLIMBING TO THE TOP OF THE CORPORATE TECHNOLOGY LADDER Do your technical skills qualify you for an executive role? Before you fire off that resume to a headhunter, you need to consider a number of critical success factors. Here are some practical suggestions for breaking
into the VP club.
http://clickthru.online.com/Click?q=2b-2FVYINzsBDSyMkgwISVxZQsc8f9R


NEW AT BUILDER.COM WHERE WILL THE VISUAL BASIC 6.0 DEVELOPERS GO? You love Visual Basic 6.0, but .NET is breathing down your neck. Should
you make the move to Visual Basic .NET or C#? Before you make the choice,
check out these three dispelled post-VB6 myths. http://clickthru.online.com/Click?q=41-qqJ1IEKImb3rPLMUvMWCV-BU0ciR

COUNTING LINES OF CODE CAN HELP MEASURE PROGRESS One developer believes that counting a developer's lines of code can yield useful information. He explains why and shares a sample app that automates the process.
http://clickthru.online.com/Click?q=56-NwKYInns9SW5UZ3rXweQyCMGMtrR

FLASH REMOTING WITH COLDFUSION COMPONENTS Flash Remoting makes it easy to use dynamic data in your Flash applications. Here's everything you need to know to use Flash Remoting with
ColdFusion Components.
http://clickthru.online.com/Click?q=6b-8g5ZIHEcwpnSwq38n4MQXnsKPa4R


DEVELOP THE MASTER PROJECT PLAN
You're tasked with keeping a project running smoothly, so you need to be
ready for potential issues to rear their ugly heads. Turn to Builder.com
for help. Sign up instantly for Builder.com Project Management Blueprint
e-newsletter, delivered each Thursday, and get the resources you need.

http://clickthru.online.com/Click?q=80-KTKvQQ0Kir-T30Eo4GJjkRXPZ1FR


This e-newsletter may contain links to sites on the Internet that are owned and operated by third parties. CNET Networks, Inc. is not responsible
for the content of any such third-party site.

To update your subscriptions:
http://builder.com.com/techmails.jhtml

To unsubscribe from this mailing list:
http://clickthru.online.com/Click?q=95-XdTrrgdemet95P2C2yRuUWn9n4HlWdRR

Questions or comments:
http://builder.com.com/builder/contact_faqs/techmails.jhtml

Visit Builder
http://builder.com.com/

Copyright 2002 CNET Networks, Inc. All rights reserved. Builder.com is a trademark of CNET Networks, Inc.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ron Rogers
  INET: RROGERS_at_galottery.org

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Received on Fri Jul 12 2002 - 07:33:23 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US