欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  数据库

Oracle EBS DB Init Parameters

程序员文章站 2022-04-28 12:17:28
...

Oracle EBS里查看数据库参数路径:System Administration gt; Oracle Applications Manager gt; Initialization Parameters或者

Oracle EBS里查看数据库参数路径:System Administration > Oracle Applications Manager > Initialization Parameters
或者
路径:System Administration > Oracle Applications Manager > System Configuration Overview > Database > Init.ora Parameters

可以查看DB的数据库parameter(init.ora或者pfile parameter)

Oracle EBS DB Init Parameters


关于Oracle Parameter可以参见我之前写得帖子:Oracle Parameters

如果是使用的init.ora的话,这个DB参数文件默认放在$RDBMS_ORACLE_HOME/dbs/init.ora

你可以在这个文件中修改DB参数,注意,修改完之后,,需要重启数据库才能生效。

EBS的DB init.ora参数文件的设置

另外这里有两篇不错的metalink notes可以帮助你来设置EBS的init.ora参数文件,给出了一些设置的建议
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 particular 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 HP-UX (PA-RISC) will not apply to 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.

    Oracle EBS DB Init Parameters