OracleµÄÓû§¹ÜÀí
ORA
ÅäÖÃÉí·ÝÑéÖ¤
OracleΪÓû§ÕË»§ÌṩÈýÖÖÉí·ÝÑéÖ¤·½·¨£º
(1)ÃÜÂëÑéÖ¤
µ±Ò»¸öʹÓÃÃÜÂëÑéÖ¤»úÖÆµÄÓû§ÊÔͼÁ¬½Óµ½Êý¾Ý¿âʱ£¬Êý¾Ý¿â»áºËʵÓû§ÃûÊÇ·ñÊÇÒ»¸öÓÐЧµØÊý¾Ý¿âÓû§£¬²¢ÇÒÌṩÓë¸ÃÓû§ÔÚÊý¾Ý¿âÖд洢µÄÃÜÂëÏàÆ¥ÅäµÄÃÜÂë¡£
(2)ÍⲿÑéÖ¤
µ±Ò»¸öÍⲿÑé֤ʽÓû§ÊÔͼÁ¬½Óµ½Êý¾Ý¿âʱ£¬Êý¾Ý¿â»áºËʵÓû§ÃûÊÇ·ñÊÇÒ»¸öÓÐЧµÄÊý¾Ý¿âÕË»§£¬²¢È·ÐŸÃÓû§ÒѾÍê³ÉÁ˲Ù×÷ϵͳ¼¶±ðµÄÉí·ÝÑéÖ¤¡£
(3)È«¾ÖÑéÖ¤
È«¾ÖÑé֤ʽÓû§Ò²²»ÔÚÊý¾Ý¿âÖд洢ÑéÖ¤ÃÜÂ룬ÕâÖÖÀàÐ͵ÄÑéÖ¤ÊÇͨ¹ýÒ»¸ö¸ß¼¶°²È«Ñ¡ÏîËùÌṩµÄÉí·ÝÑéÖ¤·þÎñÀ´½øÐеġ£
´´½¨Óû§
sql> create user shoo identified by "wangsHuo"
sql> default tablespace tempts
sql> temporary tablespace temp;
sql> quota unlimited on tempts; -- Óû§ÔÚtempts±í¿Õ¼ä²»ÊÜÏÞÖÆ
-- sql> quota XXXm on tempts; -- ÅäÖÃÓû§ÔÚ±í¿Õ¼äÉϵĴÅÅÌÏÞ¶î
-- sql> quota 0 on system; -- ²»ÔÊÐí¸ÃÓû§Ê¹ÓÃsystem±í¿Õ¼ä
ȨÏÞ¹ÜÀí
ÔÚOracleÊý¾Ý¿âÖÐȨÏÞ·ÖΪÁ½´óÀࣺϵͳȨÏÞ(System privilege)ºÍ¶ÔÏóȨÏÞ(Object privilege)¡£
ϵͳȨÏÞÊÇÔÚϵͳ¼¶¶ÔÊý¾Ý¿â½øÐдæÈ¡ºÍʹÓõĻúÖÆ£¬±ÈÈ磬Óû§ÊÇ·ñÄܹ»Á¬½Óµ½Êý¾Ý¿âϵͳ(sessionȨÏÞ)£¬Ö´ÐÐϵͳ¼¶µÄDDLÓï¾ä(Èçcreate¡¢alter¡¢drop)µÈ¡£
¶ÔÏóȨÏÞÊÇָijһÓû§¶ÔÆäËûÓû§µÄ±í¡¢ÊÓͼ¡¢ÐòÁС¢´æ´¢¹ý³Ì¡¢º¯Êý¡¢°üµÈµÄ²Ù×÷ȨÏÞ¡£²»Í¬ÀàÐ͵ĶÔÏó¾ßÓв»Í¬µÄ¶ÔÏóȨÏÞ£¬¶ÔÓÚijЩģʽ¶ÔÏ󣬱ÈÈç¾Û´Ø¡¢Ë÷Òý¡¢´¥·¢Æ÷¡¢Êý¾Ý¿âÁ´½ÓµÈûÓÐÏàÓ¦µÄʵÌåȨÏÞ£¬ÕâЩȨÏÞÓÉϵͳȨÏÞ½øÐйÜÀí¡£
Ïà¹ØÎĵµ£º
дЩ»ù´¡µÄ! ¶Ô×Ô¼º»¹ÊÇÓкô¦µÄ.
shutdownÓÐËĸö²ÎÊý£ºnormal¡¢transactional¡¢immediate¡¢abort¡£È±Ê¡²»´øÈκβÎÊýʱ±íʾÊÇnormal
Ò»:
shutdown normal:
²»¶Ï¿ªÏÖÔÚÁ¬½ÓµÄÓû§,×èÖ¹ÈκÎÓû§½¨Á¢ÐµÄÁ¬½Ó£¬°üÀ¨¹ÜÀíÔ±ÔÚÄÚ¡£ÒѾÁ¬½ÓµÄÓû§Äܹ»¼ÌÐøËûÃǵ±Ç°µÄ¹¤×÷,ÈçµÝ½»ÐµĸüÐÂÊÂÎñ,Ö±µ½´ËÓ ......
ѪҺÃ÷ϸ±íÈçÏ£º
create table "blood"."OC_CarryOrderD" (
ID nvarchar2(20) &n ......
oracleËøµÄÅŶӻúÖÆ£º
ÇëÇóËø¶¨ÐèÒªÅŶӡ£Èç¹ûij¸ö»á»°ÇëÇóÒ»¸öËø¶¨£¬µ«ÊÇÓÉÓÚÆäËû»á»°ÒÑ¾Ëø¶¨ÁËÖ¸¶¨¼Ç¼»ò¶ÔÏó¶øÎÞ·¨»ñµÃËùÐèµÄËø¶¨£¬ÄÇôÕâ¸ö»á»°½«»áµÈ´ý¡£´Ëʱ£¬¿ÉÄܶà¸ö»á»°¶¼Ôڵȴý·ÃÎÊÏàͬ¼Ç¼»ò¶ÔÏó£¬ÔÚÕâÖÖÇé¿öÏ£¬ORACLE»á¸ú×ÙÕâЩ»á»°ÇëÇóËø¶¨µÄ˳Ðò¡£
Èç¹û ......
²é¿´µ±Ç°Êý¾Ý¿â¹éµµÈÕÖ¾²Ù×÷ģʽ:
select name,log_mode from v$database;
²é¿´¹éµµÈÕ־λÖÃ:
show parameter log_archive_dest; µÚÒ»¸ö¹éµµÎ»ÖÃ
show parameter log_archive_duplex_dest; µÚ¶þ¸ö¹éµµÎ»ÖÃ
ÏȹرÕÊý¾Ý¿â,È»ºó×°ÔØÊý¾Ý¿â:
shutdown immediate;
startup mount;
Ð޸Ĺ鵵ÈÕÖ¾²Ù×÷ģʽ,È»ºó´ò¿ªÊý¾Ý¿â ......
ºÜ¶àÅóÓÑÖ»ÓÃÁËoracleµÄɾ³ý£¬µ«ºÜ¶àÇé¿öÏ£¬Ëû»á·¢ÏÖÖØÐ°²×°Ê±£¬µãÁËÏÂÒ»²½°²×°½çÃæ¾ÍÏûʧÁË£¬ÍùÍùÎÞÄÎÏÂÖ»ºÃÖØ×°ÏµÍ³£¬ÆäʵֻÊÇÄãÊý¾Ý¿âûɾ¸É¾»£¬É¾¸É¾»¾Í²»»á³öÏÖÕâÖÖÇé¿öÁË¡£
ʵÏÖ·½·¨£º
1¡¢ ¿ªÊ¼££¾ÉèÖ㣾¿ØÖÆÃæ°å££¾¹ÜÀí¹¤¾ß££¾·þÎñ Í£Ö¹ËùÓÐOracle·þÎñ¡£
&n ......