linux×Ô¶¯Æô¶¯ oracle½Å±¾
×î½ü£¬ORACLEϵͳ»ù±¾µ÷ÊÔͨ¹ý£¬ÊÇʱºòÉèÖÃORACLEËæRHEL×Ô¶¯Æô¶¯Óë¹Ø±Õ·þÎñµÄʱºòÁË£¬Ö®ËùÒÔ°ÑÕâ¸öÈÎÎñ·ÅÔÚ×îºóÀ´×ö£¬ÊÇÒòΪÎÒ¾õµÃÕâ¸öÓ¦¸Ã²»»áºÜÄÑ£¬µ«ÕæÕýʵʩÆðÀ´£¬»¹ÊÇÓöµ½Á˸ö²»Ð¡µÄÕϰ
дºÃ½Å±¾£¬×¢²áºÃ·þÎñÖ®ºó£¬¾²âÊÔ£¬ORACLE¿ÉÒÔËæRHELÆô¶¯¶øÆô¶¯£¬µ«²»ÄÜËæÏµÍ³¹Ø±Õ¶ø¹Ø±Õ¡£ÔÚÍøÉÏÕҴ𰸣¬·¢ÏÖ¼¸ºõËùÓеÄÉèÖùý³ÌÌû×Ó¶¼ÊÇ´ÓͬһƪÔÑùÕÕ³¹ýÀ´µÄ£¬¸ù±¾¾ÍÐв»Í¨¡£ÌìÏÂÎÄÕÂÒ»´ó³¡£ÇóÖúËûÈË£¬Ã»Óеõ½Ò»¸öºÃµÄ½â¾ö·½°¸¡£ÎÞÄΣ¬×Ô¼º¾²ÏÂÐÄÀ´ÂýÂýÑо¿·ÖÎö£¬×ÜËãÕÒµ½ÁËÎÊÌâµÄ¹Ø¼üÔÒòËùÔÚ¡£
ÏÖÔھͰÑÎÒµÄÕû¸ö³É¹¦ÉèÖõĹý³ÌÌù³öÀ´£¬¹©´ó¼Ò²Î¿¼£¬ÒÔÆÚ´ó¼ÒÄÜÉÙ×ßÍä·£»ÁíÍ⻹ÊÇÒª¸øÆäËûÈËÒ»¸ö½¨Ò飺ÇÐĪÉúÓ²Õհᣬ¶ÏÕÂÈ¡Ò壬·ñÔòÆäº¦´óÑÉ£¡£¡
Ê×ÏÈ£¬ÒªÔÚRHELÖÐÉèÖÃÔÊÐíORACLEϵͳ×Ô¶¯Æô¶¯£¬ÒòΪĬÈÏÇé¿öÏÂÊÇÉèÖÃΪ²»ÔÊÐíµÄ¡£²Ù×÷ÈçÏ£º
ÔÚrootÕË»§ÏÂÐÞ¸Ä /etc/oratab Îļþ£º
# vi /etc/oratab
ÕÒµ½orcl=/db/app/oracle/product /11.1.0/db_1 :NÕâÒ»ÐÐ
¸ÄΪ£º
orcl=/db/app/oracle/product/11.1.0/db_1 :Y
Ò²¾ÍÊǽ«×îºóµÄN¸ÄΪY£¬Òâ˼Êǽ«²»ÔÊÐí×Ô¶¯Æô¶¯¸ÄΪÔÊÐí×Ô¶¯Æô¶¯¡£
È»ºó£¬ÊÇÐÞ¸ÄORACLE×Ô´øµÄÆô¶¯Óë¹Ø±Õ½Å±¾£¬·Ö±ðÊÇ dbstartºÍdbshut¡£Ö´ÐÐÕâÁ½¸ö½Å±¾¾Í¿ÉÒÔʵÏÖORACLE½Å±¾µÄÆô¶¯Óë¹Ø±Õ¡£
ÔÚoracleÕË»§ÏÂÐÞ¸Ä$ORACLE_HOME/bin/dbstartÎļþ£º
¸´ÖÆ´úÂë ´úÂëÈçÏÂ:
# su - ORACLE
$ cd $ORACLE_HOME/bin
$ vi dbstart
ÕÒµ½ ORACLE_HOME_LISTNER=$1ÕâÒ»ÐÐ
¸ÄΪ£º
ORACLE_HOME_LISTNER=$ORACLE_HOME
Ö®ËùÒÔ×öÕâÒ»²½£¬ÊÇÒòΪÔÚÕâ¸ö½Å±¾×Ô¶¯Éú³ÉµÄʱºò£¬Ò²¾ÍÊÇORACLE±»°²×°½øRHELµÄʱºò£¬Õâ¸ö½Å±¾²¢²»ÖªµÀÄãµÄ
ORACLE_HOME_LISTNER ÊÇʲô£¬ÏÖÔÚÒª½«Õâ¸ö²ÎÊýÏÔʾµÄдÃ÷£¬ÕâÑù¾Í²»»áÔÚÖ´ÐÐÕâ¸ö½Å±¾µÄʱºò±¨
ORACLE_HOME_LISTNERûÓб»Ö¸¶¨µÄ´íÎóÁË¡£×¢Ò⣺dbstartºÍdbshut½Å±¾ÔÚ10gÖ®ºó¾ÍÒѾ½«¼àÌýÆ÷µÄÆô¶¯Óë¹Ø±ÕºÏ²¢½øÊý
¾Ý¿âʵÀýµÄÆô¶¯Óë¹Ø±Õ½Å±¾ÀïÃæÁË¡£¶ø²»ÔÙÊǵ¥¶À·Ö¿ªµÄÁË¡£
ͬÑùµÄ·½Ê½£¬ÎÒÃÇÒ²ÒªÐÞ¸ÄdbshutµÄÕâ¸ö²ÎÊý¡£ÕâÀï¾Í²»ÔÙÏêϸд³öÁË£¬ËûÃÇÔÚͬһ¸öĿ¼Ï¡£
ÔٴΣ¬¾ÍÊÇдһ¸ö½Å±¾£¬°ÑËü×¢²áΪһ¸öϵͳ·þÎñ£¬ÈÃËüÔÚ¿ª»úÓë¹Ø»úµÄʱºòÔËÐС£ËüµÄ×÷ÓþÍÊǵ÷Óò¢Ö´ÐÐdbstartºÍdbshut¡£ÕâÑù²»
¾ÍʵÏÖÁËÊý¾Ý¿âÆô¶¯Óë¹Ø±ÕÁËÂ𣿣¡Õâ¸ö½Å±¾±»·ÅÔÚ/etc/init.dĿ¼ÖУ¬½Å±¾µÄÃû×ÖÊÇoracle11
½Å±¾ÈçÏ£º
¸´ÖÆ´úÂë ´úÂëÈçÏÂ:
#!/bin/bash
# chkconfig: 2345 99 10
# description: Startup Script for oracle Databas
Ïà¹ØÎĵµ£º
2009 Äê 4 ÔÂ 23 ÈÕ
±¾ÎÄÖÐÎÒÃÇÕë¶Ô Linux É϶àÏ̱߳à³ÌµÄÖ÷ÒªÌØÐÔ×ܽá³ö 5 Ìõ¾Ñ飬ÓÃÒÔ¸ÄÉÆ Linux ¶àÏ̱߳à³ÌµÄϰ¹ßºÍ±ÜÃâÆäÖеĿª·¢ÏÝÚå¡£ÔÚ±¾ÎÄÖУ¬ÎÒÃÇ´©²åһЩ Windows µÄ±à³ÌÓÃÀýÓÃÒÔ¶Ô±È Linux ÌØÐÔ£¬ÒÔ¼ÓÉî¶ÁÕßÓ¡Ïó¡£
±³¾°
Linux ƽ̨ÉϵĶàÏ̳߳ÌÐò¿ª·¢Ïà¶ÔÓ¦ÆäËûƽ̨£¨±ÈÈç Windows£©µÄ¶àÏß³Ì API ÓÐһЩϸ΢ ......
60.AVG(DISTINCT|ALL)
all±íʾ¶ÔËùÓеÄÖµÇ󯽾ùÖµ,distinctÖ»¶Ô²»Í¬µÄÖµÇ󯽾ùÖµ
SQLWKS> create table table3(xm varchar(8),sal number(7,2));
Óï¾äÒÑ´¦Àí¡£
SQLWKS> insert into table3 values(gao,1111.11);
SQLWKS> insert into table3 values(gao,1111.11);
SQLWKS> insert into table3 values(zhu ......
CREATE OR REPLACE TYPE ty_str_array IS TABLE OF VARCHAR2 (4000);
CREATE OR REPLACE FUNCTION fn_split (p_str IN VARCHAR2, p_delimiter IN VARCHAR2)
RETURN ty_str_split
IS
j INT := 0;
i INT := 1;
len INT := 0;
&nbs ......
select a.constraint_name, a.table_name, b.constraint_name
from user_constraints a, user_constraints b
where a.constraint_type = 'R'
and b.constraint_type = 'P'
and a.r_constraint_name = b.constraint_name
P ´ú±íÖ÷¼ü
R ´ú±íÍâ¼ü ......
nutchµÄÅÀ³æºÍËÑË÷¿ÉÒÔ˵ÊÇ·ÖÀëµÄÁ½¿é£¬ÅÀ³æ¿ÉÒÔÊÇM/R×÷Òµ£¬µ«ËÑË÷²»ÊÇM/R×÷Òµ¡£ËÑË÷ÓÐÁ½ÖÖ·½Ê½£ºÒ»Êǽ«ÅÀ³æÊý¾Ý(»òÕß³ÆË÷ÒýÊý¾Ý)·ÅÔÚ±¾µØÓ²ÅÌ£¬½øÐÐËÑË÷¡£¶þÊÇÖ±½ÓËÑË÷HDFSÖеÄÅÀ³æÊý¾Ý¡£
ÕâÀï½éÉÜÈçºÎʹÓÃnutch-1.0µÄWEBǰ¶Ë¼ìË÷±¾µØÅÀ³æÊý¾Ý£º
(1)NutchµÄËÑË÷¿ÉÒÔ¶ÀÁ¢ÓÚhadoop¼¯Èº£¬Ö»Òª½«ÅÀ³æÏÂÀ´µÄÊý¾Ýcopyµ½ÈκλúÆ ......