oracle¸´Ï°£¨¶þ£© Ö®OracleʵÀýµÄ¹ÜÀí
½ñÌ츴ϰµÚÈýÕ£¬±¾À´ËãÆðÀ´Ó¦¸ÃÊǵڶþÕµģ¬µ«ÊǵڶþÕµÄÄÚÈÝÊǽéÉÜÊý¾Ý¿âµÄ¹ÜÀí¹¤¾ß£¬¶ø¶ÔÓÚÎÒÃǶøÑÔ£¬ÕâЩÏà¶ÔÀ´ËµÃ»Óжà´óµÄ±ØÒª£¬ËùÒÔ£¬ÏÖÔÚ²½È븴ϰOracleʵÀýµÄ¹ÜÀí¡£ÕâÕµÄÄÚÈÝ°üÀ¨³õʼ»¯²ÎÊýÎļþµÄά»¤ºÍ¹ÜÀí£¬ÒÔ¸÷ÖÖ²»Í¬µÄ·½Ê½Æô¶¯ºÍ¸ÅÄî±ÈÊý¾Ý¿âOracle Instance£¬ÒÔ¼°¶ÔOracle InstanceËù³öÏÖÎÊÌâ½øÐÐÕï¶ÏºÍά»¤¡£
Ò»¡¢²ÎÊýÎļþ
Ê×ÏÈÀ´¿´³õʼ»¯²ÎÊýÎļþ£¨initialization parameter files£©£ºÖ÷ÒªÓо²Ì¬²ÎÊýÎļþ£¨PFILE£©Ó붯̬²ÎÊýÎļþ£¨SPFILE£©Ö®·Ö£¬PFILEÊÇÕýÎÄÎļþ£¬¶þSPFILEÊǶþ½øÖÆÎļþ¡£
1¡¢¾²Ì¬²ÎÊýÎļþ£¨PFILE£©
ÕâÊÇÎÒ°²×°ÔÚ×Ô¼º»ú×ÓÉϵijõʼ»¯²ÎÊýÎļþ£¬ÄÇôÓÖÈçºÎÀ´´´½¨¾²Ì¬²ÎÊýÎļþÄØ£¿
¿ÉÒÔÀûÓø´ÖÆÃüÁî²úÉúËùÐèµÄ²ÎÊýÎļþ£¬µ«ÎļþÃûÒªº¬ÓÐÊý¾Ý¿âÃû×÷Ϊ±êʶ£º
copy intiorcl.ora $ORACLE_HOME\database\init???.ora
Ò²¿ÉÒÔ´Ó¶¯Ì¬ÎļþÖд´½¨£º
create PFILE [='PFILEÃû'] from SPFILE
2¡¢¶¯Ì¬·þÎñÆ÷²ÎÊýÎļþ£¨SPFILE£©
¶¯Ì¬²ÎÊýÎļþ¸ÃÈçºÎ´´½¨ÄØ£¿
create SPFILE [='SPFILEÃû'] from PFILE [='PFILEÃû']
¶þ¡¢Æô¶¯Êý¾Ý¿â
Êý¾Ý¿âÆô¶¯ÓÐÈýÖÖ״̬£ºNOMOUNT¡¢MOUNT¡¢OPEN£¬ÏÂÃæÊÇËüµÄÒ»¸öÆô¶¯×´Ì¬Í¼£º
ÄÇÊý¾ÝÖ®¼äµÄ״̬ÓÖÊÇÈçºÎ×°»»µÄÄØ£¿
alter database nomount;
alter database mount;
alter database open;
µ±È»£¬»¹¿ÉÒÔ½«Êý¾Ý¿âת»»³ÉÖ»¶Á״̬ºÍ¶Áд״̬
alter database read only;
alter database read write;
Èý¡¢¹Ø±ÕÊý¾Ý¿â
½ÓϾÍÊǹرÕÊý¾Ý¿âÁË£¬ÆäÖУ¬¹Ø±ÕÊý¾Ý¿âÓÐËÄÖÖ·½·¨£ºabort¡¢immediate¡¢transactional¡¢normalshutdown
ÆäÖеÄһЩÇé¿öÈçÏ£º
ºÙºÙ£¬ÕâÀïÆäʵÂù¼òµ¥£¬Ö»ÊÇÄØ£¬ÔÚת»»Ö»¶ÁÓë¶ÁдÖлáÓöµ½Ò»Ð©ÎÊÌ⣬ÏÂһƪ¾Í˵Ã÷Õâ¸öÎÊÌâ¡£ºÙºÙ
Ïà¹ØÎĵµ£º
ѧϰOracle DBAÒ²°ë¸ö¶àѧÆÚÁË£¬½ñÌìÃÍÈ»²Å·¢ÏÖ£¬ÔÀ´ÎÒµÄÊ黹ÊǺÜеģ¬ÉϿβÙ×÷ʱºòÒ²Ö»ÊÇÖªµÀ´ó¸ÅÔõô×ö£¬µ«ÊÇÒªÕæµÄÈ«²¿×Ô¼º×ö£¬¶ø²»È¥·Ê黹ÊÇÓÐÒ»¶¨µÄÄѶȵģ¬ËùÒÔÄØ£¬½ñÌ쿪ʼ½«DBA´ÓÍ·¸´Ï°Ò»±é£¬Í¬Ê±ÔÙ²Ù×÷Ò»±é¡£
µÚÒ»Õ£¬Ñ§µÄÊÇOracleµÄÌåϵ½á¹¹£ ......
2009-12-01 00:41:35
֮ǰ°²×°ÁËoracle 10g£¬ºóÀ´ÎªÁËÔÚC#ÀïÃæÁ¬½Óoracle£¬°²×°ÁËODAC£¬Ö®ºóÁ¬½ÓÊý¾Ý¿âʱ£¬ÌîдÊý¾Ý¿â·þÎñÃû£¬×ÜÊÇ»á³ö´í£¬Á¬½Ó²âÊÔÎÞ·¨Í¨¹ý£¬²»ÌîÊý¾Ý¿â·þÎñÃû£¬µ¹»¹¿ÉÒÔͨ¹ýÁ¬½Ó²âÊÔ
½ñÍíÖÕÓڲ鵽ÔÒòÁË¡£¡£¡£
ϵͳÊôÐÔÄÇÀïµÄ»·¾³±äÁ¿£¬pathÕâÀoracleµÄÁ½¸öĬÈÏ·¾¶£º
d:\oracle\product\10. ......
µÈ´ýʼþµÄÔ´Æð
µÈ´ýʼþµÄ¸ÅÄî´ó¸ÅÊÇ´ÓORACLE 7.0.12ÖÐÒýÈëµÄ£¬´óÖÂÓÐ100¸öµÈ´ýʼþ¡£ÔÚORACLE 8.0ÖÐÕâ¸öÊýÄ¿Ôö´óµ½ÁË´óÔ¼150¸ö£¬ÔÚORACLE 8IÖдóÔ¼ÓÐ220¸öʼþ£¬ÔÚORACLE 9IR2ÖдóÔ¼ÓÐ400¸öµÈ´ýʼþ£¬¶øÔÚ×î½üORACLE 10GR2ÖУ¬´óÔ¼ÓÐ874¸öµÈ´ýʼþ¡£
ËäÈ»²»Í¬°æ±¾ºÍ×é¼þ°²×°¿ÉÄÜ»áÓв»Í¬ÊýÄ¿µÄµÈ´ýʼþ£¬µ«ÊÇÕâЩµÈ´ýÊ ......
oracle constraints Ó¦ÓÃ
oracle constraints¿ÉÒÔÉèÖÃΪÁ¢¼´¼ì²é»òÕßµ±Ê±ÊÂÎñÌύʱ¼ì²é¡£
¿ÉÒÔÔÚ´´½¨Ô¼ÊøµÄʱºòÖ¸¶¨ÊÇdeferrable¡£È»ºóͨ¹ýset constraints xxx set deferred»òÕßimmediate,Ò²¿ÉÒÔÔÚseesion¼¶±ðÉ趨ËùÓÐÔ¼ÊøΪdeferred»òÕßimmediate(alter seesion set constraints deferred/immediat ......
ÉÌÒµ¿ªÔ´Êý¾Ý¿â³§¼ÒEnterpriseDBÓë6ÔÂ17ÈÕ·¢²¼ÁË×îеÄPostgres Plus¸ß¼¶·þÎñÆ÷°æ£¬ÆäÄ¿±êÊÇÌá¸ßÓëOracleÊý¾Ý¿âµÄ¼æÈÝÐÔ£¬EnterpriseDBÊÇ¿ªÔ´Êý¾Ý¿âPostgreSQL£¨Ò²½Ð×öPostgres£©±³ºóµÄÖ÷ÒªÉÌÒµÖ§³Ö¹«Ë¾¡£
ÆäʵPostgres Plus¸ß¼¶·þÎñÆ÷°æ²¢·ÇÍêÈ«¿ªÔ´£¬ËüÊÇÔÚ¿ªÔ´µÄPostgreSQLÊý¾Ý¿â»ù´¡Ö®ÉÏÌí¼ÓÁËÐí¶à¸½¼ÓÌØÐÔ£¬ÒÔÌá¸ßºÍO ......