jboss oracle rac Ïê½â!
Ò».ÔÚ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 - ÅÉÉúÀàµÄ¹¹ÔìÆ÷²»Äܲ¶»ñËüµÄ»ùÀ๹ÔìÆ÷ËùÅ׳öµÄÒì³£
1296 - java씀1297 - cannot be resolved
1298 - Need to specify class name in environment or system property
1299 - The value for the useBean class attribute goods is invalid
1300 - jspÖÐÖ¡¶ÔÓ¦
1301 - cannot resolve symbol
1302 - jsp¿ÕÒì³£
1303 - Java»·¾³±äÁ¿ÅäÖÃ
1304 - SP2-0310: ÎÞ·¨´ò¿ªÎļþ
1305 - µ¼´í±í¿Õ¼ä
1306 - compared with errors
1307 - java.lang.NoClassDefFoundError: org hibernate criterion Criterion
1308 - Communications link failure due to underlying exception
1309 - javax.mail.AuthenticationFailedException: EOF on socket
Ïà¹ØÎĵµ£º
ѧϰOracle DBAÒ²°ë¸ö¶àѧÆÚÁË£¬½ñÌìÃÍÈ»²Å·¢ÏÖ£¬ÔÀ´ÎÒµÄÊ黹ÊǺÜеģ¬ÉϿβÙ×÷ʱºòÒ²Ö»ÊÇÖªµÀ´ó¸ÅÔõô×ö£¬µ«ÊÇÒªÕæµÄÈ«²¿×Ô¼º×ö£¬¶ø²»È¥·Ê黹ÊÇÓÐÒ»¶¨µÄÄѶȵģ¬ËùÒÔÄØ£¬½ñÌ쿪ʼ½«DBA´ÓÍ·¸´Ï°Ò»±é£¬Í¬Ê±ÔÙ²Ù×÷Ò»±é¡£
µÚÒ»Õ£¬Ñ§µÄÊÇOracleµÄÌåϵ½á¹¹£ ......
OracleÈÕÆÚº¯Êý¼¯½õ(Ò»)
Ò»¡¢ ³£ÓÃÈÕÆÚÊý¾Ý¸ñʽ
1.Y»òYY»òYYY ÄêµÄ×îºóһ룬Á½Î»»òÈýλ
SQL> Select to_char(sysdate,'Y') from dual;
TO_CHAR(SYSDATE,'Y')
--------------------
7
SQL> Select to_char(sysdate,'YY') from dual;
TO_CHAR(SYSDATE,'YY')
---------------------
07
SQL> Select to_ch ......
Ëùν³öÓÚjob¶øÊ¤ÓÚjob£¬ËµµÄ¾ÍÊÇOracle 10gºóµÄÐÂÌØÐÔSchedulerÀ²¡£ÔÚ10g»·¾³ÖУ¬ORACLE½¨ÒéʹÓÃSchedulerÌæ»»ÆÕͨµÄjob£¬À´¹ÜÀíÈÎÎñµÄÖ´ÐС£Æäʵ£¬½«SchedulerÃèÊö³É¹ÜÀíjobµÄ¹¤¾ßÒѾ̫¹ýÆ¬ÃæÁË£¬10G°æ±¾ÖÐÐÂÔöµÄScheduler¾ø²»½ö½öÊÇ´´½¨ÈÎÎñÕâô¼òµ¥¡£¡£¡£¡£
Ìáʾ£ºORACLEÖйÜÀíSchedulerÊÇͨ¹ýDBMS_SCHEDULER°ü£¬ ......
Ò». ÀûÓÃrowidÀ´µÃµ½Ïà¹ØÐÅÏ¢
SQL> conn sys/admin as sysdba
ÒÑÁ¬½Ó¡£
SQL> create table bl(id number);
±íÒÑ´´½¨¡£
SQL> insert into bl values(1);
ÒÑ´´½¨ 1 ÐС£
SQL> select owner,segment_name,file_id,RELATIVE_FNO,block_id from dba_extents wh
ere owner='SYS' and segment_name='B ......
ÔÚÒ»¸ö¸ß¿ÉÓÃϵͳÖУ¬Èç¹ûÐèÒª¸Ä±äÒ»¸ö±íµÄ¶¨ÒåÊÇÒ»¼þ±È½Ï¼¬ÊÖµÄÎÊÌ⣬ÓÈÆäÊǶÔ
ÓÚ7×24ϵͳ¡£OracleÌṩµÄ»ù±¾Óï·¨»ù±¾¿ÉÒÔÂú×ãÒ»°ãÐÔÐ޸쬵«ÊǶÔÓÚ°ÑÆÕͨ¶Ñ±í¸ÄΪ·ÖÇø±í£¬°ÑË÷Òý×éÖ¯±íÐÞ¸ÄΪ¶Ñ±íµÈ²Ù×÷¾ÍÎÞ·¨Íê³ÉÁË¡£¶øÇÒ£¬
¶ÔÓÚ±»´óÁ¿DMLÓï¾ä·ÃÎÊµÄ±í£¬ÐÒÔ˵ÄÊÇ£¬Oracle´Ó9i°æ±¾¿ªÊ¼ÌṩÁËÔÚÏßÖØ¶¨Òå±í¹¦ÄÜ£¬Í ......