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

Oracle 10g°²×°ÊÖ²á

(1)´´½¨ Oracle ×éºÍÓû§ÕÊ»§
ÀýÈ磺
# /usr/sbin/groupadd oinstall
# /usr/sbin/groupadd dba
# /usr/sbin/useradd -m -g oinstall -G dba oracle
# id oracle
uid=501(oracle) gid=501(oinstall) groups=501(oinstall),502(dba)
ÉèÖà oracle ÕÊ»§µÄ¿ÚÁ
passwd oracle
(2)´´½¨Ä¿Â¼
ÀýÈ磺
# mkdir -p /oracle
# chown -R oracle:oinstall /oracle
# chmod -R 775 /oracle
(3)ÅäÖà Linux Äں˲ÎÊý,Ð޸ĺó²»ÓÃÖØÆô¶¯¸üÐÂ: /sbin/sysctl -p
µÚÒ»ÖÖ:´ò¿ª/etc/sysctl.conf ¸´ÖÆÈçÏÂÄÚÈÝ
kernel.shmall = 2097152
kernel.shmmax = 2147483648
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
fs.file-max = 65536
net.ipv4.ip_local_port_range = 1024 65000
net.core.rmem_default=262144
net.core.wmem_default=262144
net.core.rmem_max=262144
net.core.wmem_max=262144
(4)oracle Óû§µÄ»·¾³±äÁ¿
ÒÔ oracle Éí·ÝµÇ¼£¬²¢Í¨¹ýÔÚ .bash_profile »ò .profile£¨bash »ò ksh£©ÖÐÌí¼ÓÒÔÏÂÐУ¬½«
ORACLE_BASE Ìí¼Óµ½µÇ¼ÅäÖÃÎļþ(Ö±½Ógedit /home/oracle/.bash_profile)
Ôö¼ÓÏÂÁÐÄÚÈÝ:
export ORACLE_BASE=/oracle  
export ORACLE_HOME=$ORACLE_BASE/10.2.0/db_1    
export ORACLE_SID=fingerdb
export PATH=$PATH:$ORACLE_HOME/bin
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
(5)½âѹËõoracle 10g°²×°ÅÌ,È»ºóн¨ÖÕ¶Ë,ÔËÐÐ ./ runInstaller    (×¢Òâ´óСд)
¸´ÖƵ½/work/Ŀ¼£¬²¢½âѹ
$ unzip 10201_database_linux32.zip
$ cd database
$ ./runInstaller
×¢Ò⣺°²×°µÄʱºò²»ÄÜÓÃTelnet¹¤¾ß£¬±ØÐë±¾»úÓÃoracleÓû§½øÈë°²×°
(6)°²×°¹ý³ÌÖУ¬
Ñ¡Ôñ¸ß¼¶°²×°
ÔÚÑ¡Ôñ°²×°ÀàÐÍÖУ¬Ñ¡Ôñ¶¨ÖÆ£¬Ñ¡ÔñËùÓй¹¼þ
°²×°¹ý³ÌÖÐÐèÒªÒÔrootÉí·ÝÔËÐÐ
/oracle/oraInventory/orainstRoot.sh
/oracle/10.2.0/db_1/root.sh


Ïà¹ØÎĵµ£º

110¸öOracle ³£Óú¯ÊýµÄ×ܽá

SQLÖеĵ¥¼Ç¼º¯Êý
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;
......

110¸öOracle ³£Óú¯ÊýµÄ×ܽá3

80¡£LAST
¹¦ÄÜÃèÊö£º´ÓDENSE_RANK·µ»ØµÄ¼¯ºÏÖÐÈ¡³öÅÅÔÚ×îºóÃæµÄÒ»¸öÖµµÄÐУ¨¿ÉÄܶàÐУ¬ÒòΪֵ¿ÉÄÜÏàµÈ£©£¬Òò´ËÍêÕûµÄÓï·¨ÐèÒªÔÚ¿ªÊ¼´¦¼ÓÉÏÒ»¸ö¼¯ºÏº¯ÊýÒÔ´ÓÖÐÈ¡³ö¼Ç¼
SAMPLE£ºÏÂÃæÀý×ÓÖÐDENSE_RANK°´²¿ÃÅ·ÖÇø£¬ÔÙ°´Ó¶½ðcommission_pctÅÅÐò£¬FIRSTÈ¡³öÓ¶½ð×îµÍµÄ¶ÔÓ¦µÄËùÓÐÐУ¬È»ºóÇ°ÃæµÄMAXº¯Êý´ÓÕâ¸ö¼¯ºÏÖÐÈ¡³öнˮ×îµ ......

oracleÐÐתÁÐ

select i.sid,i.sname,i.birthday,i.schooltime,i.sphone,c.classname,a.assnname,sum(decode(subject,'ÓïÎÄ',s.score,0)) as chin,
                              ......

×Ô¶¯Íê³ÉOracle¿Í»§¶ËµÄ°²×°¼°ÆäÅäÖÃ


¡¡¡¡Ò»¡¢ÎÊÌâµÄÌá³ö
¡¡¡¡Ä¿Ç°µÄºÜ¶àÊý¾Ý¿âÓ¦ÓóÌÐòÊÇʹÓÃORACLEÊý¾Ý¿â¿ª·¢µÄclient/serverģʽ¡£ÖÚËùÖÜ
Öª£¬Ê¹ÓôËÖÖģʽÐèÒªÔÚÖÕ¶ËÉϰ²×°ORACLE¿Í»§¶ËÈí¼þ¡£Ó¦ÓóÌÐò¿ÉÒÔʹÓÃInstallShieldÈí¼þ´ò°ü³É°²×°³ÌÐò£¬ÓÉÓû§×ÔÐа²×°¡£µ«
ORACLE¿Í»§¶ËÈí¼þÒ»°ãÐèÒªÓо­ÑéµÄ¿ª·¢ÈËԱͨ¹ýÈË»ú½»»¥µÄ·½·¨°²×°£¬°²×°Íê³Éºó»¹ÐèÔ ......

³£ÓõÄһЩORACLEÃüÁî

²éÕÒÊý¾Ý¿âÖÐËùÓÐ×ֶΠ ÒÔ¶ÔÓ¦µÄ±í
select C.column_name,C.TABLE_NAME from dba_tab_columns C where owner=''
²éÿ¸ö¿ÆÄ¿class ·ÖÊýscroǰÈýÃû
select id, name, class, scro
   from (select row_number() over(partition by class order by scro desc)  cnt,
    &n ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ