¼×¹ÇÎÄÍƳöOracle PeopleSoft Enterprise 9.1
ΪÁË°ïÖúÆóÒµÌá¸ßÔ±¹¤Ð§Á¦£¬¼×¹ÇÎĹ«Ë¾ÈÕÇ°ÔÚ2009¼×¹ÇÎÄÈ«Çò´ó»áÉÏÍƳö×îаæOracle PeopleSoft Enterprise¹ÜÀíÈí¼þ£¬¼´PeopleSoft EnterpriseÈËÁ¦×ʱ¾¹ÜÀí9.1¡¢PeopleSoft Enterprise PeopleTools 8.50¡¢PeopleSoft Enterpriseѧϰ¹ÜÀí9.1ºÍPeopleSoft EnterpriseÃÅ»§9.1¡£¡¡¡¡Õâ¸öÎüÊÕÁËÀ´×Ô150¶à¸ö¿Í»§µÄ·´À¡ÐÅÏ¢ ¶ø¿ª·¢µÄ×îаæ¹ÜÀíÈí¼þ¿ÉÌṩ¸ü¶àй¦ÄÜ£¬ÒÔ¼ÓËÙÌá¸ßÆóÒµ¼¨Ð§ºÍÔ±¹¤Ð§ÂÊ£¬²¢½µµÍÓµÓгɱ¾¡£
¡¡¡¡PeopleSoft EnterpriseÈËÁ¦×ʱ¾¹ÜÀí9.1ÊÇÒ»¸öºËÐÄƽ̨£¬Âú×ãÈ«ÇòÆóÒµµÄ¶Ëµ½¶ËÈËÁ¦×ÊÔ´¹ÜÀíÐèÇó¡£³ýÁË×î¼ÑµÄ¼¯³ÉʽÈ˲ŹÜÀí¡¢Ô±¹¤¹ÜÀíºÍÔ±¹¤·þÎñ£¬×îаæ¹ÜÀíÈí¼þ»¹°üÀ¨Ç¶ÈëʽWeb 2.0¹¦ÄÜÒÔ¼°ÐµÄÌض¨ÐÐÒµ¹¦ÄÜ¡£
¡¡¡¡PeopleSoft Enterpriseѧϰ¹ÜÀí9.1ÊÇPeopleSoft EnterpriseÈËÁ¦×ʱ¾¹ÜÀí²úÆ·Ì×¼þµÄ×é³É²¿·Ö£¬Äܹ»°ïÖúÆóÒµÓÐЧ¹ÜÀíѧϰ»·¾³£¬È·±£Ô±¹¤»ñµÃÓëÆóҵĿ±êºÍ²»¶Ïµ÷ÕûµÄ¹æ·¶ÒªÇóËùÒ»ÖµÄ֪ʶºÍ¼¼ÄÜ¡£
¡¡¡¡People Tools 8.50ÊÇPeopleSoft EnterpriseµÄ¼¼Êõƽ̨£¬Îª¿Í»§¹ÜÀí¡¢¶¨ÖÆ¡¢¼¯³ÉºÍÖ§³ÖPeopleSoftÓ¦ÓÃÌṩһ¸ö¸ß¶ÈÁé»îµÄ¿ª·¢»·¾³¡£Õâ¸ö×îеÄÉý¼¶°æͨ¹ýʹÓÃеÄWeb 2.0¹¦ÄÜ¡¢ÔöÇ¿µÄ¼¯³ÉÒÔ¼°À©³äµÄ±¨¸æÑ¡¼þ£¬ÊµÏÖÁ˷ḻµÄ×îÖÕÓû§ÌåÑé¡£People Tools 8.50ÊÇPeopleSoft 9.1Ó¦ÓõĻù´¡£¬Óë½ÏµÍ°æ±¾ÊÇÏòºó¼æÈݵģ¬´Ó¶øÌá¸ßÁË¿Í»§ÏÖÓð汾µÄ¼ÛÖµ£¬¶ø¿Í»§ÎÞÐèÉý¼¶ºËÐÄÓ¦Óá£
¡¡¡¡PeopleSoft EnterpriseÃÅ»§9.1ͨ¹ý²¿ÊðÆóÒµµÄÔÚÏßÉçÇøºÍ»ùÓÚWebµÄ×ÔÖú·þÎñÍøÕ¾£¬°ïÖúÆóÒµ´Ù½øºÏ×÷ÓëÐͬ¡£
¡¡¡¡×î×ۺϺÍ×îÍêÕûµÄPeopleSoft Enterprise°æ±¾
¡¡¡¡Oracle PeopleSoft Enterprise 9.1ÊÇPeopleSoftÓÐÊ·ÒÔÀ´×î¿É¿¿ºÍ×î×ۺϵİ汾¡£¸Ã°æ±¾º¬ÓÐ21¸öеĽâ¾ö·½°¸£¬1,350Ïîй¦ÄÜ£¬³¬¹ý2.8Íò¸öÒ³ÃæÉý¼¶ºó¾ßÓÐWeb 2.0¹¦ÄÜ¡¢300ÏîеÄWeb·þÎñºÍ200ÖÖÌض¨ÓÚÐÐÒµµÄй¦ÄÜ¡£
¡¡¡¡PeopleSoftÓ¦ÓøüкÍÔöÇ¿ÁËÓû§½çÃ棬ÄÉÈëÁËWeb 2.0Ð×÷¹¤¾ß£¬ÈçÁÄÌì¡¢wiki¡¢ÂÛ̳ºÍ±êÇ©£¬ÒÔ°ïÖúÓû§ÓëÆä֪ʶÍøÖеÄÆäËûÈËÁªÏµºÍ¹µÍ¨¡£´ËÍ⣬¹¦ÄܷḻµÄ״̬ÏÔʾ°åºÍ¹¤×÷̨º¬ÓÐǶÈëʽ·ÖÎö¹¦ÄÜ£¬ÒÔÌá¸ß¶ÔÒµÎñµÄ¶´²ìÁ¦ºÍÓû§Ð§ÂÊ¡£
¡¡¡¡PeopleSoftÈËÁ¦×ʱ¾¹ÜÀí9.1¿É¿¿µÄÈ˲ŹÜÀí¹¦ÄÜÓÐÖúÓÚÃ÷È·ÆóҵĿ±êºÍʹÆóҵĿ±êÖ±¹Û»¯£¬²¢½«Ò»Ð©Ìض¨Ä¿±ê¼Óµ½Ò»¸ö»ò¸ü¶àµÄÔ±¹¤¼¨Ð§ÎļþÉÏ£¬ÒԴ˽¨Á¢ÆóÒµÒ»ÖÂÐÔ²¢Ìá¸ßÔ±¹¤Ð§ÂÊ£¬¼ÓËÙÌá¸ßÆóÒµ×ÜÌ弨Ч¡£ÐµļÌÈι滮(Succession Planning)½â¾ö·½°¸°ïÖúÈ·¶¨¹Ø¼üÈ˲š¢ÆÀ¶¨¸ßDZÁ¦Ô±¹¤²¢Ê¹½á¹ûÖ±¹Û»¯£¬ÎªÆóÒµ»ñµÃÁìÏȵØλ¿ª±ÙµÀ·¡£
¡
Ïà¹ØÎĵµ£º
ÎÒÃǶ¼¶¼ÖªµÀÔÚcontrolfileÖмǼ×Åÿһ¸öarchivelogµÄÏà¹ØÐÅÏ¢£¬µ±È»ÃÇÔÚOSÏ°ÑÕâЩÎïÀíÎļþdeleteµôºó£¬ÔÚÎÒÃǵÄ
controlfileÖÐÈÔÈ»¼Ç¼×ÅÕâЩarchivelogµÄÐÅÏ¢£¬ÔÚoracleµÄOEM¹ÜÀíÆ÷ÖÐÓпÉÊÓ»¯µÄÈÕÖ¾Õ¹ÏÖ³ö£¬µ±ÎÒÃÇÊÖ¹¤Çå³ýarchiveĿ¼ÏµÄÎļþºó£¬ÕâЩ¼Ç¼²¢Ã»Óб»ÎÒÃÇ´ÓcontrolfileÖÐÇå³ýµô£¬Ò²¾ÍÊÇoracle²¢²» ......
sql½Å±¾£¬Ò²¾ÍÊÇÔÚÎļþÖÐдÓÐsqlÓï¾äµÄÎļþ£¬¿ÉÒÔÔÚsqlplusÖÐÔËÐС£
ÒýÈësql½Å±¾
sqlplus Óû§Ãû/ÃÜÂë @sql½Å±¾.sql
£¨×¢Ò⣺ÔÚÓû§ÃûÃÜÂëÊäÈë½áÊøºóÒ»¶¨Òª¼Ó¿Õ¸ñÈ»ºóÔÙд@sql½Å±¾£©
OracleÖеĿÕÖµ»áµ±×÷ÎÞÇî´ó´¦Àí£¬Æäʵ¿ÕÖµ¸ù±¾¾Í²»»á´æ´¢£¬Ö»ÊÇ¿´×÷ÊÇÎÞÇî´ó¡£
OracleÖпØÖÆ´¦Àíº¯Êý NVL(×Ö¶ÎÃû£¬ ......
OracleÊý¾Ý¿âº¯Êý£¨µ¥Ðк¯Êý£©
OracleÖеĺ¯ÊýºÍCÖеĺ¯Êý²î²»¶à£¬Ò²ÊÇÓк¯ÊýÃû£¬²ÎÊý±í£¬ºÍ·µ»ØÖµÀàÐÍ×é³ÉµÄ£¬µ¥Ðк¯Êý£¬ÊÇÕë¶ÔÿÌõ¼Ç¼¶¼ÓÐÒ»¸ö½á¹û¡£µ¥Ðк¯Êý¿ÉÒÔ³öÏÖÔÚselect ºóÃ棬Ҳ¿ÉÒÔ³öÏÖÔÚwhere×Ó¾äÖС£
ÐèÒª´¦ÀíÏÖʵµÄ½á¹ûʱ£¬¾Í°Ñº¯ÊýдÔÚselectºóÃ棬ÓÃÓÚÌõ¼þ¹ýÂËʱ£¬¾Í°Ñº¯Êý ......
±¾Îijö×Ô¡¶Íø¹ÜÔ±ÊÀ½ç¡·20002ÄêµÚ8ÆÚ“¹ÊÕÏÕï¶Ï”À¸Ä¿
Ó²¼þ»·¾³£º SUN250·þÎñÆ÷£¬1G CPU , 512M Ram , 18G SCSIÓ²ÅÌ
ϵͳ»·¾³£º SUN Solaris 2.7
·þÎñ»·¾³£º Oracle 8.1.6
ÖÜÎåÎÒ·¢ÏÖOracleÊý¾Ý¿âÔÚÖ´ÐгÌÐòʱµÄÏìÓ¦ÌرðÂý£¬Õû¸öÊý¾Ý¿â·þÎñËùÔÚµÄSUN Solaris 2.7ϵͳҲÊÇÕâÑù£¬ÎÞÂÛÔËÐÐʲô³ÌÐò¶¼±ÈÍù³£ÂýÁ˺ ......