supportedoracle10g

OracleRetailValueChainCollaborationInstallationGuideRelease12.
1April2007OracleRetailValueChainCollaborationInstallationGuide,Release12.
1Copyright2007,Oracle.
Allrightsreserved.
PrimaryAuthor:UshaRajThePrograms(whichincludeboththesoftwareanddocumentation)containproprietaryinformation;theyareprovidedunderalicenseagreementcontainingrestrictionsonuseanddisclosureandarealsoprotectedbycopyright,patent,andotherintellectualandindustrialpropertylaws.
Reverseengineering,disassembly,ordecompilationofthePrograms,excepttotheextentrequiredtoobtaininteroperabilitywithotherindependentlycreatedsoftwareorasspecifiedbylaw,isprohibited.
Theinformationcontainedinthisdocumentissubjecttochangewithoutnotice.
Ifyoufindanyproblemsinthedocumentation,pleasereportthemtousinwriting.
Thisdocumentisnotwarrantedtobeerror-free.
ExceptasmaybeexpresslypermittedinyourlicenseagreementforthesePrograms,nopartoftheseProgramsmaybereproducedortransmittedinanyformorbyanymeans,electronicormechanical,foranypurpose.
IftheProgramsaredeliveredtotheUnitedStatesGovernmentoranyonelicensingorusingtheProgramsonbehalfoftheUnitedStatesGovernment,thefollowingnoticeisapplicable:U.
S.
GOVERNMENTRIGHTSPrograms,software,databases,andrelateddocumentationandtechnicaldatadeliveredtoU.
S.
Governmentcustomersare"commercialcomputersoftware"or"commercialtechnicaldata"pursuanttotheapplicableFederalAcquisitionRegulationandagency-specificsupplementalregulations.
Assuch,use,duplication,disclosure,modification,andadaptationofthePrograms,includingdocumentationandtechnicaldata,shallbesubjecttothelicensingrestrictionssetforthintheapplicableOraclelicenseagreement,and,totheextentapplicable,theadditionalrightssetforthinFAR52.
227-19,CommercialComputerSoftware—RestrictedRights(June1987).
OracleCorporation,500OracleParkway,RedwoodCity,CA94065TheProgramsarenotintendedforuseinanynuclear,aviation,masstransit,medical,orotherinherentlydangerousapplications.
Itshallbethelicensee'sresponsibilitytotakeallappropriatefail-safe,backup,redundancyandothermeasurestoensurethesafeuseofsuchapplicationsiftheProgramsareusedforsuchpurposes,andwedisclaimliabilityforanydamagescausedbysuchuseofthePrograms.
Oracle,JDEdwards,PeopleSoft,andSiebelareregisteredtrademarksofOracleCorporationand/oritsaffiliates.
Othernamesmaybetrademarksoftheirrespectiveowners.
TheProgramsmayprovidelinkstoWebsitesandaccesstocontent,products,andservicesfromthirdparties.
Oracleisnotresponsiblefortheavailabilityof,oranycontentprovidedon,third-partyWebsites.
Youbearallrisksassociatedwiththeuseofsuchcontent.
Ifyouchoosetopurchaseanyproductsorservicesfromathirdparty,therelationshipisdirectlybetweenyouandthethirdparty.
Oracleisnotresponsiblefor:(a)thequalityofthird-partyproductsorservices;or(b)fulfillinganyofthetermsoftheagreementwiththethirdparty,includingdeliveryofproductsorservicesandwarrantyobligationsrelatedtopurchasedproductsorservices.
Oracleisnotresponsibleforanylossordamageofanysortthatyoumayincurfromdealingwithanythirdparty.
iiiContentsPrefacevAudiencevRelatedDocuments.
vCustomerSupport.
vConventions.
v1HardwareandSoftwareRequirementsforVCC1VCCDatabaseServer1VCCApplicationServer.
2WebBrowserandClientrequirements.
2CreateaUNIXuseraccounttoinstallthesoftware2CreateStagingDirectoryforVCCDatabaseFiles22DatabaseInstallationTasks.
3CreatetheVCCDatabase.
3CreatetheDatabaseasFollows:3CreatetheTablespaces:4CreatetheSchemaOwner5CreateVCCObjects5MigrationfromVCC12.
0.
x63ApplicationInstallationUNIX(SunSolaris/AIX/HP-UX)7CreateaNewOC4JInstanceforVCC.
7ExpandtheVCCApplicationDistribution8RuntheVCCApplicationInstaller.
8ResolvingErrorsEncounteredDuringApplicationInstallation.
9BackupsCreatedbyInstaller.
9TesttheVCCApplication.
9configuration.
xml.
9VCCBatchScripts.
9WebHelpFiles9ivAAppendix:VCCApplicationInstallerScreens.
11BAppendix:InstallerSilentMode19RepeatinganInstallationAttempt19CAppendix:URLReference21DAppendix:CommonInstallationErrors.
23DatabaseInstallerHangsonStartup.
23"Unabletogetadeploymentmanager"Message.
23EAppendix:VCCSupportedPlatforms.
25FAppendix:ManagingSessionTimeouts27GAppendix:Oracle10gDatabaseCreationScripts.
29HAppendix:ConfigureListenerforExternalProcedures33vPrefaceOracleRetailInstallationGuidescontaintherequirementsandproceduresthatarenecessaryfortheretailertoinstallOracleRetailproducts.
AudienceThisInstallationGuideiswrittenforthefollowingaudiences:Databaseadministrators(DBA)SystemanalystsanddesignersIntegratorsandimplementationstaffRelatedDocumentsFormoreinformation,seethefollowingdocumentsintheOracleRetailValueChainCollaborationRelease12.
1documentationset:OracleRetailValueChainCollaborationReleaseNotesOracleRetailValueChainCollaborationUserGuideCustomerSupporthttps://metalink.
oracle.
comWhencontactingCustomerSupport,pleaseprovide:Productversionandprogram/modulename.
Functionalandtechnicaldescriptionoftheproblem(includebusinessimpact).
Detailedstep-by-stepinstructionstorecreate.
Exacterrormessagereceived.
Screenshotsofeachstepyoutake.
ConventionsNavigate:Thisisanavigatestatement.
Ittellsyouhowtogettothestartoftheprocedureandendswithascreenshotofthestartingpointandthestatement"theWindowNamewindowopens.
"Note:Thisisanote.
Itisusedtocalloutinformationthatisimportant,butnotnecessarilypartoftheprocedure.
ThisisacodesampleItisusedtodisplayexamplesofcodeAhyperlinkappearslikethis.
HardwareandSoftwareRequirementsforVCC11HardwareandSoftwareRequirementsforVCCPriortoinstallingvalueChainCollaborationproducts,reviewtherequirementslistedbelow.
Verifythattheserequirementsaremetandthatthehardwarewilladequatelyrunthesoftwaretobeinstalled,aswellasprocesstheanticipatedvolumeofdata.
TermsDescriptionDatabaseServerDatabasesoftwarerequirements.
ApplicationserverOperatingsystemsoftwareanddevelopmenttoolsandalistofhardwarechoices.
WebBrowserSupportedOS/Browser/Javaplug-inrequirementThefollowingtableliststheacceptableserver,operatingsystemandwebbrowserversions:DatabaseServerApplicationServerOSClientVCCOracle10gR2OAS10.
1.
3UnixSolaris9WebBrowserInternetExplorer5.
5,6.
0andhigherSunJREplugin1.
5VCCDatabaseServerGeneralRequirementsforadatabaseserverrunningVCCinclude:UNIXbasedOScertifiedwithOracleRDBMS10gEnterpriseEdition(optionsareAIX5.
2,AIX5.
3andSolaris9)OracleRDBMS10gRelease2EnterpriseEdition(minimum10.
2.
0.
2.
0patchsetrequired)withthefollowingpatchesandcomponents:Patches:4516865(WRONGPERMISSIONSAFTERINSTALLATIONINOHANDSUBSEQUENTDIRECTORIES)Components:OracleDatabase10gOraclePartitioningOracleNetServicesOracleCallInterface(OCI)OracleProgrammerOracleXMLDevelopmentKitCreateaUNIXuseraccounttoinstallthesoftware2OracleRetailValueChainCollaborationVCCApplicationServerGeneralrequirementsforanapplicationservercapableofrunningtheVCCapplicationinclude:UNIXbasedOScertifiedwithOracleApplicationServer10g10.
1.
3.
OptionsincludeAIX5.
2,AIX5.
3andSolaris9.
OracleApplicationServer10g10.
1.
3withthefollowingpatches:–4992357(ILLEGALACCESSERRORWHENATTEMPTINGTOLOADORACLE.
SQL.
CHARACTERSETCLASS)–4959854(CANNOTRESTARTMDBTHROUGHOC4JASCONSOLE)–4645524(RETEK:RMIINITIALCONTEXTFACTORYDOESNOTWORKPROPERLYWITHGLOBALJNDI)–4619599(ABILITYTOCONTROLMDBSINITIALSTATE)Note:ThisreleaseofVCCisonlysupportedinamanagedOC4JinstanceaspartofOracleAS10g.
ItisnotsupportedonOC4Jstandalone.
WebBrowserandClientrequirementsGeneralrequirementsforclientrunningVCCinclude:ClientPCrequirementsOperatingsystemisWindows2000orXPDisplayresolution:1024x768Processor;minimum1GHzMemory;minimumof512MBytesNetworking;Intranetwithatleast10Mbpsdatarate.
SunJRE1.
532bitBrowserRequirementsMicrosoftInternetExplorer;version5.
5orhigherCreateaUNIXuseraccounttoinstallthesoftwareThefollowingusershouldbecreatedonboththeapplicationanddatabaseservers.
1.
CreateaUNIXgroupnamed"dev".
2.
CreateUNIXusernamed"oretail"andassignittothe"dev"group.
ThisuserwillinstalltheVCCsoftwareCreateStagingDirectoryforVCCDatabaseFiles1.
Logintothedatabaseserverasoretail.
2.
CreateastagingdirectoryfortheVCCdatabaseinstallationsoftware.
Thereshouldbeaminimumof100MBdiskspaceavailableinthislocation.
3.
Copythevcc12dbserver.
zipfilefromtheCD/dbserverunixdirectorytothestagingdirectory.
ThiswillbereferredtoasINSTALL_DIRwheninstallingdatabasesoftware.
4.
ChangedirectoriestoINSTALL_DIRandextractthevcc12dbserver.
zipfileDatabaseInstallationTasks32DatabaseInstallationTasksCreatetheVCCDatabaseItisassumedthatOracle10grelease2,withappropriatepatches,hasalreadybeeninstalled.
Ifnot,referto"CheckDatabaseServerRequirements"inChapter1,"Pre-InstallationTasks"beforeproceeding.
Additionally,INSTALL_DIRinthissectionreferstothedirectorycreatedin"CreateStagingDirectoryforVCCDatabaseFiles",Chapter1.
Ifadatabasehasalreadybeencreated,itisnecessarytoreviewthecontentsofthissectiontodetermineifalldatabasecomponentshavebeeninstalledandconfiguredproperly.
AlsorefertoAppendicesG&H.
CreatetheDatabaseasFollows:1.
LogintoUNIXastheOracleuser;typicallytheuserthatownstheOracleRDBMSsoftware.
2.
CreatetheOraclerecommendedOFAdirectorystructureforthedatabase(datafiledirectories,adump,bdump,cdump,arch,create,exp,pfile,udump,utl_file_dir)3.
PlaceanentryintheoratabfileforthedatabaseandexecuteoraenvtosettheORACLE_SIDandORACLE_HOMEenvironmentvariables.
4.
CopyINSTALL_DIR/create_db/init.
oratothe$ORACLE_HOME/pfiledirectoryandrenameittoinit${ORACLE_SID}.
ora.
Modifytheparametersaccordingtoguidelinesspecifiedinthisfile.
5.
Createasymboliclinkfrom$ORACLE_HOME/pfile/init${ORACLE_SID}.
orato$ORACLE_HOME/dbs/init${ORACLE_SID}.
ora.
6.
ModifytheINSTALL_DIR/create_db/crdb1.
sqlfile.
Refertocommentsinthisfileregardingmodificationsthatneedtobemade.
7.
LogintoSQL*PlusasSYSDBAandexecuteINSTALL_DIR/create_db/crdb1.
sql.
Reviewcrdb1.
logforerrorsandcorrectasneeded.
8.
LogintoSQL*PlusasSYSDBAandexecuteINSTALL_DIR/create_db/crdb2.
sql.
Reviewcrdb2.
logforerrorsandcorrectasneeded.
9.
LogintoSQL*PlusasSYSDBAandexecuteINSTALL_DIR/create_db/crdb3.
sql.
ReviewJServer.
log,context.
logandxdb_protocol.
logforerrorsandcorrectasneeded.
10.
Configurethelistener.
TheVCCapplicationusesexternalprocedurecalls.
Therefore,thelistener.
oraandtnsnames.
orafilesmustbeconfiguredproperly.
RefertoAppendixG.
CreatetheVCCDatabase4OracleRetailValueChainCollaborationCreatetheTablespaces:Tablespace:SYNCRA_DATAExecutethisquerytocreateatablespaceinthesqlprompt.
CREATETABLESPACE"SYNCRA_DATA"LOGGINGDATAFILE'/files3/oradata/cssyncra/syncra_data.
dbf'SIZE5000MREUSEAUTOEXTENDONNEXT128MMAXSIZE5000M,'/files3/oradata/cssyncra/Syncra_data02.
dbf'SIZE3244288KREUSEAUTOEXTENDONNEXT8KMAXSIZE5000M,'/files5/oradata/cssyncra/Syncra_data03.
dbf'SIZE3294720KREUSEAUTOEXTENDONNEXT8KMAXSIZE5000M,'/files3/oradata/cssyncra/Syncra_data04.
dbf'SIZE5000MREUSEAUTOEXTENDONNEXT100MMAXSIZE5000M,'/files3/oradata/cssyncra/Syncra_data05.
dbf'SIZE5000MREUSEAUTOEXTENDONNEXT100MMAXSIZE5000M,'/files3/oradata/cssyncra/Syncra_data06.
dbf'SIZE700MREUSEAUTOEXTENDONNEXT100MMAXSIZE5000MEXTENTMANAGEMENTLOCALSEGMENTSPACEMANAGEMENTAUTOPath:Changethefolderpath(Blocklettersinthequery)accordingtoyourmachinewherethistablespacehastobesaved.
AminimumofONEdatafileisrequiredforatablespace.
Ifspacepermitsthenyoucanhavealldatafilesinthistablespace,elsejustonewouldbesufficient.
Tablespace:SYNCRA_INDEXCREATETABLESPACE"SYNCRA_INDEX"LOGGINGDATAFILE'/files5/oradata/cssyncra/syncra_index_01.
dbf'SIZE5000MREUSEAUTOEXTENDONNEXT128MMAXSIZE5000M,'/files5/oradata/cssyncra/Syncra_index02.
dbf'SIZE3177MREUSEAUTOEXTENDONNEXT8KMAXSIZE5000M,'/files8/oradata/cssyncra/Syncra_index03.
dbf'SIZE3226112KREUSEAUTOEXTENDONNEXT8KMAXSIZE5000M,'/files5/oradata/cssyncra/Syncra_index04.
dbf'SIZE5000MREUSEAUTOEXTENDONNEXT100MMAXSIZE5000M,'/files8/oradata/cssyncra/Syncra_index05.
dbf'SIZE5000MREUSEAUTOEXTENDONNEXT100MMAXSIZE5000M,'/files8/oradata/cssyncra/Syncra_index06.
dbf'SIZE800MREUSEAUTOEXTENDONNEXT100MMAXSIZE5000MEXTENTMANAGEMENTLOCALSEGMENTSPACEMANAGEMENTAUTOPath:Changethefolderpath(Blocklettersinthequery)accordingtowhereyouwishtoplacethetablespaceinyourmachine.
AminimumofONEdatafileisrequiredforatablespace.
Ifspacepermitsthenyoucanhavealldatafilesinthistablespace,elsejustonewouldbesufficient.
CreatetheVCCDatabaseDatabaseInstallationTasks5Tablespace:SYNCRA_TEMPCREATETEMPORARYTABLESPACE"SYNCRA_TEMP"LOGGINGDATAFILE'/files5/oradata/cssyncra/syncra_temp_01.
dbf'SIZE3584MREUSEAUTOEXTENDONNEXT128MMAXSIZE5000MEXTENTMANAGEMENTLOCALSEGMENTSPACEMANAGEMENTAUTOPath:Changethefolderpath(Blocklettersinthequery)accordingtoyourmachinewheretoplacethetablespace.
AminimumofONEdatafileisrequiredforatablespace.
Ifspacepermitsthenyoucanhavealldatafilesinthistablespace,elsejustonewouldbesufficient.
CreatetheSchemaOwnerCreateanOracleschemathatwillowntheVCCapplication.
1.
ChangedirectoriestoINSTALL_DIR/vcc/dbschema/Oracle/setupLogintosqlplusassysdba2.
Enterthefollowingcommandtocreatetheschemaowner.
SQL>@setup.
sqlThefollowingpromptswilloccur:Example:Schemaownerlogin:vcc(yourchoice)Schemaownerpasswd:vcc(yourchoice)Defaulttablespace:SYNCRA_DATA(Mandatorysamename)TEMPtablespace:Syncra_temp(same)3.
Checkthelogfilesetup.
logforanyerrors.
CreateVCCObjects1.
ChangedirectoriestoINSTALL_DIR/vcc/dbschema/Oracle/lib2.
LogintosqlplusastheVCCschemaownerandrunthefollowingcommand:SQL>@create_config.
sql3.
Checkthelogfileforanyerrors4.
LogintosqlplusastheVCCschemaownerandrunthefollowingcommand:SQL>@syncra_build.
sql5.
Checkthelogfileforanyerrors.
CreatetheVCCDatabase6OracleRetailValueChainCollaborationMigrationfromVCC12.
0.
xNote:IfthisisanewinstallandnodataneedstobemigratedfromanexistingVCCinstallpleaseproceedtoChapter3.
1.
ChangedirectoriestoINSTALL_DIR/vcc/dbschema/Oracle/scripts/migration2.
LogintosqlplusastheVCCschemaownerandrunthefollowingcommand:SQL>@reset_target_db_defaults.
sql3.
Exportthe12.
0.
xschemaowner4.
ChangedirectoriestoINSTALL_DIR/vcc/dbschema/Oracle/scripts/migration5.
LogintosqlplusastheVCCschemaownerforthe12.
0.
xSchemaandrunthefollowingcommand:SQL>@get_partitions_src_db.
sqlNote:get_partitions_src_db.
sqlwillgeneratecreate_partitions.
sql6.
LogintosqlplusastheVCCschemaownerforthe12.
1schemaandrunthefollowingcommand:SQL>@create_partitions.
sql7.
Checkthelogfileforanyerrors8.
ChangedirectoriestoINSTALL_DIR/vcc/dbschema/Oracle/scripts/migrationandedittheimp_mig.
cmdfiledbauser–TheschemaownerforVCC12.
1dbauserpwd–ThepasswordfortheVCC12.
1schemaownedbalias–ORACLE_SIDfortheVCC12.
1schemavcc1202_user–schemaowneroftheexportdoneinstep3vcc12.
1_user-TheschemaownerforVCC12.
19.
Runimp_mig.
cmdfromtheunixcommandline10.
AfterimportissuccessfulchangedirectorytoINSTALL_DIR/vcc/dbschema/Oracle/lib11.
SetyouNLS_LANG=_.
UTF812.
LogintosqlplusastheVCCschemaownerforthe12.
1schemaandrunthefollowingcommands:SQL>@load_languages.
sqlSQL>@syncra_package_compile.
sql13.
CheckthelogfileforanyerrorsApplicationInstallationUNIX(SunSolaris/AIX/HP-UX)73ApplicationInstallationUNIX(SunSolaris/AIX/HP-UX)Pointstotakenotebeforeinstallation:MustinstallOracleApplicationServer10g10.
1.
3plusthepatcheslistedintheChapter1ofthisguide.
OracleRDBMStobeconfiguredandloadedwiththeappropriateVCCschemaforyourinstallationTheVCCapplicationwillbedeployedtoanOC4JinstancewithintheOracleApplicationServerinstallation.
ItisassumedthatOracleRDBMShasalreadybeenconfiguredandloadedwiththeappropriateVCCschemaforyourinstallation.
CreateaNewOC4JInstanceforVCCYoucanskipthissectionifyouarere-deployingtoanexistingOC4Jinstance.
TheVCCapplicationmustbedeployedtoitsowndedicatedOC4Jinstance.
ForinstructionsonhowtocreateanewOC4Jinstance,seeAddingandDeletingOC4JInstancesintheReconfiguringApplicationServerInstanceschapteroftheOracleApplicationServerAdministrator'sGuide.
1.
LogintotheserverwhichisrunningyourOracleASinstallation.
SetyourORACLE_HOMEenvironmentvariabletopointtothisinstallation.
ChooseanameforthenewOC4Jinstance.
Example:vcc-oc4j-instanceCreatethisOC4JinstanceasdocumentedintheOracleApplicationServerAdministrator'sGuide.
Example:$ORACLE_HOME/bin/createinstance–instanceNamevcc-oc4j-instanceWhenpromptedfortheoc4jadminpassword,providethesameadministrativepasswordyougavefortheOracleASinstallation.
AllOC4JinstancesrunningOracleRetailapplicationsmusthavethesameoc4jadminpassword.
2.
SettheforceoptionforOC4Jshutdownin$ORACLE_HOME/opmn/conf/opmn.
xml.
Thisoptionshouldbeintheprocessidsectionoftheinstancejustcreatedadded.
Example:…CreatetheVCCDatabase8OracleRetailValueChainCollaboration3.
TheopmnprocessshouldbereloadedExample:$ORACLE_HOME/opmn/bin/opmnctlreload4.
StarttheOC4Jinstance.
YoucandothisthroughtheEnterpriseManagerwebinterface,oronthecommandlineusingtheopmnctlutility:Example:$ORACLE_HOME/opmn/bin/opmnctlstartprocprocess-type=vcc-oc4j-instance5.
VerifythattheOC4Jinstancewasfullystarted.
IfyouareusingtheEnterpriseManagerwebinterface,theinstanceshouldhaveagreenarrowindicatingthatitisrunning.
Onthecommandline,verifythattheinstancehasastatusof"Alive".
Example:$ORACLE_HOME/opmn/bin/opmnctlstatusIfyouareunabletostarttheOC4Jinstanceafterseveralattempts,tryincreasingthestartuptimeoutsinORACLE_HOME/opmn/conf/opmn.
xml.
Ifthatdoesnothelp,consulttheOracleApplicationServerdocumentationforfurtherassistance.
ExpandtheVCCApplicationDistribution1.
LogintotheUNIXserverastheuserwhoownstheOracleApplicationServerinstallation.
CreateanewstagingdirectoryfortheVCCapplicationdistribution(vcc12application.
zip).
Thereshouldbeaminimumof120MBdiskspaceavailablefortheapplicationinstallationfiles.
Example:$ORACLE_HOME/j2ee/vcc-oc4j-instance/vcc-stagingThislocationwillbereferredtoasINSTALL_DIRfortheremainderofthischapter.
Copyvcc12application.
ziptoINSTALL_DIRandextractitscontents.
RuntheVCCApplicationInstallerOnceyouhaveanOC4Jinstancethatisconfiguredandstarted,youcanruntheVCCapplicationinstaller.
ThisinstallerwillconfigureanddeploytheVCCapplication.
Note:AppendixAcontainsdetailsoneveryscreenandfieldintheapplicationinstaller.
1.
ChangedirectoriestoINSTALL_DIR/vcc/application.
2.
SettheORACLE_HOMEandJAVA_HOMEenvironmentvariables.
ORACLE_HOMEshouldpointtoyourOracleASinstallation.
JAVA_HOMEshouldpointtotheJava1.
5JDKlocatedat$ORACLE_HOME/jdk.
TheinstallerisnotcompatiblewithearlierversionsofJava.
3.
IfyouareusinganXserversuchasExceed,settheDISPLAYenvironmentvariablesothatyoucanruntheinstallerinGUImode(recommended).
IfyouarenotusinganXserver,ortheGUIistooslowoveryournetwork,unsetDISPLAYfortextmode.
4.
Runtheinstall.
shscript.
Thiswilllaunchtheinstaller.
Afterinstallationiscompleted,adetailedinstallationlogfileiscreated:vcc12install-app.
.
log.
CreatetheVCCDatabaseApplicationInstallationUNIX(SunSolaris/AIX/HP-UX)9ResolvingErrorsEncounteredDuringApplicationInstallationIftheapplicationinstallerencountersanyerrors,itwillhaltexecutionimmediately.
Youcanruntheinstallerinsilentmodesothatyoudon'thavetoretypethesettingsforyourenvironment.
SeeAppendixBofthisdocumentforinstructionsonsilentmode.
SeeAppendixDofthisdocumentforalistofcommoninstallationerrors.
Sincetheapplicationinstallationisafullreinstalleverytime,anypreviouspartialinstallswillbeoverwrittenbythesuccessfulinstallation.
BackupsCreatedbyInstallerTheVCCapplicationinstallerwillbackupthepreviousvcc-*directoriesbyrenamingthemwithatimestampsuffix.
Thisisdonetopreventtheremovalofanycustomchangesyoumighthave.
Thesebackupdirectoriescanbesafelyremovedwithoutaffectingthecurrentinstallation.
Example:vcc-bin.
200605011726TesttheVCCApplicationAftertheapplicationinstallercompletesyoushouldhaveaworkingVCCapplicationinstallation.
Tolaunchtheapplication,openawebbrowserandgotohttp://host:httpport/contextrootExample:http://myhost:7777/vccconfiguration.
xmlTheconfiguration.
xmlfilecontainsmostofthesettingsfortheVCCapplication.
Manyparametersinthisfilearesetbytheinstallertogetaworkingapplicationupandrunning,butyoumaywanttomodifyothersettingsinthisfile.
YoucanfindthisfileunderORACLE_HOME/j2ee//vcc-config.
SeetheVCCOperationsGuideregardingthesettingsinconfiguration.
xml.
VCCBatchScriptsTheVCCapplicationinstallerconfiguresandinstallsthebatchscriptsunderORACLE_HOME/j2ee//vcc-bin.
WebHelpFilesTheapplicationinstallerautomaticallydeploysthewebhelpcontentunderacontextrootequaltotheapplicationcontextrootwith"-help"appended.
Example:http://myhost:7777/vcc-helpAppendix:VCCApplicationInstallerScreens11AAppendix:VCCApplicationInstallerScreensYouwillneedthefollowingdetailsaboutyourenvironmentfortheinstallertosuccessfullydeploytheVCCapplication.
Dependingontheoptionsyouselect,youmaynotseesomescreensorfields.
AppServerORACLE_HOMEFieldsonthisscreenFieldTitleORACLE_HOMEFieldDescriptionPathtoyourOracleApplicationServerinstallation.
DefaultstothevalueoftheORACLE_HOMEenvironmentvariable.
DestinationExample/u00/oracle/product/10.
1.
3/OracleAS_1NotesCreatetheVCCDatabase12OracleRetailValueChainCollaborationDataSourceDetailsFieldsonthisscreen:FieldTitleDatabaseHostFieldDescriptionHostonwhichthedatabaseisrunningDestinationconfiguration.
xmlExamplemydbhostNotesFieldTitleDatabasePortFieldDescriptionDatabaselistenerport.
Destinationconfiguration.
xmlExample1521NotesCreatetheVCCDatabaseAppendix:VCCApplicationInstallerScreens13FieldTitleDatabaseSIDFieldDescriptionSystemidentifierforthedatabaseDestinationconfiguration.
xmlExamplevccdb01NotesFieldTitleSchemaFieldDescriptionDatabaseschemawheretheVCCtableshavebeeninstalled.
Destinationconfiguration.
xmlExampleVCC12NotesFieldTitleSchemapasswordFieldDescriptionPasswordfortheVCCdatabaseschema.
Destinationconfiguration.
xmlNotesApplicationServerDetailsCreatetheVCCDatabase14OracleRetailValueChainCollaborationFieldsonthisscreen:FieldTitleHostnameFieldDescriptionHostnameoftheapplicationserverExamplemyhostNotesFieldDescriptionFieldTitleFieldDescriptionOPMNrequestportPortonwhichOPMNlistensforrequeststoforwardontoOC4Jinstances.
ThisportcanbefoundintheORACLE_HOME/opmn/conf/opmn.
xmlfile:Example6003NotesManualDeploymentOptionCreatetheVCCDatabaseAppendix:VCCApplicationInstallerScreens15FieldDescriptionFieldTitleFieldDescriptionInstallfilestoappserverBydefault,theinstallerwilldeploytheearfileandcopyfilesundertheapplicationserverORACLE_HOME.
ThisscreengivesyoutheoptiontoleaveORACLE_HOMEunmodifiedandconfiguretheapplicationinthestagingareaforuseinamanualinstallationatalatertime.
ThisoptioncanbeusedinsituationswheremodificationstofilesunderORACLE_HOMEmustbereviewedbyanotherpartybeforebeingapplied.
IfyouchooseNo,seetheManualDeploymentOptionsectionoftheapplicationinstallationinstructionsinthisdocumentforthemanualstepsyouneedtoperformaftertheinstallercompletes.
ExampleYesNotesApplicationDeploymentDetailsFieldsonthisscreen:FieldDescriptionFieldTitleFieldDescriptionAppDeploymentNameNamebywhichthisVCCapplicationwillbeidentifiedintheapplicationserverExampleVCCNotesCreatetheVCCDatabase16OracleRetailValueChainCollaborationFieldTitleContextRootFieldDescriptionPathundertheHTTPURLthatwillbeusedtoaccesstheVCCapplication.
Forexample,acontextrootof'vcc'willresultintheapplicationbeingaccessedathttp://host:port/vcc/index.
jsp.
ExamplevccNotesFieldTitleOC4JInstanceFieldDescriptionNameoftheOC4JinstancethatwascreatedforthisVCCapplication.
Examplevcc-oc4j-instanceNotesOC4JAdministrativeUserCreatetheVCCDatabaseAppendix:VCCApplicationInstallerScreens17Fieldsonthisscreen:FieldTitleOC4JadminuserFieldDescriptionUsernameoftheadminuserforOC4JinstancetowhichtheVCCapplicationisbeingdeployed.
Exampleoc4jadminNotesFieldTitleOC4JadminpasswordFieldDescriptionPasswordfortheOC4Jadminuser.
YouchosethispasswordwhenyoucreatedtheOC4Jinstance(managedOC4J)orwhenyoustartedtheinstanceforthefirsttime(standaloneOC4J).
NotesAppendix:InstallerSilentMode19BAppendix:InstallerSilentModeRepeatinganInstallationAttemptInadditiontotheGUIandtextinterfacesoftheVCCinstaller,thereisasilentmodethatcanberun.
Thismodeisusefulifyouwishtorunarepeatinstallationwithoutretypingthesettingsyouprovidedinthepreviousinstallation.
Itisalsousefulifyouencountererrorsinthemiddleofaninstallationandwishtocontinue.
Theinstallerrunsintwodistinctphases.
Thefirstphaseinvolvesgatheringsettingsfromtheuser.
Attheendofthefirstphase,apropertiesfilenamedant.
install.
propertiesiscreatedwiththesettingsthatwereprovided.
Thenthesecondphasebegins,wherethispropertiesfileisusedtoprovideyoursettingsfortheinstallation.
Toskipthefirstphaseandre-usetheant.
install.
propertiesfilefromapreviousrun,followtheseinstructions:1.
Edittheant.
install.
propertiesfileandcorrectanyinvalidsettingsthatmayhavecausedtheinstallertofailinthepreviousrun.
2.
Theinstalleragainwiththesilentargument.
Example:install.
shsilentAppendix:URLReference21CAppendix:URLReferenceBoththedatabaseschemaandapplicationinstallersfortheVCCproductwillaskforcertainURLs.
Theseincludethefollowing.
JDBCURLforadatabaseUsedbytheJavaapplicationandbytheinstallertoconnecttothedatabase.
Syntax:jdbc:oracle:thin:@:::hostnameofthedatabaseserver:databaselistenerport:systemidentifierforthedatabaseExample:jdbc:oracle:thin:@myhost:1521:mysidDeployerURIUsedbytheOracleANTtaskstodeployanapplicationtoanOC4Jinstance.
Theapplicationinstallerdoesnotasktheuserforthisvalue;itisconstructedbasedonotherinputsandwrittentotheant.
install.
propertiesfileforinputtotheinstallationscript.
Forrepeatinstallationsusingsilentmode,youmayneedtocorrectmistakesinthedeployerURI.
Note:ThereareseveraldifferentformatsforthedeployerURIdependingonyourclustertopology.
ConsulttheDeployingwiththeOC4JAntTaskschapteroftheOC4JDeploymentGuideforfurtherdetails.
Syntax(managedOC4J):deployer:cluster:opmn://:/:hostnameoftheOracleASenvironment:OPMNrequestportoftheOracleASenvironment.
Thiscanbefoundinthe/opmn/conf/opmn.
xmlfile.
:NameoftheOC4Jinstancewheretheapplicationwillbedeployed.
Example:deployer:cluster:opmn://myhost:6003/vcc-oc4j-instanceSyntax(standaloneOC4J):deployer:oc4j:::hostnameoftheOracleASenvironment:RMIportoftheOC4Jserver.
ThiscanbefoundintheORACLE_HOME/j2ee/home/config/rmi.
xmlfile.
Example:deployer:oc4j:myhost:23791Appendix:CommonInstallationErrors23DAppendix:CommonInstallationErrorsThissectionprovidessomecommonerrorsencounteredduringinstallationofVCC.
DatabaseInstallerHangsonStartupSymptom:Whenthedatabaseschemainstallerisrun,thefollowingiswrittentotheconsoleandtheinstallerhangsindefinitely:Runningpre-installchecksRunningtnspingtogetlistenerportSolution:Theinstallerstartupscriptiswaitingforcontroltoreturnfromthetnspingcommand,buttnspingishanging.
TypeControl+Ctocanceltheinstaller,andinvestigateandsolvetheproblemthatiscausingthetnspingcommandtohang.
Thiscanbecausedbyduplicatedatabaselistenersrunning.
UnreadableButtonsintheInstallerIfyouareunabletoreadthetextwithintheinstallerbuttons,itprobablymeansthatyourJAVA_HOMEispointedtoapre-1.
4.
2JDK.
SetJAVA_HOMEtoaJavadevelopmentkitofversion1.
4.
2orlaterandruntheinstalleragain.
"Unabletogetadeploymentmanager"MessageSymptom:Theapplicationinstallerquitswiththefollowingerrormessage:[oracle:deploy]Unabletogetadeploymentmanager[oracle:deploy][oracle:deploy]ThisistypicallytheresultofaninvaliddeployerURIformatbeingsupplied,thetargetservernotbeinginastartedstateorincorrectauthenticationdetailsbeingsupplied.
[oracle:deploy][oracle:deploy]Moreinformationisavailablebyenablinglogging--pleaseseetheOracleContainersforJ2EEConfigurationandAdministrationGuidefordetails.
Solution:Thiserrorcanbecausedbyanyofthefollowingconditions:-OC4Jinstanceprovidedisnotrunning.
-IncorrectOC4Jinstancenameprovided-IncorrectOC4Jadministrativeusernameand/orpassword-IncorrectOPMNrequestportprovided.
MakesurethattheOC4Jinstanceisrunning,andthenchecktheant.
install.
propertiesfileforentrymistakes.
Paycloseattentiontotheinput.
deployer.
uri(seeAppendixD:URLReference),input.
oc4j.
instance,input.
admin.
user,andinput.
admin.
passwordproperties.
Ifyouneedtomakeacorrection,youcanruntheinstalleragainwiththisfileasinputbyrunningsilentmode(seeAppendixCofthisdocument).
CreatetheVCCDatabase24OracleRetailValueChainCollaboration"Couldnotcreatesystempreferencesdirectory"WarningSymptom:ThefollowingtextappearsintheinstallerErrorstab:May22,200611:16:39AMjava.
util.
prefs.
FileSystemPreferences$3runWARNING:Couldnotcreatesystempreferencesdirectory.
Systempreferencesareunusable.
May22,200611:17:09AMjava.
util.
prefs.
FileSystemPreferencescheckLockFile0ErrorCodeWARNING:CouldnotlockSystemprefs.
Unixerrorcode-264946424.
Solution:ThisisrelatedtoJavabug4838770.
The/etc/.
java/.
systemPrefsdirectorymaynothavebeencreatedonyoursystem.
Seehttp://bugs.
sun.
comfordetails.
ThisisanissuewithyourinstallationofJavaanddoesnotaffecttheOracleRetailproductinstallation.
Appendix:VCCSupportedPlatforms25EAppendix:VCCSupportedPlatformsThisappendixcontainsplatformsupportinformationforEnglish,French,Spanish,Japanese,andKoreanOperatingSystems.
ThediagrambelowappliestotheEnglishOSonly.
VCC-SupportedPlatformsCreatetheVCCDatabase26OracleRetailValueChainCollaborationDatabaseServerApplicationServerOSClientVCCOracle10gR2OAS10.
1.
3UnixSolaris9AIX5.
2AIX5.
3WebBrowserInternetExplorer5.
5,6.
0andhigherSunJREplugin1.
5OSLanguageEnglishJapaneseEnglishEnglishEnglishJapaneseSpanishFrenchKoreanAppendix:ManagingSessionTimeouts27FAppendix:ManagingSessionTimeoutsError!
Bookmarknotdefined.
VCCenforcesasessiontimeoutonuserswhoareloggedin.
Asessiontimeoutisthetimelimitausercanremaininactivebeforebeingloggedout.
Thesessiontimeoutdefaultis15minutes.
Iftherehasnotbeenanyuseractivityfor15minutes,theuserisloggedoutofthesession.
Youcanchangethesessiontimeoutlimitbyeditingtheweb.
xmlfile.
Theweb.
xmlislocatedin:[VCC_HOME]\webclient\syncraweb\WEB-INF\web.
xmlUseyoureditorandsearchforthestatement:15Changethetimeoutnumbertowhateverisappropriateforyourrequirementsandsavethefile.
RestarttheVCCServerforthechangestotakeeffect.
Recommendthattimeoutlimitbesetataminimumof4minutes.
Thisallowstimeforwarningmessage2minutespriortotimeout.
Appendix:Oracle10gDatabaseCreationScripts29GAppendix:Oracle10gDatabaseCreationScripts#Oracle10.
2.
0.
xParameterfile##NOTES:Beforeusingthisscript:#1.
Change,,,and#valuesasappropriate.
#2.
ReplacethewordSIDwiththedatabasename.
#3.
Sizeparametersasnecessaryfordevelopment,test,andproductionenvironments.
#MAINTENANCELOG##DateByParameterOld/NewNotes#02/20/06OracleNANAcreation##ThefollowingSGAparametersareCRITICALtotheperformanceofthe#database.
Thefollowingsettingsarebasedon1GBofallottedmemory.
#TheSGAiscomposedof:#db_cache_size,log_buffer,java_pool_size,large_pool_size,shared_pool_sizedb_cache_size=256Mjava_pool_size=150M#150Mforinitialdbcreationlog_buffer=10485760shared_pool_size=350M#350Mforinitialdbcreationshared_pool_reserved_size=35M#10%ofshared_pool_size#ThefollowingparametersdonotaffectSGAsize;audit_file_dest=/adumpbackground_dump_dest=/bdumpcompatible=10.
2.
0control_files=(/control01.
ctl,/control02.
ctl)core_dump_dest=/cdumpdb_block_size=8192#Defaultis2k;adjustbeforedbcreation,cannotchangeafterdbiscreateddb_file_multiblock_read_count=16#Platformspecific(maxiosize)/(blocksize)db_name=SIDjob_queue_processes=5#OracleRetailrequired;numberofcpu's+1local_listener="(ADDRESS=(PROTOCOL=TCP)(HOST=)(PORT=1521))"nls_calendar=GREGORIANnls_date_format=DD-MON-RR#OracleRetailrequired;ifRDWdatabaseseelaterentryforproperformatnls_language=AMERICAN#Defaultnls_numeric_charactersShouldbeexplicitlysettoensureallusers/batchgetthesameresultsnls_sort=BINARY#Shouldbeexplicitlysettoensureallsessionsgetthesameordernls_territory=AMERICA#Defaultopen_cursors=900#OracleRetailrequired(minimum=900);defaultis50CreatetheVCCDatabase30OracleRetailValueChainCollaborationoptimizer_features_enable=10.
2.
0.
1optimizer_mode=CHOOSE#OracleRetailrequiredpga_aggregate_target=100Mplsql_optimize_level=2#10gchange;usethissettingtooptimizeplsqlperformanceplsql_debug=false#10gchange;usethissettingtooptimizeplsqlpeformanceprocesses=500#MaxnumberofOSprocessesthatcanconnecttothedbquery_rewrite_enabled=TRUE#OracleRetailrequiredforfunction-basedindexessession_cached_cursors=900#OracleRetailrequired;10gusestocachesqlcursorsinpl/sqlundo_management=AUTOundo_retention=1800#Currentlysetfor30minutes;settoavglengthoftransactionsinsecundo_tablespace=undo_tsuser_dump_dest=/udumputl_file_dir=workarea_size_policy=auto#Shouldbesettoautowhenpga_aggregate_targetisset#***SettheseparametersforOracleRetailDataWarehouse(RDW)database***#nls_date_format=DD-MON-RRRR#RequiredbyMicroStrategy#query_rewrite_integrity=TRUSTED#star_transformation_enabled=TRUE#utl_file_dir=,#***ArchiveLogging,setifneeded***#log_archive_dest_1='location=/arch/'#log_archive_format=SIDarch_%r_%s_%t.
log#log_archive_max_processes=1#Default:1#log_archive_min_succeed_dest=1#Default:1#log_buffer=262144#Setto(512Kor128K)*CPUs#log_checkpoint_interval=51200#Default:0-unlimited#log_checkpoint_timeout=7200#Default:1800seconds---Script:crdb1.
sql---Executeas:sysdba---Note:Beforerunningthisscript:---Modifyvalues.
---ModifySIDvalues.
---Adjustsizesforredologs,datafilesandtempfilespoolcrdb1.
logSTARTUPNOMOUNTpfile=${ORACLE_HOME}/dbs/initSID.
oraCREATEDATABASE"SID"MAXDATAFILES1000CHARACTERSETUTF8DATAFILE'/system01.
dbf'SIZE500MAUTOEXTENDONNEXT100MMAXSIZE2000MLOGFILEGROUP1('/redo1a.
log')SIZE1000M,GROUP2('/redo2a.
log')SIZE1000M,GROUP3('/redo3a.
log')SIZE1000MDEFAULTTEMPORARYTABLESPACEtempTEMPFILE'/temp01.
dbf'SIZE5000MEXTENTMANAGEMENTLOCALUNIFORMSIZE1MUNDOTABLESPACEundo_tsDATAFILE'/undo_ts01.
dbf'SIZE5000MSYSAUXDATAFILE'/sysaux01.
dbf'SIZE500MAUTOEXTENDONNEXT100MMAXSIZE2000M;CreatetheVCCDatabaseAppendix:Oracle10gDatabaseCreationScripts31exitspooloff---Script:crdb2.
sql---Executeas:sysdbain10.
1.
0.
2databasesorhigher---Note:Thisscriptinstallsthedatadictionaryviewsinadditionto---grantingnecessaryprivilegestopublic.
spoolcrdb2.
logREM#installdatadictionaryviews:PROMPTRunningcatalog.
sql@$ORACLE_HOME/rdbms/admin/catalog.
sql;PROMPTRunningcatblock.
sql@$ORACLE_HOME/rdbms/admin/catblock.
sql;PROMPTRunningcatproc.
sql@$ORACLE_HOME/rdbms/admin/catproc.
sql;PROMPTRunningcatoctk.
sql@$ORACLE_HOME/rdbms/admin/catoctk.
sql;PROMPTRunningcatrep.
sql@$ORACLE_HOME/rdbms/admin/catrep.
sql;PROMPTRunningowminst.
plb@$ORACLE_HOME/rdbms/admin/owminst.
plb;REM*Theseprivsneededforuserstorunpropergrantcodewhencreatingusers.
grantselectondba_jobstopublicwithgrantoption;grantselectondba_rolestopublicwithgrantoption;grantselectondba_role_privstopublicwithgrantoption;grantexecuteondbms_rlstopublicwithgrantoption;grantexecuteondbms_alerttopublic;grantselect_catalog_roletopublic;grantexecute_catalog_roletopublic;grantexecuteondbms_locktopublic;grantexecuteondbms_rlstopublic;grantselectanydictionarytopublic;REM*queryrewriteprivilegeneededtocreatefunction-basedindexesgrantqueryrewritetopublic;REM*dbms_systemisneededfortracinggrantexecuteonsys.
dbms_systemtopublic;PROMPTCreatingPLANtableownedbySYSTEM@$ORACLE_HOME/rdbms/admin/utlxplan.
sqlPROMPTCreatingpublicsynonynfortheplantablecreatepublicsynonymPLAN_TABLEforSYSTEM.
PLAN_TABLE;connectSYSTEM/manager@$ORACLE_HOME/sqlplus/admin/pupbld.
sql;@$ORACLE_HOME/sqlplus/admin/help/hlpbld.
sqlhelpus.
sql;spooloffexitCreatetheVCCDatabase32OracleRetailValueChainCollaboration---Script:crdb3.
sql---Executeas:sysdbain10.
1.
0.
2databasesorhigher---Note:Thisscriptinstallsjavaandxmlcomponents;---Donotchangetheorderofthestatementsbelowdueto--dependenciesspoolJServer.
log@$ORACLE_HOME/javavm/install/initjvm.
sql;@$ORACLE_HOME/xdk/admin/initxml.
sql;@$ORACLE_HOME/xdk/admin/xmlja.
sql;@$ORACLE_HOME/rdbms/admin/catjava.
sql;@$ORACLE_HOME/rdbms/admin/catexf.
sql;spooloffspoolcontext.
log@$ORACLE_HOME/ctx/admin/catctxchange_on_installSYSAUXTEMPNOLOCK;connectCTXSYS/change_on_install@$ORACLE_HOME/ctx/admin/defaults/dr0defin.
sqlAMERICAN;spooloffspoolxdb_protocol.
logconnect/assysdba@$ORACLE_HOME/rdbms/admin/catqm.
sqlchange_on_installSYSAUXTEMP;spooloff@$ORACLE_HOME/rdbms/admin/utlrp.
sqlAppendix:ConfigureListenerforExternalProcedures33HAppendix:ConfigureListenerforExternalProceduresNote:Thisexampleillustratesthelistenerconfigurationrequiredforexternalprocedures.
Itdoesnotincludeenvironmentspecificsettingsthatmaybeneeded.
ConsultOracleNetServicesguidesforadditionalinformation.
#File:listener.
ora#Desc:OracleNet8listenerfile.
#Notes:ModifyLISTENER=(DESCRIPTION_LIST=(DESCRIPTION=(PROTOCOL_STACK=(PRESENTATION=TTC)(SESSION=NS))(ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))(ADDRESS=(PROTOCOL=IPC)(KEY=extproc_key))))SID_LIST_LISTENER=(SID_LIST=(SID_DESC=(PROGRAM=extproc)(SID_NAME=extproc_agent)(ENVS='EXTPROC_DLLS=ANY')))CreatetheVCCDatabase34OracleRetailValueChainCollaborationNote:Thisexampleillustratestheconfigurationofnetservicesnamesrequiredforexternalprocedures.
Itdoesnotincludeenvironmentspecificsettingsthatmaybeneeded.
ConsultOracleNetServicesguidesforadditionalinformation#File:tnsnames.
ora#Desc:NetServicesconfigurationfile.
#Note:Changethesevalues:,,,#EXTPROC_CONNECTION_DATA=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(Key=extproc_key)))(CONNECT_DATA=(SID=extproc_agent)))EXTPROC_CONNECTION_DATA.
world=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(Key=extproc_key)))(CONNECT_DATA=(SID=extproc_agent)))=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(host=)(Port=1521)))(CONNECT_DATA=(SID=)(GLOBAL_NAME=))).
world=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(host=)(Port=1521)))(CONNECT_DATA=(SID=)(GLOBAL_NAME=)))Example:EXTPROC_CONNECTION_DATA=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(Key=extproc_key)))(CONNECT_DATA=(SID=extproc_agent)))EXTPROC_CONNECTION_DATA.
world=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(Key=extproc_key)))(CONNECT_DATA=(SID=extproc_agent)))prod_db1=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(host=server_01)(Port=1521)))(CONNECT_DATA=(SID=prod_db1)(GLOBAL_NAME=prod_db1.
world)))prod_db1.
world=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=tcp)(host=server_01)(Port=1521)))(CONNECT_DATA=(SID=prod_db1)(GLOBAL_NAME=prod_db1.
world)))