Oracle E-Business Suite (11i/R12) is typically installed under two operating system users: oracle and applmgr. The oracle user owns the Oracle technology stack and database, and is a member of the dba group. The applmgr owns the Oracle E-Business Suite technology stack, and is a member of the oaa group. An implementer account is created for the Oracle Implementer (OI)and the interface account is created for file transfers.
The naming conventions for Oracle E-Business Suite are as follows:
Customer short code: This four-character code uniquely identifies the customer’s system. It is combined with the first letter of the environment type to form the database system identifier (SID), mount points, and user names.
Database SID: This is usually made by concatenating the first letter of the environment type, the customer short code, and the letter i. However, when the customer has additional instances, the SID is created with the first three digits of the short code plus the instance number.
Environment type: This can be the Test, Development, or additional non-production environments. Each environment uses different port numbers.
Mount point: The mount point for the applications environment is the same as the database SID (The mount point is always entered in lowercase)
User names: The names are defined as follows:
– The oracle user name is made by concatenating or with the database SID.
– The applmgr user name is made by concatenating ap with the database SID.
– The interface user name is made by concatenating inf with the database SID.
– The BOL-SETUP user name is assigned the Applications Administrator responsibility for Oracle E-Business Suite for implementation use. Prior to go-live, the application administrator responsibility should be assigned to a named application user. The user BOL-SETUP will be end dated at go-live.
Example:
Enviroment PROD –
Oracle SID : pabcdi
oracle user: orpabcdi
applmgr user: appabcdi
interface user: infpabcdi
Enviroment DEV –
Oracle SID : dabcdi
oracle user: ordabcdi
applmgr user: apdabcdi
interface user: infdabcdi
Enviroment TEST –
Oracle SID : tabcdi
oracle user: ortabcdi
applmgr user: aptabcdi
interface user: inftabcdi
YET ANOTHER ORACLE DBA 