Oracle ebs db Init Parameters

Source: Internet
Author: User

To view database Parameters in Oracle EBS, go to System Administration> Oracle Applications Manager> Initialization Parameters.
Or
Path: System Administration> Oracle Applications Manager> System Configuration Overview> Database> Init. ora Parameters

You can view the database parameter (init. ora or pfile parameter) of the DB)


For more information about Oracle Parameter, see my previous post: Oracle Parameters

If init <sid>. ora is used, the DB parameter file is stored in $ RDBMS_ORACLE_HOME/dbs/init <sid>. ora by default.

You can modify the database parameters in this file. Note that after modification, the database must be restarted to take effect.

Settings of the DB init. ora parameter file of EBS

In addition, there are two good metalink notes to help you set the EBS init. ora parameter file, and some suggestions for setting
Note: 216205.1-Database Initialization Parameters for Oracle Applications Release 11i
Note: 396009.1-Database Initialization Parameters for Oracle Applications Release 12

Index for Note 396009.1

This document describes the database initialization parameter settings required for Oracle E-Business Suite Release 12.

  • Section 1: Common Database Initialization Parameters For All Releases
  • Section 2: Release-Specific Database Initialization Parameters For Oracle 10g Release 2
  • Section 3: Release-Specific Database Initialization Parameters For Oracle 11g Release 1
  • Section 4: Release-Specific Database Initialization Parameters For Oracle 11g Release 2
  • Section 5: Using System Managed Undo (SMU)
  • Section 6: Temporary Tablespace Setup
  • Section 7: Database Initialization Parameter Sizing
Key Points
* The document consists of a common section, which provides a common set of database initialization parameters used for all releases of the Oracle Database, followed by several release-specific sections, which list parameters and settings required for a particle release of the Oracle Database.
* Put together, the parameters from the common section and appropriate release-specific section formulate a complete set of database initialization parameters.
* Parameters may appear on a removal list either because they are obsolete, or because the default value is required and no other value may be set.
* In the various parameter lists, check for comments giving any platform-specific exceptions. such comments will apply only to the exact platform mentioned: for example, a reference to a HP-UX (PA-RISC) will not apply to a HP-UX (Itanium IA-64 ).
* The "X" notation used in the release-specific section denotes all patchset releases within that major version. for example, "10.2.0.X" refers to all releases of 10.2.0, such as 10.2.0.2 and 10.2.0.3.
* Oracle E-Business Suite Release 12 requires Oracle Database 10g Release 2 (10.2.0.2) Enterprise Edition as a minimum release level and edition. no earlier releases, or other editions of any release, may be used.
  • 1
  • 2
  • Next Page

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.