ORACLEÈÏÖ¤Åàѵ³£¼ûÎÊÌâ
ORACLEÈÏÖ¤Åàѵ³£¼ûÎÊÌâ
1¡¢ÎÊ£ºÊ²Ã´ÊÇ Oracle ÈÏÖ¤£¿¶¼ÓÐÄÄЩÖÖÀࣿ
¡¡¡¡´ð£ºOracle ÈÏÖ¤ÊÇÓÉOracle¹«Ë¾°ä²¼²¢ÊµÊ©µÄÒ»ÏîȨÍþµÄרҵ¼¼Êõ±ê×¼ËüÊÇרΪÈÏÖ¤ÄÇЩÄܹ»Âú×ã¶ÔOracleºËÐIJúÆ·µÄ·þÎñÓëÖ§³Ö²¢¾ßÓÐæµÊìµÄ²Ù×÷ÄÜÁ¦Óë¹ã·ºÀíÂÛ֪ʶµÄרҵÈËÊ¿¡£Oracle ÈÏ֤Ŀǰ·ÖΪÈý¸ö²ã´ÎOCA¡¢OCP¡¢OCM¡£¼´Oracle Certified Professi£¨Ö»ÓÐOracle9iÓд˼¶ÈÏÖ¤£©£¬OCP¼´£¬Oracle Certified Professi£¬OCM¼´Oracle Certified Master¡£ÆäÖÐOCP°üÀ¨ÁËÊý¾Ý¿â¹ÜÀí·½ÏòµÄDBA¡¢Êý¾Ý¿â¿ª·¢·½ÏòµÄDEV¼°OracleÓ¦ÓòúÆ··½ÏòµÄApplicationsר¼Ò¡£
2¡¢ÎÊ£ºOracle ÈÏÖ¤¶ÔÎÒ¸öÈ˵ÄÒâÒåºÎÔÚ£¿
´ð£ºÒâÒåÖØ´ó¡£»ñµÃÓëÖ°ÎñÏà¹ØµÄÈÏÖ¤£¬Ö¤Ã÷ÄúÊÇÒ»¸öºÏ¸ñµÄ¼¼ÊõÈËÔ±¡£ ×÷ΪOracle ÈÏ֤ר¼Ò£¬Äú½«¾ßÓжÔÒµ½ç×î¾ßÌôÕ½ÐԵĻúÓö¸üÉîµÄ¶´²ìÁ¦ ²¢»ñÈ¡¸ü¶àµÄÊÕ»ñ ÐÅÏ¢¼¼ÊõÁìÓòÐèÒª´óÁ¿×¨¼Ò£¬Í¬Ê±¹¤×÷¾ºÕùÒ²Òì³£¼¤ÁÒ£¬ ²»ÂÛ¶ÔÓÚÐÂÊÖ»¹ÊÇÓоÑéµÄר¼Ò¶¼ÐèÒªÕÆÎÕÓÃÈ˵¥Î»¸ÐÐËȤµÄ¼¼Êõ¡£ÓÃÈ˵¥Î»Ñ°ÕÒ¸÷ÖÖ·½Ê½À´Çø·ÖÔ±¹¤ºÍDZÔÚÔ±¹¤ÒªÇóÔ±¹¤±ØÐë¾ß±¸ÎªÓÐЧ¹¤×÷ËùÐèµÄ¼áʵµÄ¼¼Êõ»ù´¡¡£
3¡¢ÎÊ£ºÔõÑù²ÅÄÜ»ñµÃOracle ÈÏÖ¤£¿
¡¡´ð£ºÄúÐèÒª°´ÕÕÄúµÄÖ°Òµ·¢Õ¹·½Ïò£¬²Î¼ÓÅàѵ²¢Í¨¹ýÏàÓ¦µÄOracle¹ú¼ÊÈÏÖ¤¡£
4¡¢ÎÊ£ºÎÒÏ뿼Oracle ÈÏÖ¤£¬ÇëÎʿɲ»¿ÉÒÔÖ±½Ó²Î¼Ó¿¼ÊÔ£¿
´ð£º´Ó2002Äê9ÔÂ1ÈÕÆðOracle¹«Ë¾¿ªÊ¼Ö´ÐÐеÄÈÏÖ¤¹æ¶¨£ºÖ±½Ó²Î¼Ó¿¼ÊÔÄú½«²»ÄÜ»ñµÃ Oracle ÈÏÖ¤¡£Ò²¾ÍÊÇ˵£¬ÄúÈç¹ûÏë»ñµÃOracle¾Í±ØÐë²Î¼ÓOracleÊÚȨ½ÌÓýÖÐÐĵÄÅàѵ£¬Õâ¾ÍÒâζ×ÅÖ»ÓвμÓÁËOracleÕý¹æÑϸñÅàѵµÄÈË£¬²ÅÓÐ×ʸñ»ñµÃOracleר¼ÒÈÏÖ¤£¬Õâ¾Í±£Ö¤ÁËOracle ÈÏÖ¤µÄº¬½ðÁ¿£¬Ò²ÊǶÔOracle ÈÏ֤ר¼ÒµÄ±£»¤¡£
5¡¢ÎÊ£ºOracle 9i²úÆ·µÄ¶¨Î»¼°¹¦ÄÜÊÇʲô£¿
¡¡´ð£ºOracle 9iÊý¾Ý¿âÊÇOracle¹«Ë¾ÍƳöµÄ×îÐÂÒ»´úÊý¾Ý¿â£¬ÓëOracle 8iÏà±ÈÔö¼ÓÁËÉÏ°ÙÖÖÐÂÌØÐÔ£¬ÆäÖÐ×îÍ»³öµÄÊǾ¼ÃÐÔ¡¢¸ß¿ÉÉìËõÐԺ͸߿ÉÓÃÐÔÒÔ¼°ÍêÉƵŦÄÜ¡£Oracle 9i²ÉÓÃÁËReal Application Clusters¼¼Êõ£¬ÎªÓû§ÌṩÁËÎÞÏ޵ĿÉÉìËõÐÔºÍ×
Ïà¹ØÎĵµ£º
×÷ÕߣºChris Schalk
ÇáËɹ¹½¨Ò»¸ö»ì´îÓ¦ÓóÌÐò£¬ÒÔʹÓà Oracle XML DB ½« Oracle Êý¾ÝÓë Google Maps API ¼¯³É¡£
2007 Äê 8 Ô·¢²¼
ÕýÈçÄúÖªµÀµÄÄÇÑù£¬Ðí¶àÄêÒÔÇ°£¬Oracle ¾ÍÄܹ»´ÓÊý¾Ý¿â¼´Ê±Éú³É XML¡£³ýÁË´Ó Oracle Êý¾Ý¿âÉú³É XML£¬»¹¿ÉÒÔʹÓöàÖÖÓïÑÔ£¨Èç Java Servlets ºÍ JDBC£©½«Éú³ÉµÄÊý¾Ý XML ·¢²¼µ½ Web¡£ ......
1 ¡¢´´½¨Óû§ºÍ×é
/usr/sbin/groupadd oinstall
/usr/sbin/groupadd dba
/usr/sbin/useradd -g oinstall -G dba oracle
2¡¢ÅäÖÃOSºËÐIJÎÊý
1£©±à¼Îļþ /etc/sysctl.conf
fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmall = 2097152
kernel.shmmax = 536870912
kernel.shmm ......
Jsp Á¬½Ó mySQL¡¢Oracle Êý¾Ý¿â±¸Íü
2009-12-15 16:47
Jsp »·¾³Ä¿Ç°×îÁ÷ÐеÄÊÇ Tomcat5.0¡£Tomcat5.0 ×Ô¼º°üº¬Ò»¸ö Web ·þÎñÆ÷£¬Èç¹ûÊDzâÊÔ£¬¾Íû±ØÒª°Ñ Tomcat Óë IIS »ò Apache ¼¯³ÉÆðÀ´¡£ÔÚ Tomcat ×Ô´øµÄ Web ·þÎñÆ÷Ï¿ÉÒÔ½øÐÐ Jsp ²âÊÔ¡£
°²×° Tomcat5.0 Ç°ÐèÒª°²×° JDK(Èç¹ûÊÇ Windows server ......
-- ²éѯij±íµÄÊý¾Ý×Öµä
SELECT A.TABLE_NAME AS "±íÃû",A.COLUMN_NAME AS "×Ö¶ÎÃû",
DECODE(A.CHAR_LENGTH,0,DECODE(A.DATA_SCALE,NULL,A.DATA_TYPE,A.DATA_TYPE||'('||A.DATA_PRECISION||','||A.DATA_SCALE||')'),
A.DATA_TYPE||'('||A.CHAR_LENGTH||')') as "×Ö¶ÎÀàÐÍ1",A.DATA_TYPE AS "×ֶΠ......
½ø³Ì½á¹¹
½ø³ÌÊDzÙ×÷ϵͳÖеÄÒ»ÖÖ»úÖÆ£¬Ëü¿ÉÖ´ÐÐһϵÁеIJÙ×÷²½¡£ÔÚÓÐЩ²Ù×÷ϵͳÖÐʹÓÃ×÷Òµ(JOB)»òÈÎÎñ(TASK)µÄÊõÓï¡£Ò»¸ö½ø³Ìͨ³£ÓÐËü×Ô¼ºµÄרÓô洢Çø¡£ORACLE½ø³ÌµÄÌåϵ½á¹¹Éè¼ÆʹÐÔÄÜ×î´ó¡£
ORACLEʵÀýÓÐÁ½ÖÖÀàÐÍ£ºµ¥½ø³ÌʵÀýºÍ¶à½ø³ÌʵÀý¡£
µ¥½ø³ÌORACLE£¨ÓֳƵ¥ÓÃORACLE£©ÊÇÒ»ÖÖÊý¾Ý¿âϵͳ£¬Ò»¸ö½ø³ÌÖ´ÐÐÈ«²¿ORA ......