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¼¼Êõ£¬ÎªÓû§ÌṩÁËÎÞÏ޵ĿÉÉìËõÐÔºÍ×
Ïà¹ØÎĵµ£º
SQL> conn system/oracle
Connected.
SQL> create table scott.t1(id number primary key,name varchar2(10)); --´´½¨²âÊÔ±í
Table created.
SQL> select constraint_name,table_name,constraint_type, --²é¿´ÏàÓ¦ÍêÕûÐÔÔ¼ÊøµÄ״̬
2 status,deferrable,deferred,validated
3 fro ......
·½°¸Ò»£º
ÐÂ×°ÁËϵͳºó£¬·¢ÏÖÔÚµ÷ÊÔ³ÌÐòʱTOMCATÌáʾ8080¶Ë¿ÚÒѱ»Õ¼Óã¬ÓÚÊÇÔËÐÐNETSTAT -ANO²é¿´¶Ë¿ÚʹÓÃÇé¿ö£¬·¢ÏÖ8080¶Ë¿Ú±»ORACLEµÄ¼àÌýÆ÷¸øÕ¼ÓÃÁË£¬ÓÚÊǽáºÏÉÏÍø²éµ½·½·¨£¬½«ORACLE XDBµÄHTTP·þÎñ¶Ë¿Ú¸Ä³É8081£¬ÎÊÌâ½â¾ö¡£
×ܽáһϿɽâ¾öµÄ·½ ......
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 ......
-- ²éѯ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 "×ֶΠ......
½éÉÜto_char(Êý×Ö, ‘¸ñʽ’)£¬±È½Ï³£Óõĸñʽ
9 ±íʾÓÐЧλÊý
0 ÓÃ0²¹×ãλÊý
B Óÿոñ²¹×ãλÊý
ÔÊýµÄλÖÃÓÐʵ¼ÊÊý×ÖռλµÄʱºò£¬0ºÍ9µÄЧ¹ûÊÇÒ»ÑùµÄ¡£
0ºÍ9µÄÇø±ðÔÚÓÚ¸ñʽÖеÄÄÇһλÖÃʵ¼ÊÊý×ÖûÓÐվλµÄÇé¿öÏ¡£
select to_char(0.45,'0.99'); ½á¹ûÊÇ0.45
select ......