Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

MsSQL,MySQL,Oracle,Êý¾Ý¿âÁ¬½Ó×Ö¶Î

Ms sql 2000
drivername=com.microsoft.jdbc.sqlserver.SQLServerDriver
url=jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=books
username=sa
password=sa
MySQL
drivername=com.mysql.jdbc.Driver
url=jdbc:mysql://localhost/books
username=root
password=root
Oracle
drivername=oracle.jdbc.driver.OracleDriver
url=jdbc:oracle:thin:@localhost:1521:orcl
Username=root
Password=root


Ïà¹ØÎĵµ£º

oracle 10g undo±í¿Õ¼äʹÓÃÂʾӸ߲»ÏÂbug

¶ÔÓÚUNDO
±í¿Õ¼ä´óСµÄ¶¨ÒåÐèÒª¿¼ÂÇUNDO_RETNETION
²ÎÊý¡¢²úÉúµÄUNDO BLOCKS/
Ãë¡¢UNDO BLOCK
µÄ´óС¡£undo_retention
£º¶ÔÓÚUNDO
±í¿Õ¼äµÄÊý¾ÝÎļþÊôÐÔΪautoextensible,
Ôòundo_retenion
²ÎÊý±ØÐëÉèÖã¬UNDO
ÐÅÏ¢½«ÖÁÉÙ±£ÁôÖÁundo_retention
²ÎÊýÉ趨µÄÖµÄÚ£¬µ«UNDO
±í¿Õ¼ä½«»á×Ô¶¯À©Õ¹¡£¶ÔÓڹ̶¨UNDO
±í¿Õ¼ä ......

ÔÚ Windows Éϰ²×° Oracle Êý¾Ý¿â 11g

 
ÔÚ Windows Éϰ²×° Oracle Êý¾Ý¿â 11g
°²×°Oracle Èí¼þ£¬±ØÐëʹÓà Oracle Universal Installer¡£
1.ÔÚÕâÒ»°²×°ÖУ¬ÄúÐèҪʹÓà DVD »òÏÂÔØ DVD °æ±¾¡£ÔÚ±¾½Ì³ÌÖУ¬½«´ÓÒÑÏÂÔØµÄ°æ±¾½øÐа²×°¡£ÔÚ½âѹËõ DVD ÎļþµÄĿ¼ÖУ¬´ò¿ª Windows ×ÊÔ´ä¯ÀÀÆ÷²¢Ë«»÷ \db\Disk1 Ŀ¼µÄ setup.exe¡£
2.°²×°µÄ²úƷΪ Oracle Da ......

ÈçºÎÊÖ¹¤´´½¨OracleÊý¾Ý¿â

ÈçºÎÊÖ¹¤´´½¨OracleÊý¾Ý¿â
http://www.cnhacker.com/Security/System/200808/t20080818_6325.html
½ñÌ죬ÎÒÔÚ²âÊÔ»úÆ÷ÉÏÀ´Á˸öÎó²Ù×÷rm * backup/*,°ÑÕýÔÚÔËÐеÄÊý¾Ý¿âÖеÄÊý¾ÝÎļþÈ«²¿É¾³ýÁË£¬ÕæÊÇÓôÃÆ!»¹ºÃÕâ¸öÊǸøÎÒÃÇÐÂÈËÃDzâÊÔÍæµÄ£¬Òª²»È»¾ÍËÀ¶¨ÁË!ÔÚ´ËÒ²×öÒ»¸öÌáÐÑ£¬ÉíΪDBA£¬ÒªÓÀÔ¶¼ÇסʲôÉ÷ÓûòÕß½ûֹʹÓÃrmÃüÁ ......

Oracle¹éµµÃüÁî£¨×ªÔØ£©

Ê×ÏȲ鿴Êý¾Ý¿âÏÖÓÐģʽ¿ÉʹÓÃÒÔÏÂÓï¾ä
select name,log_mode from v$database;
Ò²¿ÉÒÔÓÃÏÂÃæµÄÓï¾ä
archive log list£»(¸Ã·½·¨ÐèÒªas sysdba)
¶ÔÓڷǹ鵵ģʽµÄÊý¾Ý¿â¸ÃΪ¹éµµÄ£Ê½£¨Ö÷ÒªÒÔOracle 10gΪ²Î¿¼£©Ê¹ÓÃÒÔϲ½Ö裺
1. SQL> alter system set log_archive_dest_1='location=/oracle/oracle10g/log/archive ......

mysql 5.0 ¼¯Èº¸ºÔؾùºâ—¾­¹ý²âÊÔ


×ªÔØÇë×¢Ã÷×÷Õߺͳö´¦
http://www.cnlinux.net
Ò»¡¢½éÉÜ
========
²âÊÔ»·¾³£º
Server1:ndbd 192.168.0.11
Server2:ndbd 192.168.0.12
Server3:mysqld --ndb-cluster 192.168.0.13 (ndbd_mgm ndbd_mgmdÒ²ÔÚ±¾»ú)
²Ù×÷ϵͳ¾ùΪ
RH ES3
kernel-2.4.21-9.EL
glibc-2.3.2-95.6
ËùÐèÈí¼þ°ü£º
mysql-max-5.0.22-lin ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ