linuxƽ̨ÏÂoracleÊý¾Ý¿â°²×°
×¢£º oracle¶Ôlinux°æ±¾ÓÐÒªÇ󣬻¹ÓÐËùÐèµÄpackage°ü²»ÊǺܺÃÕÒ£¬ÈçÓÐÐèÒª¿ÉÒÔ·¢email¸øÎÒ:tianlesoftware@vip.qq.com£¬ÎÒ¿ÉÒÔ´«¸øÄã.....
Steep1: ÏÂÔØÈí¼þ°ü
10201_database_linux32
openmotif21-2.1.30-14.i386.rpm
Steep3: ÉèÖÃÄں˲ÎÊý(ÔÚ/etc/sysctl.confÎļþÖмÓÈëÏÂÁÐÐÐ)
kernel.shmall = 2097152
kernel.shmmax = 2147483648
kernel.shmmni = 4096
# semaphores: semmsl, semmns, semopm, semmni
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.rmem_max=262144
net.core.wmem_default=262144
net.core.wmem_max=262144
--È»ºóÔËÐÐÏÂÃæÃüÁʹÉÏÃæµÄÉèÖÃÉúЧ
#/sbin/sysctl -p
Steep4: ½«ÏÂÃ漸ÐÐÌí¼Óµ½ /etc/security/limits.conf ÎļþÖÐ:
* soft nproc 2047
* hard nproc 16384
* soft nofile 1024
* hard nofile 65536
Steep5: ½«ÏÂÃæÒ»ÐÐÌí¼Óµ½/etc/pam.d/loginÎļþÖÐ:
session required /lib/security/pam_limits.so
Steep6: ½ûÓÃSELINUX£¬±à¼/etc/selinux/config£¬½«SELINUXÉèÖÃΪSELINUX=disabled
Steep7: °²×°ÏÂÃæÈí¼þ°ü
--´Ó Fedora Core 6 DVD ¹âÅÌÎļþ
#cd /media/dvd/Fedora/RPMS
#rpm -Uvh setarch-*
#rpm -Uvh --force tcl-*
#rpm -Uvh --force libXau-devel-* libXp-*
#rpm -Uvh compat-db-*
#rpm -Uvh compat-libstdc++-33*
#rpm -Uvh compat-libf2c-34-*
#rpm -Uvh compat-gcc-34-*
#rpm -Uvh libaio-*
#rpm -Uvh compat-gcc-34-c++-*
#rpm -Uvh compat-libstdc++-296*
#rpm -Uvh compat-libgcc-296*
--°²×°ÏÂÔصÄopenmotif21°ü
#rpm -Uvh openmotif21-2.1.30-14.i386.rpm
######
¿ÉÓÃÒ»ÌõÃüÁîÌæ´ú£º
rpm -Uvh *.rpm --force --nodeps
rpm -Uvh setarch-*
rpm -Uvh --force tcl-*
rpm -Uvh --force libXau-devel-* libXp-*
rpm -Uvh compat-db-*
rpm -Uvh compat-libstdc++-33*
rpm -Uvh compat-libf2c-34-*
rpm -Uvh compat-gcc-34-*
rpm -Uvh libaio-*
rpm -Uvh compat-gcc-34-c++-*
rpm -Uvh compat-libstdc++-296*
rpm -Uvh compat-libgcc-296*
rpm -Uvh openmotif21-2.1.30-14.i386.rpm
Steep8: Ìí¼ÓÓû§×éºÍÓû§£¬²¢Î
Ïà¹ØÎĵµ£º
OracleϵÁУº¼Ç¼£¨Record£©
Ò»£¬Ê²Ã´ÊǼǼ£¨Record£©£¿
Óɵ¥ÐжàÁеıêÁ¿¹¹³ÉµÄ¸´ºÏ½á¹¹¡£¿ÉÒÔ¿´×öÊÇÒ»ÖÖÓû§×Ô¶¨ÒåÊý¾ÝÀàÐÍ¡£×é³ÉÀàËÆÓÚ¶àάÊý×é¡£
½«Ò»¸ö»ò¶à¸ö±êÁ¿·â×°³ÉÒ»¸ö¶ÔÏó½øÐвÙ×÷¡£ÊÇÒ»ÖÖÁÙʱ¸´ºÏ¶ÔÏóÀàÐÍ¡£
¼Ç¼¿ÉÒÔÖ±½Ó¸³Öµ¡£RECORD1 :=RECORD2£»
¼Ç¼²»¿ÉÒÔÕûÌå±È½Ï. ......
1£¬Ê²Ã´ÊÇÓαꣿ
¢Ù´Ó±íÖмìË÷³ö½á¹û¼¯£¬´ÓÖÐÿ´ÎÖ¸ÏòÒ»Ìõ¼Ç¼½øÐн»»¥µÄ»úÖÆ¡£
¢Ú¹ØϵÊý¾Ý¿âÖеIJÙ×÷ÊÇÔÚÍêÕûµÄÐм¯ºÏÉÏÖ´Ðеġ£
ÓÉ SELECT Óï¾ä·µ»ØµÄÐм¯ºÏ°üÀ¨Âú×ã¸ÃÓï¾äµÄ WHERE ×Ó¾äËùÁÐÌõ¼þµÄËùÓÐÐС£ÓɸÃÓï¾ä·µ»ØÍêÕûµÄÐм¯ºÏ½Ð×ö½á¹û¼¯¡£
&n ......
FORALLÓï¾äµÄÒ»¸ö¹Ø¼üÐԸĽø£¬Ëü¿É´ó´ó¼ò»¯´úÂ룬²¢ÇÒ¶ÔÓÚÄÇЩҪÔÚPL/SQL³ÌÐòÖиüкܶàÐÐÊý¾ÝµÄ³ÌÐòÀ´Ëµ£¬Ëü¿ÉÏÔÖøÌá¸ßÆäÐÔÄÜ¡£
1:
ÓÃFORALLÀ´ÔöÇ¿DMLµÄ´¦ÀíÄÜÁ¦
OracleΪOracle8iÖеÄPL/SQLÒýÈëÁËÁ½¸öеÄÊý¾Ý²Ù×ÝÓïÑÔ£¨DML£©Óï¾ä£ºBULK COLLECTºÍFORALL¡£ÕâÁ½¸öÓï¾äÔÚPL/SQLÄÚ²¿½øÐÐÒ»ÖÖÊý×é´¦Àí
£»BULK COLLE ......
Oracle Database 10g ÌṩÁËÒ»¸öÏÔÖø¸Ä½øµÄ¹¤¾ß£º×Ô¶¯¹¤×÷¸ºÔØÐÅÏ¢¿â (AWR:Automatic Workload Repository)¡£Oracle ½¨ÒéÓû§ÓÃÕâ¸öÈ¡´ú Statspack¡£AWR ʵÖÊÉÏÊÇÒ»¸ö Oracle µÄÄÚÖù¤¾ß£¬Ëü²É¼¯ÓëÐÔÄÜÏà¹ØµÄͳ¼ÆÊý¾Ý£¬²¢´ÓÄÇЩͳ¼ÆÊý¾ÝÖе¼³öÐÔÄÜÁ¿¶È£¬ÒÔ¸ú×ÙDZÔÚµÄÎÊÌâ¡£Óë Statspack ²»Í¬£¬¿ìÕÕÓÉÒ»¸ö³ÆΪ MMON µÄеĺó ......
RMAN> startup nomount;
RMAN> sql 'alter session set nls_date_format=''yyyy-mm-dd hh24:mi:ss''";
--ÒòΪrmanĬÈÏÒÔ»·¾³±äÁ¿À´¶Áȡʱ¼ä¸ñʽ£¬ÓësqlplusµÄ¹Ì¶¨¸ñʽ²»Í¬£¬ËùÒÔ£¬´Ë´¦ÒªÉ趨ʱ¼ä¸ñʽ±äÁ¿¡£
RMAN> restore controlfile from autobackup until time '2009-03-10 18:15:00';
×¢Ò⣬ÈÔÈ»ÐèÒªÊʵ±µ ......