oracleÃüÁîÆô¶¯
ÎÒ°´ÊéÉÏ˵µÄÆô¶¯Êý¾Ý¿â£º
ËùÓзþÎñ¶¼Í£Ö¹Ê±
£¨1£©´ò¿ª¼àÌý£ºlsnrctl start
£¨2£©£ºsqlplus /nolog
£¨3£©,connect system/password as sysdba /*ÕâÒ»²½¾Í²»ÐÐÁË£¬±¨ERROR:ORA-12560: TNS: ÐÒéÊÊÅäÆ÷´íÎó*/
£¨4£©startup
Ϊʲôµ½µÚÈý²½¾Í²»ÐÐÁËÄØ£¬ÄѵÀ˵ÊéÉÏ´íÁËô£¬ÉÏÍø²éÁËÒ»ÏÂÓÃnet start oracleservicesid¾ÍÄÜÆô¶¯·þÎñ£¬
Æô¶¯·þÎñºÍÆô¶¯Êý¾Ý¿âÊÇÒ»Ñùô£¿ÎªÊ²Ã´ÓÃshutdown immediate¡¢normal¡¢abortµÈÃüÁî¹Ø±ÕÊý¾Ý¿âºóoracleservicesid·þÎñÈ´»¹ÊÇÆô¶¯µÄ ÄØ£¿
»¹ÓиöÎÊÌ⣺ÊéÉÏ˵ÓÃStartup nomountÆô¶¯
ÔÙÓÃ alter database mount
alter database open
¾Í¿ÉÒÔÍêÈ«Æô¶¯£¬¿ÉÊÇÎÒÓÃStartup nomountÆô¶¯ºóÔÙÊäÈëalter database mount °´»Ø³µÔÚµÚ¶þÐÐÏÔʾһ¸ö2ÔÙ°´»Ø³µÓÖ³öÒ»¸ösql>ºÃÏñÒ»µãû·´Ó¦£¬ÕâÊÇÔõô»ØÊ£¿
1.²»Ò»Ñù£»
2.©·ÖºÅ.
1. ½¨ÒéÂ¥Ö÷¿´ÏÂÕâƬÎÄÕ£¬¶ÔORACLE µÄÆô¶¯Ó¦¸Ã¾ÍÇå³þÁË.
Éî¿ÌÀí½âOracleÊý¾Ý¿âµÄÆô¶¯ºÍ¹Ø±Õ
http://blog.csdn.net/tianlesoftware/archive/2009/10/20/4704877.aspx
2. Â¥Ö÷Â¥µôÁË¡®£»¡¯£¬ ·ÖºÅ±íʾ½áÊø..
ÔÚwindowÏ£¬Æô¶¯·þÎñ³É¹¦£¬²»´ú±íoracleʵÀýÒѾopenÁË¡£µ«ÊÇÒªÆ
Ïà¹ØÎÊ´ð£º
<?php
getenv("ORACLE_HOME");
$conn=ocilogon("test","test","test_db");
if($conn)
echo success;
&nb ......
delphi Ôõô½«oracleµÄlong raw ×Ö¶ÎÖµ µ¼Èëblob×Ö¶Î
http://blog.csdn.net/zxf_feng/archive/2008/12/21/3571961.aspx
¿´¿´Õâ¸ö
ÒýÓÃ
vStream := TMemorySt ......
ÎÒÏÖÔÚÓÐһЩ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, ......
SQL code:
SQL> begin
2 dbms_job.run(24);
3 end;
4 /
begin
dbms_job.run(24);
end;
ORA-12011: ÎÞ·¨Ö´ÐÐ 1 ×÷Òµ
ORA-06512: ÔÚ "SYS.DBMS_IJOB", line 406
ORA-06512: ÔÚ &q ......