OracleÊý¾Ý¿â
ɾ³ýÊý¾Ý¿â£º
1¡¢Í£Ö¹Êý¾Ý¿â·þÎñ
2¡¢É¾³ýʵÀý oradim –delete –sid liluf
3¡¢É¾³ýÊý¾Ý¿âÎļþ
ÐÂÔöÊý¾Ý¿â£º
1¡¢ ½¨Á¢Êý¾Ý¿â¡¢ÅäÖüàÌý¡¢½¨Á¢Óû§
2¡¢ ÓÃÃüÁîÆô¶¯Êý¾Ý¿â
×¢:×¢²á±íregedit HKEY_LOCAL_MACHINE-----SOFTWARE------ORACLE----HOMEO
²ÎÊýÖУºORA_LMIS_AUTOSTART=TRUE ±íʾ£ºÆô¶¯/¹Ø±Õ·þÎñʱÆô¶¯Êý¾Ý¿â
ORA_LMIS_AUTOSTART=FALSE ±íʾ£ºÆô¶¯/¹Ø±Õ·þÎñʱ²»Æô¶¯Êý¾Ý¿â
3¡¢ Æô¶¯·þÎñ
oradim -startup -sid lmis -starttype srvc
Èç¹ûÊÇ oradim -startup -sid lmis ϵͳ»á±¨´í
ORA-01031: insufficient privileges
µ«ÊDz»Ó°Ïì·þÎñµÄÆô¶¯
4¡¢ Æô¶¯Êý¾Ý¿â
1£© C:\Documents and Settings\liuf>sqlplus /nolog
2£© SQL> conn sys/liuf@lmis_liuf as sysdba
3£© SQL> select * from dual;
select * from dual
*
ERROR λÓÚµÚ 1 ÐÐ:
ORA-01034: ORACLE not available
ÓÉÓÚ²ÎÊýORA_LMIS_AUTOSTART=FALSE£¬ËùÒÔ·þÎñÆô¶¯£¬Êý¾Ý¿âûÓÐÆô¶¯
4£© SQL> startup
5¡¢ ¹Ø±ÕÊý¾Ý¿â
SQL> shutdown abort
Ö¸¶¨ÈÎÎñ¼Æ»®±¸·ÝÊý¾Ý¿â- - Oracle Tips 23
1¡¢±àдµ¼³öÅú´¦ÀíÎļþ£¨*.BAT£©
Eg: EXP liuf/**@lmis_local buffer=50000000 FILE=d:\lmissd0830.dmp LOG=d:\lmissd0830.log ōwner=liuf feedback=1000000
2¡¢Öƶ¨ÈÎÎñ¼Æ»®
¿ØÖÆÃæ°å->ÈÎÎñ¼Æ»®->Ìí¼ÓÈÎÎñ¼Æ»®£ºÌí¼ÓдºÃµÄµ¼³öÅú´¦ÀíÎļþ
3¡¢Ö¸¶¨±¸·ÝÖÜÆÚ
4¡¢ÊäÈëÆôÓÃÓû§Ãû¼°ÃÜÂë
×¢£º±ØÐëÊÇ»úÆ÷µÄÓû§ÃûºÍÃÜÂë
˵Ã÷£ºÃ¿´Î±¸·ÝµÄDMPÎļþ¶¼ÊÇÉϴεĸ²¸Ç£¬¶ø²»ÊÇDMPÎļþµÄÔö¼Ó¡£
Ô¶³Ìά»¤¹¤¾ß£PcAnyWhere - - Oracle Tips 22
Ïà¹ØÎĵµ£º
£±£º´´½¨»·¾³±äÁ¿
¡¡¡¡export $ORACLE_HOME $ORACLE_SID£¨×¼±¸½¨Á¢µÄÊý¾Ý¿âµÄSID)
£²£º½¨Á¢³õʼ»¯²ÎÊýÎļþ
¡¡¡¡$ORACLE_HOME/dbs/init$ORACLE_SID.ora (¿ÉÒÔ´ÓÒѾ½¨ºÃµÄ¿âÀïÃæÄÃ,ͨ³£ÔÚpfile ÀïÃæ£©,Ò²¿ÉÒÔ×Ô¼º½¨£º
¡¡¡¡control_files = ($ORACLE_HOME/oradata/$ORACLE_SID/control1.ctl,$ORACLE_HOME/oradata/$ORACLE ......
ÊÖÍ·ÕýÔÚ½øÐÐÒ»¸öÏîÄ¿£¬ÐèҪȫÎļìË÷£¬¾¹ýͬÊÂ×ÐϸËÑË÷·¢ÏÖ£ºoracleÌṩoracle textµÄÈ«ÎļìË÷¹¦ÄÜ¡£
oracle textµÄ¼òµ¥Ó¦ÓþͬʲâÊÔ½á¹ûÕý³££¬°´ÕÕÏîĿҪÇó(ÏîĿԤ¶¨·½°¸wordÎĵµ´æÈëÊý¾Ý¿â(blobÀàÐÍ))ʹÓÃoracle text²éѯ½á¹ûÈ·ÊÇΪ¿Õ£¬Í¬ÊÂÑо¿µ½´ËÖжϡ£
  ......
2009Äê9ÔÂOracle¹«Ë¾·¢²¼ÁËÆÚ´ýÒѾõÄOracle 11g R2£¬±¾ÏµÁÐÎÄÕ½«¸ø¶ÁÕßÒ»Ò»½Ò¿ªÐ°汾ÖеÄÐÂÌØÐÔ£¬²¢»á½éÉÜÆóÒµÈçºÎÀûÓÃÕâЩÐÂÌØÐÔ½«ÏÖÓеÄOracle 9i£¬10g£¬11g R1Éý¼¶µ½Oracle 11g R2.
¡¡¡¡¾ÀúÁËÄÑÒÔÈÌÊܵij¤Ê±¼äµÈ´ý£¬Oracle¹«Ë¾Í»È»ÔÚ9ÔÂ1·¢²¼ÁËOracle 11g R2£¬ÎÒ²»µÃ²»³ÐÈÏOracleµÄ±£Ãܹ¤×÷×öµÃ¶àôºÃ£¬ÎÒÏàÐÅOracl ......
ÎÒÃÇÒª×öµ½²»µ«»áдSQL,»¹Òª×öµ½Ð´³öÐÔÄÜÓÅÁ¼µÄSQL,ÒÔÏÂΪ±ÊÕßѧϰ¡¢ÕªÂ¼¡¢²¢»ã×ܲ¿·Ö×ÊÁÏÓë´ó¼Ò·ÖÏí£¡
£¨1£© Ñ¡Ôñ×îÓÐЧÂʵıíÃû˳Ðò(Ö»ÔÚ»ùÓÚ¹æÔòµÄÓÅ»¯Æ÷ÖÐÓÐЧ)£º
ORACLEµÄ½âÎöÆ÷°´ÕÕ´ÓÓÒµ½×óµÄ˳Ðò´¦Àífrom×Ó¾äÖеıíÃû£¬from×Ó¾äÖÐдÔÚ×îºóµÄ±í(»ù´¡±í driving table)½«±»×îÏÈ´¦Àí£ ......
Oracle,MySQL,MSSQL ServerºÍAccessÊý¾Ý¿âµÄͳ¼Æº¯Êý
ÎÒÃÇÔÚ±à³ÌÖг£ÓõÄͳ¼Æº¯ÊýÓмÆÊý,ÇóºÍ,Çó×î´óÖµ,Çó×îСֵ,Ç󯽾ù,·½²îºÍ±ê×¼²î.
·½²î(Variance)
·½²îÊDZê׼ƫ²îµÄƽ·½¡£×éÖеÄÖµ£¬ÓëËüÃÇÆ½¾ùÖµÖ®¼äÆ«Àë³Ì¶ÈµÄ¶ÈÁ¿¡£
±ê׼ƫ²î(Standard Deviation)
Ò»¸ö²ÎÊý£¬Ö¸³öÒ»ÖÖ·½Ê½£¬Ò»¸ö¸ÅÂʺ¯ÊýÒÔÕâÖÖ·½Ê½·Ö²¼ÔÚÆ½¾ùÖµ¸ ......