Oracle listenerÈÕÖ¾ÎļþµÄ´¦Àí
Ëæ×Åʱ¼äºÍÁ¬½Ó£¬OracleµÄlistener.log»á²»¶ÏÔö³¤,Õâʱ¾ÍÐèÒªÎÒÃǶÔÆä½øÐд¦Àí¡£ÈôÊÔͼֱ½ÓÔÚlistenerÆô¶¯Ê±Ö±½Óɾ³ý£¬¿ÉÄÜ»áÊÕµ½±¨´íÐÅÏ¢ÀàËÆ£ºThe process cannot access the file because it is being used by another process¡£ÈôÖ±½ÓÍ£µô¼àÌýÔÙɾ³ý£¬¶ÔÓÚÉú²ú¿â,Õâ»ù±¾ÊDz»±»ÔÊÐíµÄ²Ù×÷,ÔÚUnixÏÂÃ浱Ȼ¿ÉÒÔrm,µ«Õâ¸öÎļþ²»»á±»×Ô¶¯ÖØд´½¨¡£
ÕýÈ··½·¨£º
cd $ORACLE_HOME/network/log
¹Ø±ÕÈÕÖ¾¼Ç¼:
lsnrctl set log_status off
LSNRCTL for Linux: Version 10.2.0.4.0 - Production on 18-JAN-2010 10:35:57
Copyright (c) 1991, 2007, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=***)(PORT=1521)))
LISTENER parameter "log_status" set to OFF
The command completed successfully
Òƶ¯¼àÌýÈÕÖ¾µ½ÁíÒ»¸öµØ·½:
mv listener.log listener.bak
È»ºó´ò¿ªÈÕÖ¾¼Ç¼:
lsnrctl set log_status on
LSNRCTL for Linux: Version 10.2.0.4.0 - Production on 18-JAN-2010 10:37:13
Copyright (c) 1991, 2007, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=***)(PORT=1521)))
LISTENER parameter "log_status" set to ON
The command completed successfully
×¢Òâ:listener.logÈç¹û䱬ÁËlistener¾Í»á¹ÒµôÓò»ÁË£¬ËùÒÔ¶ÔÓÚÁ¬½ÓºÜ¶àµÄÊý¾Ý¿âÒª¶¨ÆÚ¼ì²éÕâ¸ölog¡£
Ïà¹ØÎĵµ£º
oracle±í¿Õ¼ä²Ù×÷Ïê½â
1
2
3×÷Õߣº À´Ô´£º ¸üÐÂÈÕÆÚ£º2006-01-04
5
6
7½¨Á¢±í¿Õ¼ä
8
9CREATE TABLESPACE data01
10DATAFILE '/ora ......
ORACLE to_date ÏÝÚå
oracle Öв»´øʱ·ÖÃëµÄ×Ö·û´® to_date ת»»Ê±¼äºóÓë´øʱ·ÖÃëµÄdateÐÍ×Ö¶Î×ö´øµÈÖµµÄ±È½Ï (>=,<=,=)ʱ£¬ÓÉÓÚ×Ö·û´®²»´øʱ·ÖÃ룬ËùÒÔת»»ºóʱ·ÖÃëĬÈÏΪ00:00:00,oracleÖбȽÏdateÊÇÒÔÒ»¸öʱ¼äµãÀ´±È½ÏµÄ£¬¾«È·µ½ÃëÉõÖÁºÁÃë΢ÃëÄÉÃë,ËùÒÔdate×ֶεÄʱ·ÖÃ벻Ϊ00:00:00µÄ¾ÍÓë²»´øʱ·ÖÃë×Ö·û´®×ª»»º ......
oracle½«×Ö·û´®×ª»»Îª12СʱÓë24СʱÖÆ£º
--12СʱÖÆ£º
select hsv.mydate from huhai_seq_value hsv
where hsv.mydate = to_date('2009-03-03 00:00:00','yyyy-mm-dd hh:mi:ss');
--24СʱÖÆ£º
select hsv.mydate from huhai_seq_value hsv
where hsv.mydate = to_date('2009-03-03 00:00:00','yyyy-m ......
Oracle Flashback ¼¼Êõ×ܽá
Flashback ¼¼ÊõÊÇÒÔUndo segmentÖеÄÄÚÈÝΪ»ù´¡µÄ£¬ Òò´ËÊÜÏÞÓÚUNDO_RETENTON²ÎÊý¡£ÒªÊ¹ÓÃflashback µÄÌØÐÔ£¬±ØÐëÆôÓÃ×Ô¶¯³·Ïú¹ÜÀí±í¿Õ¼ä¡£
ÔÚOracle 10gÖУ¬ Flash back¼Ò×å·ÖΪÒÔϳÉÔ±£º Flashback Database£¬ Flashback Drop£¬Flashback Query(·ÖFlashback Query,Flashback Version Query ......
Ò»¡¢Æô¶¯ºÍ¹Ø±ÕOracleÊý¾Ý¿â
¡¡¡¡ÒªÆô¶¯ºÍ¹Ø±ÕÊý¾Ý¿â£¬±ØÐëÒªÒÔ¾ßÓÐOracle ¹ÜÀíԱȨÏÞµÄÓû§µÇ½£¬Í¨³£Ò²¾ÍÊÇÒÔ¾ßÓÐSYSDBAȨÏÞµÄÓû§µÇ½¡£Ò»°ãÎÒÃdz£ÓÃINTERNALÓû§À´Æô¶¯ºÍ¹Ø±ÕÊý¾Ý¿â£¨INTERNALÓû§Êµ¼ÊÉÏÊÇSYSÓû§ÒÔSYSDBAÁ¬½ÓµÄͬÒå´Ê£©¡£OracleÊý¾Ý¿âµÄа汾½«Öð²½ÌÔÌINTERNALÕâ¸öÄÚ²¿Óû§£¬ËùÒÔÎÒÃÇ×îºÃ»¹ÊÇÉèÖÃDB ......