²»ÊÇ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±í¿Õ¼ä²Ù×÷Ïê½â
1
2
3×÷Õߣº À´Ô´£º ¸üÐÂÈÕÆÚ£º2006-01-04
5
6
7½¨Á¢±í¿Õ¼ä
8
9CREATE TABLESPACE data01
10DATAFILE '/ora ......
ѧϰOracle DBAÒ²°ë¸ö¶àѧÆÚÁË£¬½ñÌìÃÍÈ»²Å·¢ÏÖ£¬ÔÀ´ÎÒµÄÊ黹ÊǺÜеģ¬ÉϿβÙ×÷ʱºòÒ²Ö»ÊÇÖªµÀ´ó¸ÅÔõô×ö£¬µ«ÊÇÒªÕæµÄÈ«²¿×Ô¼º×ö£¬¶ø²»È¥·Ê黹ÊÇÓÐÒ»¶¨µÄÄѶȵģ¬ËùÒÔÄØ£¬½ñÌ쿪ʼ½«DBA´ÓÍ·¸´Ï°Ò»±é£¬Í¬Ê±ÔÙ²Ù×÷Ò»±é¡£
µÚÒ»Õ£¬Ñ§µÄÊÇOracleµÄÌåϵ½á¹¹£ ......
ת×Ô£ºhttp://www.91linux.com/html/article/database/oracle/20081205/14333.html
proc oracle Á¬½ÓÊͷŲ»Á˵ÄÎÊÌâ
±ÊÕß¹«Ë¾µÄÓ¦ÓÃϵͳÿ¸ôÒ»¶Îʱ¼ä£¬oracleÁ¬½Ó¾Í´ïµ½ÉÏÏÞÁË£»»³ÒÉÊÇÓ¦ÓÃûÓÐÕýÈ·µÄÊÍ·ÅoracleÁ¬½Ó£»ËµÀ´²ÑÀ¢£¬proc¶Ï¶ÏÐøÐøµÄÓÃÁ˼¸Ä꣬¿É
ÄÜÊÇÒÔǰ¹«Ë¾µÄ´úÂëдµÃÌ«ºÃÁË£¬´ÓûÓÐÈ¥¹ØÐÄ»ù±¾µÄprocÁ¬½Ó¡¢Ê ......
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 ......
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
-- ......