在Oracle Database 10g Express Edition Release 10.2.0.1.0 上安装Apex

Oracle示例系列：Oracle数据库11ghttp://www.oracle.com/technology/global/cn/obe/11gr1_db/index.htm在OracleDatabase10gExpressEditionRelease10.2.0.1.0安装OracleApplicationExpress一、准备C:\\oraclexe\\apex>sqlplussys/managerassysdbaSQL*Plus:Release10.2.0.1.0-Productionon星期二7月1315:57:242010Copyright(c)1982,2005,Oracle.Allrightsreserved.连接到:OracleDatabase10gExpressEditionRelease10.2.0.1.0-ProductionSQL>@owa\\owainst.sqlPL/SQL过程已成功完成。PL/SQL过程已成功完成。PL/SQL过程已成功完成。OWA_DBG_MSG-------------------------------------------------------------------------------InstalledOWAversionis:10.1.2.0.4;ShippedOWAversionis:10.1.2.0.6;OWApackagesv10.1.2.0.6willbeinstalledintoyourdatabasev102010Willinstallowadummy.sqlandowacomm.sql………………………………同义词已创建。会话已更改。SQL>@C:\\oraclexe\\app\\oracle\\product\\10.2.0\\server\\RDBMS\\ADMIN\TIMESTAMP-------------------------------------------------------------------------------COMP_TIMESTAMPUTLRP_BGN2010-07-1316:04:10DOC>DOC>DOC>DOC>DOC>DOC>DOC>ThefollowingPL/SQLblockinvokesUTL_RECOMPtorecompileinvalidobjectsinthedatabase.Recompilationtimeisproportionaltothenumberofinvalidobjectsinthedatabase,sothiscommandmaytakealongtimetoexecuteonadatabasewithalargenumberofinvalidobjects.Usethefollowingqueriestotrackrecompilationprogress:DOC>DOC>1.Queryreturningthenumberofinvalidobjectsremaining.ThisDOC>numbershoulddecreasewithtime.DOC>SELECTCOUNT(*)FROMobj$WHEREstatusIN(4,5,6);DOC>DOC>2.Queryreturningthenumberofobjectscompiledsofar.ThisnumberDOC>shouldincreasewithtime.DOC>SELECTCOUNT(*)FROMUTL_RECOMP_COMPILED;DOC>DOC>ThisscriptautomaticallychoosesserialorparallelrecompilationDOC>basedonthenumberofCPUsavailable(parametercpu_count)multipliedDOC>bythenumberofthreadsperCPU(parameterparallel_threads_per_cpu).DOC>OnRAC,thisnumberisaddedacrossallRACnodes.DOC>DOC>UTL_RECOMPusesDBMS_SCHEDULERtocreatejobsforparallelDOC>recompilation.JobsarecreatedwithoutinstanceaffinitysothattheyDOC>canmigrateacrossRACnodes.UsethefollowingqueriestoverifyDOC>whetherUTL_RECOMPjobsarebeingcreatedandruncorrectly:DOC>DOC>1.QueryshowingjobscreatedbyUTL_RECOMPDOC>SELECTjob_nameFROMdba_scheduler_jobsDOC>WHEREjob_namelike'UTL_RECOMP_SLAVE_%';DOC>DOC>2.QueryshowingUTL_RECOMPjobsthatarerunningDOC>SELECTjob_nameFROMdba_scheduler_running_jobsDOC>WHEREjob_namelike'UTL_RECOMP_SLAVE_%';PL/SQL过程已成功完成。TIMESTAMP--------------------------------------------------------------------------------COMP_TIMESTAMPUTLRP_END2010-07-1316:05:46PL/SQL过程已成功完成。DOC>ThefollowingqueryreportsthenumberofobjectsthathavecompiledDOC>witherrors(objectsthatcompilewitherrorshavestatussetto3inDOC>obj$).Ifthenumberishigherthanexpected,pleaseexaminetheerrorDOC>messagesreportedwitheachobject(usingSHOWERRORS)toseeiftheyDOC>pointtosystemmisconfigurationorresourceconstraintsthatmustbeDOC>fixedbeforeattemptingtorecompiletheseobjects.DOC>#OBJECTSWITHERRORS-------------------0DOC>ThefollowingqueryreportsthenumberoferrorscaughtduringDOC>recompilation.Ifthisnumberisnon-zero,pleasequerytheerrorDOC>messagesinthetableUTL_RECOMP_ERRORStoseeifanyoftheseerrorsDOC>areduetomisconfigurationorresourceconstraintsthatmustbeDOC>fixedbeforeobjectscancompilesuccessfully.DOC>#ERRORSDURINGRECOMPILATION---------------------------0PL/SQL过程已成功完成。SQL>@apexins.sqlSYSAUXSYSAUXTEMP/i/PL/SQL过程已成功完成。--Nowbeginningupgrade.Thiswilltakeseveralminutes.---------Ensuringtemplatenamesareunique---------Migratingmetadatatonewschema---------Switchingbuildertonewschema---------MigratingSQLWorkshopmetadata-------PL/SQL过程已成功完成。...AdjustOracleAPEXApplicationownertoinstallowner已更新13行。提交完成。...AdjustApplicationExpress(APEX)version已更新12行。已更新1行。ThankyouforinstallingOracleApplicationExpress.OracleApplicationExpressisinstalledintheAPEX_040000schema.（这个提示很关键，以后的语言版本也应安装在次schema中！）ThestructureofthelinktotheApplicationExpressadministrationservicesisasfollows:http://host:port/pls/apex/apex_admin(OracleHTTPServerwithmod_plsql)http://host:port/apex/apex_admin(OracleXMLDBHTTPlistenerwiththeembeddedPL/SQLgateway)ThestructureofthelinktotheApplicationExpressdevelopmentinterfaceisasfollows:http://host:port/pls/apex(OracleHTTPServerwithmod_plsql)http://host:port/apex(OracleXMLDBHTTPlistenerwiththeembeddedPL/SQLgateway)JOB_QUEUE_PROCESSES:4PerformingApplicationExpresscomponentvalidation-pleasewait......SettingDBMSRegistry17:10:09...SettingDBMSRegistryComplete17:10:09...Exitingvalidate17:10:09计时:ValidateInstallation已用时间:00:09:53.32计时:DevelopmentInstallation已用时间:00:47:37.04从OracleDatabase10gExpressEditionRelease10.2.0.1.0-Production断开C:\\oraclexe\\apex>sqlplussys/managerassysdbaSQL*Plus:Release10.2.0.1.0-Productionon星期二7月1317:16:542010Copyright(c)1982,2005,Oracle.Allrightsreserved.连接到:OracleDatabase10gExpressEditionRelease10.2.0.1.0-ProductionSQL>@apxchpwdEnteravaluebelowforthepasswordfortheApplicationExpressADMINuser.EnterapasswordfortheADMINuser[]会话已更改。...changingpasswordforADMINPL/SQL过程已成功完成。SQL>@apxldimg.sqlC:\\oraclexePL/SQL过程已成功完成。目录已创建。PL/SQL过程已成功完成。PL/SQL过程已成功完成。PL/SQL过程已成功完成。提交完成。计时:LoadImages已用时间:00:13:11.14目录已删除。(c\\oraclexe为apex所在的目录)SQL>@apex_epg_configc:\\oraclexePL/SQL过程已成功完成。PL/SQL过程已成功完成。目录已创建。SQL>@apex_epg_configc:\\oraclexePL/SQL过程已成功完成。PL/SQL过程已成功完成。目录已创建。PL/SQL过程已成功完成。提交完成。PL/SQL过程已成功完成。PL/SQL过程已成功完成。计时:LoadImages已用时间:00:10:18.32会话已更改。PL/SQL过程已成功完成。提交完成。会话已更改。目录已删除。SQL>ALTERUSERANONYMOUSACCOUNTUNLOCK;用户已更改。SQL>SELECTDBMS_XDB.GETHTTPPORTFROMDUAL;GETHTTPPORT-----------8080SQL>selectusernamefromdba_users;USERNAME------------------------------------------------------------SYSSYSTEMANONYMOUSAPEX_PUBLIC_USERAPEX_040000MDSYSOUTLNDIPTSMSYSFLOWS_FILESCTXSYSUSERNAME------------------------------------------------------------DBSNMPFLOWS_020100XDBHR已选择15行。SQL>exit从OracleDatabase10gExpressEditionRelease10.2.0.1.0-Production断开C:\\oraclexe\\apex>setNLS_LANG=American_America.AL32UTF8C:\\oraclexe\\apex>sqlplussys/managerassysdbaSQL*Plus:Release10.2.0.1.0-ProductiononTueJul1317:54:052010Copyright(c)1982,2005,Oracle.Allrightsreserved.Connectedto:OracleDatabase10gExpressEditionRelease10.2.0.1.0–ProductionSQL>ALTERSESSIONSETCURRENT_SCHEMA=APEX_040000;SQL>@C:\\oraclexe\\apex\\builder\\zh-cn\\load_zh-cn.sql