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


Ïà¹ØÎÊ´ð£º

linux + oracleÓÃXP·ÃÎʲ»ÁË

ÎÒ°²×°Ò»Ì¨redhat linux5+oracle 10gµÄ·þÎñÆ÷£¬±Ê¼Ç±¾£¨XPϵͳ£©°²×°ÁËoracle 10g¿Í»§¶Ë,½á¹ûÀÏÊdzö12560µÄ´íÎó£¬Çë¸ßÊÖÖ¸µãÒ»¶þ£¬

-A RH-Firewall-1-INPUT -m state –state NEW -m tcp -p tcp –dpor ......

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

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

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

ÇóʹÓÃt-sqlÓï¾ä½«paradoxÊý¾Ýµ¼ÈëoracleµÄ°ì·¨

ʹÓÃt-sqlÓï¾ä½«sqlserver2kÊý¾Ýµ¼ÈëparadoxµÄ¹¦ÄÜÎÒÒÑʵÏÖ£¬ÓõÄÊÇinsert into ... from table in [ODBC][ODBC;Driver=SQL Server...]µÄ°ì·¨£¬µ±ÎÒ×¼±¸Èç·¨ÅÚÖÆÍê³Éparadoxµ¼Èëoracleʱȴ²»ÐУ¬²»±¨´íµ«ÊÇÖ´ÐкóÃ»Ó ......

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

ÎÒдµÄÒ»¸öJob
declare
  job1 integer;
begin
  dbms_job.submit(job1,
    'Sale_FinanceUseFee(4,null,null,null);',
    TRUNC(SYSDATE)+1.103, ......

oracle impdpÎÊÌâ

ÎÒÓÃimpdp µ¼ÈëÊý¾Ýʱ±¨ÏÂÃæ´íÎó:
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
. . imported "EPMA"."A_ACCT_BAL":"A_ACCT_SZ"          ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ