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
ÔÙÊÔÒ»ÏÂÁ¬½Ó£¬Ó¦¸Ã²»»á³öÏÖÉÏÊö´íÎóÁË
Ïà¹ØÎĵµ£º
ѧϰOracle DBAÒ²°ë¸ö¶àѧÆÚÁË£¬½ñÌìÃÍÈ»²Å·¢ÏÖ£¬ÔÀ´ÎÒµÄÊ黹ÊǺÜеģ¬ÉϿβÙ×÷ʱºòÒ²Ö»ÊÇÖªµÀ´ó¸ÅÔõô×ö£¬µ«ÊÇÒªÕæµÄÈ«²¿×Ô¼º×ö£¬¶ø²»È¥·Ê黹ÊÇÓÐÒ»¶¨µÄÄѶȵģ¬ËùÒÔÄØ£¬½ñÌ쿪ʼ½«DBA´ÓÍ·¸´Ï°Ò»±é£¬Í¬Ê±ÔÙ²Ù×÷Ò»±é¡£
µÚÒ»Õ£¬Ñ§µÄÊÇOracleµÄÌåϵ½á¹¹£ ......
@@servername:·µ»ØÔËÐÐSQL ServerÊý¾Ý¿â±¾µØ·þÎñÆ÷µÄÃû³Æ¡£
@@remserver:·µ»ØµÇ¼¼Ç¼ÖмÇÔØµÄÔ¶³ÌSQL Server·þÎñÆ÷µÄÃû³Æ¡£
@@connections:·µ»Ø×ÔÉÏ´ÎÆô¶¯SQL ServerÒÔÀ´Á¬½Ó»òÊÔͼÁ¬½ÓµÄ´ÎÊý£¬ÓÃÆä¿ÉÈùÜÀíÈËÔ±·½±ãµØÁ˽â½ñÌìËùÓÐÊÔͼÁ¬½Ó·þÎñÆ÷µÄ´ÎÊý¡£
@@cursor_rows:·µ»Ø×îºóÁ¬½ÓÉϲ¢´ò¿ªµÄÓαêÖе±Ç°´æÔڵĺϸñ ......
oracle constraints Ó¦ÓÃ
oracle constraints¿ÉÒÔÉèÖÃΪÁ¢¼´¼ì²é»òÕßµ±Ê±ÊÂÎñÌύʱ¼ì²é¡£
¿ÉÒÔÔÚ´´½¨Ô¼ÊøµÄʱºòÖ¸¶¨ÊÇdeferrable¡£È»ºóͨ¹ýset constraints xxx set deferred»òÕßimmediate,Ò²¿ÉÒÔÔÚseesion¼¶±ðÉ趨ËùÓÐÔ¼ÊøÎªdeferred»òÕßimmediate(alter seesion set constraints deferred/immediat ......
ºÙºÙ£¬Õ⻹ÊÇÉÏÕÂ֪ʶÁË£¬Ö»Êǵ¥Ò»Ð´³öÀ´±È½ÏºÃÒ»µã£¬ÒòΪÉÏÃæµÄÊǽϻù´¡µÄ£¬²»ÔõÃ´Éæ¼°²Ù×÷£¬¶øÕâÀïÊÇͨ¹ý²Ù×÷³öÀ´µÄ£¬ºÇºÇ¡£
Ê×ÏÈ£¬´ò¿ªÊý¾Ý¿â·þÎñ£¬È»ºóͨ¹ý¿ØÖÆÌ¨´ò¿ªsqlplus£º
È»ºó½«Êý¾Ý¿âÉèÖÃΪֻ¶Á£ºalter database read only£»µ«ÊÇÄØ£¬ÕâÑùÊDz»Ä ......
Ò».×ÊÔ´ÐèÒª£º
ÖÁÉÙ1024 MBÎïÀíÄÚ´æ
1024£2048 Ðè1.5±¶µÄ½»»¥¿Õ¼ä
2048£8192 Ðè1±¶µÄ½»»¥¿Õ¼ä
8192£ Ðè0.75±¶µÄ½»»¥¿Õ¼ä
ÖÁÉÙ400 MB /tmp ÁÙʱĿ¼¿Õ¼ä
oracleÈí¼þÐèÒª1.5 GB µ½ 3.5 GB ´ÅÅ̿ռä
ĬÈÏÊý¾Ý¿âÐèÒª1.2 GB
¶þ.²é¿´ÏµÍ³×ÊÔ´Ïà¹ØÓï ......