OracleÉó¼Æ¹¦ÄÜ
OracleÉó¼Æ¹¦ÄÜ
Ò»¡¢ Éó¼Æ·ÖÀࣺ
OracleÖÐÉó¼Æ×ÜÌåÉÏ¿É·ÖΪ“±ê×¼Éó¼Æ”ºÍ“ϸÁ£¶ÈÉó¼Æ”ºóÕßÒ²³ÆΪ“»ùÓÚÕþ²ßµÄÉó¼Æ”£¬ÔÚOracle10GÖ®ºó¹¦Äܵõ½ºÜ´óÔöÇ¿¡£ÆäÖбê×¼Éó¼Æ¿É·ÖΪÓû§¼¶Éó¼ÆºÍϵͳ¼¶Éó¼Æ¡£Óû§¼¶Éó¼ÆÊÇÈκÎOracleÓû§¿ÉÉèÖõÄÉó¼Æ£¬Ö÷ÒªÊÇÓû§Õë¶Ô×Ô¼º´´½¨µÄÊý¾Ý¿â±í»òÊÓͼ½øÐÐÉó¼Æ£¬¼Ç¼ËùÓÐÓû§¶ÔÕâЩ±í»òÊÓͼµÄÒ»Çгɹ¦ºÍ(»ò)²»³É¹¦µÄ·ÃÎÊÒªÇóÒÔ¼°¸÷ÖÖÀàÐ͵ÄSQL²Ù×÷¡£ÏµÍ³¼¶Éó¼ÆÖ»ÄÜÓÉDBAÉèÖã¬ÓÃÒÔ¼à²â³É¹¦»òʧ°ÜµÄµÇ¼ҪÇó¡¢¼à²âGRANTºÍREVOKE²Ù×÷ÒÔ¼°ÆäËûÊý¾Ý¿â¼¶È¨ÏÞϵIJÙ×÷¡£
¶þ¡¢ ±ê×¼Éó¼Æ£º
2.1 ·ÖÀࣺ
ÔÚORACLEÖзֱðÖ§³ÖÒÔÏÂÈýÖÖ±ê×¼Éó¼ÆÀàÐÍ£º
u Óï¾äÉó¼Æ£¬¶ÔijÖÖÀàÐ͵ÄSQLÓï¾äÉó¼Æ£¬²»Ö¸¶¨½á¹¹»ò¶ÔÏó¡£
u ÌØȨÉó¼Æ£¬¶ÔÖ´ÐÐÏàÓ¦¶¯×÷µÄϵͳÌØȨµÄʹÓÃÉó¼Æ¡£
u ¶ÔÏóÉó¼Æ£¬¶ÔÒ»ÌØÊâģʽ¶ÔÏóÉϵÄÖ¸¶¨Óï¾äµÄÉó¼Æ¡£
ÕâÈýÖÖ±ê×¼Éó¼ÆÀàÐÍ·Ö±ð¶ÔÈçÏÂ3·½Ãæ½øÐÐÉó¼Æ£º
u Éó¼ÆÓï¾äµÄ³É¹¦Ö´ÐС¢²»³É¹¦Ö´ÐУ¬»òÕßÆäÁ½Õß¡£
u ¶ÔÿһÓû§»á»°Éó¼ÆÓï¾äÖ´ÐÐÒ»´Î»òÕ߶ÔÓï¾äÿ´ÎÖ´ÐÐÉó¼ÆÒ»´Î¡£
u ¶ÔÈ«²¿Óû§»òÖ¸¶¨Óû§µÄ»î¶¯µÄÉó¼Æ¡£
µ±Êý¾Ý¿âµÄÉó¼Æ¹¦ÄÜ´ò¿ªºó£¬ÔÚÓï¾äÖ´Ðн׶βúÉúÉó¼Æ¼Ç¼¡£Éó¼Æ¼Ç¼°üº¬ÓÐÉó¼ÆµÄ²Ù×÷¡¢Óû§Ö´ÐеIJÙ×÷¡¢²Ù×÷µÄÈÕÆÚºÍʱ¼äµÈÐÅÏ¢¡£Éó¼Æ¼Ç¼¿É´æÔÚÊý¾Ý×Öµä±í£¨³ÆΪÉó¼Æ¼Ç¼£©»ò²Ù×÷ϵͳÉó¼Æ¼Ç¼ÖС£Êý¾Ý¿âÉó¼Æ¼Ç¼ÊÇÔÚSYSģʽµÄAUD$±íÖС£
2.2ÉèÖÃORACLE±ê×¼Éó¼Æ£º
ÏÂÁв½Öè¿ÉÒÔÉèÖÃORACLEµÄ±ê×¼Éó¼Æ¹¦ÄÜ£º
1. Ð޸ijõʼ»¯²ÎÊýÎļþ£¨init<sid>.ora£©
Èç¹ûʹÓ÷þÎñÆ÷²ÎÊýÎļþʹÓÃalter system set <parameter>=<value> scope=spfile|both£¬ÏêÇé²ÎÕÕ1.1½ÚÖйØÓÚ²ÎÊýÎļþµÄ½éÉÜ£©£¬ÉèÖà AUDIT_TRAIL²ÎÊý£¬²¢ÇÒÖØÆôÊý¾Ý¿â¡£AUDIT_TRAILµÄÈ¡ÖµÈçÏ£º
l DB/TRUE£ºÆô¶¯Éó¼Æ¹¦ÄÜ£¬²¢ÇÒ°ÑÉó¼Æ½á¹û´æ·ÅÔÚÊý¾Ý¿âµÄ SYS.AUD$ ±íÖÐ
l &nb
Ïà¹ØÎĵµ£º
¿ÉǨÒƱí¿Õ¼ätransport tablespace
¿ÉǨÒƱí¿Õ¼ä
ʹÓÿÉǨÒƱí¿Õ¼ä(Transportable Tablespaces)µÄÌØÐÔÔÚÊý¾Ý¿âÖ®¼äÒƶ¯´óÁ¿Êý¾Ý£¬ÐÔÄܱÈexport/importºÍunload/loadÒª¿ìºÜ¶à£¬ÒòΪËüǨÒƱí¿Õ¼äÖ»ÐèÒª¸´ÖÆÊý¾ÝÎļþºÍ²åÈë±í¿Õ¼äÔªÊý¾Ýµ½Ä¿±êÊý¾Ý¿âÖС£
ǨÒƱí¿Õ¼ä¶ÔÒÔÏÂÓ¦ÓÃÌرðÓÐÓãº
·Ö½×¶Î½«OLTPµÄÊý¾ÝÒÆÈëÊý¾Ý²Ö¿â
¸ ......
ΪÁË×öÐéÄâ»ú£¬ÐèÒª½«·þÎñÆ÷ÉϵÄ11gµÄÓû§µÄÍêÕûÊý¾Ýµ¼³öÀ´¡£¶øÐéÄâ»úÉϵÄoracle10gµÄ£¬Ö±½Óµ¼³öÀ´£¬ÎÞ·¨µ¼Èëµ½ÐéÄâ»ú¡£
ËùÒÔ£¬ÊÔ×ÅÓÃ10gµÄ¿Í»§¶ËÀ´µ¼³öÊý¾Ý£¬
ÓÃÃüÁî:exp exoa/*****@exoa1 file=20100526.dmp grants=y full=y
Ö´Ðкó£¬ÏµÍ³Ìáʾ£º
EXP-00008:Óöµ½ ORACLE´íÎó1406
&nb ......
ÔÚoracleÖУ¬ÎÒÃÇ´´½¨Ò»¸öÖ÷¼ü£¬Ôòͬʱ×Ô¶¯´´½¨ÁËÒ»¸öͬÃûµÄΨһË÷Òý£»É¾³ýÖ÷¼ü£¬ÔòÖ÷¼üÔ¼ÊøºÍ¶ÔÓ¦µÄΨһË÷Òý¶¼É¾³ýÁË¡£ÕâÊÇÎÒÃǾ³£¼ûµ½µÄÏÖÏó¡£
·¢³öÒ»¸ö´´½¨Ö÷¼üµÄsql£¬oracleÆäʵִÐÐÁËÁ½²½£º´´½¨Ö÷¼üÔ¼Êø¡¢´´½¨/¹ØÁª ΨһË÷Òý¡£²½ÖèÊÇÕâÑùµÄ£º
´´½¨Ö÷¼üÔ¼Êøʱ£¬¼ì²é¸ÃÖ÷¼ü×Ö¶ÎÉÏÊÇ·ñÒѾ´æÔÚΨһË÷Òý¡£Èô² ......
Õâ¶Îʱ¼äΪ¹«Ë¾ÄÚ²¿µÄÊý¾Ý´¦Àí¿ª·¢ÁËÒ»¸ö¹¤¾ß£¬Ç£Éæµ½ÔÚOracleÖм¯³ÉjavaÓ¦Óã¬×ܽáÁËһЩ¾Ñ飬ÒÔ¹©´ó¼Ò²Î¿¼ÁË£¡
³ÌÐò·ÖÁ½²¿·Ö£¬Ç°¶Ë½çÃæÓÉVB/VC¿ª·¢£¬Ö÷ҪʵÏÖÊý¾Ý´¦ÀíÅäÖü°³£¹æ¼Ç¼ÔËË㣬Õⲿ·ÖûÓÐʲôºÃ˵µÄÁË¡£
ºǫ́ÒÔOracleΪÊý¾Ý»ù´¡´¦ÀíÍйÜƽ̨£¬ÔÚÊý¾Ý´¦Àí¹ý³ÌÖУ¬ÐèÒª¶ÔһЩÃû³Æ¡¢µØַʲôµÄ½øÐÐÕªÒªÌáÈ¡¡¢² ......
create or replace and compile java source named md5util as
import java.security.MessageDigest;
public class MD5Util
{
public static String encrypt(String s)
{
char hexDigits[] = {'0', '1', '2', '3', '4', '5', '6', '7', '8', '9', 'a', 'b', 'c', ......