oracle¼òµ¥stream Ò»¸öÓû§µ¥Ïò¸´ÖÆÅäÖÃ
ÒÔÏÂÎÒ×östreammͬ²½Á½Ì¨»úÆ÷¼äµÄijһ¸öÓû§µÄ²Ù×÷²½Öè¡£ºÜ¼òµ¥,¿´µ½stream
»¹
ÓкܶàÒª¿´µÄ¡£
1.»·¾³½éÉÜ
Ö÷Êý¾Ý¿âSID : obpm
²Ù×÷ϵͳ : win 2003
IPµØÖ· : 192.168.0.1
Global_name :
oracle
version: 10.2.0.1
´ÓÊý¾Ý¿âSID: orcl
²Ù×÷ϵͳ : win 2003
IPµØÖ· : 192.168.0.2
Global_name :
oracle
version: 10.2.0.1
2.ÔÚÖ÷/´ÓÊý¾Ý¿âÉèÖóõʼ»¯²ÎÊý(ÔÚÖ÷´ÓÊý¾Ý¿â¶¼Ö´ÐÐÒÔϲÙ×÷)
1) sqlplus / as sysdba ----ÒÔdbaÉí·ÝµÇ¼
2)alter system set aq_tm_processes=2 scope=both; ---ÆôÓöԶÓÁÐÏûÏ¢µÄʱ¼ä¼àÊÓ
¡¡¡¡alter system set global_names=true scope=both; ---ÉèÖÃÈ«¾ÖÃû³ÆÎªtrue
¡¡¡¡---alter system set job_queue_processes=10 scope=both;
--ÉèÖö¨Ê±×÷Òµ½ø³Ì×î´óΪ10¸ö,ĬÈÏÊÇ10
¡¡¡¡alter system set undo_retention=3600 scope=both;
--ÉèÖûعö¶Îʱ¼ä,ĬÈÏÊÇ900
alter system set streams_pool_size=25M scope=spfile;
--sgaÉèÖÃΪ×Ô¶¯µ÷ÕûÇé¿öϲ»ÐèÉèÖøòÎÊý
3)ÖØÆô¶¯Á½¸öÊý¾Ý¿â
3.ÉèÖÃÖ÷Êý¾Ý¿âΪ¹éµµmode
1)archive log list; --²éÊÇ·ñ¹éµµ,ÈçÊǹ鵵,ÇëºöÂÔµÚ3µã
2)shutdown immediate;
startup mount;
alter database archivelog;
alter system set LOG_ARCHIVE_DEST_1='LOCATION=D:\arc\';
---ÉèÖù鵵Ŀ¼
alter system switch logfile; --ÏàӦĿ¼¼ì²éÊÇ·ñÉú³ÉarcÎļþ
alter database open;
4.Ö÷/´ÓÊý¾Ýн¨stream
¹ÜÀíÓû§(ÔÚÖ÷´ÓÊý¾Ý¿â¶¼Ö´ÐÐÒÔϲÙ×÷)
1)sqlplus / as sysdba;
2)create tablespace tbs_stream datafile 'E:\tbs_stream01.dbf' size
100m autoextend on maxsize unlimited segment space management auto;
---´´½¨Ö÷»·¾³µÄStream
רÓñí¿Õ¼ä
3)execute dbms_logmnr_d.set_tablespace('tbs_stream');
--½«logminerµÄÊý¾Ý×Öµä´Ósystem±í¿Õ¼ä×ªÒÆµ½Ð½¨µÄ±í¿Õ¼ä£¬·ÀÖ¹³ÅÂúsystem±í¿Õ¼ä
4)create user strmadmin identified by strmadmin default tablespace
tbs
Ïà¹ØÎĵµ£º
alter session set nls_sort='schinese_pinyin_m';
select * from dept order by
nlssort(name,'NLS_SORT=SCHINESE_PINYIN_M');
Oracle9i֮ǰ£¬ÖÐÎÄÊǰ´ÕÕ¶þ½øÖƱàÂë½øÐÐÅÅÐòµÄ¡£
ÔÚoracle9iÖÐÐÂÔöÁ˰´ÕÕÆ´Òô¡¢²¿Êס¢±Ê»
ÅÅÐò¹¦ÄÜ¡£ÉèÖÃNLS_SORTÖµ
SCHINESE_RADICAL_M °´ÕÕ²¿Ê×£¨µÚһ˳Ðò£©¡¢±Ê»®£¨µÚ¶þ˳Ðò£©Å ......
ÓÐʱºò£¬ÐèÒªÔÚÁ½¸öOracleÊý¾Ý¿âÖ®¼äÊÖ¹¤Í¬²½Êý¾Ýʱ£¬DBLinkÊÇ×î·½±ã¿ì½ÝµÄÊÖ¶ÎÖ®Ò»£¬´´½¨DBLinkµÄ·½Ê½Ò»°ãÊÇÕâÑù£º
create public database link <DBLinkÃû³Æ> connect to <±»Á¬½Ó¿âµÄÓû§Ãû> identified by <±»Á¬½Ó¿âµÄÃÜÂë> using '< ......
OracleÊý¾Ýµ¼Èëµ¼³öimp/exp¾ÍÏ൱ÓÚoracleÊý¾Ý»¹ÔÓ뱸·Ý¡£expÃüÁî¿ÉÒÔ°ÑÊý¾Ý´ÓÔ¶³ÌÊý¾Ý¿â·þÎñÆ÷µ¼³öµ½±¾µØµÄdmpÎļþ£¬impÃüÁî¿ÉÒÔ°ÑdmpÎļþ´Ó±¾µØµ¼Èëµ½Ô¶´¦µÄÊý¾Ý¿â·þÎñÆ÷ÖС£ ÀûÓÃÕâ¸ö¹¦ÄÜ¿ÉÒÔ¹¹½¨Á½¸öÏàͬµÄÊý¾Ý¿â£¬Ò»¸öÓÃÀ´²âÊÔ£¬Ò»¸öÓÃÀ´ÕýʽʹÓá£
Ö´Ðл·¾³£º¿ÉÒÔÔÚSQLPLUS.EXE»òÕßDOS£¨ÃüÁîÐУ©ÖÐÖ´ÐУ¬
......
ÔÚÖ´ÐÐÆô¶¯¹Ø±ÕÃüÁî֮ǰÐèÒªÕýÈ·ÉèÖÃÏÂÁл·¾³±äÁ¿£º
ORACLE_BASE
ORACLE_HOME °²×°¹ý³ÌÖÐÏÔʾµÄoracle home Ŀ¼
ORACLE_SID
PATH=$PAHT£º$ORACLE_HOME/bin
ÒÔ oracle Õ˺ŵǽ Linux£¬»òÕß´Ó root ÏÂÊäÈë su - or ......
Oracle Database 10g Release 2 (10.2.0.1.0) Enterprise/Standard Edition for Microsoft Windows (32-bit)
http://download.oracle.com/otn/nt/oracle10g/10201/10201_database_win32.zip
http://download.oracle.com/otn/nt/oracle10g/10201/10201_client_win32.zip
http://download.oracle.com/otn/nt/oracle10g/10 ......