Oracle OSÈÏÖ¤ÒÔ¼°¿ÚÁîÎļþ
1.OSÈÏÖ¤
Oracle°²×°Ö®ºóĬÈÏÇé¿öÏÂÊÇÆôÓÃÁËOSÈÏÖ¤µÄ£¬ÕâÀïÌáµ½µÄosÈÏÖ¤ÊÇÖ¸·þÎñÆ÷¶ËosÈÏÖ¤¡£OSÈÏÖ¤µÄÒâ˼°ÑµÇ¼Êý¾Ý¿âµÄÓû§ºÍ¿ÚÁîУÑé·ÅÔÚÁ˲Ù×÷ϵͳһ¼¶¡£Èç¹ûÒÔ°²×°OracleʱµÄÓû§µÇ¼OS£¬ÄÇô´ËʱÔڵǼOracleÊý¾Ý¿âʱ²»ÐèÒªÈκÎÑéÖ¤£¬È磺
SQL> connect /as sysdba
ÒÑÁ¬½Ó¡£
SQL> connect sys/aaa@test as sysdba
ÒÑÁ¬½Ó¡£
SQL> connect sys/bbb as sysdba
ÒÑÁ¬½Ó¡£
SQL> connect aaa/bbb as sysdba
ÒÑÁ¬½Ó¡£
SQL> show user
SYS
SQL>
²»ÂÛÊäÈëʲôÓû§£¨ÄÄÅÂÕâ¸öÓû§ÈçaaaÔÚÊý¾Ý¿âÖиù±¾²»´æÔÚ£©£¬Ö»ÒªÒÔsysdbaȨÏÞÁ¬½ÓÊý¾Ý¿â£¬¶¼¿ÉÒÔÁ¬½ÓÉÏ£¬²¢ÇÒÁ¬½ÓÓû§ÊÇsys£¬ÕâÑùºÜ·½±ã£¬ÓÐʱºò£¬Èç¹ûÍü¼ÇÁËÊý¾Ý¿âµÄÃÜÂ룬¶øÓÖÏëµÇ¼Êý¾Ý¿â£¬¿ÉÒÔͨ¹ýÕâÖÖ·½Ê½£¬Ç°ÌáÊÇÔÚÊý¾Ý¿â·þÎñÆ÷ÉÏ.
µ«ÊÇ·½±ãµÄͬʱҲ´øÀ´ÁËһЩ°²È«Òþ»¼£¬ÓÚÊǺܶàÈËÏëÆÁ±ÎosÈÏÖ¤£¬
ÔÚwinÏÂÖ»Òª°Ñoracle_home/NETWORK/admin/sqlnet.oraÖеÄSQLNET.AUTHENTICATION_SERVICES= (nts)nts¸Ä³Énone»òÕß×¢Ê͵ôÕâ¾ä»°(ÔÚÇ°Ãæ¼ÓÉÏ#)£¬¾Í¿ÉÒÔÆÁ±Îos¹¦ÄÜ£¬ÒªÏëÒÔsysÓû§Á¬ÉÏÊý¾Ý¿â±ØÐëÊäÈëÕýÈ·µÄsys¿ÚÁ»òÕß¿ÉÒÔ°ÑoracleµÄ°²×°Óû§´Ó×éora_dbaÖÐɾ³ýµô£¬µ±È»Ò²¿ÉÒÔÖ±½Ó°Ñora_dbaÕâ¸ö×éҲɾ³ý£¬¶¼¿ÉÒÔÆÁ±Îos¹¦ÄÜ.È磺
SQL> connect /as sysdba
ERROR:
ORA-01031: ȨÏÞ²»×ã
SQL> connect sys/aaa as sysdba
ERROR:
ORA-01017: Óû§Ãû/¿ÚÁîÎÞЧ; µÇ¼±»¾Ü¾ø
SQL> connect aaa/bbb as sysdba
ERROR:
ORA-01031: ȨÏÞ²»×ã
SQL> connect sys/system as sysdba
ÒÑÁ¬½Ó¡£
SQL>
ÔÚunix/linuxÏÂÒ²¿ÉÒÔÔÚÎļþsqlnet.oraÖÐÔö¼ÓSQLNET.AUTHENTICATION_SERVICES=(none)ÒÔ¼°É¾³ýdba(groupdel dba)×é»òÕß°ÑoracleÓû§´Ódba×éÖÐɾ³ý¶¼¿ÉÒÔÆÁ±ÎosÈÏÖ¤¡£ÀûÓÃÕâÁ½ÖÖ·½·¨ÆÁ±Îos¹¦ÄÜËƺõ×ÜÓÐЩÈÃÈ˲»·ÅÐÄ£¬»òÕß˵²»ÄÜÈÃÈËÍêÈ«ÐÅ·þ£¬ÒòΪ±Ï¾¹ÏµÍ³¹ÜÀíÔ±»¹ÊÇ¿ÉÒÔ´´½¨ora_dba or dba×éÒÔ¼°ÐÞ¸Äsqlnet.oraÎļþ......
2. ¿ÚÁîÎļþ
OracleµÄ¿ÚÁîÎļþµÄ×÷ÓÃÊÇ´æ·ÅËùÓÐÒÔsysdba»òÕßsysoperȨÏÞÁ¬½ÓÊý¾Ý¿âµÄÓû§µÄ¿ÚÁÈç¹ûÏëÒÔsysdbaȨÏÞÔ¶³ÌÁ¬½ÓÊý¾Ý¿â£¬±ØÐëʹÓÿÚÁîÎļþ£¬·ñÔò²»ÄÜÁ¬ÉÏ£¬ÓÉÓÚsysÓû§ÔÚÁ¬½ÓÊý¾Ý¿âʱ±ØÐëÒÔsysdba or sysoper·½Ê½£¬Ò²¾ÍÊÇ˵sysÓû§ÒªÏëÁ¬½ÓÊý¾Ý¿â±ØÐëʹÓÿÚÁîÎļþ£¬Òò´ËÎÒÈÏΪÔÚÊý¾Ý¿âÖдæ·ÅsysÓû§µÄ¿ÚÁîÆäʵûÓÐÈκÎÒâÒ壡ʹÓÿÚÁîÎļþµÄºÃ´¦ÊǼ´Ê¹Êý¾Ý¿â²»´¦ÓÚopen״̬£¬ÒÀÈ»¿ÉÒÔͨ¹ý¿ÚÁîÎļþÑéÖ¤À´Á¬½ÓÊý¾Ý¿â¡£¿ªÊ¼°²×°Íêo
Ïà¹ØÎĵµ£º
¸Õ¸Õ½Ó´¥ORACLEµÄÈËÀ´Ëµ,´ÓÄÇÀïѧ,ÈçºÎѧ,ÓÐÄÇЩ¹¤¾ß¿ÉÒÔʹÓÃ,Ó¦¸ÃÖ´ÐÐʲô²Ù×÷,Ò»¶¨»Ø¸Ðµ½ÎÞÖú¡£ËùÒÔÔÚѧϰʹÓÃORACLE֮ǰ£¬Ê×ÏÈÀ´°²×°Ò»ÏÂORACLE 10g£¬ÔÚÀ´ÕÆÎÕÆä»ù±¾¹¤¾ß¡£Ë×»°ËµµÄºÃ£º¹¤ÓûÉÆÆäÊ£¬±ØÏÈÀûÆäÆ÷¡£ÎÒÃÇ¿ªÊ¼°É£¡
¡¡¡¡Ê×ÏȽ«ORACLE 10gµÄ°²×°¹âÅÌ·ÅÈë¹âÇý£¬Èç¹û×Ô¶¯ÔËÐУ¬Ò»°ã»á³öÏÖÈçͼ1°²×°½çÃ棺
ͼ1
......
Ó¦¸ö±¨±íÒªÇó×ö¸ö
ʱ¼ä Ë«É«Çò£¬ ʤ¸º²Ê¡£¡£¡£¡£¡£
200905 ÏúÁ¿ ÏúÁ¿
200906 ÏúÁ¿ ÏúÁ¿
200907 &n ......
´æ´¢¹ý³ÌÔÚ·þÎñÆ÷¶ËÔçÒѱà¼Ö´ÐйýµÄ´úÂë¡£Óû§Òª×öµÄÖ»Êǵ÷ÓúͽÓÊÕ´æ´¢¹ý·µ»ØµÄ½á¹û¡£ËùÒÔµ÷Óô洢¹ý³Ì±ÈÆÕͨµÄÓòéѯÓï¾ä·µ»ØÖµÒª¿ìµÃ¶à,´æ´¢¹ý³ÌµÄÖ´ÐÐËٶȸü¿ì,´æ ´¢¹ý³ÌÊDZ£´æÆðÀ´µÄ¿ÉÒÔ½ÓÊܺͷµ»ØÓû§ÌṩµÄ²ÎÊýµÄ Transact-SQL Óï¾äµÄ¼¯ºÏ¡£¿ÉÒÔ´´½¨Ò»¸ö¹ý³Ì¹©ÓÀ¾ÃʹÓ㬻òÔÚÒ»¸ö»á»°ÖÐÁÙʱʹÓ㨾ֲ¿ÁÙʱ¹ý ......
oracle11g¾ßÓÐ×Ô¶¯µÄ±íѹËõ¹¦ÄÜ£¬ µ«µ±insertÓï¾äδָ¶¨¾ßÌåµÄÁÐÃûʱ£¬ »áʹÓÃ×Ô¶¯±íѹËõ¹¦ÄÜʧЧ¡£(Èç¸ÃÓï¾ä»áʹµÃ±ít_test²»ÄÜ×Ô¶¯Ñ¹Ëõ: insert into t_test select * from t_test2)
ÁíÍâʹÓÃһЩÍⲿ¹¤¾ß½øÐÐÊý¾Ý×°ÔØ(sqlload)£¬Ò²ÓпÉÄÜʹµÃ±í²»ÄÜ×Ô¶¯Ñ¹Ëõ£¬´ËʱÐèÒªÓÃÒÔÏÂÓï¾ä£¬ÒÔÖØзÖÎö±í£¬·ÖÎöÍê³ÉÖ®ºó£¬¸Ã±í¼´»á ......
ÎÄÕÂÌáµ½£¬ÓÃCache hit ratioµÄ·½·¨À´¼ì²éORACLEÐÔÄÜÎÊÌâ¹ýʱÁË£¬ÀïÃæÓоä·Ç³£ÐÎÏóµÄ»°£ºÕâÎÞÒìÓÚÒ»¸öÒ½ÉúÖ»ÖªµÀ¸ù¾ÝѪѹµÄÀ´ÖÎÁƲ¡ÈË£¬¶ø²¡ÈËÓÉÓÚÌÛÍ´£¬Éñ¾ÐË·Ü£¬ÑªÑ¹ÔÚÒ»¸öºÏÀíµÄ·¶Î§ÄÚ£¬Ò½ÉúÈ´¸æËß»¼Õߣ¬Äãû²¡£¬µÈÄãѪѹµÍµÄʱºòÔÙÀ´¡£Í¬ÑùµÄ£¬ÎÒÃDz»Äܽö½ö¸ù¾ÝCache hit ratioÀ´ÅжÏORACLEÊ ......