Äþ²¨ÒøÐвÉÓÃOracle CRM ÌáÉý¾ºÕùÓÅÊÆ
2009Äê12ÔÂ24ÈÕ£¬Äþ²¨ÒøÐÐÔÚÈ«ÐÐÒýÈëOracle Siebel CRM£¬ÒÔȫйÜÀíÀíÄî¼°ÒµÎñÁ÷³Ì¹¹½¨Äþ²¨ÒøÐÐͳһµÄCRM£¨¿Í»§¹ØÏµ¹ÜÀí£©ÏµÍ³£¬ÊµÏÖÒÔ¿Í»§ÎªÖÐÐĵĿͻ§¹ØÏµ¹ÜÀíºÍÆóÒµ¹¤×÷ЧÂʵÄÈ«ÃæÌáÉý¡£“ÒÔ¿Í»§ÎªÖÐÐÄ”µÄÏúÊÛ·þÎñƽ̨£¬ÄÜÌṩȫÐÐͳһµÄ¿Í»§ÊÓͼ£¬Í¬Ê±ÊµÏÖÁ˿粿ÃÅÐͬ¹¤×÷£¬²¢Ìṩ¿Í»§ÉúÃüÖÜÆÚ¹ÜÀíÓë·þÎñ£¬²»½öÌá¸ßÁ˿ͻ§ÂúÒâ¶ÈºÍÖҳ϶ȣ¬ÓÐЧÌáÉýÁËÆóÒµµÄ¹¤×÷ЧÂÊÒÔ¼°¿Í»§·þÎñÖÊÁ¿£¬²¢´ó·ùÌáÉýÁ˿ͻ§µÄ½»²æÏúÊÛ£¬ÎªÄþ²¨ÒøÐдøÀ´ÁËÏÔÖøµÄÉÌÒµÐ§Òæ¡£
Ïà¹ØÎĵµ£º
ËäȻѧϰJavaºÜ¾ÃÁË£¬×Ô¼ºÒ²Á¬½Ó¹ýһЩÊý¾Ý¿â£¬±ÈÈçmysqlÖ®ÀàµÄ£¬Èç½ñÄØ£¬Ò²Ñ§Ï°ÁËÒ»¶Îʱ¼äµÄOracle£¬È»¶øÄØ£¬½ñÌìÊÇÎÒµÚÒ»´ÎÁ¬½ÓOracle£¬ºÙºÙ£¬Ó¦¸Ã»¹²»ËãÌ«³Ù°É¡£
½ñÌìÄØ£¬Óе㱿׾£¬´ó¼ÒĪЦ£¡
ÎÒÕâÊÇÒ»¸ö²éѯÀý×Ó
Ê×ÏÈ£¬Ô ......
ѧϰOracle DBAÒ²°ë¸ö¶àѧÆÚÁË£¬½ñÌìÃÍÈ»²Å·¢ÏÖ£¬ÔÀ´ÎÒµÄÊ黹ÊǺÜеģ¬ÉϿβÙ×÷ʱºòÒ²Ö»ÊÇÖªµÀ´ó¸ÅÔõô×ö£¬µ«ÊÇÒªÕæµÄÈ«²¿×Ô¼º×ö£¬¶ø²»È¥·Ê黹ÊÇÓÐÒ»¶¨µÄÄѶȵģ¬ËùÒÔÄØ£¬½ñÌ쿪ʼ½«DBA´ÓÍ·¸´Ï°Ò»±é£¬Í¬Ê±ÔÙ²Ù×÷Ò»±é¡£
µÚÒ»Õ£¬Ñ§µÄÊÇOracleµÄÌåϵ½á¹¹£ ......
1 ×ʲúÀàÐÍ
×ʲúÀàÐÍ£º×ʱ¾»¯¡¢CIP¡¢·ÑÓÃÐÔ
×ʱ¾»¯£ºÊÇÖ¸ÐèÒª¼ÆËãÕ۾ɵÄ×ʲú
CIP£ºÊÇÔÚ½¨¹¤³Ì×ʲú£¬Éв»ÐèÕ۾ɣ¬´ýÆä×ʱ¾»¯Ö®ºóÔÙ¿ªÊ¼ÕÛ¾É
·ÑÓÃÐÔ£ºÊDz»¼ÆËãÕ۾ɣ¬¸Ã×ʲúµÄ³É±¾¶¼×÷Ϊ·ÑÓô¦Àí
2 ×ʲúÔö¼Ó
×ʲúÔö¼ÓÓÐÁ½ÖÖ·½Ê½£ºÊÖ¶¯Ôö¼Ó£¬×Ô¶¯Ôö¼Ó¡£
×Ô¶¯Ôö¼ÓÊÇÖ¸ÓÉÆäËûÄ£¿é£¨APÄ£¿é»òPAÄ£¿é£©´«µÝµ½×ʲúÄ£¿é ......
1¡¢×ª»»·þÎñÆ÷¹éµµÄ£Ê½£¬Èç¹ûÒÑÊǹ鵵ģʽ¿ÉÌø¹ý´Ë²½£º
¡¡%sqlplus /nolog (Æô¶¯sqlplus)
¡¡¡¡SQL> conn / as sysdba (ÒÔDBAÉí·ÝÁ¬½ÓÊý¾Ý¿â)
¡¡¡¡SQL> shutdown immediate; (¼´Ê±¹Ø±ÕÊý¾Ý¿â)
¡¡¡¡SQL> startup mount (Æô¶¯ÊµÀý²¢¼ÓÔØÊý¾Ý¿â£¬µ«²»´ò¿ª)
¡¡¡¡SQL> alter database archivelog; (¸ü¸ÄÊ ......
-- create by zh
-- n ÊÇ×÷ÎïµÄʱ¼ä,x ÊÇÏ£ÍûÔÚ¼¸µã³ÉÊì,·µ»Ø²¥ÖÖµÄʱ¼ä
with t as
(
select 64 n,9 x from dual union all
select 64 n,13 x from dual union all
select 64 n,17 x from dual union all
select 64 n,20 x from dual
)
select '³ÉÊìʱ¼ä:' || lpad(to_char(n),4,' ' ......