架构英文

C:iknowdocsharedatacur_

OracleApplications11iArchitectureIntroduction

OracleApplications11iArchitectureIntroduction......................................................1

-TierArchitecture.......................................................................................1

1.1DatabaTier.......................................................................................2

1.2ApplicationTier.....................................................................................2

1.3DesktopTier.........................................................................................3

tTypes....................................................................................................3

2.1Forms-badProductArchitecture........................................................3

2.2HTML-badProductArchitecture........................................................3

2.3BusinessIntelligenceSystem(BIS)ProductArchitecture......................4

tVersions................................................................................................4

e11iNewFeatures.................................................................................5

4.1PersonalHomepage.............................................................................5

4.2Cost-badOptimization.......................................................................5

4.3RapidInstall..........................................................................................6

ationalizationSupport................................................................................6

5.1LanguageSupport................................................................................6

5.1.1LanguagesandCharacterSetsontheDatabaTier....................6

5.1.2LanguagesandCharacterSetsontheApplicationTier..................6

5.1.3CharacterSetsontheDesktopTier................................................7

5.2TerritoryandOrganizationSupport.......................................................7

5.2.1Country-specificFunctionality.........................................................7

5.2.2MultipleOrganizationArchitecture..................................................7

5.2.3MultipleReportingCurrencies........................................................7

stem.........................................................................................................7

6.1MainDirectoryStructures......................................................................7

6.2TheDATADirectory..............................................................................8

6.3TheAPPLDirectory..............................................................................8

6.3.1TheCoreTechnologyDirectory......................................................9

6.3.2TheProductDirectory....................................................................9

6.3.3LanguageFiles...............................................................................9

6.4TheORADirectory................................................................................9

6.5TheCOMNDirectory...........................................................................10

-TierArchitecture

Databatier:

ItmanagesOracle8idataba.

Applicationtier:

ItmanagesOracleApplicationsandothertools.

AllOracleApplicationssoftwareandothertoolsaredeployedonthe

Applicationtierandthusiteliminatestheneedtoinstallandmaintain

applicationsoftwareoneachdesktopclient.

ThesoftwareontheapplicationtieralsoenablesOracleApplicationsto

scalewithloadandtokeepnetworktrafficlow.

Desktoptier:

rwords,onlythe

prentationlayerofOracleApplicationsisonthedesktoptierintheform

ofaplug-intoastandardInternetbrowr.

C:iknowdocsharedatacur_

1.1DatabaTier

DataServer:AmachineonwhichthedatabaholdingOracleApplications

abarverprocessSQLandJavarequestsfrom

othermachines,suchasFormsrvers,HTTPrvers,andconcurrent

processingrvers.

ReportsServer:Therverthatsupportsdataanalysisandad-hocqueries.

ConcurrentProcessingServer:AnOracleApplicationsrverthatruns

time-consuming,non-interactivetasksinthebackground.

AdministrationServer:Therverfromwhichthesystemadministratorruns

programsthatmaintainandupdatetheOracleApplicationsdataba.

1.2ApplicationTier

HTTPServer:AnapplicationrverthatrunsanHTTPlistener,andnds

outwebpagesinrespontoHTTPrequestsfromremotebrowrs.

FormsServer:AtypeofapplicationrverthathoststheFormrverengine.

Itmediatesbetweenthedesktopclientandthedataba,providinginput

screensfortheForms-badproductsonthedesktopclientandcreatingor

changingdatabarecordsbadonuractions.

DiscovererServer:Therverthatprovidesad-hocanalysis.

C:iknowdocsharedatacur_

1.3DesktopTier

WebBrowr:Aprogramrunningonadesktopclienttheviewsdocuments

owrndsrequeststo

aHTTPrverusingaspecialprotocol(HTTP)toretrievedocumentsand

Javaapplets.

tTypes

2.1Forms-badProductArchitecture

FormsServerandFormsClient:

TheFormsServermediatesbetweentheFormsclient,aJavaapplet

runningonthedesktop,andtheOracle8idatabarveronthe

msrverproducestheeffectsauresonthe

desktopscreenandcauschangestodatabarecordsbadonur

actions.

AJava-enabledwebbrowrmanagesthedownloading,start-up,and

executionoftheFormsclientonthedesktop.

2.2HTML-badProductArchitecture

OracleSelf-ServiceWebApplicationsandOracleWorkflow

Self-ServiceWebApplicationsprovideaneasy-to-uinterfacetours.

SincetheinterfaceisfamiliartoWeburs,itdoesnotrequireany

training.

ManyOracleApplicationsproductsuOracleWorkflowtoautomatically

enforcebusinessrulesandpoliciesandtoprovideacommonnotification

cleWorkflowmonitorsbusinessprocess,collects

processdata,andprovidesane-mailandwebpagenotificationsystem.

C:iknowdocsharedatacur_

2.3BusinessIntelligenceSystem(BIS)ProductArchitecture

BusinessIntelligenceSystemisadecisionsupportsolutionintegratedwith

heBISproducts,amanagercanquerytheOracle

Applicationsdatabatomonitorrecentbusinessperformanceacross

multipleorganizations.

BISERPandCRMproductsdonotutheFormsrverorFormsclient.

Instead,BISproductsutheOracleDiscovererrverandOracleReports

ppletrunningondesktopclient

communicateswiththeHTTPrver,whichconnectstotheDiscoverer

rverorReportsrver.

tVersions

Thefollowingtableshowstheversioninformationofproductcomponents

workingwithOracleApplications11.5.6.

ComponentNameVersion

Oracle8iEnterpriEdition8.1.7.2

C:iknowdocsharedatacur_

OracleiAS1.0.0.0.0

ApacheHTTPServer1.3.9

Developer6i

-Forms

-Reports

Patcht8

6.0.8.17.x

6.0.8.17.x

JInitiator1.1.8.16

JDK(web_tier)1.3.1

e11iNewFeatures

4.1PersonalHomepage

ThePersonalHomepageisthestartingpointfromwhichyoucanaccessall

ERP,CRM,Self-ServiceWebApplications,gged

intothePersonalHomepage,youneednotsignonagaintoaccessother

partsofthesystem.

OracleApplicationsalsoretainspreferencesasyounavigatetoothertools

andproducts.

YoucanalsocustomizethePersonalHomepagetofityourindividualneeds

andresponsibilities.

4.2Cost-badOptimization

TheOracleoptimizerevaluatesmanyfactorstocalculatethemostefficient

eitherarule-badorcost-bad

-badoptimizationwasudinearlierreleas,buttheSQL

udinRelea11itunedforcost-badoptimization,andRelea11i

requirestheoptimizertouthecost-badoptimization(CBO).

C:iknowdocsharedatacur_

UsingCBO,theoptimizerconsiderstheavailableaccesspathsandfactorsin

statisticalinformationforthetablesandindexesthattheSQLstatementwill

,theoptimizercreatesatofpotentialexecutionplansforthe

e

optimizerestimatesthecostofeachexecutionplanbadonstatisticsinthe

datadictionaryforthedatadistributionandstoragecharacteristicsofthe

tables,indexes,imizercomparesthecostsofthe

executionplansandchoostheonewiththesmallestcost.

OracleApplications11iprovidestheconcurrentprogram“GatherSchema

Statistics”tohelptocollectufulstatisticsforCBOtogenerateoptimalplans.

4.3RapidInstall

Relea11iintroducesRapidInstall:awizardthathelpsyouinstalla

completetofOracleApplicationsatthelatestavailableMaintenancePack

nstallinstallstherequiredtechnologystackandcreatesthe

OracleApplicationsdataba.

YoucanuRapidInstalltoinstallanyofthreeenvironments:aproduction

installation,atestinstallation,andaninstallationoftheVisionDemo

databa.

RapidInstallalsoletsyoulicenproducts,country-specificfunctionality,and

languages.

RapidInstallstoresalltheparametersyouchooinaconfigurationfile,

defaultnamedas“”.

ationalizationSupport

5.1LanguageSupport

5.1.1LanguagesandCharacterSetsontheDatabaTier

TheOracle8idatabatierisinstalledintheUS7ASCIIcharactertby

default,butcanbeconvertedtoruninanyothersupportedcharactert.

YouchoothedatabacharactertwhenrunningRapidInstall,and

RapidInstallconvertsthedatabatothenewcharactert.

ThesuitabledatabacharactertforSimplifiedChineis

“ZHS16GBK”.

5.1.2LanguagesandCharacterSetsontheApplicationTier

TheapplicationtierisinstalledintheUS7ASCIIcharactertbydefault,

specifytheapplicationtiercharactertwhenrunningRapidInstall.

ThesuitableapplicationtiercharactertforSimplifiedChineis

“ZHS16GBK”.

TheHTTPrversontheapplicationtiermustuacharactert

characterts

the

onlycompatibilityrequirementbetweenthedesktoptierandapplication

tier.

C:iknowdocsharedatacur_

5.1.3CharacterSetsontheDesktopTier

Languagesupport,whichincludessupportfordatainputmethodsand

requiredcharactertsandfonts,mustbeavailableinthedesktopclient’s

operatingsystem.

Thedesktopbrowrmustbeconfiguredtoinputdataintherequired

languageandmusthandleanylanguage-specificcapabilities.

ust

notchangetheircharactertinthebrowrduringanOracle

Applicationsssion.

5.2TerritoryandOrganizationSupport

5.2.1Country-specificFunctionality

OracleApplicationshasasinglecommoncoreoffunctionality,with

country-specificextensionstomeetthestatutory,legal,andcultural

practicesofdifferentcountries.

Althoughallcountry-specificextensionsareinstalled,youmustlicen

Installlistsallthecountriesthathaveextensionsandlicensthe

extensionsyouchoo.

5.2.2MultipleOrganizationArchitecture

Youcandefinemultipleorganizations(Multi-Org)andtherelationships

amongtheminasingleinstallationofOracleApplications.

Thetypesoforganizationsthatcanbedefinedincludebusinessgroups,

tofbooks,legalentities,balancingentities,operatingunits,inventory

organizations,HRorganizations,andorganizationsinOracleProjectsand

OracleFixedAsts.

WhenyourunOracleApplicationsproducts,youfirstchooan

organization–eitherimplicitlybychoosingaresponsibility,orexplicitlyin

ndowandreportthendisplays

informationforyourorganizationonly.

5.2.3MultipleReportingCurrencies

TheMultipleReportingCurrencies(MRC)featureallowsyoutoreportand

maintainaccountingrecordsatthetransactionlevel,inmorethanone

functionalcurrency.

Primaryfunctionalcurrencyisthecurrencyyouutorecordtransactions

primaryfunctionalcurrencyisgenerallythecurrencyinwhichyouperform

mostofyourbusinesstransactionsandtheoneyouuforlegalreporting.

Areportingfunctionalcurrencyisacurrency,otherthenyourprimary

functionalcurrency,thatyouneedforreports.

stem

6.1MainDirectoryStructures

InRelea11i,

followingshowsthemaindirectorystructuresondatabatierandapplication

tier.

C:iknowdocsharedatacur_

DatabaTierApplicationTier

DATAAPPLCOMNORA

Oracle8iDatabaFiles

Oracle

Applications

ProductFiles

OracleHomesfor

Oracle8iRDBMS,

Oracle

Technology

Stack,and

ApacheServer

CommonFiles,

suchasLog,

Output,HTMLand

JavaFiles

Exampleofeachdirectorystructurelocation:

DATA:/data//data

APPL:/app//appl

ORA:

/ora//db/8.1.7(OracleHomefor8iRDBMS)

/app//ora/8.0.6(OracleHomeforTechnologyStack)

/app//ora/iAS(OracleHomeforApacheServer)

COMN:/app//comn

6.2TheDATADirectory

esoftheOracleApplications

Oracle8idataba.

TheDATAdirectory

data

6.3TheAPPLDirectory

nstallsaves

thenameofthisAPPLdirectoryintheAPPL_TOPenvironmenttting.

EachApplicationTopdirectoryhasamainenvironmentfile,.env,

whichnamedafterthedatabainstanceassociatedwiththeinstallation.

WithintheAPPL_TOPdirectory,filesassociatedwithaproductareinstalled

undertheproduct’stop-leveldirectory,whichisstoredinthe_TOP

portionofthinvironmentttingisthe

product’sshortname,suchasad,au,fnd,gl,responding

_TOPenvironmentttingsareAD_TOP,AU_TOP,FND_TOP,

GL_TOP,andINV_TOP.

Forcompatibilitywithearlierreleas,RapidInstallcreatesanotherdirectory,

namedfortheversionnumber,withintheproduct’

example,thevaluecontainedintheAD_TOPenvironmentttingis

APPL_TOP/ad/11.5.0

C:iknowdocsharedatacur_

TheAPPL_TOPDirectory

.envadminadaufnd

11.5.011.5.011.5.0

(otherproduct

directories)

gl

11.5.0

adminbinforms

USZHS

6.3.1TheCoreTechnologyDirectory

Theadmin,ad,au,andfnddirectoriesarethecoretechnologydirectories.

Theadmindirectoryholdsfilesudforthepreliminaryinstallorupgrade

ectoriesinthisadmin

directoryholdthelogandrestartfilesthatrecordtheactionsperformedby

installationandupgradeutilitiesandscripts.

Thead(ApplicationsDBA)directorycontainstheinstallationand

maintenanceutilitiessuchasAutoUpgrade,AutoPatch,andtheadadmin

utility.

Theau(ApplicationsUtilities)directorycontainsPL/SQLlibrariesudby

OracleFormsandOracleReports,OracleFormssourcefiles,andacopy

ofallJavafilesudtogeneratethedesktopclient.

Thefnd(Foundation)directorycontainstheformsandCobjectlibraries,

andscriptsthatareudtobuildtheOracleApplicationsdatadictionary.

6.3.2TheProductDirectory

Each_TOPdirectory,suchasAPPL_TOP/gl/11.5.0,contains

subdirectoriesforproductfiles.

Productfilesincludeshellscriptsforconcurrentprograms,formsfiles,

reportfiles,andsomefilestoinstallorupgradethedataba(buttables

andotherdatabaobjectsarestoredparatelyontheOracle8i

databarver).

6.3.3LanguageFiles

WhenyouinstallOracleApplicationsinalanguageotherthanAmerican

English(languagecode=US),eachproducttreeincludesdirectoriesthat

irectoriesholdtranslateddata,form,

html,messageandreportfiles.

ThelanguagecodeforSimplifiedChineisZHS.

6.4TheORADirectory

OracleApplicationssupportsrunningwithdatainadatabaofoneversion,

whilelinkingOracleApplicationsprogramsusingthetoolsfromacondor

knownasmultipleOracleHomes.

C:iknowdocsharedatacur_

ThismodelallowsOracletosupportfeaturesinlaterdatabarver

versionsandstillmaintaincompatibilitywithanearlierrelea.

Relea11ihasthreeOracleHomes.

DatabaHome:containsthefilesforcreatingandmaintainingthe

Oracle8idatabaonthedatabarver.

TechnologyStackHome:containslibraryandobjectfilestheADRelink

UtilityustolinkOracleApplicationsprogramswithForms-badtools

ontheFormsrverandReportrver.

HTTPHome:containstheobjectandlibraryfilesudtolinkwiththe

HTTPrver.

6.5TheCOMNDirectory

TheCOMN(COMMON_TOP)directorycontainsfilesthatareudby

veraldifferentOracleApplicationsproducts(orallOracleApplications

products),orthatareudwiththird-partyproducts.

TheCOMNDirectory

adminhtmljavaportaltemputil

TheOA_cle

Applicationshtmlsign-onscreenandOracleSelf-ServiceWebApplications

nstallalanguageotherthanAmerican

English,thehtmltopdirectorycontainssubdirectories,namedbylanguage

code,forthetranslatedhtmlfiles.

TheJAVA_nstall

installsallOracleApplicationsclassfilesintheOraclenamespaceofthis

JAVA_adirectoryholdsthird-partyjavafilesudby

OracleApplicationsaswellasotherzipfiles.

idInstall

Portalisawebpagethatincludesthepost-installtasksthatmaybe

necessaryforyourinstallation,ServerAdministrationscripts,installation

documentation,andonlinehelp.