oracleÊÂÎñµÄÖ´Ðйý³Ì
1.¿Í»§¶ËÁ¬½ÓÖÁoralce:
Ê×ÏÈ¿Í»§¶ËÁ¬½ÓÖÁoracleµÄ¼àÌýÆ÷,È»ºó¼àÌýÆ÷·ÖÅäÒ»¸öÊý¾Ý¿âʵÀý(ÕâÀïµÄÊÇʵÀý)¸ø¿Í»§¶Ë,È»ºó¿Í»§¶ËÒÔºó¾ÍÖ±½ÓÓëÕâ¸öÊý¾Ý¿âʵÀý½øÐÐÁ¬½Ó,Ö±ÖÁ¶Ï¿ªÓëoracleµÄÁ¬½Ó.
2.Ìá½»sql:
(1)¿Í»§¶ËÓû§Ìá½»Ò»¸ösqlÖÁoracle·þÎñÆ÷ʵÀý½ø³Ì,oracleÊ×Ïȼì²éÒ»ÏÂsgaµÄ¹²ÏísqlÇøÊÇ·ñÓÐÏàͬ½á¹¹µÄsql,Èç¹ûÓоÍÓÃËüµÄÖ´Ðз¾¶ºÍ×ÊÔ´,Èç¹ûûÓоʹ´½¨sqlµÄÖ´Ðз¾¶Óë×ÊÔ´ºÍÖ´Ðмƻ®,´´½¨Íê³Éºó,½«sqlµÄ½á¹¹·ÅÔÚ¹²ÏíÇø;
(2)ʵÀý½«sqlµÄ¸üвÙ×÷֮ǰµÄÔʼÐÅÏ¢·ÅÖÁ»Ø¹ö¶ÎºÍredo¶Î;
(3)ʵÀýÍê³ÉsqlµÄ¸üвÙ×÷,½«¸üкóµÄÊý¾Ý·ÅÖÁÊý¾Ý»º´æ¶ÎÖÐ;
(4)¿Í»§¶ËÌá½»ÊÂÎñ(commit);
(5)Êý¾Ý¿âʵÀý½«redo¶ÎÖеÄÐÅϢдÈëredoÈÕÖ¾ÎļþÖÐ,Ìá½»Íê³Éºó,Íê³ÉÊÂÎñµÄÌá½»;
(6)¸æËß¿Í»§¶Ë,ÊÂÎñÌá½»Íê³É.(×¢ÒâÕâʱÊý¾Ý¶Î»º´æÖеÄÊý¾Ý²¢Î´Ð´ÈëÊý¾ÝÎļþÖÐ,ʵÀý½ø³Ì»á¶¨Ê±½«Êý¾Ý¶Î»º´æÖеÄÊý¾ÝдÈëÊý¾ÝÎļþÖÐ);
Ïà¹ØÎĵµ£º
ËäȻѧϰJavaºÜ¾ÃÁË£¬×Ô¼ºÒ²Á¬½Ó¹ýһЩÊý¾Ý¿â£¬±ÈÈçmysqlÖ®ÀàµÄ£¬Èç½ñÄØ£¬Ò²Ñ§Ï°ÁËÒ»¶Îʱ¼äµÄOracle£¬È»¶øÄØ£¬½ñÌìÊÇÎÒµÚÒ»´ÎÁ¬½ÓOracle£¬ºÙºÙ£¬Ó¦¸Ã»¹²»ËãÌ«³Ù°É¡£
½ñÌìÄØ£¬Óе㱿׾£¬´ó¼ÒĪЦ£¡
ÎÒÕâÊÇÒ»¸ö²éѯÀý×Ó
Ê×ÏÈ£¬Ô ......
ÏÈroot´ò²¹¶¡£ºp3006854_9204_linux.zip
ÔÙÉèoracle»·¾³±äÁ¿
°²×°
°²×°½áÊø½¨¿â֮ǰÐèÒª´òµÄ²¹¶¡ÓУº
p2617419_220_GENERIC.zip
p3119415_9204_linux.zip
¾ßÌå²Î¿¼ÕâƪÎÄÕ£º
Redhat Enterprise Linux 4°²×°oracle
¹Ø¼ü×Ö: redhat el4 oracle °²×°
Ò». °²×°×¼±¸
1. as4°²×°Íêºó£¬ÐèÒª¼ì²éÏÂÁÐÈí¼þ ......
ORACLEÈÏÖ¤Åàѵ³£¼ûÎÊÌâ
1¡¢ÎÊ£ºÊ²Ã´ÊÇ Oracle ÈÏÖ¤£¿¶¼ÓÐÄÄЩÖÖÀࣿ
¡¡¡¡´ð£ºOracle ÈÏÖ¤ÊÇÓÉOracle¹«Ë¾°ä²¼²¢ÊµÊ©µÄÒ»ÏîÈ¨Í ......
ÓÃtg4mssqlÁ´½Óoracle.
¹ý³Ì²»ÔÚÃèÊö£¬googleºÜ¶à¡£
ÎÊÌ⣺
1¡¢mssql expressµÄʱºò£¬Ê§°Ü
½«serverÓÃתÒå×Ö·ûд³ö£¬³É¹¦¡£
HS_FDS_CONNECT_INFO="SERVER=SHAM0415\\SQLEXPRESS;DATABASE=GMT_KJ"
2¡¢½¨¶à¸öµÄʱºò£¬²»ÄܽâÎö¡£ tnsping ÃüÁî×ܲ»Í¨¹ý¡£
ÕÒÁ˺ܶ࣬ͬһ¸öÌû×Ó£¬×ªÁËÎÞÊý´Î¡£¡£
°¦¡£¡£ÖйúµÄ ......
¼ÙÉèÊý¾Ý¿âµÄÓµÓÐÕßΪoracle£¬Êý¾Ý¿âµÄÓû§Îªscott£¬Æä¿ÚÁîΪtrigger£¬
OracleÊý¾Ý¿âµÄ²ÎÊý$ORACLE_HOMEΪ/usr/oracle£¬$ORACLE_SIDΪoracle1£¬ÔòʵÏÖ²½ÖèÈçÏ£º
1¡¢½¨Á¢ÊµÏÖ±¸·ÝµÄshell
ÔÚ/usr/oracleÖÐÓÃviÃüÁÁ¢Îļþbackup.sh£¬ÆäÄÚÈÝΪ:
ORACLE_HOME=/usr/oracle; <br>export ORACLE_HOME;
ORACLE_SID= ......