Oracle²¢·¢Á¬½ÓÊýµÄÉèÖÃ
²»ÄÜÁ¬½ÓOracleÊý¾Ý¿âÁË,ÌáʾÏà¹ØµÄ´íÎó
OERR: ORA-12519 TNS:no appropriate service handler found
¿Í»§¶ËÁ¬½Ó¼äЪÐÔʧ°Ü£¬±¨´íORA-12519
Cause: the listener could not find any available service handlers that are
appropriate for the client connection.
Action: run "lsnrctl services" to ensure that the instance(s) have registered
with the listener, and are accepting connections. ¼ì²élsnrctl service £¬instanceÒѾע²á£¬
״̬ÏÔʾreadyʱ£¬¿ÉÒÔÁ¬½Ó¡£
When the listener believes the current number of connections has reached maximum load,
it may set the state of the service handler for an instance to "blocked" and begin refusing
incoming client connections with either of the following errors: ora-12519 or ora-12516
²ÉÓ÷þÎñ¶¯Ì¬×¢²áµÄ·½Ê½£¬ÓÉPMON ͨ¹ýSERVICE_UPDATE À´µÃµ½Ä¿Ç°Á¬½ÓÇé¿ö£¬µ«SERVICE_UPDATE ÓÐʱ¼ä¼ä¸ô£¬
ËùÒÔ£¬listenerÏÔʾµÄÁ¬½ÓÊýºÍµ±Ç°Êµ¼ÊµÄÁ¬½ÓÊý¿ÉÄܲ»Í¬¡£
²éѯ½â¾ö·½·¨:
²é¿´Ò»ÏÂÊý¾Ý¿âÏÖÓеĽø³ÌÊý£¬ÊÇ·ñÒѾ´ïµ½²ÎÊýprocessesµÄ´óС¡£
1.select count(*) from v$process; È¡µÃÊý¾Ý¿âÄ¿Ç°µÄ½ø³ÌÊý¡£
2.select value from v$parameter where name = 'processes'; È¡µÃ½ø³ÌÊýµÄÉÏÏÞ¡£
3.ÈçÒÑ´ïµ½ÉÏÏÞ£¬ÐÞ¸ÄinitSID.oraÖеÄprocessesµÄ´óС¡£
4.ÖØÐÂÆô¶¯Êý¾Ý¿âµ½nomount״̬Ï£¬Ö´ÐÐcreate spfile from pfile; ²¢startup open¡£
²éѯÊý¾Ý¿â×ÔÆô¶¯ÒÔÀ´×î´óµÄ²¢·¢ÊýÁ¿
ÐÞ¸Ä×î´óÁ¬½ÓÊý:
alter system set processes = 300 scope = spfile;
ÖØÆôÊý¾Ý¿â:
shutdown immediate;
startup;
--²é¿´
Ïà¹ØÎĵµ£º
µ±ÔËÐÐsqlplus.shµÄʱºò±¨³ö£º
/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/nls_lang.sh: 114: [[: not found
ºÜÆæ¹Ö
nls_lang.shµÄ114ÐÐÇ°ºóÊÇÕâÑùµÄ
if [[ -n "$LC_ALL" ]]; then
locale=$LC_ALL
elif [[ -n "$LANG" ]]; then
locale=$LANG
else
locale=
fi
[[ÓдíÎ󣿲»¿ ......
sql server
Ìæ»»null:isnull(arg,value)
Èç:select isnull(price,0.0) from orders ,Èç¹ûpriceΪnullµÄ»°£¬ÓÃ0 ......
¡¡¡¡¿Í»§ÓõÄÊý¾Ý¿âÊÇmysql£¬¶øÑз¢ºÃµÄ²úÆ·Ö§³Öoracle£¬ÎªÁËÈÿͻ§ÌÍÑü°ü£¬ÎÒÃDZØÐë°ÑÊý¾Ý¿â»·¾³´ÓoracleתÏòmysql¡£ÎÒÃÇÔÚת»»µÄ¹ý³ÌÖÐÅöµ½ÁËÏÂÃæһЩÎÊÌ⣬ϣÍûÄܸøͬÑùÔâÓöµÄͬÈÊÃÇһЩ½è¼ø¡£Èç¹ûÎÒÃÇÔÚ×î³õµÄÉè¼Æ¡¢±àÂë¹ý³ÌÖÐ×¢ÒâÊý¾Ý¿âµÄÒÆÖ²ÐÔ£¬ÕâÖÖÇé¿öÏ¿ÉÒÔÍêÈ«²»ÐèÒª×÷¶îÍ⹤×÷¡£
¡¡¡¡Ò»¡¢Êý¾Ý¿â»·¾³´Óoracleת ......
oracleÖеÄtz_offsetÊÇÓÃÀ´·µ»Ø¸ø¶¨Ê±ÇøÓë±ê׼ʱÇø(UTC universal of time Coordinate ͨÓÃʱ¼ä×ø±ê)µÄÆ«ÒÆÁ¿£¬Æä²ÎÊý¿ÉÒÔÊÇ£º
1.Ò»¸öºÏ·¨µÄʱÇøÃû
2.Ò»¸öÀëUTCµÄ±ê׼ƫÒÆÁ¿
3.¹Ø¼ü×ÖSessionTimeZone»òÕßÊÇDB_timezone
ÆäÖкϷ¨µÄʱÇøÃû¿ÉÒÔ´ÓϵͳÊÓͼV$TimeZone_namesÖеÄÁÐTZnameÖеĵõ½£º
TZNAME
— ......