¼×¹ÇÎÄÍÆ³ö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Á¦Ô±¹¤²¢Ê¹½á¹ûÖ±¹Û»¯£¬ÎªÆóÒµ»ñµÃÁìÏȵØÎ»¿ª±ÙµÀ·¡£
¡
Ïà¹ØÎĵµ£º
oracle±í¿Õ¼ä²Ù×÷Ïê½â
1
2
3×÷Õߣº À´Ô´£º ¸üÐÂÈÕÆÚ£º2006-01-04
5
6
7½¨Á¢±í¿Õ¼ä
8
9CREATE TABLESPACE data01
10DATAFILE '/ora ......
RMAN> startup nomount;
RMAN> sql 'alter session set nls_date_format=''yyyy-mm-dd hh24:mi:ss''";
--ÒòΪrmanĬÈÏÒÔ»·¾³±äÁ¿À´¶Áȡʱ¼ä¸ñʽ£¬ÓësqlplusµÄ¹Ì¶¨¸ñʽ²»Í¬£¬ËùÒÔ£¬´Ë´¦ÒªÉ趨ʱ¼ä¸ñʽ±äÁ¿¡£
RMAN> restore controlfile from autobackup until time '2009-03-10 18:15:00';
×¢Ò⣬ÈÔÈ»ÐèÒªÊʵ±µ ......
Ô´´ÓÚ2007Äê04ÔÂ12ÈÕ£¬2009Äê10ÔÂ15ÈÕÇ¨ÒÆÖÁ´Ë¡£
windows xp£¬Êý¾Ý¿âoracle 10.2.0¡£1
ûÓб¸·Ý£¬»ù±¾ÉÏÊÇĬÈϰ²×°£¬ºÃÏñ»¹²»Êǹ鵵ģʽ
Ö¢×´£ºsqlplusÖ»ÓÐsysdbaÓû§ÄܽøÈ¥£¬ÆäËûÓû§½øÈ¥Ò»¸Å±¨£ºora-01033£ºoracleÕýÔÚ³õʼ»¯»ò¹Ø±Õ
¶øÇÒsysdbaÓû§½øÈ¥Ö®ºóÄÜÖ´ÐÐselect sysdate from dual£¬µ«ÊÇÖ´ÐÐselect use ......
sql½Å±¾£¬Ò²¾ÍÊÇÔÚÎļþÖÐдÓÐsqlÓï¾äµÄÎļþ£¬¿ÉÒÔÔÚsqlplusÖÐÔËÐС£
ÒýÈësql½Å±¾
sqlplus Óû§Ãû/ÃÜÂë @sql½Å±¾.sql
£¨×¢Ò⣺ÔÚÓû§ÃûÃÜÂëÊäÈë½áÊøºóÒ»¶¨Òª¼Ó¿Õ¸ñÈ»ºóÔÙд@sql½Å±¾£©
OracleÖеĿÕÖµ»áµ±×÷ÎÞÇî´ó´¦Àí£¬Æäʵ¿ÕÖµ¸ù±¾¾Í²»»á´æ´¢£¬Ö»ÊÇ¿´×÷ÊÇÎÞÇî´ó¡£
OracleÖпØÖÆ´¦Àíº¯Êý NVL(×Ö¶ÎÃû£¬ ......
±¾Îijö×Ô¡¶Íø¹ÜÔ±ÊÀ½ç¡·20002ÄêµÚ8ÆÚ“¹ÊÕÏÕï¶Ï”À¸Ä¿
Ó²¼þ»·¾³£º SUN250·þÎñÆ÷£¬1G CPU , 512M Ram , 18G SCSIÓ²ÅÌ
ϵͳ»·¾³£º SUN Solaris 2.7
·þÎñ»·¾³£º Oracle 8.1.6
ÖÜÎåÎÒ·¢ÏÖOracleÊý¾Ý¿âÔÚÖ´ÐгÌÐòʱµÄÏìÓ¦ÌØ±ðÂý£¬Õû¸öÊý¾Ý¿â·þÎñËùÔÚµÄSUN Solaris 2.7ϵͳҲÊÇÕâÑù£¬ÎÞÂÛÔËÐÐʲô³ÌÐò¶¼±ÈÍù³£ÂýÁ˺ ......