oracleѧϰÃÔ»ó
ÎÒÊÇÒ»¸öJava³ÌÐòÔ±£¬×öÁËÁ½ÈýÄêÁË£¬ÏÖÔÚÕýºÃÓÃoracle±È½Ï¶à£¬Ïë
¶àѧѧoracle¡£µ«ÊÇ£¬ÎÒÓÖ²»ÊÇDBAÖ®ÀàµÄÖ±½ÓºÍoracleÌìÌìÅÝÔÚÒ»ÆðµÄ£¬
µ£ÐÄѧÆðÀ´µÄ»°£¬ÓкܶàÌõ¼þ²»ÄÜÔÊÐí¡£
ÎÒÖ»ÄÜÔÚ×Ô¼º»úÆ÷ÉÏ×°ÉÏoracle·þÎñÆ÷À´Ñ§Ï°£¬µ«±¾»úȷʵ²»ÄÜÈݵÄÏÂ
Õâ¸öÅÓ´óµÄ¶«Î÷¡£Èç¹ûÕæµÄÖ»ÊÇÔÚÎҵĵçÄÔÉÏÀ´Ñ§Ï°µÄ»°£¬²»ÖªµÀÄÜѧµ½
ʲôµØ²½£¬ÈçºÎ²ÅÄÜÀ©Õ¹×Ô¼ºµÄ֪ʶ¡£
Ò²²»ÖªµÀÕâôѧ£¬ÄÜ·ñ¶Ô×Ô¼ºµÄoracleÕæÊÇÓкõİïÖú¡£
¸Ð¾õÎÒÏÖÔÚѧoracle£¬¸ü¶àµÄÊÇÔÚ¹Ø×¢sqlÓï¾ä£¨È·Êµ²»Ôõô»áÓã©£¬µ½
µ×ѧϰoracleÊÇÓÐÄÄЩ´óµÄ·½ÃæÊÇÒª¹Ø×¢µÄ£¬È»ºóÈç¹ûҪϸ»¯µÄ»°£¬¸ÃÔõô
¸ãÄØ¡£
ÏÈ¿´¿´»ù±¾µÄÎĵµ£¬´òºÃ»ù´¡¡£
³ýÁËSQL/PLSQL£¬ORACLE»¹ÓкܶණÎ÷¡£¿´ÄãÏëÏòÄÄ·½Ãæ·¢Õ¹ÁË¡£
Èç¹ûÏë×öDBA£¬°²×°/ÅäÖᢱ¸·Ý/»Ö¸´£¬ÐÔÄܵ÷Õû£¬¶¼ÊDZØÐëµÄ£¡
Ò»¸öORACLE DBMS+Ò»¸öѧϰÊý¾Ý¿â£¬Ö»ÒªÊý¾ÝÁ¿²»´ó£¬²»»á³¬¹ý10G£¬ÏÖÔÚµÄÓ²ÅÌ£¬×ã¹»ÁË¡£
²»ÖªµÀÓÐÄÄЩºÃÊéÖµµÃÍÆ¼öÄØ¡£
Áí£ºÒ»Ì¨µçÄÔÖ÷»ú¿ÉÒÔÓжà¸öÈ«¾ÖÊý¾Ý¿âÂð£¿
ORACLEµÄÎĵµ£¬¾ÍÊÇ×îºÃµÄÊé¡£µ±È»£¬ÊÇÓ¢Îĵġ£
Áí£ºÒ»Ì¨µçÄÔÖ÷»ú¿ÉÒÔÓжà¸öÈ«¾ÖÊý¾Ý¿âÂð£¿
·Ç³£¿ÉÒÔ£¡
ÕâÖÖ°ïÖúÎĵµÊDZ¾»ú°²×°µÄʱºò¾Í¸½´øÓе쬻¹ÊÇÒªÖØÐÂÏÂÔØµÄ¡£
²»¹ýÏëÏëÊÇÓ¢Îĵ쬾ÍÓеãÐÄÐéÁË¡£
ÁíÍ⣬×öjdbcÁ´½ÓµÄʱºò£¬Ê¹ÓÃSIDÃû³Æ»¹ÊÇÈ«¾ÖÊý¾Ý¿âÃû°¡¡£
¼ÙÈ磺strConn = "jdbc:oracle:thin:@china-e7ed21b49:1521:abc";
×îºóµÄÓ¦¸ÃÊÇSID Ãû³Æ£¿»¹ÊÇ È«¾ÖÊý¾Ý¿âÃû°¡£¿
ѧjava »¹×öÁËÈýÄê ¿´À´sqlÓï¾ä¶¼Ã»Ê²Ã´ÎÊÌâ
Ö÷ÒªÏÈѧѧÊý¾Ý¿âÌåϵ½á¹¹
www.itpub.net Ê
Ïà¹ØÎÊ´ð£º
ÇëÎÊÕâ¸ö»º³å³ØÊÇÔõô»ØÊ°¡£¿¿ÉÒÔÁ¬½Ó»º³å³ØÀûÓÃÆäÖеÄÊý¾Ý°É£¿ÔõôÓã¿
Õâ¸öÊÇoracle×Ô¶¯×öµÄ£¬Ò»°ãÓ¦ÓóÌÐòÊDzÙ×÷²»Á˵ġ£
²»ÄÜÖ±½ÓÁ¬½ÓÂð£¿
ÒýÓÃ
²»ÄÜÖ±½ÓÁ¬½ÓÂð£¿
²»ÄÜ
ÄÇ»º³å³ØÀïµÄÊý¾ÝÒ²²»Äܲéѯ ......
¸÷λoracle¸ßÊÖ£¬Çë½ÌÒ»ÏÂΪʲôoracle 10gÔÚ°²×°µ½°Ù·ÖÖ®°ËÊ®ÎåµÄʱºò¾Í±¨´í²»ÄܼÌÐø°²×°£¿
ÄÚ´æ¶à´ó£¿¡¡ÖØÐÂϸöÊý¾Ý¿â°²×°ÊÔÊÔ..
ÒýÓÃ
¸÷λoracle¸ßÊÖ£¬Çë½ÌÒ»ÏÂΪʲôoracle 10gÔÚ°²×°µ½°Ù·ÖÖ®°ËÊ®ÎåµÄʱ ......
¸÷λ´ó¸ç£¬°ï¸öæ¡£
ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ
10GºÍ11GµÄ
http://www.oracle.com/technology/software/products/database/index.html
------------------------------------------- ......
oracle 11g °²×° 01092 ´íÎó,
ÈÕÖ¾ÐÅÏ¢£º
[oracle@linux trace]$ vi alert_orcl.log
MMON started with pid=14, OS id=9089
RESETLOGS after incomplete recovery UNTIL CHANGE 522752
Errors in file / ......