Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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 ±í¿Õ¼ä²Ù×÷

oracle±í¿Õ¼ä²Ù×÷Ïê½â
  1
  2
  3×÷Õߣº   À´Ô´£º    ¸üÐÂÈÕÆÚ£º2006-01-04 
  5
  6 
  7½¨Á¢±í¿Õ¼ä
  8
  9CREATE TABLESPACE data01
 10DATAFILE '/ora ......

oracleÖÐblock

°´×ÊÁÏ˵V$BH²é¿´±íÀ´ÏÔʾÊý¾Ý¿âÀïÿ¸ö¶ÔÏóÀàÐ͵ÄÊý¾Ý»º³åÇøÀïÊý¾Ý¿éµÄÊýÁ¿.
È»ºó²éѯV$bh
select
   owner, object_name                 
  from
   dba_objects o,
   v$bh      &nbs ......

110¸öoracle³£Óú¯Êý×ܽá

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 10g Proc+VS2008¿ª·¢»·¾³

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¡ ......

Windowsϳ£¼ûOracle·þÎñ½éÉÜ

ÄÇЩ·þÎñÐèÒªÆô¶¯ÐèÒª¿´Äã×Ô¼ºµÄÐèÇó£¬Ïê¼û£º
Windowsϳ£¼ûOracle·þÎñ½éÉÜ£º
£¨1£©OracleServiceSID                       
  Êý¾Ý¿â·þÎñ£¬Õâ¸ö·þÎñ»á×Ô¶¯µØÆô¶¯ºÍÍ£Ö¹Êý¾Ý¿â¡£Èç¹û°²×°ÁË ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ