¡¾ÊÕ²ØÕûÀí¡¿OracleÊý¾Ý¿âÌåϵ¼Ü¹¹
ÔÎļûhttp://blog.csdn.net/kele1121/archive/2009/10/30/4742051.aspxÓëhttp://www.itpub.net/thread-1105403-1-1.html
Ëùν
Oracle
µÄÌåϵ¼Ü¹¹£¬ÊÇÖ¸
Oracle
Êý¾Ý¿â¹ÜÀíϵͳµÄµÄ×é³É²¿·ÖºÍÕâЩ×é³É²¿·ÖÖ®¼äµÄÏ໥¹ØÏµ£¬°üÀ¨
ÄÚ´æ½á¹¹¡¢ºǫ́½ø³Ì¡¢ÎïÀíÓëÂß¼½á¹¹µÈ¡£
Oracle
Êý¾Ý¿âµÄÌåϵºÜ¸´ÔÓ£¬¸´ÔÓµÄÔÒòÔÚÓÚËü×î´óÏ޶ȵĽÚÔ¼
Äڴ棬´ÓÉÏͼ¿ÉÒÔ¿´³ö£¬ËüÔÚÕûÌåÉÏ·ÖʵÀýºÍÊý¾Ý¿âÎļþÁ½²¿·Ö¡£
£¨
1
£©Ê×ÏÈÇø·ÖÒ»ÏÂÊý¾Ý¿âµÄʵÀý£¨
Instance
£©ºÍÊý¾Ý¿âÁ½¸ö¸ÅÄ
l
ORACLE
ʵÀý
=
½ø³Ì
+
½ø³ÌËùʹÓõÄÄÚ´æ
(SGA)
£¬ÊµÀýÊÇÒ»¸öÁÙʱÐԵĶ«Î÷£¬ÄãÒ²¿ÉÒÔÈÏΪËü´ú±íÁËÊý¾Ý¿âijһʱ¿ÌµÄ״̬£¡
l
Êý¾Ý¿â
=
ÖØ×öÎļþ
+
¿ØÖÆÎļþ
+
Êý¾ÝÎļþ
+
ÁÙʱÎļþ£¬Êý¾Ý¿âÊÇÓÀ¾ÃµÄ£¬ÊÇÒ»¸öÎļþµÄ¼¯ºÏ¡£
ORACLE
ʵÀýºÍÊý¾Ý¿âÖ®¼äµÄ¹ØÏµ
1.
ÁÙʱÐÔ
(instance)
ºÍÓÀ¾ÃÐÔ
(
Êý¾Ý¿â
)
2.
ʵÀý£¨
instance
£©¿ÉÒÔÔÚûÓÐÊý¾ÝÎļþµÄÇé¿öϵ¥¶ÀÆô¶¯
startup nomount ,
ͨ³£Ã»Ê²Ã´ÒâÒå
3.
Ò»¸öʵÀýÔÚÆäÉú´æÆÚÄÚÖ»ÄÜ×°ÔØ
(alter database mount)
ºÍ´ò¿ª
(alter database open)
Ò»¸öÊý¾Ý¿â
4.
Ò»¸öÊý¾Ý¿â¿É±»Ðí¶àʵÀýÍ¬Ê±×°ÔØºÍ´ò¿ª
(
¼´
RAC)
£¬
RAC
»·¾³ÖÐʵÀýµÄ×÷ÓÃÄܹ»µÃµ½³ä·ÖµÄÌåÏÖ
!
ÏÂÃæ¶ÔʵÀýºÍÊý¾Ý¿â×öÏêϸµÄÚ¹ÊÍ£º
ÔÚ
Oracle
ÁìÓòÖÐÓÐÁ½¸ö´ÊºÜÈÝÒ×»ìÏý£¬Õâ¾ÍÊÇ
“
ʵÀý
”
£¨
instance
£©ºÍ
“
Êý¾Ý¿â
”
£¨
database
£©¡£×÷Ϊ
Oracle
ÊõÓÕâÁ½¸ö´ÊµÄ¶¨ÒåÈçÏ£º
Êý¾Ý¿â
£¨
database
£©£ºÎïÀí²Ù×÷ϵͳÎļþ»ò
´ÅÅÌ
£¨
disk
£©µÄ¼¯ºÏ¡£Ê¹ÓÃ
Oracle 10g
µÄ×Ô¶¯´æ´¢¹ÜÀí£¨
Automatic Storage Management
£¬
ASM
£©»ò
RAW
·ÖÇøÊ±£¬Êý¾Ý¿â¿ÉÄܲ»×÷Ϊ²Ù×÷ϵͳÖе¥¶ÀµÄÎļþ£¬µ«¶¨ÒåÈÔÈ»²»±ä¡£
ʵÀý
£¨
instance
£©£ºÒ»×é
Oracle
ºǫ́½ø³Ì
/
Ïß³ÌÒÔ¼°Ò»¸ö¹²ÏíÄÚ´æÇø£¬ÕâЩÄÚ´æÓÉͬһ¸ö¼ÆËã»úÉÏÔËÐеÄÏß³Ì
/
½ø³ÌËù¹²Ïí¡£ÕâÀï¿ÉÒÔά»¤Ò×ʧµÄ¡¢·Ç³Ö¾ÃÐÔÄÚÈÝ£¨ÓÐЩ¿ÉÒÔË¢ÐÂÊä³öµ½´ÅÅÌ£©¡£¾ÍËãûÓдÅÅÌ´æ´¢£¬Êý¾Ý¿âʵÀýÒ²ÄÜ´æÔÚ¡£Ò²ÐíʵÀý²»ÄÜËãÊÇÊÀ½çÉÏ
Ïà¹ØÎĵµ£º
oracle±í¿Õ¼ä²Ù×÷Ïê½â
1
2
3×÷Õߣº À´Ô´£º ¸üÐÂÈÕÆÚ£º2006-01-04
5
6
7½¨Á¢±í¿Õ¼ä
8
9CREATE TABLESPACE data01
10DATAFILE '/ora ......
ÔÚijЩ³¡ºÏÏ£¬´æ´¢¹ý³Ì»ò´¥·¢Æ÷ÀïµÄSQLÓï¾äÐèÒª¶¯Ì¬Éú³É¡£OracleµÄDBMS_SQL°ü¿ÉÒÔÓÃÀ´Ö´Ðж¯Ì¬SQLÓï¾ä¡£±¾ÎÄͨ¹ýÒ»¸ö¼òµ¥µÄÀý×ÓÀ´Õ¹Ê¾ÈçºÎÀûÓÃDBMS_SQL°üÖ´Ðж¯Ì¬SQLÓï¾ä£º
DECLARE
v_cursor NUMBER;
v_stat NUMBER;
& ......
Ò»£ºsql loader µÄÌØµã
oracle×Ô¼º´øÁ˺ܶàµÄ¹¤¾ß¿ÉÒÔÓÃÀ´½øÐÐÊý¾ÝµÄÇ¨ÒÆ¡¢±¸·ÝºÍ»Ö¸´µÈ¹¤×÷¡£µ«ÊÇÿ¸ö¹¤¾ß¶¼ÓÐ×Ô¼ºµÄÌØµã¡£
±ÈÈç˵expºÍimp¿ÉÒÔ¶ÔÊý¾Ý¿âÖеÄÊý¾Ý½øÐе¼³öºÍµ¼³öµÄ¹¤×÷£¬ÊÇÒ»ÖֺܺõÄÊý¾Ý¿â±¸·ÝºÍ»Ö¸´µÄ¹¤¾ß£¬Òò´ËÖ÷ÒªÓÃÔÚÊý¾Ý¿âµÄÈȱ¸·ÝºÍ»Ö¸´·½Ãæ¡£ÓÐ×ÅËٶȿ죬ʹÓüòµ¥£¬¿ì½ÝµÄÓŵ㣻ͬʱҲÓÐһР......
´ó¼ÒºÃ£¬ÎÒÔÚhttp://download.csdn.net/source/836323ÉÏ·¢µÄÌû×Ó£¬È·ÊµÖ»ÊǸödemo£¬ÆäÌâ¿âÄÚÈݼûÏÂÎÄ£¬´ËΪ×îÐÂÌâ¿âµÄÒ»²¿·Ö£¬Õýʽ°æÌâ¿âÊÇ175Ìâ¡£ÐèÒªÕýʽ°æ±¾µÄÅóÓÑ£¬¿ÉÒÔÖ±½ÓÁªÏµÎÒ»òÕßµ½www.certinside.cn/1z0-051 ÉÏÃæ¿´¿´£¬ÎÒÃǺÍtestinsideÊÇÒ»¼ÒµÄ£¬ÐèÒªµÄ»°ÎÒ¿ÉÒÔ¸øÄã´ò¸öÕÛ£¬¼Û¸ñÔÙÒé¡£ÎÒµÄQQ£º390970748¡¡ ......
DML Error Logging in Oracle 10g
Ö÷ÒªÔÚÓÚʹÓÃDBMS_ERRLOG.create_error_log Õâ¸ö°üÀ´¸ú×Ùdml´íÎóÐÅÏ¢
SQL> CREATE TABLE source (
2 id NUMBER(10) NOT NULL,
3 code VARCHAR2(10),
4 description VARCHAR2(50),
5 CONSTRAINT source_pk PRIMARY KEY (id)
6 );
±íÒÑ´´½¨¡£
SQL> DECLARE
2 TYPE t_tab IS ......