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ÎļþÖж¨ÒåµÄ¡£
ÊÇÐéÄâ»úµÄÎÊÌâÂð£¿Ó¦¸ÃÔõô½â¾ö£¿
ÔõôûÈËÁËÄØ£¿´ó¼Ò°ï°ïæ!
Ïà¹ØÎÊ´ð£º
ÎÒÏÖÔÚÓÐһЩsasÉÏÃæµÄÊý¾ÝÎļþ ÏÖÔÚÎÒÐèÒª°Ñsasµ¼Èëµ½oracle
ÏÖÔÚ°ÑÒ»¸ösasÎļþµ¼Èëµ½Ò»¸öoracleÖеÄÒ»¸ö±íÖÐÎÒÒѾ֪µÀÔõôŪÁË
µ«ÊÇ ÎÒÏÖÔÚÐèÒª°ÑsasÖеÄÁíÒ»¸öÎļþ×·¼Óµ½oracleÖеÄÒ»¸öÓÐÊý¾ÝµÄÒ»¸ö±íÉÏà ......
ÎÒдµÄÒ»¸öJob
declare
job1 integer;
begin
dbms_job.submit(job1,
'Sale_FinanceUseFee(4,null,null,null);',
TRUNC(SYSDATE)+1.103, ......
±¾À´ÒªÐ´¸ö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 ......
ÏÂÃæ´æ´¢¹ý³ÌÖ´ÐкóÓдíÎó£¬
create or replace procedure test_mail(msg_subject in varchar2,
mes_co ......