ÔÚÒ»¸ö¸ß¿ÉÓÃϵͳÖУ¬Èç¹ûÐèÒª¸Ä±äÒ»¸ö±íµÄ¶¨ÒåÊÇÒ»¼þ±È½Ï¼¬ÊÖµÄÎÊÌ⣬ÓÈÆäÊǶÔ
ÓÚ7×24ϵͳ¡£OracleÌṩµÄ»ù±¾Óï·¨»ù±¾¿ÉÒÔÂú×ãÒ»°ãÐÔÐ޸쬵«ÊǶÔÓÚ°ÑÆÕͨ¶Ñ±í¸ÄΪ·ÖÇø±í£¬°ÑË÷Òý×éÖ¯±íÐÞ¸ÄΪ¶Ñ±íµÈ²Ù×÷¾ÍÎÞ·¨Íê³ÉÁË¡£¶øÇÒ£¬
¶ÔÓÚ±»´óÁ¿DMLÓï¾ä·ÃÎÊµÄ±í£¬ÐÒÔ˵ÄÊÇ£¬Oracle´Ó9i°æ±¾¿ªÊ¼ÌṩÁËÔÚÏßÖØ¶¨Òå±í¹¦ÄÜ£¬Í¨¹ýµ÷ÓÃDBMS_REDEFINITION°ü£¬¿ÉÒÔÔÚÐÞ
¸Ä±í½á¹¹µÄͬʱÔÊÐíDML²Ù×÷¡£
ÔÚÏßÖØ¶¨Òå±í¾ßÓÐÒÔϹ¦ÄÜ£º
Ð޸ıíµÄ´æ´¢²ÎÊý£»
¿ÉÒÔ½«±í×ªÒÆµ½ÆäËû±í¿Õ¼ä£»
Ôö¼Ó²¢ÐвéѯѡÏ
Ôö¼Ó»òɾ³ý·ÖÇø£»
ÖØ½¨±íÒÔ¼õÉÙË鯬£»
½«¶Ñ±í¸ÄΪË÷Òý×éÖ¯±í»òÏà·´µÄ²Ù×÷£»
Ôö¼Ó»òɾ³ýÒ»¸öÁС£
µ÷ÓÃDBMS_REDEFINITION°üÐèÒªEXECUTE_CATALOG_ROLE½ÇÉ«£¬³ý´ËÖ®Í⣬»¹ÐèÒªCREATE ANY
TABLE¡¢ALTER ANY TABLE¡¢DROP ANY TABLE¡¢LOCK ANY TABLEºÍSELECT ANY
TABLEµÄȨÏÞ¡£
ÔÚÏßÖØ¶¨Òå±íµÄ²½ÖèÈçÏ£º
1.Ñ¡ÔñÒ»ÖÖÖØ¶¨Òå·½·¨£º
´æÔÚÁ½ÖÖÖØ¶¨Òå·½·¨£¬Ò»ÖÖÊÇ»ùÓÚÖ÷¼ü¡¢ÁíÒ»ÖÖÊÇ»ùÓÚROWID¡£ROWIDµÄ·½Ê½²»ÄÜÓÃÓÚË÷Òý×éÖ¯±í£¬¶øÇÒÖØ¶¨Òåºó»á´æÔÚÒþ²ØÁÐM_ROW$$¡£Ä¬ÈϲÉÓÃÖ÷¼üµÄ·½Ê½¡£
2.µ÷ÓÃDBMS_REDEFINITION.CAN_REDEF_TABLE()¹ý³Ì£¬Èç¹û±í²»Âú×ãÖØ¶¨ÒåµÄÌõ¼þ£¬½« ......
OracleÒì³£·ÖΪ3ÖÖ:
(1)Ô¤¶¨ÒåÒì³£:no_data_foundµÈ,ÊÇOracleϵͳ¶¨ÒåµÄÒì³£.
declare
s_test varchar2
begin
select id into s_test from test; --´Ëʱtest±íÎÞÊý¾Ý
exception
when no_data_found then
raise_application_error(-20001, 'ûÓÐÊý¾Ý');
end;
(2)×Ô¶¨ÒåÒì³£:×Ô¼º¶¨ÒåµÄÒì³£,×Ô¼ºÅ×,×Ô¼º²¶»ñ.
declare
exp_test exception;
begin
if 1 = 1 then
raise exp_test;
end if;
exception
when exp_test then
raise_application_error(-20002, '×Ô¶¨ÒåÒì³£');
end;
(3)·ÇÔ¤¶¨ÒåÒì³£.
--Õâ¸öÀý×ӾͲ»ÐèÒª×Ô¼ºÅ×,ÒòΪÒѾ°ÑÖ÷¼ü³åÍ»µÄÒì³£¸ø¸²¸ÇÁË,ËùÒÔÖ»ÒªÊÇÖ÷¼ü³åÍ»,ÄÇô¾ÍÊÇexp_testÀ´´úÌæÒÔǰÄǸöÁË.
declare
exp_test exception;
progam exception_init(exp_test ,-1); --¸²¸Ç-1Õâ¸öÒì³£,-1´ú±íÖ÷¼ü³åÍ»
begin
insert into test values('1'); --test±íµÄÖ÷¼ü´æÔÚ1Õâ¸öÖµ.
exception
when exp_test then
raise_application_error(-20003, 'Ö÷¼ü³åÍ ......
ÒòΪÃ÷°Ú×ŵÄÔµ¹Ê£¬10.2Òý³öµÄTDEЧÄܶÔÁмÓÃÜÒÔºó£¬ÕÐÖÂÏà¸ÉĿ¼ɥʧÁ˶Բ»µÈʽµÄÅжÏÄÜÁ¦¡£
鍫룼
ENCRYPTIONDEMO@fmw//scripts> create table tde_table(id number encrypt no salt,na
me varchar¶þ(30))
¶þ ;
Table created.
Elapsed: 00:00:00.11
ENCRYPTIONDEMO@fmw//scripts> begin
¶þ for i in 1..20000 loop
Èý insert into tde_table values (i,i);
ËÄ end loop;
Îå commit;
Áù end;
Æß /
PL/SQL procedure successfully completed.
ENCRYPTIONDEMO@fmw//scripts> create unique index tde_idx on tde_table(id);
Index created.
µÈʽÅжϵ±È»Ã»Êܵ½Ó°Ïì¡£
ENCRYPTIONDEMO@fmw//scripts> select * from tde_table where id=¾Å;
Elapsed: 00:00:00.00
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time
| Áã | SELECT STATEMENT | | Ò» | 64 | Ò» (Áã)| 00:00:01 |
| Ò» | TABLE ACCESS BY INDEX ROWID| TDE_TABLE | Ò» | 64 | Ò» (Áã)| 00:00:01 |
|* ¶þ | INDEX UNIQUE SCAN | TDE_IDX | Ò» | | Ò» (Áã)| 00:00:01 |
²»µÈʽ¾Í¾½ÆÈÁË¡£
ENCRYPTIONDEMO@fmw//scripts> select * from tde_table where id<¶þ; ......
WebspereÅ䱸Oracle RAC¼¯ÈºÊý¾ÝÔ´£¬OracleË«»úµÄIPΪ10.10.10.121Óë10.10.10.122 £¬·¶ÀýÃûλ±ðΪorclÒ»Óëorcl¶þ£¬·þÎñÃû½Ðoracledbservice£¬²ÉÈ¡Áª½Ó´®Ó¦Îª£º
jdbc:oracle:thin:@(description=(ADDRESS_LIST=(ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.10.121)(PORT = 1521))(ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.10.122)(PORT = 1521)))(FAILOVER=yes)(LOAD_BALANCE=yes)(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = oracledbservice)))
²âÊÔµÄʱ·Ö£¬ÓÐʱºò˳Àû£¬ÓÐʱºòʧ°Ü£¬±¨Èç´Î´í´¦£º
java.sql.SQLException: Io Òì³£: The Network Adapter could not establish the connectionDSRA0010E: SQL ״̬ = null£¬´íÎó´úÂë = 17,002 ¶øÊ§°Ü¡£
½â¾ö°ì·¨£º
Åú¸Ä·þÎñÆ÷µÄhosts×ÊÁÏ£¬¼ÓÈëIPµØÖ·Óë·þÎñÆ÷Ãû¶ÔÓ¦¹ØÏµ£¬Èç´Î£º
127.0.0.1 localhost
10.10.10.121 orclÒ»
10.10.10.122 orcl¶þ
Ô¸åhttp://diysnoopy.javaeye.com/blog/471054
WebspereÅ䱸Oracle RAC¼¯ÈºÊý¾ÝÔ´µÄÎÊÌâ
WebspereÅ䱸Oracle RAC¼¯ÈºÊý¾ÝÔ´£¬OracleË«»úµÄIPΪ10.10.10.121Óë10.10.10.122 £¬·¶ÀýÃûλ±ðΪorclÒ»Óëorcl¶þ£¬·þÎñÃû½Ðoracledbservice£¬²ÉÈ¡Áª½Ó´®Ó¦Îª£º
jdbc:oracle:t ......
Ò».ÔÚWEBLOGICÉÏÅ䱸ÁËÒ»¸ö¶à³Ø£¬ÀûÓÃWEBLOGICÌṩµÄ¸ººÉ¾ùºâıÂÔ£¬½«²¢·¢¾ùºâµÄ¾÷±ðµ½Á½¸ö½ÚµãÉÏ¡£ÏêϸÅ䱸ÔÚÈç´Î²Î¿¼×ÊÁÏ»ò¸½¼þÖС£
²Î¿¼×ÊÁÏ:http://www.oracle.com/technology/products/weblogic/howto/rac/index.html
¶þ.Ö±½ÓÊ©ÓÃÁËRACµÄÔØºÉ¾ùºâ¶Ô²ß¡£
ÔÚOracleÖÐÕÒ³ötnsnames.oraÕâ¸ö×ÊÁÏ¡£ÔÚÅ䱸Êý¾ÝԴʱ£¬URLÅú¸ÄΪÈç´Î
jdbc:oracle:thin:@(description=(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = 10.11.1.159)(PORT = 1521))(ADDRESS = (PROTOCOL = TCP)(HOST = 10.11.1.158)(PORT = 1521))(load_balance=yes)(failover=yes))(connect_data=(service_name= racdb)(instance_name=racdbÒ»)(instance_name=racdb¶þ)))
Ô¸åhttp://jbossweek.javaeye.com/blog/138932
http://jbossweek.javaeye.com/blog/138932
±¾ÎÄÀ´Ô´£º
ÎÒµÄÒì³£Íø
Java Exception
Dotnet Exception
Oracle Exception
1290 - 1335 _3382_rtl_x86_chs_bin.cabËð»µ
1291 - δÄÜ´ò¿ª
1292 - return³öÏÖÒì³£
1293 - ¶ÔtmpÎļþÎÞдȨÏÞ»òÊÇtmpϵĿռ䲻µÃÉÙÓÚ60M
1294 - ORA-00445: background process 'PMON ' did not start after 120 seconds
1295 - ÅÉÉúÀàµÄ¹ ......
--1²é¿´±í¿Õ¼äÒѾʹÓõİٷֱÈ
select a.tablespace_name,a.bytes/1024/1024
"Sum MB",(a.bytes-b.bytes)/1024/1024 "used MB",b.bytes/1024/1024
"free MB",round(((a.bytes-b.bytes)/a.bytes)*100,2) "percent_used"
from
(select tablespace_name,sum(bytes) bytes from dba_data_files group by tablespace_name) a,
(select tablespace_name,sum(bytes) bytes,max(bytes) largest from dba_free_space group by tablespace_name) b
where a.tablespace_name=b.tablespace_name
order by ((a.bytes-b.bytes)/a.bytes) desc
“Sum MB”±íʾ±í¿Õ¼äËùÓеÄÊý¾ÝÎļþ×ܹ²ÔÚ²Ù×÷ϵͳռÓôÅÅ̿ռäµÄ´óС
±ÈÈ磺test±í¿Õ¼äÓÐ2¸öÊý¾ÝÎļþ£¬datafile1Ϊ300MB£¬datafile2Ϊ400MB£¬ÄÇôtest±í¿Õ¼äµÄ“Sum MB”¾ÍÊÇ700MB
“userd MB”±íʾ±í¿Õ¼äÒѾʹÓÃÁ˶àÉÙ
“free MB”±íʾ±í¿Õ¼äÊ£Óà¶àÉÙ
“percent_user”±íʾÒѾʹÓõİٷֱÈ
--2±ÈÈç´Ó1Öв鿴µ½MLOG_NORM_SPACE±í ......