Oracle ÓÅ»¯ÅäÖà ÊÕ²Ø
Êý¾Ý¿âϵͳºÍ²Ù×÷ϵͳһÑù£¬ÔÚ¼ÆËã»úÉϰ²×°³É¹¦ºó£¬»¹ÐèÒª½øÒ»²½ÅäÖúÍÓÅ»¯£¬´Ó¶øÊ¹Æä¾ßÓиüÇ¿´óµÄ¹¦ÄܺÍÔËÐÐÔÚ×î¼Ñ״̬¡£Èç¹ûÔÚÉè¼Æ½×¶ÎÒòΪ¸÷ÖÖÒòËØÃ»ÓнøÐнÏΪºÏÀíµÄÅäÖúͼƻ®£¬ÄÇô¾ÍÐèÒªÔÚºóÆÚ¶ÔÊý¾Ý¿âϵͳ½øÐÐÓÅ»¯¡£
Êý¾Ý¿âϵͳÐÔÄܵÄÓÅ»¯£¬³ýÁËÔÚÉè¼Æ½×¶Î¶ÔÆäÂß¼´æ´¢½á¹¹ºÍÎïÀí´æ´¢½á¹¹Éè¼Æ½øÐÐÓÅ»¯£¬Ê¹Ö®ÔÚÂú×ãÐèÇóÌõ¼þÏ£¬Ê±¿Õ¿ªÏúÐÔÄÜ×î¼ÑÍ⣬»¹¿ÉÔÚÔËÐн׶Σ¬²ÉȡһЩÓÅ»¯´ëÊ©£¬Ê¹ÏµÍ³ÐÔÄÜ×î¼Ñ¡£±¾×¨ÌâËùÌÖÂÛµÄÐÔÄÜÓÅ»¯Ö÷ÒªÖ¸ÔËÐн׶εÄÐÔÄÜÓÅ»¯£¬¼´ÌÖÂÛÈçºÎʹÓÃOracleËùÌṩµÄÓÅ»¯ÊÖ¶ÎÀ´Ìá¸ßϵͳÐÔÄÜ¡£´ó¶àÊýÐÔÄÜÎÊÌâ²¢²»ÊÇÒ»ÖÖ¹ÂÁ¢µÄÖ¢×´£¬¶øÊÇϵͳÉè¼ÆµÄ½á¹û£¬Òò´ËÐÔÄÜÓÅ»¯¾Í¼¯ÖÐÔÚÄÇЩµ¼Ö²»¿É½ÓÊÜÌØÕ÷µÄͬһµÄ¡¢¹Ì¶¨µÄºÍDZÔÚµÄÎÊÌâÉÏ¡£ÓÅ»¯ÊÇÊý¾Ý¿âÉè¼ÆÖГ¼Æ»® ”¡¢“Éè¼Æ”¡¢“¼àÊÓ”ºÍ“ÓÅ»¯”ËÄ´ó²½ÖèµÄ×îºóÒ»²½¡£ ³ýÁËÓÃOracleÓÅ»¯Æ÷À´ÓÅ»¯Êý¾Ý¿âµÄÐÔÄÜÍ⣬DBA»¹¿Éͨ¹ýÓÅ»¯OracleµÄ²ÎÊýÉèÖõÈÊÖ¶ÎÀ´ÓÅ»¯Êý¾Ý¿âµÄÐÔÄÜ£¬¶Ô²ÎÊýµÄϸ΢ÓÅ»¯±ãÄÜÓ°ÏìϵͳÕûÌåÐÔÄÜ¡£
ΪÁËÓÐÄ¿µÄÓÅ»¯ÏµÍ³ÐÔÄÜ£¬Ê×ÏÈÓ¦Ã÷È·ÓÅ»¯Ä¿±ê£¬È»ºóÔÙ¸ù¾ÝÄ¿±êÓÅ»¯¸÷ÖÖ³õʼ²ÎÊýµÄÉèÖã¬ÒÔ´ïµ½¸üºÃЧ¹û¡£¿ÉÓÐÈçϼ¸¸öÓÅ»¯Ä¿±ê£º
¡ô Ó¦ÓóÌÐòÉè¼ÆµÄÓÅ»¯
¡ô Ö¸¶¨ÀàÐÍSQLÓï¾äµÄÓÅ»¯
¡ô ÄÚ´æÊ¹ÓõÄÓÅ»¯
¡ô Êý¾Ý´æ´¢¡¢ÎïÀí´æ´¢ºÍÂß¼´æ´¢µÄÓÅ»¯
¡ô ÍøÂçͨÐÅÁ¿µÄÓÅ»¯
DBA¿ÉÑ¡¶¨ÉÏÊöÒ»¸ö»ò¶à¸öÄ¿±êÀ´ÊµÊ©ÓÅ»¯¡£ÐÔÄÜÓÅ»¯Ö÷ÒªÊÇͨ¹ýÓÅ»¯³õʼ»¯²ÎÊýÀ´ÊµÏÖ¡£±¾×¨Ìâ´ÓÒÔϼ¸¸ö·½ÃæÀ´Ì¸Ì¸ÈçºÎÓÅ»¯OracleÊý¾Ý¿â£¬Ê¹Æä¾ßÓÐ×î¼ÑÐÔÄÜ¡£
(1)ÓÅ»¯³õʼ²ÎÊý
(2)ÓÅ»¯ÄÚ´æ
(3)ÓÅ»¯I£¯O
(4)ÓÅ»¯×ÊÔ´ÕùÓÃ
(5)ÆäËü²ÎÊýÓÅ»¯
¿É±ä²ÎÊýµÄÓÅ»¯
ÔÚ¶ÔOracleÊý¾Ý¿â½øÐÐÓÅ»¯Ê±£¬ÐèÒªÓõ½Ðí¶àµÄ²ÎÊý£¬ÆäÖÐÓÐÒ»²¿·Ö²ÎÊý¶ÔϵͳÐÔÄÜÓ°Ïì½Ï´ó£¬Õⲿ·Ö²ÎÊý½Ð¿É±ä²ÎÊý¡£¿É±ä²ÎÊý°´Æä×÷ÓÿÉÒÔ·ÖΪÁ½´óÀ࣬һ´óÀàÊÇÆðÏÞÖÆ×÷Óõģ¬ÈçOPEN_CURSORS£»ÁíÒ»´óÀàÊÇÓ°ÏìϵͳÐÔÄܵģ¬ÈçDB_BLOCK_BUFFERS¡£
ÔÚ½øÐÐÊý¾Ý¿âϵͳÐÔÄÜÓÅ»¯Ê±£¬ÐèÒªÊìÁ·ÕÆÎÕºÍÁ˽âһЩ¿É±ä²ÎÊý¡£±¾ÎÄÌÖÂÛÁËһЩ¶ÔϵͳÐÔÄÜÓнϴóÓ°ÏìµÄ²ÎÊý¡£
ÏÞÖÆÀà¿É±ä²ÎÊý
(1)DML_LOCKS
¸Ã²ÎÊý±íÃ÷¶àÉÙ¸öÓû§£¬¿ÉͬʱÄÜÐ޸ĶàÉÙÕÅ±í¡£ÀýÈ磺ÓÐÈý¸öÓû§Í¬Ê±Ð޸ĶþÕÅ±í£¬ÔòÒªÇó±íÉϵÄ×ÜÊýΪ6¡£ÈôÖÃΪ0£¬Ôò×éÖ¯¶ÓÁв»Æð×÷Óã¬ÆäÐÔÄÜ»áÉÔÓÐÌá¸ß¡£Ê¹ÓøòÎÊýʱ²»ÄÜÓÃDROP TABLE¡¢CREATE INDEX»òÏÔʽ·âËø¡£
(2)LICENSE_MAX_SESSION
¸Ã²ÎÊýÖ¸³öÔÊÐí²¢·¢Óû§»á»°µÄ×î´óÊý¡£Èô´
Ïà¹ØÎĵµ£º
°²×°¹ý³ÌÖгöÏÖ“X11/extensions/Print.h: No such file or directory”µÄ½â¾ö·½·¨
ÕâÊÇÒòΪϵͳÖÐȱÉÙlibXp-devel
# yum install libXp-devel
°²×°¹ý³ÌÖгöÏÖ“X11/bitmaps/gray: No such file or directory”µÄ½â¾ö·½·¨
ÕâÊÇÒòΪϵͳÖÐȱÉÙxorg-x11-xbitmaps£¨x11/xbitmaps (Ubuntu) and xorg-x1 ......
ÔÚSQLÓï¾äÓÅ»¯¹ý³ÌÖУ¬¾³£»áÓõ½hint,ÏÂÃæÎÒÃÇÀ´½éÉÜÒ»ÏÂÔÚSQLÓÅ»¯¹ý³ÌÖг£¼ûOracleÖÐ"HINT"µÄ30¸öÓ÷¨£º
¡¡¡¡1. /*+ALL_ROWS*/
¡¡¡¡±íÃ÷¶ÔÓï¾ä¿éÑ¡Ôñ»ùÓÚ¿ªÏúµÄÓÅ»¯·½·¨,²¢»ñµÃ×î¼ÑÍÌÍÂÁ¿,ʹ×ÊÔ´ÏûºÄ×îС»¯¡£
¡¡¡¡2. /*+FIRST_ROWS*/
¡¡¡¡±íÃ÷¶ÔÓï¾ä¿éÑ¡Ôñ»ùÓÚ¿ªÏúµÄÓÅ»¯·½·¨,²¢»ñµÃ×î¼ÑÏìӦʱ¼ä,ʹ×ÊÔ´ÏûºÄ×îÐ ......
ÎÊÌâ
£¨1£©±íemployeesºÍdepartment´æÔÚ²ÎÕÕÍêÕûÐÔÔ¼Êø£¬ÔÚ±íemployeesÖвåÈë¼Ç¼£¨‘70’£¬‘999’£©department_idΪ‘999’ʱ£¬department±íÖл¹²»´æÔÚdepartment_idΪ‘999’µÄ¼Ç¼£¬ËùÒÔÎ¥±³Á˲ÎÕÕÍêÕûÐÔÔ¼Êø,³öÏÖ“Integrity constraint violation error”ÌáʾÐÅÏ ......
ĬÈÏÇé¿öÏ£¬ÔÚOracleµÄÖ÷»úÉÏ£¨linuxϵͳ£©µÄOracle²Ù×÷ϵͳÓû§Ï£¬ÒÔsysÓû§µÇ½Êý¾Ý¿âʱ¿ÉÒÔ²»ÓÃÊäÈëÃÜÂëÖ±½ÓµÇ¼¡£Êµ¼ÊÉÏ£¬Ö»ÒªÊÇÊôÓÚdba×飨linux£©»òosdba×飨windows£©Ï£¬¶¼¿ÉÒÔ²»ÓÃÃÜÂë½øÐеǼ¡£ÕâÊÇÈÏÖ¤·½Ê½³ÆÎªOSÈÏÖ¤¡£
ÕâÖֵǼ·½Ê½µÄ¿ØÖÆ£¬ÊÇͨ¹ý$ORACLE_HOME/network/admin/sqlnet.oraÖеģº
SQLNET.AUTH ......
×î½üÔÚÂÛ̳ÉÏÒ»Ö±¿´µ½ÓÐÅóÓѶÔÊý¾Ý×ÖµäÀïµÄÄÚÈݸ㲻̫Çå³þ£¬±ÈÈç˵V$¡¢V_$¡¢GV$µÈµÈ£¬µ½µ×ÄĸöÊÇͬÒå´Ê£¬ÄĸöÊÇÊÓͼ£¬Äĸö»ùÓÚÄĸö´´½¨¡£½ñÌìÕýºÃ¿´µ½¸Ç¹úÇ¿µÄ¡¶ÉîÈëdz³öORACLE¡·µÚÈýÕ½²µ½Õâ·½ÃæÄÚÈÝ£¬×ܽáһϣ¬Ò²·½±ã´ó¼Òѧϰ¡£
Êý¾Ý×ÖµäÓÉËIJ¿·Ö×é³É£º
1¡¢ÄÚ²¿RDBMS(X$)±í
X$ÊÇOracleÊý¾Ý¿âµÄºËÐIJ¿·Ö£¬ÕâЩ ......