Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

Ò»¸ö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 °¡£¡

ºöÂÔÁË
лл¸÷λÁË


Ïà¹ØÎÊ´ð£º

Oracle Êý¾Ýµ¼³öÎÊÌâ - Oracle / ¸ß¼¶¼¼Êõ

exp user/password@dbname file=c:\table.dmp tables=jbitaku,jbitakum grants=y
È»áá°´»Ø車鍵 說Ã÷:¡¡ user/password@dbname ¡¡·Ö別±íʾÓÃ戶Ãû£¬ÃÜ碼ºÍ·þ務Ãû f ......

oracleÓëaix - Oracle / ¸ß¼¶¼¼Êõ

ÔÚϵͳÔËÐеÄʱºò×ÜÊÇÓÐÒ»¿é´ÅÅÌʼÖÕÉÁºìµÆ£¬½øÈëϵͳºó
#topas²é¿´×ÜÊÇÓÐÒ»¿é´ÅÅÌ%BUSYΪ90%ÒÔÉÏ£¬
Êý¾Ý¿â°æ±¾£ºoracle 9.2.0.7 
Êý¾ÝÎļþ¹ÒÔØµÄ½Úµã£º/oradata/pcs/ Âß¼­¾íºÅlv04 
#lslv -l lv04 ......

oracle °²×° 01092 ´íÎó - Oracle / »ù´¡ºÍ¹ÜÀí

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 / ......

sqlÓÅ»¯ - Oracle / »ù´¡ºÍ¹ÜÀí

select count(1) from FX_RETURNBOOKCHECKLIST fxreturnbo0_ where fxreturnbo0_.BOOKID='164 ' AND fxreturnbo0_.RETURNID='00025.S0000001' 
ÉÏÃæÒ»¸ö¼òµ¥µÄSQL,Ö´ÐÐʱ¼ä2.6à ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ