²»ÊÇORACLEµÄÎÊÌâ
²»ÊÇORACLEµÄÎÊÌâ
2009-12-30 15:00
ÏÂÎ翪·¢Í¬Ê´òÀ´µç»°£¬”Êý¾Ý¿â²»ºÃʹÁË”. ÃèÊöÊÇһ̨ÐÂÉϵÄСÐÍ»úIBM 570
ÉÏÖ»ÅÜORACLEÊý¾Ý¿â£¬ÊÇÐÂÒµÎñÃ÷Ìì¾ÍÒªÉÏÏßÁË¡£½ñÌì×ö²âÊÔ£¬ÔÚ²âÊÔÆÚ¼äÁ¬½ÓÊý´ïµ½110¶à¾ÍÁ¬½Ó²»ÉÏÁË£¬ÒѾÁ¬½ÓÉϵÄÒ²²Ù×÷²»ÁË¡£
ƽ̨£ºIBM AIX 570
Êý¾Ý¿â£ºORACLE9201
·ÖÎö¾ßÌå²½Ö裺
Ê×ÏÈÔ¶³ÌÁ¬½Óµ½ÏµÍ³(¿ÉÒÔʹÓöàÖÖ¹¤¾ß ÀýÈçSecureCRT)
±¾°²ÀýÖÐÎÒʹÓÃϵͳ×Ô´ø¹¤¾ß Telnet
¼ÈȻ˵ÊÇORACLEµÄÎÊÌ⣬ÄÇÎÒÃǾʹÓÊý¾Ý¿âµÄ½Ç¶ÈÈ¥ÅŲéÎÊÌâ¡£
µÚÒ»²½ ¼ì²éORACLE µÄ¸æ¾¯ÈÕÖ¾(Ö»ÒªÊÇÊý¾Ý¿âµÄÖØ´ó²Ù×÷»ò±¨´í¶¼»á¼Ç¼ÔÚÕâ¸öÈÕÖ¾ÖУ¬ËùÒÔÊ×ÏÈÒª¼ì²éÕâ¸öÈÕÖ¾) ´Ó×îÏÈ·¢ÉúÎÊÌâµÄʱ¼ä¿ªÊ¼¼ì²é¡£·¢ÏÖ²¢Ã»Óб¨´í¡£Èç¹ûÊÇORACLE²ÎÊý·½ÃæÏÞÖÆ ÀýÈç PROCESSESÕâ¸ö²ÎÊýÓÐÏÞÖÆ £¬Èç¹ûÊÇËüÓ°ÏìµÄ Ò»¶¨»á¼Ç¼ÔÚORACLEµÄ¸æ¾¯ÈÕÖ¾ÖС£¿ÉÊÇÏÖÔÚÕâ¸öÈÕÖ¾Îļþ²¢Ã»ÓмǼ¡£ËµÃ÷²»ÊÇÕâ¸ö²ÎÊýÒýÆðµÄ¡£
µÚ¶þ²½ ÓÉÓÚÊÇÁ¬½Ó²»ÉÏÊý¾Ý¿â ´Ó¼àÌý²éÆð£¬ÕâʱµÄ¼àÌýÒѾSTOP ¡£ÕÒµ½¼àÌýÈÕÖ¾ËùÔÚĿ¼¡£·ÖÎö¼àÌýÈÕÖ¾ listener.log ¶¨Î»µ½15£º00 ×îÏÈ·¢ÉúÎÊÌâµÄʱ¼ä¡£
31-DEC-2009 15:01:33 * (CONNECT_DATA=(SID=*****)(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))) * (ADDRESS=(PROTOCOL=tcp)(HOST=***********)(PORT=40707)) * establish * TNS-12500: TNS:listener failed to start a dedicated server process
TNS-12540: TNS:internal limit restriction exceeded
TNS-12560: TNS Protocol adapter error
TNS-00510: Internal limit restriction exceeded
IBM/AIX RISC System/6000 Error: 11: Resource temporarily unavailable
****ÓÐʱÄãÒª¼áÐÅ ×Ô¼ºµÄ¼¼Êõ¡£Õâ¸öºÜÖØÒª¡£ÔÚÅÅ´íʱ¡£
¸ù¾ÝÌáʾӦ¸ÃÊÇÓÐÏÞÖÆ¡£ÉÏÃæÒѾÅųýÊý¾Ý¿â²ÎÊýµÄÎÊÌâ¡£Ó¦¸ÃÊÇAIXϵͳ²ÎÊýÏÞÖÆ
AIX²Ù×÷ϵͳ²ÎÊýmaxuproc
Ö´ÐÐÏàÓ¦µÄ¼ì²é£¬·¢ÏָòÎÊýµÄÖµ²»¹»´ó£º
$ lsattr -El sys0|grep maxuproc
Ïà¹ØÎĵµ£º
ת×Ô£ºhttp://www.91linux.com/html/article/database/oracle/20081205/14333.html
proc oracle Á¬½ÓÊͷŲ»Á˵ÄÎÊÌâ
±ÊÕß¹«Ë¾µÄÓ¦ÓÃϵͳÿ¸ôÒ»¶Îʱ¼ä£¬oracleÁ¬½Ó¾Í´ïµ½ÉÏÏÞÁË£»»³ÒÉÊÇÓ¦ÓÃûÓÐÕýÈ·µÄÊÍ·ÅoracleÁ¬½Ó£»ËµÀ´²ÑÀ¢£¬proc¶Ï¶ÏÐøÐøµÄÓÃÁ˼¸Ä꣬¿É
ÄÜÊÇÒÔÇ°¹«Ë¾µÄ´úÂëдµÃÌ«ºÃÁË£¬´ÓûÓÐÈ¥¹ØÐÄ»ù±¾µÄprocÁ¬½Ó¡¢Ê ......
Çé¿öÃèÊö£º°²×°Ê±Ñ¡ÔñµÄ×Ô¶¯°²×°£¬ÓÉÓÚʱ¼ä¾ÃÔ¶Íü¼ÇÓû§Ãû¡¢ÃÜÂëÁË£¬µ¼ÖÂÏÖÔÚÊÔÁ˼¸¸öĬÈϵÄÓû§ÃûÃÜÂëºó£¬¶¼ÌáʾÎÞЧµÄÓû§Ãû¡¢ÃÜÂë¡£
½â¾ö·½·¨£ºÆô¶¯SQLPLUS£¬ÌáʾÊäÈëÓû§Ãû£¬È»ºóÊäÈësqlplus/as sysdba£¬ÃÜÂëΪ¿Õ¡£ÌáʾÁ¬½Óµ½ÐÅÏ¢£¬Á¬½Ó³É¹¦£¡
Ö´ÐÐalter user sys identified by ÃÜÂë;
ÉèÖóɹ¦£¡
ÏÖÔÚ¿ÉÒÔ´ÓEnterp ......
ORACLE SQLÐÔÄÜÓÅ»¯
ORACLE SQLÐÔÄÜÓÅ»¯ÏµÁÐ (Ò»)
1. Ñ¡ÓÃÊʺϵÄORACLEÓÅ»¯Æ÷
ORACLEµÄÓÅ»¯Æ÷¹²ÓÐ3ÖÖ:
a. RULE (»ùÓÚ¹æÔò) b. COST (»ùÓڳɱ¾) c. CHOOSE (Ñ¡ÔñÐÔ)
ÉèÖÃȱʡµÄÓÅ»¯Æ÷,¿ÉÒÔͨ¹ý¶Ôinit.oraÎļþÖÐOPTIMIZER_MODE²ÎÊýµÄ¸÷ÖÖÉùÃ÷,ÈçRULE,COST,CHOOSE,ALL_ROWS,FIRST_ROWS . Ä㵱ȻҲÔÚSQ ......
1.°²×°jdk(°æ±¾6u7);
¡¡¡¡2.ÅäÖÃjdk»·¾³±äÁ¿(°²×°Ä¿Â¼:D:\tools\java\jdk1.6.0_07):
¡¡¡¡1). JAVA_HOME = D:\tools\java\jdk1.6.0_07;
¡¡¡¡2). PathµÄ×îÇ°Ãæ×·¼Ó"D:\tools\java\jdk1.6.0_07\bin;D:\tools\java\jre1.6.0_07\bin";
¡¡¡¡3). CLASSPATH = D:\tools\java\jdk1.6.0_07\lib;D:\tools\java\jdk1.6.0_07\lib\too ......
ÔÚÊý¾Ý¿âÖо³£ÒªºÏ²¢×Ö·û´®£¬¶øºÏ²¢×Ö·û´®µÄ·½·¨Óкܶ࣬ÏÖÔÚ×ܽáÈçÏ£º
--´´½¨»á»°¼¶ÁÙʱ±í
create global temporary table TMPA
(
ID INTEGER,
NAME VARCHAR2(10)
)
on commit preserve rows;
--²åÈë¼Ç¼
insert into tmpa select 1,'aa' from dual;
insert into tmpa select 1,'bb ......