Ò»¸öoracleÊý¾Ý¿âÆô¶¯µÄÎÊÌâ
oracle °æ±¾Îª10g ²Ù×÷ϵͳΪwindows xp ƽʱֻҪÆô¶¯ÁËÊý¾Ý¿â·þÎñºÍ¼àÌý³ÌÐòºó ÔÚdosÃüÁîÆ½Ì¨ÊäÈëSQLPLU USER/PWD@SID¾Í¿ÉÒÔÁ¬½Óµ½ÏàÓ¦µÄÊý¾Ý¿â µ«ÊÇ£¬½ñÌì³öÏÖÁËÒ»¸öÎÊÌ⣺ ÎÊÌâ²úÉú²½ÖèÈçÏ£º 1¡¢Æô¶¯Êý¾Ý¿â·þÎñºÍ¼àÌý³ÌÐò 2¡¢sqlplus sys/pwd@sid as sysdbaÒÔ¹ÜÀíÔ±½øÈë 3¡¢shutdown¹Ø±ÕÊý¾Ý¿â£¬¹Ø±ÕÕý³£ 4¡¢Æô¶¯Êý¾Ý¿â£¬sqlplus /nolog 5¡¢startup£¬´Ëʱ±¨´íÁË£¬´íÎóÐÅÏ¢ÈçÏ£º SQL> startup ORA-01031: insufficient privileges ²»ÖªµÀÊÇʲôÔÒò£¬Çë¸÷λ´óϺ°ïæ¿´¿´£¬ÊÇÄÄÀï³öÁË´í¡£Ó¦¸ÃÔõô×ö²ÅÄÜÆô¶¯¡£
Æô¶¯Êý¾Ý¿âÒ²ÐèÒªÓû§Ãû£¬ÃÜÂëÒýÓà oracle °æ±¾Îª10g ²Ù×÷ϵͳΪwindows xp ƽʱֻҪÆô¶¯ÁËÊý¾Ý¿â·þÎñºÍ¼àÌý³ÌÐòºó ÔÚdosÃüÁîÆ½Ì¨ÊäÈëSQLPLU USER/PWD@SID¾Í¿ÉÒÔÁ¬½Óµ½ÏàÓ¦µÄÊý¾Ý¿â µ«ÊÇ£¬½ñÌì³öÏÖÁËÒ»¸öÎÊÌ⣺ ÎÊÌâ²úÉú²½ÖèÈçÏ£º 1¡¢Æô¶¯Êý¾Ý¿â·þÎñºÍ¼àÌý³ÌÐò 2¡¢sqlplus sys/pwd@sid as sysdbaÒÔ¹ÜÀíÔ±½øÈë 3¡¢shutdown¹Ø±ÕÊý¾Ý¿â£¬¹Ø±ÕÕý³£ 4¡¢Æô¶¯Êý¾Ý¿â£¬sqlplus /nolog 5¡¢startup£¬´Ëʱ±¨´íÁË£¬´íÎóÐÅÏ¢ÈçÏ£º SQL> startup ORA-01031:insufficient privileges ²»ÖªµÀÊÇʲôÔÒò£¬Çë¸÷λ´óϺ°ïæ¿´¿´£¬ÊÇÄÄÀï³öÁË´í¡£Ó¦¸ÃÔõô×ö²ÅÄÜÆô¶¯¡£ startup Ö®ºó£¬ÐèÒªconnect as sysdba °¡£¡ ºöÂÔÁË Ð»Ð»¸÷λÁË
Ïà¹ØÎÊ´ð£º
exp user/password@dbname file=c:\table.dmp tables=jbitaku,jbitakum grants=y È»áá°´»Ø車鍵 說Ã÷:¡¡ user/password@dbname ¡¡·Ö別±íʾÓÃ戶Ãû£¬ÃÜ碼ºÍ·þ務Ãû f ......
ÔÚϵͳÔËÐеÄʱºò×ÜÊÇÓÐÒ»¿é´ÅÅÌʼÖÕÉÁºìµÆ£¬½øÈëϵͳºó #topas²é¿´×ÜÊÇÓÐÒ»¿é´ÅÅÌ%BUSYΪ90%ÒÔÉÏ£¬ Êý¾Ý¿â°æ±¾£ºoracle 9.2.0.7 Êý¾ÝÎļþ¹ÒÔØµÄ½Úµã£º/oradata/pcs/ Âß¼¾íºÅlv04 #lslv -l lv04
......
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à ......