[Oracle]TNSListener ÎÞ·¨Æô¶¯ÎÊÌâ
OracleµÄ¼àÌýÆ÷TNSListenerÓÐʱÎÞ·¨Æô¶¯£¬ÓÐʱÆô¶¯ÍêÒÔºó»á×Ô¶¯¹Ø±Õ£¬ÕâÀï¸ø³öÒ»ÖÖ¿ÉÄܵÄÔÒò¾ÍÊǼÆËã»úÃû³ÆµÄÐ޸쬽â¾öµÄ·½·¨ÊÇ´ò¿ª<ORALE_HOME>\network\admin\listener.ora£¬ÐÞ¸Ä(HOST = [compute_name])(PORT = 1521)£¬ÖØÐÂÐ޸ľͿÉÒÔÕý³£Æô¶¯¡££¨×¢ÒâOracleÆóÒµ¹ÜÀíÆ÷ÖÐĬÈϵÄÊý¾Ý¿âÁ¬½ÓÒ²ÐèÒª¸Ä±ä£¬·ñÔòÈÔÈ»»áÌáʾ³ö´í¡££©
Ïà¹ØÎĵµ£º
ORACLE±¸·Ý²ßÂÔ(ORACLE BACKUP STRATEGY)
2007Äê11ÔÂ02ÈÕ ÐÇÆÚÎå 16:03
¸ÅÒª
1¡¢Á˽âʲôÊDZ¸·Ý
2¡¢Á˽ⱸ·ÝµÄÖØÒªÐÔ
3¡¢Àí½âÊý¾Ý¿âµÄÁ½ÖÖÔËÐз½Ê½
4¡¢Àí½â²»Í¬µÄ±¸·Ý·½Ê½¼°ÆäÇø±ð
5¡¢Á˽âÕýÈ·µÄ±¸·Ý²ßÂÔ¼°ÆäºÃ´¦
Ò»¡¢Á˽ⱸ·ÝµÄÖØÒªÐÔ
¿ÉÒÔ˵£¬´Ó¼ÆËã»úϵͳ³öÊÀµÄÄÇÌìÆð£¬¾ÍÓÐÁ˱¸·ÝÕâ¸ö¸ÅÄ ......
¶Ô³õѧORACLEµÄÈËһʱºÜÄÑ·ÖÇåORACLEÖйØÓÚ“¿Õ¼ä”µÄ¸ÅÄ±ÈÈç±í¿Õ¼ä ÁÙʱ±í¿Õ¼ä Óû§±í¿Õ¼äµÈ£¬¶ÔÓÚÓÉSQLתµ½ORACLEµÄ¾Í¸ü¼Ó»ìÏýÁË£¬ÈÃÈ˸оõORACLE·±Ëö£»·±ËöÔÚÄĶù£¬ÎÒÕûÀíÂÞÁÐÈçÏ£º
1.ORACLE×Ô´ø¹¤¾ß²»Ê®·ÖÒ×Óã»
2.ORACLEµÚÈý·½¹¤¾ßÒ×ÉÏÊÖ£¬µ«ÄÑÉîÈ룻
&n ......
1 spool
spool d:\test\table.dat
select * from table_name;
spool off
2 sqlplus user/password@sid @test.sql > table.dat
test.sql
select * from table_name;
exit; ......
String sql = "select t.FILE_INFO from T_FILE_DB_DETAIL t where t.id= "
+ fileDBUpDownDetail.getId() + " for update";
rs = stmt.executeQuery(sql);
if (rs.next()) {
// ÔÚweblogicϲ¿Êðʱ£¬ÐèÒª¸ü¸ÄΪBea We ......