ɾ³ýORACLE FOR windows µÄoci.dll´íÎóµÄ½â¾ö·½·¨
ɾ³ýORACLE FOR windows µÄoci.dll´íÎóµÄ½â¾ö·½·¨
ɾ³ýORACLE FOR windows µÄoci.dll´íÎóµÄ½â¾ö·½·¨
½ñÌì·¢ÏÖ×Ô¼ºÌ¨Ê½»úÉϵÄORACLEÓÐÎÊÌ⣬´òËãÖØװһϣ¬·¢ÏÖÕû¸öORACLEĿ¼ɾ³ý£¬±¨OCI.DLLÎÞ·¨É¾³ý´íÎó£¬Ñо¿ÁËһϣ¬
·¢ÏֹصôMSDTC·þÎñ¾Í¿ÉÒÔÁË£¬MSDTC·þÎñÔÚϵͳÖеķþÎñÃûΪ
Distributed Transaction Coordinator
¼ÇµÃÒÔÇ°Ò²Ñо¿¹ý£¬²»ÖªµÀÔõô¾ÍÍüÁË£¬ÔÚ´Ë×ö¸ö¼ÇºÅ¡£
Ïà¹ØÎĵµ£º
²ì¿´listener.log È·ÈÏûÓÐÎÊÌâ
# find / -name listener.log
/home/oracle/app/OraHome_1/network/log/listener.log
λÖÃÔÚ$ORACLE_HOME/network/log/listener.log
TNSLSNR for IBM/AIX RISC System/6000: Version 10.2.0.4.0 - Production on 29-DEC-2009 15:12:15
Copyright (c) 1991, 2007, Oracle. All ......
²»ÊÇORACLEµÄÎÊÌâ
2009-12-30 15:00
  ......
·¢ÏÖ´íÎó£ºÊý¾Ý¿âδ´ò¿ª: ½öÔÊÐíÔڹ̶¨±í/ÊÓͼÖвéѯ
½â¾ö·½°¸£º
1. ÔÚÔËÐÐ-->ÃüÁîÀïÊäÈësqlplus /nologÈ»ºó»Ø³µ£¬
2. ÒÔsysdbaµÄ½ÇÉ«µÇ¼£ºconnect sys/¿ÚÁî as sysdba
3. ÏÈÖ´ÐДalter database open”£¬»á³öÏÖÈçϵĴíÎó
µÚ 1 ÐгöÏÖ´íÎó:
ORA-01157: ÎÞ·¨±êʶ/Ëø¶¨Êý¾ÝÎļþ 6 - Çë² ......
oracle¾Þ´ó±íµÄÊý¾Ýɾ³ýµÄ·½·¨£¬20·ÖÖӸ㶨
Ò»¸ö¿Í»§µÄÈÕÖ¾±í£¬ÒѾÓÐ3000¶àǧÍòµÄ¼Ç¼ÁË£¬ÈÝÁ¿´óÔ¼30G£¬´òËãά»¤Ò»Ï£¬¿´ÁËÒ»ÏÂ×ֶΣ¬·¢ÏÖÈÕÖ¾ÊÇ°´ÈÕÆڼǼµÄ£¬´òËãÖ»±£Áô3¸öÔµÄÈÕÖ¾¾ÍºÃÁË¡£
µÚÒ»¸ö˼·£º
°´Ìõ¼þ²é³öÀ´£¬Ö±½ÓDELETE
ÊÔÁËÒ»ÏÂ
delete from NTLS_LOGS where to_char(START ......
¿ØÖÆÎļþºÍREDOLOGͬʱË𻵵ÄORACLEÊý¾Ý¿â»Ö¸´Ò»Àý
Ò»¸ö¿Í»§´òµç»°¸øÎÒ£¬ËµËûÃÇÒ»¸ö²âÊÔÊý¾Ý¿âÆð²»À´ÁË£¬ÈÃÎÒ¹ýÈ¥¿´¿´£¬
µ½¿Í»§ÏÖ³¡·¢ÏÖÊý¾Ý¿âÒѾDOWNÁË£¬ÊÔ×ÅÆô¶¯Ò»ÏÂ
SQL*Plus: Release 10.2.0.3.0 - Production on Tue Oct 7 10:33:29 2008
Copyright (c) 1982, 2006, Oracle. All Rig ......