oracleÁ¬½Ó
ÔÚÍøÂçÉÏÓÐһ̨ORACLE·þÎñÆ÷£¨windows2003£¬ORACLE 10G£© ¿Í»§»úʹÓÃXP£¬°²×°ORACLE8I¿Í»§¶Ë ʹÓÃSQLPLUS¿ÉÒÔÔ¶³ÌÁ¬½Óµ½ORACLE·þÎñÆ÷£¨ÒÔSYSDBAÉí·Ý£© ͨ¹ýÃüÁîshutdown immediate¹Ø±ÕÊý¾Ý¿âºó£¬ÎÞ·¨Ê¹ÓÃstartupÆô¶¯Êý¾Ý¿â ÌáʾÕÒ²»µ½³õʼ²ÎÊýÎļþ´íÎó Íû¸ßÊÖÖ¸µã¡£¡£¡£¡£¡£
startupµÄʱºòÌáʾ´íÎóÊÇ?ÒýÓà startupµÄʱºòÌáʾ´íÎóÊÇ? failure in processing system parmeter ??????????? "g:/oracle/....." ÄãÕâÀï¿ÉÄÜÊÇspfileÎļþËð»µÁË£¬ ÄãÓÐûÓÐÊÖ¶¯Ð޸ĹýspfileµÄÎļþ¡£ÒýÓà ÄãÕâÀï¿ÉÄÜÊÇspfileÎļþËð»µÁË£¬ ÄãÓÐûÓÐÊÖ¶¯Ð޸ĹýspfileµÄÎļþ¡£ ÎÒÒÔǰ¾ÍÊÇʹÓÃVI ÊÖ¶¯ÐÞ¸ÄÁËSPFILE£¬½á¹ûÊý¾Ý¿âÆð²»À´¡£ ORACLE¶¼ÊÇÔËÐÐÔÚLinuxÉϵÄ......... ΢ÈíÒ»ÏòÊÇÒÔ¢¶ÏΪ·¢Õ¹·½Ïò,ÎÒÃÇÔÚÒÔǰ֪µÀ,JavaÔÚWindowsÉϵÄÔËÐÐÐÔÄÜÔ¶Ô¶²îÓÚLinuxµÈOS,ÓÐʱÔÚWindowsÉÏ»¹ »á³öÏÖһЩÕâÑù»òÄÇÑùµÄÎÊÌâ..... ÏÖÔÚÓÐЩ´óµÄÈí¼þ²úÆ·¶¼Ç¿µ÷ÔÚLunixµÈÆäËü²Ù×÷ϵͳÉϵÄÐÔÄÜÓëÎȶ¨,ÈçOracle,Sybase,DB2....Ì«¶àµÄ²úÆ·Ö§³Ö Linux ÁË.......ËäÈ»ÓеIJúÆ·Ò²·¢ÏÖÁËWindows°æ,µ«ÊÇÐí¶àÆóÒµÒ²²»¸ÒÔÚWindowsÉÏÅÜËüÃǵĺËÐÄÒµÎñ....... ÀëÁË΢ÈíµÄÕóÓª,ÍâÃæµÄÊÀ½çºÜ¾«²Ê............ ͨ¹ýÒÔÉÏ˵Ã÷...Èç¹ûÄãÓÃ΢ÈíµÄ²úÆ·,ÈçÂ¥Ö÷µÄC#+.NET,SQL Serverµ±È»ÊÇ×îºÃµÄ...ΪÁ˲úÉú²»±ØÒªµÄÂé·³ÀË·ÑÄãµÄ Çà´º...Äã×îºÃ¾ÍÓÃ΢ÈíµÄ²úÆ·.....Èç¹ûÄãϲ»¶Mysql¾ÍÓÃLinux.... Õâ¸öÊÀ½çÊǾºÕùµ
Ïà¹ØÎÊ´ð£º
oracle not available shared memory realm does not exist ÇëÎʸßÊÖÕâ¸öÎÊÌâÈçºÎ½â¾ö£¿ http://www.inthirties.com/thread-109-2-1.html Ö¸¶¨ÏÂORACLE_SID,ORACLE_HOME¿´¿´£¬²»ÐоÍÓÃ1Â¥µÃ·½·¨ÁË.. cm ......
ÔÚlomboz eclipseÖеÄwindow->show view->others->ÖеÄÔõÑù¼ÓÈëconnectivityÖеÄdata sourceÖÐÁ¬½ÓoracleʱֻÓÐ8,9,10ÕâÈý¸ö°æ±¾£¬ÔõÑù²ÅÄÜÁ¬½Óoracle11Õâ¸ö°æ±¾ÄØ£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿ ......
¸Õ¿ªÊ¼Ó㬲»Ì«»á£¬dropÔÙcreateµÄÇëÈÆÐÐ SQL code: select 'drop '||object_type||' ' || object_name ; ' from dba_objects where owner = 'yourUser' http://edu.codepub.com/2009/0616/6398.php ......
´æ´¢¹ýÊÇÕâÑù¶¨ÒåµÄ create or replace procedure PROC_ReportStoreBanBao1(stime in varchar2, &n ......
ÎÒдµÄÒ»¸öJob declare job1 integer; begin dbms_job.submit(job1, 'Sale_FinanceUseFee(4,null,null,null);', TRUNC(SYSDATE)+1.103, ......