OracleÄÚ´æ½á¹¹ÓëʵÀý¼°Æä¹ÜÀí
OracleÄÚ´æ½á¹¹ÓëʵÀý¼°Æä¹ÜÀí
1¡¢ ÄÚ´æ½á¹¹£º
OracleÊý¾Ý¿âµÄ×ÜÌå½á¹¹ÈçÏÂͼ£º
ÿ¸öOracleÊý¾Ý¿â¶¼ÊÇÓÉOracle Instance£¨ÊµÀý£©ÓëÊý¾Ý¿â£¨Êý¾ÝÎļþ£¬¿ØÖÆÎļþ¡¢ÖØ×öÈÕÖ¾Îļþ£©×é³É£¬ÆäÖÐËùνʵÀý¾ÍÊÇÓû§Í¬Êý¾Ý¿â½»»¥µÄý½é£¬Óû§Í¨¹ýÓÚÒ»¸öʵÀýÏàÁ¬À´²Ù×÷Êý¾Ý¿â¡£¶øʵÀýÓÖÊÇÓÉͳһµÄÄÚ´æ½á¹¹£¨SGA£¬PGA£¬UGA£©ºÍÒ»ÅúÄÚ´æפÁô½ø³Ì×é³É¡£ÊµÀýÔÚ²Ù×÷ϵͳÖÐÓÃORACLE_SIDÀ´±êʶ£¬ÔÚOracleÖÐÓòÎÊýINSTANCE_NAMEÀ´±êʶ£¬ ËüÃÇÁ½¸öµÄÖµÊÇÏàͬµÄ¡£Êý¾Ý¿âÆô¶¯Ê±£¬ÏµÍ³Ê×ÏÈÔÚ·þÎñÆ÷ÄÚ´æÖзÖÅäϵͳȫ¾ÖÇø£¨SGA£©£¬ ¹¹³ÉÁËOracleµÄÄÚ´æ½á¹¹£¬È»ºóÆô¶¯Èô¸É¸ö³£×¤ÄÚ´æµÄ²Ù×÷ϵͳ½ø³Ì£¬¼´×é³ÉÁËOracleµÄ ½ø³Ì½á¹¹£¬ÄÚ´æÇøÓòºÍºǫ́½ø³ÌºÏ³ÆΪһ¸öOracleʵÀý¡£
ʵÀý½á¹¹ÈçÏÂͼ£º
1.1ÄÚ´æ¶ÔÊý¾Ý¿âµÄÓ°Ï죺
ÄÚ´æÊÇÓ°ÏìÊý¾Ý¿âÐÔÄܵÄÖØÒªÒòËØ£¬Oracle8iʹÓþ²Ì¬ÄÚ´æ¹ÜÀí£¬Oracle 10gʹÓö¯Ì¬ ÄÚ´æ¹ÜÀí¡£Ëùν¾²Ì¬ÄÚ´æ¹ÜÀí£¬¾ÍÊÇÔÚÊý¾Ý¿âϵͳÖУ¬ÎÞÂÛÊÇ·ñÓÐÓû§Á¬½Ó£¬Ò²ÎÞÂÛ²¢·¢Óà Á¿´óС£¬Ö»ÒªÊý¾Ý¿â·þÎñÔÚÔËÐУ¬¾Í»á·ÖÅä¹Ì¶¨´óСµÄÄڴ棻¶¯Ì¬ÄÚ´æ¹ÜÀíÔÊÐíÔÚÊý¾Ý¿â·þ ÎñÔËÐÐʱ¶ÔÄÚ´æµÄ´óС½øÐÐÐ޸ģ¬¶ÁÈ¡´óÊý¾Ý¿éʱʹÓôóÄڴ棬СÊý¾Ý¿éʱʹÓÃСÄڴ棬¶Á È¡±ê×¼ÄÚ´æ¿éʱʹÓñê×¼ÄÚ´æÉèÖá£
1.2 SGAÄÚ²¿½á¹¹¼°¹ÜÀí£º
SGAÊÇÒ»×éΪϵͳ·ÖÅäµÄ¹²ÏíµÄÄÚ´æ½á¹¹£¬¿ÉÒÔ°üº¬Ò»¸öÊý¾Ý¿âʵÀýµÄÊý¾Ý»ò¿ØÖÆЊϢ¡£Èç¹û¶à¸öÓû§Á¬½Óµ½Í¬Ò»¸öÊý¾Ý¿âʵÀý£¬ÔÚʵÀýµÄSGAÖУ¬Êý¾Ý¿ÉÒÔ±»¶à¸öÓû§¹²Ïí¡£ µ±Êý¾Ý¿âʵÀýÆô¶¯Ê±£¬SGAµÄÄÚ´æ±»×Ô¶¯·ÖÅ䣻µ±Êý¾Ý¿âʵÀý¹Ø±Õʱ£¬SGAÄÚ´æ±»»ØÊÕ¡£ SGAÊÇÕ¼ÓÃÄÚ´æ×î´óµÄÒ»¸öÇøÓò£¬Í¬Ê±Ò²ÊÇÓ°ÏìÊý¾Ý¿âÐÔÄܵÄÖØÒªÒòËØ¡£
ͨ¹ýÏÂÃæµÄÓï¾ä²éѯ
SQL> show parameter sga NAME
TYPE VALUE ------------------------------------ ----------- --------
lock_sga boolean &nbs
Ïà¹ØÎĵµ£º
ÍüÁËOracleµÄsysÓû§ºÍMySQLµÄrootÓû§ÃÜÂ룬½â¾ö·½·¨
2007Äê03ÔÂ16ÈÕ ÐÇÆÚÎå 09:44
×÷Õߣºhexiong¡¡
°æȨÉùÃ÷£º¿ÉÒÔÈÎÒâתÔØ£¬×ªÔØʱÇëÎñ±ØÒÔ³¬Á´½ÓÐÎʽ±êÃ÷ÎÄÕÂÔʼ³ö´¦ºÍ×÷ÕßÐÅÏ¢¼°±¾ÉùÃ÷¡£
http://hi.baidu.com/hexiong/blog/item/b4acd72a85272d2cd42af1b1.html
¾³£Åöµ½ÓÐÈËÔÚÂÛ̳ÉÏÎÊÕâ¸öÎÊÌ⣬¸É´àÔÚÕâÀï×ܽáÒ ......
×÷Óãºmerge into ½â¾öÓÃB±í¸úÐÂA±íÊý¾Ý£¬Èç¹ûA±íÖÐûÓУ¬Ôò°ÑB±íµÄÊý¾Ý²åÈëA±í£»
Óï·¨£º
MERGE INTO [your table-name] [rename your table here]
USING ( [write your query here] )[rename your query-sql and using just like a table]
ON ([conditional expression here] AND [...]...)
WHEN MATHED THEN [here ......
Ò»¡¢¼àÌýÆ÷(LISTENER)
¡¡¡¡¼àÌýÆ÷ÊÇOracle»ùÓÚ·þÎñÆ÷¶ËµÄÒ»ÖÖÍøÂç·þÎñ£¬Ö÷ÒªÓÃÓÚ¼àÌý¿Í»§¶ËÏòÊý¾Ý¿â·þÎñÆ÷¶ËÌá³öµÄÁ¬½ÓÇëÇó¡£¼ÈÈ»ÊÇ»ùÓÚ·þÎñÆ÷¶ËµÄ·þÎñ£¬ÄÇôËüÒ²Ö»´æÔÚÓÚÊý¾Ý¿â·þÎñÆ÷¶Ë£¬½øÐмàÌýÆ÷µÄÉèÖÃÒ²ÊÇÔÚÊý¾Ý¿â·þÎñÆ÷¶ËÍê³ÉµÄ¡£
¶þ¡¢±¾µØ·þÎñÃû(Tnsname)
¡¡¡¡Oracle¿Í»§¶ËÓë·þÎñÆ÷¶ËµÄÁ¬½ÓÊÇͨ¹ý¿Í»§¶Ë· ......
--´´½¨Óû§
create user iagent identified by ia
--profile default
default tablespace users
temporary tablespace temp;
--account unlock;
--ɾ³ýÓû§
drop user iagent cascade;
--ÐÞ¸ÄÓû§ÃÜÂë
alter user iagent identified by ia;
--¸ø´´½¨µ ......
1¡¢ÔÚ±¾»ú69ÉÏ´´½¨Êý¾Ý¿âorcl £¬global_name=orcl£¬Ê¹ÓÃÓï¾ä
alter database rename global_name to orcl.us.oracle.com ÐÞ¸ÄÊý¾Ý¿âµÄÈ«¾ÖÊý¾Ý¿âÃûΪorcl.us.oracle.com
2¡¢ÔÚÐé»ú188ÉÏ´´½¨Êý¾Ý¿âviotest£¬global_name=viotest£¬Ê¹ÓÃÓï¾ä
alter database rename global_name to viotest.us.oracle.com ÐÞ¸ÄÊý¾Ý¿âµÄÈ«¾ÖÊ ......