Ò»¸ö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 ......
¼ÙÉètable01 ÖÐÓÐ ÒÔÏÂ×ÊÁÏ emp_no emp_name ------- ------------ 0001 TOM 0002 JOHN 0003 MARY ³£Óõ绰 ¶øÎÒÃÇÒªµÃµ½ÒÔϵÄOUTPUT (»òÊǸ÷ÖÖÆäËûµÄoutput) 0001,TOM 0002,JOHN
......
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à ......
²é¿´ÊÂÎñ¸ôÀë¼¶±ðµÄÃüÁ MySQLʹÓõÄÊÇselect @@tx_isolation; ÔÚOracleÖв鿴ÊÂÎñ¸ôÀë¼¶±ðµÄÃüÁîÊÇÄĸö£¿ SQL code: SELECT /*+ rule */ s.username,decode(l.type,'TM','TABLE LOCK','TX','ROW LOCK', ......