Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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


Ïà¹ØÎĵµ£º

oracle¼¶ÁªÉ¾³ý

oracleÖÐʹÓÃon delete cascadeºÍon delete set nullÀ´½¨Á¢Íâ¼ü
ÆäÃæÎÒÃǽéÉÜÁË´´½¨Íâ¼üÔ¼ÊøÊ±Èç¹ûʹÓÃoracleĬÈϵĴ´½¨·½Ê½£¬ÔÚɾ³ý±»²ÎÕÕµÄÊý¾Ýʱ£¬½«ÎÞ·¨±»É¾³ý£¬ÕâÒ»µãÔÚoracle9iÖиøÁËÎÒÃǸü¶àÁé»îµÄÑ¡Ôñ£¬ÎÒÃÇ¿ÉÊÇʹÓÃon delete cascadeºÍ on delete set null¹Ø¼ü×ÖÀ´¾ö¶¨É¾³ý±»²ÎÕÕÊý¾ÝʱÊÇ·ñÒª½«²ÎÕÕÕâ¸öÊý¾ÝµÄÄÇÐ ......

OracleÓï¾äÓÅ»¯£µ£³¸ö¹æÔòÏê½â

OracleÓï¾äÓÅ»¯£µ£³¸ö¹æÔòÏê½â(1)
Oracle sql ÐÔÄÜÓÅ»¯µ÷Õû    1. Ñ¡ÓÃÊʺϵÄORACLEÓÅ»¯Æ÷
        ORACLEµÄÓÅ»¯Æ÷¹²ÓÐ3ÖÖ£º
a. RULE £¨»ùÓÚ¹æÔò£©  
b. COST £¨»ùÓڳɱ¾£©
c. CHOOSE £¨Ñ¡ÔñÐÔ£©
    ÉèÖÃȱʡµÄÓÅ»¯Æ÷£¬¿ÉÒÔͨ¹ý¶ ......

Oracle 10gѧϰµãµÎ

°²×°ÍêOracle 10g£¬sql*plusµÇ½
  "Óû§Ãû³Æ£¨U£©:"ÖÐÊäÈë'system'
  "¿ÚÁP£©:"ÖÐÊäÈë'manager'
  "Ö÷»ú×Ö·û´®£¨H£©:" tnsname.oraÖÐÅäÖõķþÎñÃû(Èç¹ûÊÇϵͳĬÈÏÊý¾Ý¿â¿ÉÒÔ²»ÊäÈë)
  (×¢1£ºÕâ¸öÓû§Ãû/ÃÜÂëÊÇÔÚ°²×°¹ý³ÌÖÐ×Ô¼ºÉ趨µÄ)
  (×¢2:  Èç¹ûÉÏÊö²Ù×÷Å׳öûÓмàÌýÆ÷£¬ÔòÐè¿ ......

oracleºÍmysqlÈÕÆÚº¯Êý¶Ô±È

MySQLÈÕÆÚ×ֶηÖDateºÍTimeÁ½ÖÖ£¬oracleÈÕÆÚ×Ö¶ÎÖ»ÓÐDate£¬°üº¬ÄêÔÂÈÕʱ·ÖÃëÐÅÏ¢£¬Óõ±Ç°Êý¾Ý¿âµÄϵͳʱ¼äΪsysdate,¾«È·µ½Ã룬»òÕßÓÃ×Ö·û´®×ª»»ÈÕÆÚÐͺ¯Êý£º
 
    To_date('2001-08-01','YYYY-MM-DD'); Äê-ÔÂ-ÈÕ
    24Сʱ£º·ÖÖÓ£ºÃëµÄ¸ñʽ  'YYYY-MM-DD HH24:MI:SS'  ......

oracleÐÞ¸ÄÓû§ÃÜÂë

1¡¢Ê¹ÓÃoracleÓû§µÇ¼£¬Á¬½ÓÊý¾Ý¿â
[oracle@wuzj ~]$ sqlplus /nolog
SQL*Plus: Release 10.2.0.1.0 - Production on Thu Feb 26 12:06:29 2009
Copyright (c) 1982, 2005, Oracle.  All rights reserved.
SQL> conn /as sysdba
Connected.
//²é¿´Óû§
SQL> select username,password from dba_users;
......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ