Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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 EBS ϵͳÖ÷Êý¾Ý¹ÜÀí£¨A£©ÕªÂ¼

ϵÁÐÖ®Î壺ORACLE EBS ϵͳÖ÷Êý¾Ý¹ÜÀí£¨A£©
ÎïÁÏÊÇÔÚINVÄ£¿éÖж¨ÒåµÄ£¬¹©Ó¦ÉÌÊÇÔÚAPÄ£¿éÖж¨ÒåµÄ£¬¿Í»§ÊÇÔÚARÄ£¿éÖж¨ÒåµÄ
Èý¸ö³£ÓÃÖ÷Êý¾Ý£ºÎïÁÏ¡¢¹©Ó¦ÉÌÓë¿Í»§¡£ÕâÈý¸öÖ÷Êý¾Ý¶¼ÓÐÒ»¸ö¹²Í¬µÄϵͳʹÓÃÌØµã£º¿ç×éÖ¯µÄÈ«¾ÖÐÔ¡£
¶ø¶ÔÓÚBOMÊý¾Ý£¬¾¡¹ÜÔÚÆóҵʵ¼Ê¹ÜÀí¹¤×÷ÖУ¬¿ÉÄܾßÓÐÒ»¶¨µÄÈ«¾ÖÐÔÌØµã£¨ÀýÈ粻ͬ¹¤³§Éú²úͬÑù² ......

Oracle 10g ÒªµãÕûÀí Ö® Ìåϵ½á¹¹ºÍÊý¾Ý×Öµä

1Á¬½ÓÊý¾Ý¿âʵÀý
£¨1£©Óû§½ø³Ì£ºÈí¼þ£¬SQL*Plus£¬Ê¹ÓÃOracle Net Services£¨ÍøÂç·þÎñ£©ÓëÊý¾Ý¿âͨѶ
£¨2£©Oracle¼àÌýÆ÷£ºlistener.ora£¬¶¨ÒåÁËÊý¾Ý¿âʵÀýÃû£¬Â·¾¶£¬¿ÉÒÔʹÓõÄЭÒ飬¶Ë¿Ú
£¨3£©OracleÍøÂç¿Í»§£ºtnsnames.ora£¬¶¨ÒåÁËͨѶЭÒ飬¶Ë¿Ú£¬·þÎñÆ÷µØÖ·
 
2 ·þÎñÆ÷½ø³Ì
  ¸ºÔðÓû§½ø³ÌºÍOracleʵÀý ......

oracleµ¼Èëµ¼³ö²Ù×÷

oracleµ¼³öµ¼ÈëÊý¾Ý²Ù×÷
OracleÊý¾Ýµ¼Èëµ¼³öimp/expÃüÁî
    Oracle Êý¾Ýµ¼Èëµ¼³öimp/exp¾ÍÏ൱ÓÚoracleÊý¾Ý»¹Ô­Ó뱸·Ý¡£expÃüÁî¿ÉÒÔ°ÑÊý¾Ý´ÓÔ¶³ÌÊý¾Ý¿â·þÎñÆ÷µ¼³öµ½±¾µØµÄdmpÎļþ£¬impÃüÁî¿ÉÒÔ°Ñ dmpÎļþ´Ó±¾µØµ¼Èëµ½Ô¶´¦µÄÊý¾Ý¿â·þÎñÆ÷ÖС£ ÀûÓÃÕâ¸ö¹¦ÄÜ¿ÉÒÔ¹¹½¨Á½¸öÏàͬµÄÊý¾Ý¿â£¬Ò»¸öÓÃÀ´²âÊÔ£¬Ò»¸öÓà ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ