Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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ÁË¡£µ«ÊÇÒªÆ


Ïà¹ØÎÊ´ð£º

½éÉÜOracleºÍmysqlµÄÊé - Oracle / ·Ç¼¼ÊõÇø

ÎÒ¶ÔSQL SERVERºÍACCESS±È½ÏÊ죬ËùÒÔÊý¾Ý¿âµÄͨÓûù´¡¶«Î÷¿ÉÒÔ˵¶¼ÕÆÎյIJ¶àÁË£¬ÎÒÏÖÔÚÏëÒªµÄ¾ÍÊÇÒÔÉÏÁ½Êý¾Ý¿âµÄ¶ÀÌØÖ®´¦µÄ½éÉܺÍÓ¦ÓýéÉÜ¡£
ÁíÍâÊé×îºÃ¶ÔÓ¦×îа汾 oracleÊÇ11g°É 10µÄÒ²ÐУ»mysqlÊÇ5.1°É
л ......

ÇóÖúORACLEÅúÁ¿Çå³ý±íÊý¾ÝµÄÎÊÌâ - Oracle / ¿ª·¢

±ÈÈçÎÒÓÐtestA¡¢testB¡¢testCÈý¸ö±í
ÎÒÏÖÔÚÐèҪдһ¸öÅú´¦Àí»òÕ߽ű¾¸ø±ðÈË ×÷ÓþÍÊÇÖ´ÐÐÕâ¶ÎÓï¾ä¿ÉÒÔÇå³ýÕâÈý¸ö±íÀïÃæµÄÊý¾Ý ¾ÍÊÇÒ»¸ö³õʼ»¯µÄÒâ˼
ÄÄλ¸ßÈ˰ïÖúϰ¡ Ò»¸öÊý¾Ý¿âС°×ÔÚ´ËÇó¾ÈÀ²
SQL code:
......

OracleÖÐÃèÊöµÄ¿Í»§¶ËÓ¦Óõ½µ×Ö¸µÄʲô?

1.OracleÖÐÃèÊöµÄ¿Í»§¶ËÓ¦Óõ½µ×Ö¸µÄʲô?

2.OracleתÂëʱ,Èç¹û¿Í»§¶ËΪ×Ó¼¯(UASCII)·þÎñ¶ËΪ³¬¼¯(AL32UTF8).
ÄÇÑϸñµÄ½²ÊÇ×Ó¼¯×ª³¬¼¯, ¿ÉÒÔתµÄͨ.
²éѯµÄʱºò³¬¼¯×ª×Ó¼¯ÄDz»¾Í³öÎÊÌâÁËô?
Äĸö»Ø¸öÌ ......

lomboz eclipse ÖмÓÈëoracleµÄÎÊÌâ

ÔÚlomboz eclipseÖеÄwindow->show view->others->ÖеÄÔõÑù¼ÓÈëconnectivityÖеÄdata sourceÖÐÁ¬½ÓoracleʱֻÓÐ8,9,10ÕâÈý¸ö°æ±¾£¬ÔõÑù²ÅÄÜÁ¬½Óoracle11Õâ¸ö°æ±¾ÄØ£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿


......

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

ÎÒдµÄÒ»¸öJob
declare
  job1 integer;
begin
  dbms_job.submit(job1,
    'Sale_FinanceUseFee(4,null,null,null);',
    TRUNC(SYSDATE)+1.103, ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ