ÈçºÎ»ñµÃOracle OCPÈÏÖ¤ÒÔ¼°OCPÈÏÖ¤µÄÓÅÊÆ
OracleÈÏ֤ר¼Ò——OCP£¬ÊÇÓÉOracle¹«Ë¾ÊÚȨ¹ú¼Ê¿¼ÊÔÈÏÖ¤ÖÐÐĶԿ¼Éú½øÐеÄ×ʸñÈÏÖ¤¡£¿¼Éú°´¿¼ÊÔ±ê×¼ÒªÇó²Î¼Ó¼¸Ãſγ̵Ŀ¼ÊÔ(Ò»°ãΪ3—5ÃÅ)£¬ÔÚͨ¹ýÈ«²¿¿¼ÊԺ󣬱ã¿É»ñµÃOCPµÄר¼ÒÈÏÖ¤¡£
ĿǰOCPÈÏÖ¤¿¼ÊÔ·ÖΪ£º
Database AdministratorDatabase OperatoDatabase DeveloperJava DeveloperApplication ConsultantÆäÖУ¬Oracle DBAÊÇ×î³ÔÏ㣬µ«Ò²ÊÇ×îÄÑ¿¼µÄÒ»¸öÈÏÖ¤¡£
OCPÈÏÖ¤µÄËùÓп¼ÊÔÒ²ÊÇͨ¹ýPrometric¹«Ë¾×éÖ¯µÄ£¬ÔÚPrometricÊÚȨ¿¼ÊÔÖÐÐÄ¿ÉÒÔ±¨Ãû²Î¼ÓOCPÈÏÖ¤¿¼ÊÔ¡£Ä¿Ç°OCPÿÃÅ¿¼ÊԵķÑÓÃΪ125ÃÀÔª¡£
×ܵÄÀ´Ëµ£¬ITÒµ¶Ôר¼ÒµÄÒªÇóºÜ¸ß£¬Ö°Òµ¾ºÕùѹÁ¦ºÜ´ó¡£ÎÞÂÛÊÇнøÈëÕâ¸öÐÐÒµµÄÈË£¬»¹ÊÇ´ËÐÐÒµÖеÄÀÏÊÖ£¬¶¼ÐèÒªÖªµÀËûÃǵÄÄÇЩ¼¼Êõ±³¾°ÄÜÕæÕýÎüÒýµ½¹ÍÖ÷µÄÑ۹⡣ͬʱ£¬¹ÍÖ÷ÃÇÒ²ÐèÒªÒ»¸ö±ê×¼°ïÖúËûÃÇÌôÑ¡³öÄÇЩ¼¼ÊõÉÏÕæÕý¹ýÓ²µÄ¹ÍÔ±¡£OCPÈÏÖ¤¾ÍÄܹ»°ïÖúITÒµ½ç½¨Á¢ÆðÃæÏòÌØ¶¨Ö°Î»µÄÑ¡Ôñ±ê×¼¡£OCPÈÏÖ¤ÊÇÒ»¸öÓмÛÖµµÄ¡¢Òµ½ç³ÐÈϵıê×¼£¬Õâ¸ö±ê×¼¿ÉÒÔÖ¤Ã÷³ÖÖ¤ÕßµÄ֪ʶºÍÄÜÁ¦Ë®Æ½¡£
OCPÈÏÖ¤¿ÉÒÔ¸øÄãÒ»¸öÏÊÃ÷µÄÓÅÊÆ¡£OCPÈÏÖ¤¿ÉÒÔ±íÃ÷Äã¶Ôijһְλ¼°Ïà¹ØµÄOracle²úÆ·ÓÐ×ÅÉî¿ÌµÄÀí½â¡£³ÉΪһ¸öOCPÈÏ֤ר¼Ò¿ÉÒÔ°ïÖúÄã±»¸ü¶àµÄ¹ÍÖ÷×¢Òâµ½£¬²¢ÇÒÔö¼ÓÄã»ñµÃITÒµ×î¾ßÌôÕ½ÐÔ»úÓöµÄ»ú»á¡£OCPÈÏ֤ר¼ÒÃÇ֤ʵÁËOCPÈÏÖ¤µÄ¼ÛÖµ£º97%µÄ OCPÈÏΪËûÃÇ»ñÒæÓÚOCPÈÏÖ¤;89%µÄOCPÈÏΪ»ñµÃÈÏÖ¤ºó£¬ËûÃÇÔÚOracleר¼ÒµÄְλÉϸü¾ßÐÅÐÄ;
OCPÈÏ֤ͬʱ¿ÉÒÔ°ïÖúITÒµµÄÈËʾÀíÔÚӦƸÕßÖÐÌôÑ¡³ö·ûºÏÌôÕ½ÐÔְλµÄÔ±¹¤¡£¶ÔÓÚÄÇЩÿÄê°ÑÔ±¹¤ËÍÈ¥ÅàѵµÄ¹«Ë¾£¬ÈÏÖ¤¿ÉÒÔ±£Ö¤ËûÃÇÔÚÅàѵÉϵÄǮûÓа׻¨——ËûÃǵÄÔ±¹¤»ñµÃÁ˶ÔÓÚÉîÈëÀí½âºÍ±ØÒªµÄ֪ʶ¡£¹«Ë¾Ò²¿ÉÒÔ°ÑÈÏÖ¤ºÍÔ±¹¤µÄÖ°Òµ·¢Õ¹ÁªºÏÆðÀ´£¬ÕâÑù¿ÉÒÔÔöǿԱ¹¤µÄÖҳ϶ȼ°ËûÃÇÔÚÖ°Òµ¸ÚλÉϵıíÏÖ¡£Í¬Ê±£¬¹ÍÓûñµÃÈÏÖ¤µÄר¼Ò¿ÉÒÔÖ±½ÓÌá¸ß¹«Ë¾µÄʵÁ¦£¬¹ú¼ÊÊý¾Ý¹«Ë¾(International Data Corporation)µÄÒ»ÏîÑо¿ÏÔʾÁËÕâÒ»µã¡£
¶«·½ÈðͨITÅàѵÓë·þÎñÖÐÐÄÓµÓÐÊ®ÄêITÅàѵ¾Ñ飬רעÖйú¸ß¶ËITÅàѵÊÇÖйú¸ß¶ËITÅàѵµÚÒ»Æ·ÅÆ£¬¶«·½ÈðͨITÅàѵÓë·þÎñÖÐÐÄΪITÅàѵ»ú¹¹¼°¹ã´óѧԱÌá¹©È«Ãæ¡¢Ï¸Ö¡¢×¨ÒµµÄÏßÉÏ¡¢ÏßÏ·þÎñ£¬ÖÂÁ¦ÓÚΪ¿Í»§ÌáÉýÁ¼ºÃµÄÖ°Òµ¾ºÕùÁ¦£¬http://www.easthome.com/
Ïà¹ØÎĵµ£º
IP µØÖ·×öÈçÏÂÐ޸ģº
Public IP 10.85.10.119/121 -- > 10.85.10.219/221
Privite IP 192.168.1.119/121 -- > 192.168.1.219/221
Virtual IP 10.85.10.122/123 -- ......
oracle Set ÃüÁî½éÉÜ
http://luoke920.javaeye.com/blog/323743
1). ÉèÖõ±Ç°sessionÊÇ·ñ¶ÔÐ޸ĵÄÊý¾Ý½øÐÐ×Ô¶¯Ìá½»
SQL>SET AUTO[COMMIT] {ON|OFF|IMM[EDIATE]| n}
2)£®ÔÚÓÃstartÃüÁîÖ´ÐÐÒ»¸ösql½Å±¾Ê±£¬ÊÇ·ñÏÔʾ½Å±¾ÖÐÕýÔÚÖ´ÐеÄSQLÓï¾ä
SQL> SET ECHO {ON|OFF}
3).ÊÇ·ñÏÔʾµ±Ç°sqlÓï¾ä²éѯ»òÐ޸ĵÄÐÐÊý ......
Oracle EBS AlertÔÚOracle EBSÖÐÓ¦Ó÷dz£¹ã·º,Ö÷Òª¼¯ÖÐÔÚ¶¨ÆÚ֪ͨºÍÌáÐÑ,ʼþÀàµÄ֪ͨºÍÌáÐÑ,ÀýÈç:
1)ij¸öÖ°Ô±¹ýÉúÈÕ,µ«ÊÇÈËÁ¦×ÊÔ´²¿ÃÅÏ£Íû·¢¸ö×£ºØµÄÓʼþ,¾Í¿ÉÒÔͨ¹ýAlert½øÐÐ֪ͨףºØ;
2)ÔÚDBA¼ì²âϵͳÊÇ·ñÕý³£ÔËתµÄ¹ý³ÌÖÐ,Èç¹ûij¸ö±í¿Õ¼ä¿ìÂúÁË,¿ÉÒÔ½¨Á¢Alert½øÐÐ֪ͨ¹ÜÀíÔ±;
3)¿ÉÒÔ½øÐÐÌáÐÑEBSÖеÄËùÓÐÈËÔ±,µ±È»Ò²¿ ......
1¡¢OracleµÄPackage³ýÁ˰Ѵ洢¹ý³Ì·Åµ½Ò»¶Ñ¶ùÒÔÍ⻹ÓÐûÓÐÆäËûµÄ×÷Ó㨺ô¦£©£¿
2¡¢ÈçºÎ°ÑÏÖÓеĴ洢¹ý³Ì¼ÓÈëµ½PackageÖУ¿
3¡¢³ýÁËʹÓÃSQL Plus£¬»¹ÓÐûÓÐʲô¹¤¾ß×öPackage?
4¡¢Ê¹ÓÃSQL Plus±àÒëPackage£¬ÊÇ·ñÿ´Î¶¼ÊDZàÒëPackageÖÐËùÓеĴ洢¹ý³Ì£¿
1¡¢Äã²»¾õµÃ°Ñ´æ´¢¹ý³Ì·ÖÃűðÀàÊǺÜÖØÒªµÄô£¬¶øÇÒ²»Í¬µÄpackageµÄ ......
¹Ø¼ü×Ö: oracle cast() º¯ÊýÎÊÌâ
SQL> create table t1(a varchar(10));
Table created.
SQL> insert into t1 values ('12.3456');
1 row created.
SQL> select round(a) from t1;
ROUND(A)
----------
12
SQL> select round(a,3) from t1;
ROUN ......