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 IFILE


1 to 20 of 26 results. Previous page Prev  Next next page


Heterogeneous Connectivity Administrator's Guide, 9i Release 2 (9.2.0.2)

Heterogeneous Services Initialization Parameters

IFILEDefault value: None Range of values: Valid parameter filenames Use IFILE to embed another … not contain environment variables; the three levels of nesting limit does not apply. See Also: IFILE

Reference, 9i Release 2 (9.2.0.2)

Initialization Parameters, 76 of 222

IFILEParameter type Parameter file Syntax IFILE = parameter_file_name Default value There is no default … Multiple instances can have different values. Use IFILE to embed another parameter file within the … current parameter file. For example: IFILE = COMMON.ORA You can have up to three levels of nesting. In … this example, the file

Administration, 9i Release 2 (9.2.0.2)

Parameter Management in Real Application Clusters Environments

Placement and Use of IFILE Parameters in Instance-Specific Files, place the IFILE parameter at the end of any instance-specific parameter files. Conversely, you can … override common parameter values by placing the IFILE parameter before the instance-specific parameter … setting. Note: The DBCA places the IFILE parameter at the top of the parameter file.

Administration, 9i Release 2 (9.2.0.2)

Parameter Management in Real Application Clusters Environments

Using Multiple IFILE Entries in Client-Side Parameter FilesYou can specify IFILE more than once in your initial parameter file to include multiple global … files. Otherwise, each subsequent entry in the files specified by IFILE overrides previous values. For … parameter files for other parameter settings as in this example: IFILE=INIT_CLUSTER.ORA IFILE … =INIT_LOG.ORA

Heterogeneous Connectivity Administrator's Guide, 9i Release 2 (9.2.0.2)

Heterogeneous Services Initialization Parameters

A Heterogeneous Services Initialization ParametersHS_ROWID_CACHE_SIZE HS_RPC_FETCH_REBLOCKING HS_RPC_FETCH_SIZE HS_TIME_ZONE IFILE See Also: "Setting

Administration, 9i Release 2 (9.2.0.2)

Parameter Management in Real Application Clusters Environments

Purpose of init sid .oraThe init sid.ora file uses the IFILE parameter to point to the common file for common parameter … : Example 2-1 initdb1.ora ifile='C:\OracleSW\admin\db\pfile\initdb.ora' thread=1 instance_name=db1 … instance_number=1 Example 2-2 initdb2.ora ifile='C:\OracleSW\admin\db\pfile\initdb.ora' thread=2

Heterogeneous Connectivity Administrator's Guide, 9i Release 2 (9.2.0.2)

Using Heterogeneous Services Agents

Syntax for Initialization Parameter Settingskeywords ( SET, PRIVATE and IFILE ) are case insensitive. Initialization parameter names and values are … initialization file can be included in an Heterogeneous Services initialization file by using the IFILE … directive. The syntax for this is IFILE = pathname for file to be included

Setup and Configuration, 9i Release 2 (9.2.0.2)

Configuring the Server Parameter File in Real Application Clusters Environments

Procedures for Migrating to the Server Parameter Fileinto one init dbname.ora file by copying all shared IFILE contents as is. All parameters defined in … your IFILE parameter files are global. Therefore, create them as "parameter=value" without sid

Administration, 9i Release 2 (9.2.0.2)

Parameter Management in Real Application Clusters Environments

Starting Two Instances on Remote Nodessid.ora file specifies a location on the remote instance. IFILE Use in Traditional Parameter File … Scenarios In the previous example, both parameter files can use the IFILE parameter to include values from an init_dbname.ora file.

Migration, 9i Release 2 (9.2.0.2)

After Upgrading a Database

Changing the Word Size of Your Current Releaseto the new release. If your parameter file has an IFILE (include file) entry and the file specified … in the IFILE entry resides within the old environment's Oracle home, then copy the file specified by … the IFILE entry to a location outside of the old environment's Oracle home. The file specified in … the IFILE

Administration, 9i Release 2 (9.2.0.2)

Parameter Management in Real Application Clusters Environments

Using Client-Side Parameter Filesparameter files. You can also maintain one file for global parameters and point to it with the IFILE … defines the instance-specific parameter settings. Use the IFILE parameter from within this file to call

Administration, 9i Release 2 (9.2.0.2)

Parameter Management in Real Application Clusters Environments

Purpose of init db_name .oraName the init db_name.ora parameter file using the IFILE parameter setting in each init sid.ora

Administrator's Guide, 9i Release 2 (9.2.0.2)

Creating an Oracle Database

The SPFILE Initialization Parameterspecify a server parameter file located in a nondefault location. Do not use an IFILE initialization

Migration, 9i Release 2 (9.2.0.2)

Downgrading a Database Back to the Previous Oracle Release

Downgrade the Databaseparameter to specify a server parameter file, then change the SPFILE parameter to an IFILE parameter … in the initialization parameter file used to start up the instance. Make sure the IFILE parameter … exported from the server parameter file. You can use the IFILE parameter in each instance-specific … release 9.2 Oracle home.

Error Messages, 9i Release 2 (9.2.0.2)

ORA-24280 to ORA-29249

ORA-28542 Error in reading HS init filefile name to see that the gateway initialization file acctually exists. Check the ifile parameter to see that it points to the correct location.

Real Application Clusters Guard I - Concepts and Administration, 9i Release 2 (9.2.0.2)

Oracle Real Application Clusters Guard Configuration Parameters

Changing Database Configuration Parametersby using the IFILE initialization parameter. See Also: Oracle9i Database Reference for information … about the IFILE initialization parameter Invoke PFSCTL as root:# pfsctl You should see output

Reference, 9i Release 2 (9.2.0.2)

Initialization Parameters, 3 of 222

Initialization Parameter Filesexample:ROLLBACK_SEGMENTS = (SEG1, SEG2, \ SEG3, SEG4, SEG5) You can use the IFILE initialization … system-specific Oracle documentation for more information on initialization parameter files "IFILE

Migration, 9i Release 2 (9.2.0.2)

Upgrading a Database to the New Oracle9i Release

Upgrade the Databaseparameter file has an IFILE (include file) entry and the file specified in the IFILE entry resides … within the old environment's Oracle home, then copy the file specified by the IFILE entry to the new … Oracle home. The file specified in the IFILE entry contains additional initialization parameters … names in

Administrator's Guide, 9i Release 2 (9.2.0.2)

Starting Up and Shutting Down

Using SQL*Plus to Start Up a Databasethe following parameter: SPFILE = /u01/oracle/dbs/test_spfile.ora Note: You cannot use the IFILE

Administration, 9i Release 2 (9.2.0.2)

Oracle9i Real Application Clusters Administration -- Contents

Oracle9i Real Application Clusters Administration -- ContentsUse of IFILE Parameters in Instance-Specific Files Using Multiple IFILE Entries in Client-Side