OracleEBSR12 file system structure (learn and summarize online materials)

OracleEBSR12 file system structure (learn and summarize online materials)

The file structure of Oracle EBS R12 on the server is as follows:

The top-level directory is divided

1) inst --- configuration information related to the entire ebs instance and other information

2) db --- mainly stores information on the DB Layer

3) apps --- mainly information at the application layer

1) First, let's look at the INST_TOP situation.

2) Check the database content again.

3) The last part is the content of apps.

 

The folder is described as follows:

Pai_st/appl ---- separate by product (hr, pay, gl, etc.). Each product has a separate folder. For example, there will be hr folders under appl, which are used by the HR Module. All Forms, reports, and,SQLScripts and oaf pages are all under the hr folder.

Performance_st/comn ---- below this directory is some common things that every product will use. It should be noted that allJavaClass will be placed under the subdirectory of this directory.

Tech_st/------ divide the ebs architecture from the bottom layer (for example). The content in this folder should be corresponding to Applications Technology Stack, pay, gl, etc.) to act as a Public Caller.

Tech_st/10.1.2 ---- stores forms service, report, and other related content files and information

Tech_st/10.1.3 ----WebService-related files and information

The configuration file information is as follows:

<CONTEXT_NAME>. env 10.2.0.2 ORACLE_HOME OracleServerEnterprise Edition <BASE_PATH>/db/tech_st/11.1.0

<CONTEXT_NAME>. env AS 10.1.2 ORACLE_HOME Oracle Tools Technology Stack <BASE_PATH>/appl/tech_st/10.1.2 (AS if not)

<CONTEXT_NAME>. env AS 10.1.3 ORACLE_HOME Java Technology Stack <BASE_PATH>/appl/tech_st/10.1.3 (AS if not)

<CONTEXT_NAME>. env APPL_TOP Oracle Applications $ APPL_TOP

APPS <CONTEXT_NAME>. env APPL_TOP extends lidated Environment File $ APPL_TOP

EBS DBAs often use some scripts,

1) In Application Tier, some scripts related to Application-layer processes will be provided to DBAs. These scripts are in the path $ ADMIN_SCRIPTS_HOME and $ INST_TOP/admin/scripts. Examples of these scripts are as follows:

Adautocfg. sh can be used to run AutoConfig. Each operation reads the information in the configuration file and takes effect.

Adcmctl. sh can be used to start/stop the concurrent manager process.

Adapcctl. sh can be used to start/stop HTTP server

Adfrmctl. sh can be used to start/stop forms Solaris instance

2) In DB tier, some scripts can be used to manage database processes. Their path is

<RDBMS ORACLE_HOME>/appsutil/scripts/<CONTEXT_HOME>, for example:

Addlnctl. sh start/stop <SID> start/stop listener process of the database

Addbctl. sh start/stop normal start/stop database Process

3) In addition, there are some scripts related to the AD Administration work, which are located under the directory $ APPL_TOP/ad/12.0.0/bin. These script tasks are mainly divided into the following types:

File generation tasks

File system maintenance tasks

Database maintenance tasks

Database entities compilation and reloading tasks

For example, adpatch is used for patching, and adconfig. sh can be used to report related configuration information. The information generated by these scripts is under $ APPL_TOP/admin/<SID>/log.

EBS 11i and R12 Directory structure (EBS Directory structure)

=== For Applmgr User ===
APPL_TOP:
11i: <pai_base>/<SID> appl
R12: <pai_base>/apps/pai_st/appl
NOTE: Oracle Applicaitons product files, including $ INV_TOP, $ AU_TOP ....

COMMON_TOP:
11i: <pai_base>/<SID> comn
R12: <cmd_base>/apps/cmd_st/comn (Common files such as Java & HTML)
NOTE: $ JAVA_TOP is under $ COMMON_TOP

ORACLE_HOME
11i: <pai_base>/<SID> ora/8.0.6
R12: <pai_base>/apps/tech_st/10.1.2

=== For Oracle User ===
ORACLE_HOME
11i: <ORACLE_BASE>/<SID> db/10.2.0
R12: <ORACLE_BASE>/db/tech_st/10.2.0
NOTE: Oracle Home for 10g RDBMS

ORADATA
11i: <ORACLE_BASE>/<SID> data
R12: <ORACLE_BASE>/db/pai_st/data
NOTE: Oracle 10g database files

=== INSTANCE_HOME ===
INST_TOP
11i: N/
R12: <pai_base>/inst/apps/<context_name>
NOTE: Configuration, logs, Certificates.

11i

R12

Common

N

Other Pic