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

²»ÊÇ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


Ïà¹ØÎĵµ£º

oracle ±í¿Õ¼ä²Ù×÷

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

oracle¸´Ï°£¨Ò»£© Ö®OracleÌåϵ½á¹¹

      ѧϰOracle DBAÒ²°ë¸ö¶àѧÆÚÁË£¬½ñÌìÃÍÈ»²Å·¢ÏÖ£¬Ô­À´ÎÒµÄÊ黹ÊǺÜеģ¬ÉϿβÙ×÷ʱºòÒ²Ö»ÊÇÖªµÀ´ó¸ÅÔõô×ö£¬µ«ÊÇÒªÕæµÄÈ«²¿×Ô¼º×ö£¬¶ø²»È¥·­Ê黹ÊÇÓÐÒ»¶¨µÄÄѶȵģ¬ËùÒÔÄØ£¬½ñÌ쿪ʼ½«DBA´ÓÍ·¸´Ï°Ò»±é£¬Í¬Ê±ÔÙ²Ù×÷Ò»±é¡£
      µÚÒ»Õ£¬Ñ§µÄÊÇOracleµÄÌåϵ½á¹¹£ ......

[ת] proc oracle Á¬½ÓÊͷŲ»Á˵ÄÎÊÌâ

ת×Ô£ºhttp://www.91linux.com/html/article/database/oracle/20081205/14333.html
proc oracle Á¬½ÓÊͷŲ»Á˵ÄÎÊÌâ
±ÊÕß¹«Ë¾µÄÓ¦ÓÃϵͳÿ¸ôÒ»¶Îʱ¼ä£¬oracleÁ¬½Ó¾Í´ïµ½ÉÏÏÞÁË£»»³ÒÉÊÇÓ¦ÓÃûÓÐÕýÈ·µÄÊÍ·ÅoracleÁ¬½Ó£»ËµÀ´²ÑÀ¢£¬proc¶Ï¶ÏÐøÐøµÄÓÃÁ˼¸Ä꣬¿É
ÄÜÊÇÒÔǰ¹«Ë¾µÄ´úÂëдµÃÌ«ºÃÁË£¬´ÓûÓÐÈ¥¹ØÐÄ»ù±¾µÄprocÁ¬½Ó¡¢Ê ......

Exam : Oracle 1Z0 051

Exam : Oracle 1Z0-051
Title : Oracle Database: SQL Fundamentals I
1. View the Exhibit to examine the description for the SALES table.
Which views can have all DML operations performed on it? (Choose all that apply.)
A. CREATE VIEW v3
AS SELECT * from SALES
WHERE cust_id = 2034
WITH CHECK OPTI ......

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
-- ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ