FedoraÏÂoracle 11g r2¼àÌýÆ÷ÎÞ·¨Æô¶¯µÄÎÊÌâ
ÔÚFedoraϰ²×°ÁËoracle 11g r2 £¬°²×°¹ý³Ì˳Àû£¬Ã»Óб¨´í¡£µ«ÊÇ£¬°²×°ºÃºó£¬Æô¶¯¼àÌýµÄʱºò¾Í±¨´í
´úÂ룺
su oracle
cd /u01/app/oracle/product/11.2.0/dbhome_2/bin
./lsnrctl start
È»ºó¾ÍÊDZ¨´í£¬´íÎóÐÅÏ¢ÈçÏ£º
LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 24-FEB-2010 03:03:09
Copyright (c) 1991, 2009, Oracle. All rights reserved.
Message 1070 not found; No message file for product=network, facility=TNSTNS-12546: Message 12546 not found; No message file for product=network, facility=TNS
TNS-12560: Message 12560 not found; No message file for product=network, facility=TNS
TNS-00516: Message 516 not found; No message file for product=network, facility=TNS
Linux Error: 13: Permission denied
´ó¼ÒÓÐÓöµ½¹ýÕâ¸öÎÊÌâµÄÂð£¿Ôõô½â¾ö°¢£¿
°²×°¹ý³ÌÎÒÊDzÎÕÕµÄÕâÆªÌû×Ó
http://bbs.fedora-zh.org/showthread.php?4776-%E5%9C%A8fedora-12%E4%B8%8A%E9%9D%A2%E5%AE%89%E8%A3%85oracle-11-2
°²×°Ê±hostsÎļþû×öÐÞ¸Ä
Ïà¹ØÎÊ´ð£º
exp user/password@dbname file=c:\table.dmp tables=jbitaku,jbitakum grants=y
È»áá°´»Ø車鍵 說Ã÷:¡¡ user/password@dbname ¡¡·Ö別±íʾÓÃ戶Ãû£¬ÃÜ碼ºÍ·þ務Ãû f ......
ÎÒÔÚ¿ª·¢µÄÕâ¸öÓ¦Óò¢·¢ÐԱȽϸߣ¬oracle¸üÐÂÊý¾ÝʱºòÈçºÎ´¦Àí²¢·¢´¦ÀíÄØ£¿¸÷λ´óÏÀ·¢±íºÃµÄ¹Ûµã°¡£¬ÔÚÏߵȴý£¡
oracleÊý¾Ý¸üÐÂʱ£¬»á×Ô¶¯Ä¬ÈÏÐÐËø¶¨£¬Â¥Ö÷²»Òª²ÙÐÄ£¬Oracle¶Ô²¢Ðд¦ÀíÒѾºÜ³ÉÊìÁË
ÒýÓÃ
oracle ......
ÔÚϵͳÔËÐеÄʱºò×ÜÊÇÓÐÒ»¿é´ÅÅÌʼÖÕÉÁºìµÆ£¬½øÈëϵͳºó
#topas²é¿´×ÜÊÇÓÐÒ»¿é´ÅÅÌ%BUSYΪ90%ÒÔÉÏ£¬
Êý¾Ý¿â°æ±¾£ºoracle 9.2.0.7
Êý¾ÝÎļþ¹ÒÔØµÄ½Úµã£º/oradata/pcs/ Âß¼¾íºÅlv04
#lslv -l lv04
......
select count(1) from FX_RETURNBOOKCHECKLIST fxreturnbo0_ where fxreturnbo0_.BOOKID='164 ' AND fxreturnbo0_.RETURNID='00025.S0000001'
ÉÏÃæÒ»¸ö¼òµ¥µÄSQL,Ö´ÐÐʱ¼ä2.6à ......