OracleÊý¾Ý¿â»¹Õæ²»ºÃÕû
´ÓÔÚLinuxÉϰ²×°Oracleµ½Í¶ÈëʹÓòż¸Ì죬Åöµ½µÄÎÊÌâ¾Í³É°ÙÉÏǧµÄ¡£ÔÚʹÓÿͻ§¶ËÁ¬½ÓÔ¶³ÌOracleÊý¾Ý¿â·þÎñÆ÷ʱ£¬³öÏÖÁËlistener refused the connection with the following error ora-12519 Listener refused the connection with the following error:ORA-12519, TNS:no appropriate service handler foundThe Connection descriptor used by the client was: xxx
¸Õ¿ªÊ¼ÒÔΪÊǿͻ§¶Ëlistenerû¸ãºÃ£¬¸ãÁ˺ó¤Ê±¼ä»¹ÊDz»ÄÜÁ¬½Ó³É¹¦¡£
ºóÀ´¾ÍµÇ¼Êý¾Ý¿â·þÎñÆ÷£¬Ö´ÐÐsqlplus¿´¿´Êý¾Ý¿âÊÇ·ñÕý³££¬µ«È´³öÏÖÁËORA-00020: maximum number of processes (%s) exceededµÄ´íÎó£¬Õâ²Å»ÐÈ»´óÎò¡£°¥ ÓÐÀË·ÑÕâô¶àʱ¼ä¡£
µ½ÍøÉÏËÑÁËÒ»°Ñ£¬ÕÒµ½Á˽â¾ö·½·¨¡£
1. ÒÔÏȰÑÄãµÄÓ¦ÓóÌÐò¹Ø±Õ£¬ÕâÑù¾Í½µµÍÁËoracleµÄÁ¬½ÓÊý
2. ÒÔsysdbaÉí·ÝµÇ¼Êý¾Ý¿â
3. Ö´ÐÐshow parameter process, ¿´¿´processesµÄÖµÊǶàÉÙ
4. Ö´ÐÐ alter system set processes = <±ÈÄã¸Õ²Å¿´µ½µÄprocessesÖµ´óµÄÊý×Ö> scope=spfile
ÔÙÊÔÒ»ÏÂÁ¬½Ó£¬Ó¦¸Ã²»»á³öÏÖÉÏÊö´íÎóÁË
Ïà¹ØÎĵµ£º
ËäȻѧϰJavaºÜ¾ÃÁË£¬×Ô¼ºÒ²Á¬½Ó¹ýһЩÊý¾Ý¿â£¬±ÈÈçmysqlÖ®ÀàµÄ£¬Èç½ñÄØ£¬Ò²Ñ§Ï°ÁËÒ»¶Îʱ¼äµÄOracle£¬È»¶øÄØ£¬½ñÌìÊÇÎÒµÚÒ»´ÎÁ¬½ÓOracle£¬ºÙºÙ£¬Ó¦¸Ã»¹²»ËãÌ«³Ù°É¡£
½ñÌìÄØ£¬Óе㱿׾£¬´ó¼ÒĪЦ£¡
ÎÒÕâÊÇÒ»¸ö²éѯÀý×Ó
Ê×ÏÈ£¬Ô ......
Ò»¡¢Ê²Ã´ÊÇOracle×Ö·û¼¯
Oracle×Ö·û¼¯ÊÇÒ»¸ö×Ö½ÚÊý¾ÝµÄ½âÊ͵ķûºÅ¼¯ºÏ,ÓдóС֮·Ö,ÓÐÏ໥µÄ°üÈݹØÏµ¡£ORACLE Ö§³Ö¹ú¼ÒÓïÑÔµÄÌåϵ½á¹¹ÔÊÐíÄãʹÓñ¾µØ»¯ÓïÑÔÀ´´æ´¢£¬´¦Àí£¬¼ìË÷Êý¾Ý¡£ËüʹÊý¾Ý¿â¹¤¾ß£¬´íÎóÏûÏ¢£¬ÅÅÐò´ÎÐò£¬ÈÕÆÚ£¬Ê±¼ä£¬»õ±Ò£¬Êý×Ö£¬ºÍÈÕÀú×Ô¶¯ÊÊÓ¦±¾µØ»¯ÓïÑÔº ......
oracle constraints Ó¦ÓÃ
oracle constraints¿ÉÒÔÉèÖÃΪÁ¢¼´¼ì²é»òÕßµ±Ê±ÊÂÎñÌύʱ¼ì²é¡£
¿ÉÒÔÔÚ´´½¨Ô¼ÊøµÄʱºòÖ¸¶¨ÊÇdeferrable¡£È»ºóͨ¹ýset constraints xxx set deferred»òÕßimmediate,Ò²¿ÉÒÔÔÚseesion¼¶±ðÉ趨ËùÓÐÔ¼ÊøÎªdeferred»òÕßimmediate(alter seesion set constraints deferred/immediat ......
Èç¹ûÄãÒª°ÑOracleÀïµÄ´óÁ¿Êý¾Ý(80MÒÔÉÏ)×ªÒÆµ½ÁíÍâµÄÓû§£¬ÁíÍâµÄ±í¿Õ¼äÀï¡£¿ÉÒÔÓÃÏÂÃæ½éÉܵĿìËÙ×ªÒÆÊý¾ÝµÄ·½·¨¡£
Ò»¡¢½¨Ð±íµÄ·½Ê½
create table target_tablename tablespace
target_tablespace_name nologging
pctfree 10 pctused 60
storage(initial 5M next 5M minextents 1
maxextents unlimited pctincr ......
½ñÌ츴ϰµÚÈýÕ£¬±¾À´ËãÆðÀ´Ó¦¸ÃÊǵڶþյ쬵«ÊǵڶþÕµÄÄÚÈÝÊǽéÉÜÊý¾Ý¿âµÄ¹ÜÀí¹¤¾ß£¬¶ø¶ÔÓÚÎÒÃǶøÑÔ£¬ÕâЩÏà¶ÔÀ´ËµÃ»Óжà´óµÄ±ØÒª£¬ËùÒÔ£¬ÏÖÔÚ²½È븴ϰOracleʵÀýµÄ¹ÜÀí¡£ÕâÕµÄÄÚÈݰüÀ¨³õʼ»¯²ÎÊýÎļþµÄά»¤ºÍ¹ÜÀí£¬ÒÔ¸÷ÖÖ²»Í¬µÄ·½Ê½Æô¶¯ºÍ¸ÅÄî±ÈÊý¾Ý¿âOracle Instance£¬ÒÔ¼°¶ÔOracle I ......