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±í¿Õ¼ä²Ù×÷Ïê½â
1
2
3×÷Õߣº À´Ô´£º ¸üÐÂÈÕÆÚ£º2006-01-04
5
6
7½¨Á¢±í¿Õ¼ä
8
9CREATE TABLESPACE data01
10DATAFILE '/ora ......
ËäȻѧϰJavaºÜ¾ÃÁË£¬×Ô¼ºÒ²Á¬½Ó¹ýһЩÊý¾Ý¿â£¬±ÈÈçmysqlÖ®ÀàµÄ£¬Èç½ñÄØ£¬Ò²Ñ§Ï°ÁËÒ»¶Îʱ¼äµÄOracle£¬È»¶øÄØ£¬½ñÌìÊÇÎÒµÚÒ»´ÎÁ¬½ÓOracle£¬ºÙºÙ£¬Ó¦¸Ã»¹²»ËãÌ«³Ù°É¡£
½ñÌìÄØ£¬Óе㱿׾£¬´ó¼ÒĪЦ£¡
ÎÒÕâÊÇÒ»¸ö²éѯÀý×Ó
Ê×ÏÈ£¬Ô ......
½ñÌ츴ϰµÚÈýÕ£¬±¾À´ËãÆðÀ´Ó¦¸ÃÊǵڶþյ쬵«ÊǵڶþÕµÄÄÚÈÝÊǽéÉÜÊý¾Ý¿âµÄ¹ÜÀí¹¤¾ß£¬¶ø¶ÔÓÚÎÒÃǶøÑÔ£¬ÕâЩÏà¶ÔÀ´ËµÃ»Óжà´óµÄ±ØÒª£¬ËùÒÔ£¬ÏÖÔÚ²½È븴ϰOracleʵÀýµÄ¹ÜÀí¡£ÕâÕµÄÄÚÈݰüÀ¨³õʼ»¯²ÎÊýÎļþµÄά»¤ºÍ¹ÜÀí£¬ÒÔ¸÷ÖÖ²»Í¬µÄ·½Ê½Æô¶¯ºÍ¸ÅÄî±ÈÊý¾Ý¿âOracle Instance£¬ÒÔ¼°¶ÔOracle I ......
1. ASCII
·µ»ØÓëÖ¸¶¨µÄ×Ö·û¶ÔÓ¦µÄÊ®½øÖÆÊý;
SQL> select ascii(A) A,ascii(a) a,ascii(0) zero,ascii( ) space from dual;
A A ZERO SPACE
--------- --------- --------- ---------
65 97 48 32
2. CHR
¸ø³öÕûÊý,·µ»Ø¶ÔÓ¦µÄ×Ö·û;
SQL> select chr(54740) zhao,chr(65) chr65 from dual;
ZH C
-- -
ÕÔ A
......
ÄÇЩ·þÎñÐèÒªÆô¶¯ÐèÒª¿´Äã×Ô¼ºµÄÐèÇó£¬Ïê¼û£º
Windowsϳ£¼ûOracle·þÎñ½éÉÜ£º
£¨1£©OracleServiceSID
Êý¾Ý¿â·þÎñ£¬Õâ¸ö·þÎñ»á×Ô¶¯µØÆô¶¯ºÍÍ£Ö¹Êý¾Ý¿â¡£Èç¹û°²×°ÁË ......