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

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. Â¥Ö÷Â¥µôÁË¡®£»¡¯£¬ ·ÖºÅ±íʾ½áÊø..


ÒýÓÃ
Ϊʲôµ½µÚÈý²½¾Í²»ÐÐÁËÄØ£¬ÄѵÀ˵ÊéÉÏ´íÁËô£¬ÉÏÍø²éÁËÒ»ÏÂÓÃnet start oracleservicesid¾ÍÄÜÆô¶¯·þÎñ
Æô¶¯·þÎñºÍÆô¶¯Êý¾Ý¿âÊÇÒ»Ñùô£¿ÎªÊ²Ã´ÓÃshutdown immediate¡¢normal¡¢abortµÈÃüÁî¹Ø±ÕÊý¾Ý¿âoracleservicesid·þÎñÈ´»¹ÊÇÆô¶¯µÄ ÄØ£¿


ÔÚwindowÏ£¬Æô¶¯·þÎñ³É¹¦£¬²»´ú±íoracleʵÀýÒѾ­openÁË¡£µ«ÊÇÒªÆ


Ïà¹ØÎÊ´ð£º

PHP Á¬½ÓOracle ³ö´í

<?php
  getenv("ORACLE_HOME");
  $conn=ocilogon("test","test","test_db");
  if($conn)  
  echo success;  
&nb ......

delphi Ôõô½«oracleµÄlong raw ×Ö¶ÎÖµ µ¼Èëblob×Ö¶Î

delphi Ôõô½«oracleµÄlong raw ×Ö¶ÎÖµ µ¼Èëblob×Ö¶Î

http://blog.csdn.net/zxf_feng/archive/2008/12/21/3571961.aspx
¿´¿´Õâ¸ö

ÒýÓÃ
            vStream := TMemorySt ......

ÖªµÀÔõô°Ñ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¼Æ»®ÈÎÎñ

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 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ