You are using an outdated browser. Please upgrade to the latest version for the best experience.
How do I narrow my search results?

After you submit your search query:

  1. On the Refine Search results page, select one or more categories of products or services from the left sidebar.
  2. Then for a category with search results, click Select to choose your product and release filters, and then click OK.

For search queries that contain multiple words, surround the query with quotes, and then resubmit your query. Example: "database cloud service"

How do I find the documentation for my product or service?

From the home page, click the technology categories for your products or services. If you do not know which category to pick, try the following features:

  • Click the Find a product tab and search for your product or service.
  • Click Browse All Products & Services at the bottom of the home page to view an alphabetical listing of products and services.
  • Apple Safari: Version 6
  • Google Chrome: Version 29 and later
  • Mozilla Firefox: Version 24 and later
  • Microsoft Internet Explorer: Version 9 and later
Results for initialization parameter


21 to 40 of 13202 results. previous page Prev  Next next page
Results per page:   20  | 40 | 60


Database Administrator's Guide, 11g Release 1 (11.1)

Managing Initialization Parameters Using a Server Parameter File

Exporting the Server Parameter Fileinitialization parameter file. Doing so might be necessary for several reasons: For diagnostic purposes … creates a text initialization parameter file from the SPFILE: CREATE PFILE FROM SPFILE; Because no … names were specified for the files, the database creates an initialization parameter

Database Administrator's Guide, 11g Release 1 (11.1)

Managing Initialization Parameters Using a Server Parameter File

Managing Initialization Parameters Using a Server Parameter Fileinitialization parameter file. For better manageability, you can choose to maintain initialization … section introduces the server parameter file, and explains how to manage initialization parameters … Storing the Server Parameter File on HARD-Enabled Storage The SPFILE Initialization

Database Administrator's Guide, 11g Release 1 (11.1)

Managing Initialization Parameters Using a Server Parameter File

Recovering a Lost or Damaged Server Parameter Fileyou have a valid text initialization parameter file (PFILE), recreate the SPFILE from the PFILE with … If your server parameter file (SPFILE) becomes lost or corrupted, the current instance may fail, or … current values of initialization parameters in memory: CREATE SPFILE FROM MEMORY; This command … a new name

Database Administrator's Guide, 11g Release 1 (11.1)

Managing Initialization Parameters Using a Server Parameter File

Storing the Server Parameter File on HARD-Enabled Storagea Release 11 g database, the COMPATIBLE initialization parameter defaults to 11.1.0, so this … text initialization parameter file (PFILE) in the default location with the following single entry … : Create a text initialization parameter file (PFILE) in the default location with the following

Database Administrator's Guide, 11g Release 1 (11.1)

Managing Initialization Parameters Using a Server Parameter File

What Is a Server Parameter File?, by design, a server-side initialization parameter file. Initialization parameters stored in a server … is initially built from a text initialization parameter file using the CREATE SPFILE statement. (It … initialization parameter settings. If no server parameter

Database Administrator's Guide, 11g Release 1 (11.1)

Managing Initialization Parameters Using a Server Parameter File

Viewing Parameter Settingsinitialization parameters in the server parameter file (SPFILE). CREATE PFILE This SQL statement creates a text … initialization parameter file (PFILE) from the SPFILE or from the current in-memory settings. You can … initialization parameters in effect for the current session. It is easier to distinguish

Database Administrator's Guide, 11g Release 1 (11.1)

Managing Initialization Parameters Using a Server Parameter File

Creating a Server Parameter Filefile (SPFILE) from an existing text initialization parameter file or from memory. Creating the … to the SPFILE. The following example creates a server parameter file from text initialization … message. When you create an SPFILE from a text initialization parameter file, comments specified

Database Administrator's Guide, 11g Release 1 (11.1)

Managing Initialization Parameters Using a Server Parameter File

Migrating to a Server Parameter FileIf you are currently using a text initialization parameter file, use the following steps to migrate … to a server parameter file. If the initialization parameter file is located on a client machine … combine all of your instance-specific initialization parameter files

Database Reference, 11g Release 1 (11.1)

Initialization Parameter Descriptions

Initialization Parameter DescriptionsInitialization parameter values apply to the entire database, not to an individual user, unless otherwise … operating system-specific Oracle documentation Press the \"Next\" button to go to the first initialization parameter. … The remainder of this chapter describes the initialization parameters

Database Administrator's Guide, 11g Release 1 (11.1)

Guidelines for Managing Datafiles

Determine a Value for the DB_FILES Initialization ParameterWhen starting an Oracle Database instance, the DB_FILES initialization parameter indicates the … value of DB_FILES (by changing the initialization parameter setting), but the new value does not

Database Backup and Recovery User's Guide, 11g Release 1 (11.1)

Performing RMAN Recovery: Advanced Scenarios

Creating an Initialization Parameter File with RMANYou can also restore the server parameter file as a client-side initialization parameter file with … running the instance. The following RMAN command creates an initialization parameter file named /tmp … restart the instance with the initialization parameter file, use

Database Upgrade Guide, 11g Release 1 (11.1)

After Upgrading to the New Release

Set CLUSTER_DATABASE Initialization ParameterIn \"Prepare the New Oracle Home\", you were instructed to set the CLUSTER_DATABASE initializationparameter to false before upgrading a cluster database. Now that the upgrade is finished, you must set this parameter to true.

Database Reference, 11g Release 1 (11.1)

Parameter Files

Initialization Parameter FilesAn initialization parameter file is a text file that contains a list of initialization parameters … in an initialization parameter file: PROCESSES = 100 OPEN_LINKS = 12 GLOBAL_NAMES = true The name of … the initialization parameter file varies depending on the operating

Database Concepts, 11g Release 1 (11.1)

Database and Instance Startup and Shutdown

Initialization Parameter Files and Server Parameter FilesTo start an instance, Oracle Database must read either an initialization parameter file or a server … parameter file. You can also choose to maintain initialization parameters in a server-side binary server … parameter file (SPFI LE). Initialization parameters stored in a server parameter

Database Reference, 11g Release 1 (11.1)

Parameter Files

Specifying Values in an Initialization Parameter FileThis section describes several aspects of setting parameter values in an initialization parameter … file. Rules Governing Initialization Parameter Files The following rules govern the specification of … parameters in initialization parameter files: An initialization

Database Upgrade Guide, 11g Release 1 (11.1)

After Upgrading to the New Release

Migrate Your Initialization Parameter File to a Server Parameter FileIf you are currently using a traditional initialization parameter file, then perform the following … steps to migrate to a server parameter file: If the initialization parameter file is located on a … initialization parameter files into a single initialization

Database Backup and Recovery User's Guide, 11g Release 1 (11.1)

Duplicating a Database

Step 3: Create an Initialization Parameter File for the Auxiliary InstanceCreate a text-based initialization parameter file for the auxiliary instance. If you are using the … initialization parameter file because you can set these and all other parameters in the DUPLICATE command … set in the initialization parameter file. Table 23-1 describes these initialization

Real Application Clusters Installation Guide for Microsoft Windows, 11g Release 1 (11.1)

Understanding the Oracle Real Application Clusters Installed Configuration

6.5 Initialization Parameter FilesOracle recommends using the server parameter file (SPFILE). This file resides on the server on the … shared disk; all instances in a cluster database can access this parameter file. See Also: Chapter 5 … , \" Parameter Management for Oracle Real Application Clusters Databases\" for more information about the creation and use of parameter

Database Installation Guide for Linux, 11g Release 1 (11.1)

Glossary

initialization parameter fileAn ASCII text file that contains information needed to initialize a database and instance.

Real Application Clusters Installation Guide for Linux and UNIX, 11g Release 1 (11.1)

Understanding the Oracle Real Application Clusters Installed Configuration

7.6 Initialization Parameter FilesOracle recommends using the server parameter file (SPFILE). This file resides on the server on the … shared disk; all instances in a cluster database can access this parameter file. See Also: Chapter 6 … , \" Configuring the Server Parameter File in Oracle Real Application Clusters Environments\" for … more information about the