Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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 to_dateÏÝÚå

ORACLE to_date ÏÝÚå
oracle Öв»´øʱ·ÖÃëµÄ×Ö·û´® to_date ת»»Ê±¼äºóÓë´øʱ·ÖÃëµÄdateÐÍ×Ö¶Î×ö´øµÈÖµµÄ±È½Ï (>=,<=,=)ʱ£¬ÓÉÓÚ×Ö·û´®²»´øʱ·ÖÃ룬ËùÒÔת»»ºóʱ·ÖÃëĬÈÏΪ00:00:00,oracleÖбȽÏdateÊÇÒÔÒ»¸öʱ¼äµãÀ´±È½ÏµÄ£¬¾«È·µ½ÃëÉõÖÁºÁÃë΢ÃëÄÉÃë,ËùÒÔdate×ֶεÄʱ·ÖÃ벻Ϊ00:00:00µÄ¾ÍÓë²»´øʱ·ÖÃë×Ö·û´®×ª»»º ......

»ØÍû£¬ÎÒµÄOracle֮·


¡¡¡¡´óѧµÄʱºò£¬ÎÒÊǹÜÀíѧԺµÄ£¬ºóÀ´Ï¸·ÖרҵµÄʱºòÑ¡ÔñÁËÐÅÏ¢¹ÜÀí¡£ÓÚÊǹÜÀí¡¢»á¼Æ¡¢²ÆÎñ¡¢»úе¡¢µç×Ó£¬ÉõÖÁ˵Ç鱨¼ìË÷¶¼Ñ§¹ý£¬µ±È»Ò²°üÀ¨¼ÆËã»ú¡£
¡¡¡¡Èç¹û²»ËãfoxbaseºÍfoxproµÄ»°£¬Êý¾Ý¿â·½Ãæ½ö½öѧ¹ýÒ»ÃÅÊý¾Ý¿âÔ­Àí£¬ÓõĽ̲ÄÊÇStanfordµÄÓ°Ó¡°æ¡£
¡¡¡¡µ±Ê±ÓÐÒ»¸öΤÀÏʦ£¬×ÜÊÇ´µËýÀϹ«ÊÇMITµÄ²©Ê¿£¬ºÜNB¡£×ÜÊÇ¶Ô ......

OracleѧϰµÄһЩ½¨Òé


¡¡¡¡Ñ§Ï°OracleÊÇÒ»¸öÂþ³¤¼èÐÁµÄ¹ý³Ì¡£Èç¹ûûÓÐÐËȤ£¬Ö»ÊDZ»ÆÈѧϰ£¬ÄÇôÊǺÜÄÑѧºÃµÄ¡£Ñ§Ï°µ½Ò»¶¨³Ì¶ÈµÄʱºò£¬ÒªÏë½øÒ»²½Ìá¸ß£¬¾Í²»µÃ²»½Ó´¥ºÜ¶àOracleÖ®ÍâµÄ¶«Î÷£¬ÈçUnix£¬ÈçÍøÂç¡¢´æ´¢µÈ¡£Òò´Ë£¬ÒªÕæµÄ¾öÐÄѧºÃOracle£¬¾ÍÒ»¶¨ÒªÓÐÐËȤ¡£ÓÐÁËÐËȤ£¬¾Í»áÒ»ÇбäµÃ¼òµ¥¿ìÀÖÆðÀ´¡£¼òµ¥×ܽáһϣ¬ÄǾÍÊÇ£ºÐËȤ¡¢Ñ§Ï°¡¢Êµ¼ù¡£ ......

ͨ¹ýJDBCÁ¬½ÓoracleÊý¾Ý¿âµÄÊ®´ó¼¼ÇÉ

JavaÊý¾Ý¿âÁ¬½Ó£¨JDBC£©APIÊÇһϵÁÐÄܹ»ÈÃJava±à³ÌÈËÔ±·ÃÎÊÊý¾Ý¿âµÄ½Ó¿Ú£¬¸÷¸ö¿ª·¢É̵Ľӿڲ¢²»ÍêÈ«Ïàͬ¡£ÔÚʹÓöàÄêµÄOracle¹«Ë¾µÄJDBCºó£¬ÎÒ»ýÀÛÁËÐí¶à¼¼ÇÉ£¬ÕâЩ¼¼ÇÉÄܹ»Ê¹ÎÒÃǸüºÃµØ·¢»ÓϵͳµÄÐÔÄܺÍʵÏÖ¸ü¶àµÄ¹¦ÄÜ¡£¡¡
¡¡¡¡1¡¢ÔÚ¿Í»§¶ËÈí¼þ¿ª·¢ÖÐʹÓÃThinÇý¶¯³ÌÐò¡¡
¡¡¡¡ÔÚ¿ª·¢JavaÈí¼þ·½Ã棬OracleµÄÊý¾Ý¿âÌṩÁËËÄ ......

Oracle 10g ÒªµãÕûÀí Ö® ¹ÜÀí°²È«ÐÔ


¹ÜÀí°²È«ÐÔ
1 Oracle±êʾ·û
¢Ù²»ÊDZ£Áô×Ö
¢Ú1~30¸ö×Ö·û
¢ÛÖ»ÄÜÊÇ×ÖĸºÍ#¡¢$¡¢_
¢Ü²»ÄÜ°üº¬µ¥ÒýºÅºÍË«ÒýºÅ
 
2 Óû§
ÔÚOracleÖУ¬Êý¾Ý¿âÓû§ºÍģʽÊÇ°²È«µÄ×î»ù±¾µ¥Ôª¡£
£¨1£©Óû§ºÍģʽ
Êý¾Ý¿âģʽ¶¨ÒåΪÊý¾Ý¿â¶ÔÏóµÄ¼¯ºÏ£¬¶øģʽµÄÃû³Æ¾ÍÊÇÓµÓлò¿ØÖÆÕâЩÊý¾Ý¿â¶ÔÏ󼯺ϵÄÓû§Ãû³Æ¡£
 
£¨2£©½¨Á¢Ó ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ