Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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 Á¬½Ó×Ö´® - Oracle / ·Ç¼¼ÊõÇø

¼ÙÉètable01 ÖÐÓÐ ÒÔÏÂ×ÊÁÏ
emp_no emp_name
------- ------------
0001 TOM
0002 JOHN
0003 MARY
³£Óõ绰 
¶øÎÒÃÇÒªµÃµ½ÒÔϵÄOUTPUT (»òÊǸ÷ÖÖÆäËûµÄoutput)
0001,TOM
0002,JOHN ......

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

Çë½ÌOracleÊÂÎñ¸ôÀë¼¶±ðÎÊÌâ - Oracle / ·Ç¼¼ÊõÇø

²é¿´ÊÂÎñ¸ôÀë¼¶±ðµÄÃüÁ
MySQLʹÓõÄÊÇselect @@tx_isolation;
ÔÚOracleÖв鿴ÊÂÎñ¸ôÀë¼¶±ðµÄÃüÁîÊÇÄĸö£¿

SQL code:

SELECT /*+ rule */ s.username,decode(l.type,'TM','TABLE LOCK','TX','ROW LOCK', ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ