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 ......
ceil(number) ´óÓÚ»òµÈÓÚµÄ×îСÕûÊý
floor(number) СÓÚ»òµÈÓÚµÄ×î´óÕûÊý
trunc(number,m) ÔÚÕûÊýnumberµÄmλÖýصôm¼°ÒÔºóµÄλÊý:
Èç:trunc(15.78,1)=15.7
trunc(15.78,-1)=15;
round ......
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
......
ÈçºÎÔ¶³ÌÅжÏOracleÊý¾Ý¿âµÄ°²×°Æ½Ì¨
select * from v$version;
²é¿´±í¿Õ¼äµÄʹÓÃÇé¿ö
select sum(bytes)/(1024*1024) as free_space,tablespace_name
from dba_free_space
group by tablespace_name;
SELECT A.TABLESPACE_NAME,A.BYTES TOTAL,B.BYTES USED, C.BYTES FREE,
(B.BYTES*100)/A.BYTES "% USED",(C.BYTES ......
1¡¢ÏÂÔØ°²×°Microsoft Visual Studio 2008£º
ÏÂÔØµØÖ·£ºhttp://www.microsoft.com/downloads/details.aspx?FamilyId=83C3A1EC-ED72-4A79-8961-25635DB0192B&displaylang=zh-cn£¬Õâ¸öÊÇ“Visual Studio 2008 רҵ°æ£¨90 ÌìÊÔÓð棩”¡£
°²×°²½ÖèÂÔ¡£
2¡ ......