LinuxÉϵǼoracle±¨´íÎÊÌâ - Oracle / »ù´¡ºÍ¹ÜÀí
ÎÒÔÚLinuxÉÏÏȵǼΪoracleÓû§ºó£¬ÔÙÖ´ÐÐsqlplus '/as sysdba'ʱ±¨´í£¬
SQL*Plus: Release 10.2.0.4.0 - Production on ÐÇÆÚÈý 4ÔÂ 21 16:29:38 2010
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
ERROR:
ORA-01031: insufficient privileges
Enter user-name:
È»ºóÎÒÔÚuser-name:ºóÃæÊäÈëÊý¾Ý¿âµÄÓû§ÃûºÍÃÜÂëºó¾Í¿ÉÒÔÕý³£½øÈëoracleÃüÁîÐÐÁË¡£
µ«ÎÒÔÚ±ðµÄLinuxÖ÷»úÉÏÈ´²¢Ã»ÓÐÕâ¸öÎÊÌ⣬ִÐÐÍêsqlplus '/as sysdba'¾Í¿ÉÒÔ½øÈëoracleÃüÁîÐÐÁË
ÇëÎÊÊÇʲôÔÒòÄØ
Äã˵µÄÊÇÕâÑùµÄ°É
SQL> CONN /AS SYSDBA
ÒÑÁ¬½Ó¡£
ERROR:
ORA-01031: insufficient privileges
export ORACLE_SID=ʵÀýÃû
sqlplus /nolog
conn / as sysdba
1¡¢Ò»¶¨ÒªÔ¶³Ìµ½Êý¾Ý¿âËùÔڵķþÎñÆ÷ÉÏ
2¡¢Ò»¶¨ÒªÉèÖÃORACLE_SID£¬Ö÷Òª»·¾³±äÁ¿ÃûºÍʵÀýÃû¶¼Òª´óд
Èç¹û»¹ÓÐÎÊÌâ¾ÍÕÒÎÒ
²»ÊÇ£¬¾ÍÊÇÎÒ˵µÄÄÇÖÖÇé¿ö
Äã˵µÄÕâÖÖÇé¿öÎÒÔÚÍøÉÏ¿´µ½¹ý£¬²»¹ý²»Ò»Ñù
ÎÒÊÇÔÚһ̨·þÎñÆ÷ÉÏ×öµÄ¶Ë¿Úת·¢Á¬µ½ÁËÊý¾Ý¿âÉÏ£¬²»ÖªµÀÊDz»ÊÇÕâ¸öÔÒòÄØ
ûÈ˻ᰡ£¿£¿
²»¶®£¬°ï¶¥
End_rbody_64885567//-->
¸Ã»Ø¸´ÓÚ2010-04-22 14:24:52±»¹ÜÀíԱɾ³ý
¶ÔÎÒÓÐ
Ïà¹ØÎÊ´ð£º
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
×ÉѯQQ£º269562808
bzip2recover
¹¦ÄÜ˵Ã÷£ºÓÃÀ´ÐÞ¸´Ë𻵵Ä.bz2Îļþ¡£
Óï·¨£ºbzip2recover[.bz2ѹËõÎļþ]
²¹³ä˵Ã÷£ºbzip2ÊÇÒÔÇø¿éµÄ·½Ê½À´Ñ¹ËõÎļþ£¬Ã¿¸öÇø¿éÊÓΪ¶ÀÁ¢µÄµ¥Î»¡£Òò´Ë£¬µ±Ä³Ò»Çø
¿éËð»µÊ±£¬±ã¿ÉÀû ......
ÔÚϵͳÔËÐеÄʱºò×ÜÊÇÓÐÒ»¿é´ÅÅÌʼÖÕÉÁºìµÆ£¬½øÈëϵͳºó
#topas²é¿´×ÜÊÇÓÐÒ»¿é´ÅÅÌ%BUSYΪ90%ÒÔÉÏ£¬
Êý¾Ý¿â°æ±¾£ºoracle 9.2.0.7
Êý¾ÝÎļþ¹ÒÔØµÄ½Úµã£º/oradata/pcs/ Âß¼¾íºÅlv04
#lslv -l lv04
......
¼ÙÉètable01 ÖÐÓÐ ÒÔÏÂ×ÊÁÏ
emp_no emp_name
------- ------------
0001 TOM
0002 JOHN
0003 MARY
³£Óõ绰
¶øÎÒÃÇÒªµÃµ½ÒÔϵÄOUTPUT (»òÊǸ÷ÖÖÆäËûµÄoutput)
0001,TOM
0002,JOHN
......
rt£¬ÎÒÊÔÁËÍøÉÏÖ±Á¬AccesÊý¾Ý¿âµÄ·½·¨,windowsÏÂûÓÐÎÊÌâ,µ«ÊÇÔÚlinuxϲ»ÐУ¬ËÄܸøµãÌáʾ£¿Ð»Ð»
ÄãÔõôÁ¬µÄ£¿
AccesÊý¾Ý¿â..
ÄãÔõôÁ·µÄÄØ£¿
Java code:
static String DBDRIVER = "sun.jd ......