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
Ïà¹ØÎĵµ£º
×î½ü¹¤×÷ÉÔ΢±È½Ï¿ÕÏУ¬±ã°ÑʹÓÃDBCA ´´½¨Êý¾Ý¿âʱµÄÊä³öµÄ½Å±¾ÄÃÀ´Ñо¿Ñо¿£¬²¢²ÎÕսű¾Îļþ£¬ÊÖ¶¯ÊµÏÖÒ»¸öÊý¾Ý¿âµÄ´´½¨¹ý³Ì¡£Ê×ÏÈʹÓÃDBCA¹¤¾ß´´½¨Ò»·Ý½¨¿â½Å±¾£¬Õû¸ö½Å±¾Îļþ°üº¬ÈçÏÂÎļþ£¬
¸Ð¾õÓ¦¸ÃÊÇ´ÓBATÎļþ¿ªÊ¼ÈëÊÖ£¬´ò¿ªBATÎļþ²é¿´ÄÚÈÝÈçÏ£º
mkdir f:\oracle\product\10.2.0\admin\test\adump
mkdir f:\oracl ......
OracleÊý¾Ý¿âSCNºÅÏê½â:
¡¡¡¡ÏµÍ³¼ì²éµãscn(v$database(checkpoint_change#))
¡¡¡¡Êý¾ÝÎļþ¼ì²éµã(v$datafile(checkpoint_change#))
¡¡¡¡Êý¾ÝÎļþÖÕÖ¹scn(v$datafile(last_change#))
¡¡¡¡Êý¾ÝÎļþÖдæ·ÅµÄ¼ì²éµã
¡¡¡¡Æô¶¯scn (v$datafile_header(checkpoint_change#)
¡¡¡¡1¡¢ÏµÍ³¼ì²éµãscn
¡¡¡¡µ±Ò»¸ö¼ì²éµã¶¯×÷Íê³ ......
1 ²éѯsqlÓÅ»¯
1.1 Ñ¡Ôñ×îÓÐЧÂʵıíÃû˳Ðò£¨Ö»ÔÚ»ùÓÚ¹æÔòµÄÓÅ»¯Æ÷ÖÐÓÐЧORACLE£©
½âÎöÆ÷°´ÕÕ´ÓÓÒµ½×óµÄ˳Ðò´¦Àífrom×Ó¾äÖеıíÃû£¬Òò´Ëfrom×Ó¾äÖÐдÔÚ×îºóµÄ±í£¨»ù´¡±ídriving table£©½«±»×îÏÈ´¦Àí¡£ÔÚfrom×Ó¾äÖаüº¬¶à¸ö±íµÄÇé¿öÏ£¬Äã±ØÐëÑ¡Ôñ¼Ç¼ÌõÊý×îÉٵıí ......
ת×Ô£ºhttp://blog.csdn.net/scorpio3k/archive/2009/05/09/4162079.aspx
ÔںܶàÇé¿öÏ£¬ÎÒÃÇʹÓÃHibernateÔÚÒѾ½¨Á¢ºÃÊý¾Ý¿âµÄ»ù´¡ÉÏ¡£ÔÚoracleÖУ¬Èç¹ûÒѾ½¨Á¢ºÃµÄÊý¾Ý¿âÖÐʹÓÃÁËsequence
,Ôò¿ÉÒÔ°´ÕÕÏÂÃæµÄ²½Öè°ÑËüÒýÈëµ½HibernateÖУº
1¡¢ÔÚoracle Ê×ÏÈ´´½¨sequence
......
½ñÌìÔÚ¿ª·¢µÄʱºòÐèÒª²éѯÊý¾Ý¿âÖÐÄÄЩѧÉúÓжà¸öѧºÅ£¬Ð´µÄsqlÈçÏ£º
select * from(
select count(t1.xh) as xhs,t2.uuid,t3.xm as xsxm,t3.sfzjh, t1.xjzt as xjzt from hust_xs_jb t1
INNER JOIN hust_xx_identity t2 on t1.sfid ......