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

Ubuntu×°oracleºó£ºproductºÍadminÎļþ¼ÐΪ¿Õ

ÎÒÔÚÐéÄâ»úÉϵÄubuntuϵͳϰ²×°oracle10£¬¸Õ°²×°Íê³Éʱ¿ÉÒÔ·ÃÎÊemºÍsqlplus£¬¿ÉÊÇÖØÐ¿ª»úºó¾ÍÎÞ·¨·ÃÎÊÁË¡£
ÔÚstartupʱ³öÏÖora-01078:failure in processing system parametersºÍlrm-00109:could not open parameter file '/opt/oracle10/product/10.2.0/db_1/dbs/initcity.ora'Á½¸ö´íÎó¡£
ÔÚÍøÉϲéÁËһЩ½â¾ö·½·¨£¬¶¼²»¿ÉÒÔ¡£ÎÒ·¢ÏÖ/opt/oracle10/Ŀ¼ÏµÄproductºÍadminÎļþ¼ÐÈ«Êǿյģ¡
Ôõô»áÊǿյÄÄØ£¿¼±Çó¸÷λ´óÏÀ°ï棡·Ç³£¸Ðл£¡
虛擬機µÄ問題°É



Â¥Ö÷µÄOracle Êǰ²×°ÔÚÕâ¸öĿ¼ÏÂÂð£¿
/opt/oracle10/product/10.2.0/db_1/

Èç¹û²»ÊÇ£¬ÔÚ/HOME/ORACLE Ŀ¼ÏÂ
ls -a
ÔÚ.profile ÎļþÀ¿´¿´ÄãµÄ$ORACLE_HOMEºÍÄãORACLEÈí¼þ°²×°µÄĿ¼ÊÇ·ñÏàͬ¡£

»òÕ߯ô¶¯Ö®Ç°ÊÖ¶¯µÄÉèÏÂ$ORACLE_HOME
export ORACLE_HOME=/../..



oracleÊÇ×°ÔÚ/opt/oracle10/product/10.2.0/db_1/ ϵģ¬
$ORACLE_HOME±äÁ¿ÊÇÔÚ.bashrcÎļþÖж¨ÒåµÄ¡£

ÒýÓÃ
虛擬機µÄ問題°É

ÊÇÐéÄâ»úµÄÎÊÌâÂð£¿Ó¦¸ÃÔõô½â¾ö£¿

ÔõôûÈËÁËÄØ£¿´ó¼Ò°ï°ïæ!

ÒýÓÃ
Â¥Ö÷µÄOracle Êǰ²×°ÔÚÕâ¸öĿ¼ÏÂÂð£¿
/opt/oracle10/product/10.2.0/db_1/

Èç¹û²»ÊÇ£¬ÔÚ/HOME/ORACLE Ŀ¼ÏÂ
ls -a
ÔÚ.profile ÎļþÀ¿´¿´ÄãµÄ$ORACLE_HOMEºÍÄãORACLEÈí¼þ°²×°µÄĿ¼ÊÇ·ñÏàͬ¡£

»òÕ߯ô¶¯Ö®Ç°ÊÖ¶¯µÄÉèÏÂ$ORACLE_HOME
export ORACLE_HOME=/../..

<


Ïà¹ØÎÊ´ð£º

ÖªµÀÔõô°Ñsasµ¼ÈëoracleµÄ½øÀ´¿´¿´

ÎÒÏÖÔÚÓÐһЩsasÉÏÃæµÄÊý¾ÝÎļþ ÏÖÔÚÎÒÐèÒª°Ñsasµ¼Èëµ½oracle
ÏÖÔÚ°ÑÒ»¸ösasÎļþµ¼Èëµ½Ò»¸öoracleÖеÄÒ»¸ö±íÖÐÎÒÒѾ­ÖªµÀÔõôŪÁË
µ«ÊÇ ÎÒÏÖÔÚÐèÒª°ÑsasÖеÄÁíÒ»¸öÎļþ×·¼Óµ½oracleÖеÄÒ»¸öÓÐÊý¾ÝµÄÒ»¸ö±íÉÏà ......

½èˮԴÈËÆø£¡oracle jobÎÊÌ⣡ÔÚÏßµÈ

ÎÒдµÄÒ»¸öJob
declare
  job1 integer;
begin
  dbms_job.submit(job1,
    'Sale_FinanceUseFee(4,null,null,null);',
    TRUNC(SYSDATE)+1.103, ......

ÊÇoracleµÄbugô£¿É¢·ÖÁË£¡ - Oracle / »ù´¡ºÍ¹ÜÀí

±¾À´ÒªÐ´¸öupdateÓï¾ä
update table_a A
  set A.flag=1
  where A.id in (select B.id from table_b B)
½á¹ûÎóд³É
update table_a A
  set A.flag=1
  where ......

oracle ·¢Óʼþ´íÎó

ÏÂÃæ´æ´¢¹ý³ÌÖ´ÐкóÓдíÎó£¬
create or replace procedure test_mail(msg_subject in varchar2,
                            mes_co ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ