Oracle°²×° - Oracle / »ù´¡ºÍ¹ÜÀí
ÔÚwin7ϰ²×°OracleûÓÐORCL·þÎñ³ÌÐò£¬Çë¸÷λ¸ßÊÖÖ¸µãÖ¸µã°¡£¡
ORACLE°æ±¾ÎÊÌâ,ÀúÊ·Ìù×Ӳο¼ÏÂ....
ÕýÔÚ¼ì²é²Ù×÷ϵͳҪÇó...
ÒªÇóµÄ½á¹û: 5.0,5.1,5.2,6.0 Ö®Ò»
ʵ¼Ê½á¹û: 6.1
¼ì²éÍê³É¡£´Ë´Î¼ì²éµÄ×ÜÌå½á¹ûΪ: ʧ°Ü <<<<
ÎÊÌâ: Oracle Database 11g δÔÚµ±Ç°²Ù×÷ϵͳÖо¹ýÈÏÖ¤¡£
½¨Òé°¸: È·±£ÔÚÕýÈ·µÄƽ̨Éϰ²×°Èí¼þ¡£
========================================================
ÕýÔÚ¼ì²é Service Pack ÒªÇó...
¼ì²éÍê³É¡£´Ë´Î¼ì²éµÄ×ÜÌå½á¹ûΪ: δִÐÐ <<<<
OUI-18001: ²»Ö§³Ö²Ù×÷ϵͳ 'Windows Vista °æ±¾ 6.1'¡£
½¨Òé°¸: Çë°²×°½¨ÒéµÄ Service Pack¡£
========================================================
Çó½â£¡
Ö±½Ó°²×°32λµÄ¾Í¿ÉÒÔÁË¡£²»ÒªÓÃoracle for vistaµÄ¡£
win7ϰ²×°oracleȷʵÎÊÌâ¶à¶à£¬¿´¹ý¼¸¸öÏà¹ØµÄÌû×Ó£¬ÔÚÐéÄâ»úÀïÊÔÑéÁËÏ»¹ÊÇδÄܳɹ¦¡£
²Î¿¼
Òѽâ¾öÁË
ºÇºÇ
ÕÒµ½ refhost.xml Îļþ£¨Î»Öãºdatabase\stage\prereq\db £¬¿ÉÒÔʹÓüÆËã»úµÄËÑË÷¹¦ÄÜ£©£¬´ò¿ª refhost.xml ÅäÖÃÎļþ²¢ÕÒµ½ <CERTIFIED_SYSTEMS> ½Úµã£¬½Ó×ÅÔÚ½ÚµãºóÃæÌí¼ÓÒÔÏÂÄÚÈݲ¢±£´æ¼´¿É£º
<!--Microsoft Windows 7-->
<OPERATING_SYSTEM>
<VERSION VALUE="6.1"/>
</OPERATING_SYSTEM>
Ïà¹ØÎÊ´ð£º
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
ÔÚϵͳÔËÐеÄʱºò×ÜÊÇÓÐÒ»¿é´ÅÅÌʼÖÕÉÁºìµÆ£¬½øÈëϵͳºó
#topas²é¿´×ÜÊÇÓÐÒ»¿é´ÅÅÌ%BUSYΪ90%ÒÔÉÏ£¬
Êý¾Ý¿â°æ±¾£ºoracle 9.2.0.7
Êý¾ÝÎļþ¹ÒÔØµÄ½Úµã£º/oradata/pcs/ Âß¼¾íºÅlv04
#lslv -l lv04
......
×öÍædata guard ºó
ÔÚPrimary·þÎñÆ÷ Ö´ÐÐ
SQL>SELECT SEQUENCE#,APPLIED from V$ARCHIVED_LOG ORDER BY SEQUENCE#;
SEQUENCE# APP
---------- ---
13 NO
13 YES ......
·þÎñÆ÷ºǫ́µÄÊý¾Ý¿âÊÇoracle£¬ÔÚ½ñÌìϵͳµÇ¼µÄʱºò±¨¡°µÇ¼²»ÁËÊý¾Ý¿â£¬IOÒì³£¡±£¬½á¹ûÊÇÈ«¹«Ë¾¶¼µÇ²»ÉÏÈ¥£¬ÎÒÖØÆôÁËһϷþÎñÆ÷²ÅºÃÁË£¬ÎÒÏë¿ÉÄÜÊÇÓû§²¢·¢Á¿Ì«´óµÄÔµ¹Ê£¬²»ÖªµÀ¸÷λ´óϺÈÏͬ²»£¿ÓÐʲô½â¾ö°ì·¨Ã»£¿ ......
CREATE OR REPLACE PROCEDURE usp_refreshTopN
IS
BEGIN
--Îĵµ
INSERT INTO topnresource(resourceId,title,type,cover,brief,properUser,tag,clickAmount,createDate,topNCreateDate,o ......