Çó½Ìoracle±¸·ÝÎÊÌâ - Oracle / ¿ª·¢
ÔÚoracle±¸·ÝÍê³ÉÒÔºó,ÈçºÎ²é¿´±¸·ÝÊÇ·ñ³É¹¦,ËüÓÐûÓÐÈÕÖ¾Îļþ,Èç¹ûÓÐÔÚʲôµØ·½,Ôõô²é¿´!лл
ʲô²Ù×÷ϵͳ°¡£¬Ä㲻˵ÎÒ¾ÍĬÈÏÊÇlinuxÁË¡£ ÓÐÈÕÖ¾Îļþ£¬alert.log £¬ÊÔÊÔshow parameter background_dump_dest µÄ·¾¶ÏÂÕÒÕÒ£¬ÒªÊÇûÓоÍfind / -name alert.log ²é¿´±¸·ÝÊÇ·ñ³É¹¦£¬ rman connect target / list backupsetÒýÓà ʲô²Ù×÷ϵͳ°¡£¬Ä㲻˵ÎÒ¾ÍĬÈÏÊÇlinuxÁË¡£ ÓÐÈÕÖ¾Îļþ£¬alert.log £¬ÊÔÊÔshow parameter background_dump_dest µÄ·¾¶ÏÂÕÒÕÒ£¬ÒªÊÇûÓоÍfind / -name alert.log ²é¿´±¸·ÝÊÇ·ñ³É¹¦£¬ rman connect target / list backupset ȷʵÊÇlinux,µ«ÊÇÎÒûÓÐÕÒµ½ÄǸöalert.log ÏÖÔÚÎÒµÄÒµÎñÊÇÕâÑùµÄ:ÓɱðÈË×ölinuxÔöÁ¿±¸·Ý,µ«ÊÇËû²»¼ì²éÊÇ·ñ³É¹¦,ÎÒÕâ±ß¸øËû×ö±¸·Ý¼ì²â.¼ì²âËûÊÇ·ñ³É¹¦! ÁíÍâÄãµÄÕâ¸öÃüÁîµÄʹÓ÷½·¨ÄúÄÜÔÚ˵µÄÏêϸµãÂð? ÎÒÊÖͷûlinuxϵÄoracle£¬Äã°Ñalter.logµÄ.logÈ¥µô¡£¿Ï¶¨ÄÜfindµ½µÄ д´íÁË£¬²»ÊÇalter.logÊÇalert
Ïà¹ØÎÊ´ð£º
oracle 11g °²×° 01092 ´íÎó, ÈÕÖ¾ÐÅÏ¢£º [oracle@linux trace]$ vi alert_orcl.log MMON started with pid=14, OS id=9089 RESETLOGS after incomplete recovery UNTIL CHANGE 522752 Errors in file / ......
select count(1) from FX_RETURNBOOKCHECKLIST fxreturnbo0_ where fxreturnbo0_.BOOKID='164 ' AND fxreturnbo0_.RETURNID='00025.S0000001' ÉÏÃæÒ»¸ö¼òµ¥µÄSQL,Ö´ÐÐʱ¼ä2.6à ......
oracleµÄ°²×°ºÍʹÓö¼ºÜÄÑÂð£¿ÔÀ´Ê²Ã´¶¼²»»áʱѧÁËMySQL£¬Ò²Ã»Ôõôѧ¹ý£¬¾Í×Ô¼º×°¼¸´Î£¬Óü¸Ï£¬¾Í´ïµ½ÁË´óÌåÄÜʹÓõij̶ÈÁË£¬¿ÉÊÇoracleµ½ÏÖÔÚ²»»á×°²»»áÓ㬲»»áÅ䣬ÎÒ¾ÍÏë×°¸öoracle£¬È»ºó½¨¸öÊý¾Ý¿â£¬ÀïÃæÓм¸Õ ......
ÅäÖû·¾³±äÁ¿oracleÔÚ XP ÐüÉÍ·Ö£º105 - ½â¾öʱ¼ä£º2008-9-23 23:39 ÎÒÖ»°Ñoracle×°ÔÚÁËE:\oracleÖÐ »·¾³±äÁ¿²»ÖªµÀÈçºÎÅäÖÃ. XPϰ²×°ORACLE ûÓÐÐèÒªÅäÖõĻ·¾³±äÁ¿ ¿ÉÒÔͨ¹ýEMÅäÖÃÏ·þÎñÃûº ......
java.sql.SQLException: Io Òì³£: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=186646784)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4)))) at oracle.jdbc.dbaccess.DBError.throwSqlException(DBErro ......