Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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Щģʽ¶ÔÏ󣬱ÈÈç¾Û´Ø¡¢Ë÷Òý¡¢´¥·¢Æ÷¡¢Êý¾Ý¿âÁ´½ÓµÈûÓÐÏàÓ¦µÄʵÌåȨÏÞ£¬ÕâЩȨÏÞÓÉϵͳȨÏÞ½øÐйÜÀí¡£


Ïà¹ØÎĵµ£º

oracle startup shutdownÃüÁî

дЩ»ù´¡µÄ! ¶Ô×Ô¼º»¹ÊÇÓкô¦µÄ.
shutdownÓÐËĸö²ÎÊý£ºnormal¡¢transactional¡¢immediate¡¢abort¡£È±Ê¡²»´øÈκβÎÊýʱ±íʾÊÇnormal
Ò»:
shutdown normal:
     ²»¶Ï¿ªÏÖÔÚÁ¬½ÓµÄÓû§,×èÖ¹ÈκÎÓû§½¨Á¢ÐµÄÁ¬½Ó£¬°üÀ¨¹ÜÀíÔ±ÔÚÄÚ¡£ÒѾ­Á¬½ÓµÄÓû§Äܹ»¼ÌÐøËûÃǵ±Ç°µÄ¹¤×÷,ÈçµÝ½»ÐµĸüÐÂÊÂÎñ,Ö±µ½´ËÓ ......

Oracle³£ÓòÎÊýÉèÖÃ

²éѯµ±Ç°Ê¹ÓõÄÓαêÊý¾Ý£ºselect count(*) from v$open_cursor
²éѯµ±Ç°×î´óÓαêÊý£ºshow parameter open_cursors;
ÐÞ¸Ä×î´óÓαêÊý£ºalter system set open_cursors=1000 scope=spfile;
=========================================================
²éѯµ±Ç°×î´ó»á»°Êý£ºshow parameter sessions;
ÐÞ¸Ä×î´ó»á»°Êý£ºalt ......

Oracle Listener ¶¯Ì¬×¢²á Óë ¾²Ì¬×¢²á

Ò»£®Ê²Ã´ÊÇ×¢²á
×¢²á¾ÍÊǽ«Êý¾Ý¿â×÷Ϊһ¸ö·þÎñ×¢²áµ½¼àÌý³ÌÐò¡£¿Í»§¶Ë²»ÐèÒªÖªµÀÊý¾Ý¿âÃûºÍʵÀýÃû£¬Ö»ÐèÒªÖªµÀ¸ÃÊý¾Ý¿â¶ÔÍâÌṩµÄ·þÎñÃû¾Í¿ÉÒÔÉêÇëÁ¬½Óµ½Êý¾Ý¿â¡£Õâ¸ö·þÎñÃû¿ÉÄÜÓëʵÀýÃûÒ»Ñù£¬Ò²ÓпÉÄܲ»Ò»Ñù¡£
¡¡¡¡ÔÚÊý¾Ý¿â·þÎñÆ÷Æô¶¯¹ý³ÌÖУ¬Êý¾Ý¿â·þÎñÆ÷»áÏò¼àÌý³ÌÐò×¢²áÏàÓ¦µÄ·þÎñ£¨ÎÞÂÛºÎʱÆô¶¯Ò»¸öÊý¾Ý¿â£¬Ä¬Èϵض¼ ......

¼×¹ÇÎÄÍÆ³öOracleÆóÒµ¹ÜÀíÆ÷11g£¨Ò»£©

OracleÆóÒµ¹ÜÀíÆ÷11gÌṩҵ½ç×îÈ«ÃæµÄÒµÎñÇý¶¯ÐÍIT¹ÜÀí¹¦ÄÜ£¬ÓÐÖúÓÚͨ¹ý¼¯³ÉʽIT¹ÜÀí·½·¨£¬×î´óÏ޶ȵØÌá¸ßÆóÒµÃô½ÝÐÔºÍЧÂÊ¡£
¡¡¡¡OracleÆóÒµ¹ÜÀíÆ÷11gÒýÈëÁË£º
¡¡¡¡ÒµÎñÇý¶¯ÐÍÓ¦ÓùÜÀí - ʹITϵͳÄܹ»¸ü¿ìµØÏìÓ¦ÓÅÏÈÒµÎñ£¬Í¨¹ý¹ÜÀíÃæÏòÓû§ÌåÑéºÍÉÌÎñ½»Ò׵ĹؼüÖ¸±ê£¬Ìṩ¸ü¸ßµÄÉÌÒµ¼ÛÖµ¡£
¡¡¡¡¼¯³ÉʽӦÓÃÈí¼þÖÁ´ÅÅ̹ÜÀ ......

¼×¹ÇÎÄÍÆ³öOracleÆóÒµ¹ÜÀíÆ÷11g£¨¶þ£©

¼¯³ÉʽӦÓÃÈí¼þÖÁ´ÅÅ̹ÜÀí£¬¼ò»¯¹ÜÀí»·¾³£¬Ìá¸ßͶ×ʻر¨ÂÊ
¡¡¡¡È«Ãæ¹ÜÀíOracleµÄ²úÆ·£¬°üÀ¨Äܹ»¹ÜÀíOracleÓ¦ÓÃÈí¼þ¡¢OracleÈÚºÏÖмä¼þ¡¢OracleÊý¾Ý¿â¡¢Oracle Solaris¡¢OracleÆóÒµ¼¶Linux¡¢Oracle VMºÍOracle Sun·þÎñÆ÷µÄ¹¤¾ß¡£ÕâʹµÃITÄܹ»¿ìËÙÈ·¶¨ÎÊÌâµÄ¸ù±¾Ô­Òò£¬¶øÇÒÔںܶàÇé¿öÏ£¬»¹ÄÜ×Ô¶¯µØ½â¾öÎÊÌâ¡£
¡¡¡¡ÁíÍ⣬Õâ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ