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

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 Æô¶¯µÄÎÊÌâ

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 ÖмÓÈëoracleµÄÎÊÌâ

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


......

oracleÈçºÎɾ³ýÓû§µÄËùÓжÔÏ󣬱£ÁôÓû§

¸Õ¿ªÊ¼Ó㬲»Ì«»á£¬dropÔÙcreateµÄÇëÈÆÐÐ

SQL code:

select 'drop '||object_type||' ' || object_name ; '
from dba_objects
where owner = 'yourUser'

http://edu.codepub.com/2009/0616/6398.php
......

Oracle²ÎÊýÀàÐͺÍC#ÀàÐÍÎÊÌ⡾ÔÚÏߵȣ¡£¡¡¿

´æ´¢¹ýÊÇÕâÑù¶¨ÒåµÄ

create or replace procedure PROC_ReportStoreBanBao1(stime    in varchar2,
                        &n ......

½èˮԴÈËÆø£¡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ºÅ