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.