redhat enterprise linux5.4 °²×° oracle 11g R2
Ò»£¬Ó²¼þÅäÖÃ×îµÍÒªÇó£º
32루X86£©£º
¸öÈËÈÏΪÖÁÉÙ1GÄڴ棨linux ÉÏ512M ¿ÉÒÔ£¬µ«Ì«¹ýÓÚÃãÇ¿ÁË£¬ÄÇÑùÈÝÒ×ËÀ»ú»ò¿¨×¡²»¶¯£¬»áÈÃÈË×¥¿ñµÄ;
windows 512M µÄ¿Ï¶¨²»ÐУ©
10GµÄ¿ÉÓôÅÅ̿ռ䣺3.5GÓÃÓÚÈí¼þ£¬1.5GÓÃÓÚÊý¾Ý¿â£¬ 3GÓÃÓÚOEL5£¬ 2GÓÃÓÚ½»»»¿Õ¼ä
64 λ (x86_64)
10.5 GB µÄ¿ÉÓôÅÅ̿ռ䣨4 GB ÓÃÓÚ Oracle Èí¼þ + 1.5 GB ÓÃÓÚÊý¾Ý¿â + 3 GB ÓÃÓÚ OEL5 + 2 GB ½»»»¿Õ¼ä£©
×¢£ºLinux ºÍ Oracle ±ØÐë°²×°ÔÚͬһÌåϵ½á¹¹ÉÏ¡£32 λ Oracle Ö»ÄÜÔËÐÐÓÚ 32 λ Linux Ö®ÉÏ£¬
64 λ Oracle Ö»ÄÜÔËÐÐÓÚ 64 λ Linux Ö®ÉÏ¡£
oracle 11g R2 µÄÅäÖÃÒª±ÈÎÒÉÏÃæÁгöµÄÄÚ´æÒªÇóÒª¸ü¸ß£¬µ±È»ÎÒÄÇÑùµÄÅäÖÃÒѰ²×°³É¹¦¡£
ÁíÍ⣺¾¡¿ÉÄܰ²×°ÔÚ´ÅÅ̿ռä½Ï´óµÄ£¬Òª²»ºÜÈÝÒ××°µ½Ò»°ë³öÏÖÏñÊǰ²×°²»ÏÂÈ¥µÄ¼ÙÏ󣬽ø¶ÈÌõһֱͣÔÚÄÇÀï²»¶¯¡£
»áÈÃÈËÒÔΪ×Ô¼º°²×°Ç°×öµÄÅäÖù¤×÷ÓÐÎÊÌ⣬Æäʵ²»ÊÇÄÇÑùµÄ£¬Ö»ÒªÃ»Óе¯³ö´íÎóÐÅÏ¢µÄ»°Ó¦¸Ãûʲô´óÎÊÌâ¡£
²é¿´Ó²Å̺ͽ»»»ÇøµÄ¿Õ¼äÇé¿ö£¬²¢ÊÔ×ÅÀ©´óÓ²Å̵ĿռäºÍ½»»»¿Õ¼ä¡££¨Èç¹ûÓе¯³ö˵ʲô°üÕÒ²»µ½¾ÍÁíµ±±ðÂÛ£©
¶þ£¬ÅäÖû·¾³£º£¨32룩
¼ì²é°²×°11gËùÐèµÄ°üÈ«²»È«
ËùÐè°üÃû£º£¨ÏÂÃæÕâЩ°üÒ»°ãÊÇÔÚCD1ºÍCD2£¬ÉÏÍøÕÒ×ÜÊÇ»áÕÒµ½Óë×Ô¼ºÏµÍ³ÊDz»¼æÈݵ쬽¨Òé²»Òª£©
°²×°Ç°×îºÃÊǼì²éÈ«Ãæ£¬Ò»¸ö²»ÒªÉÙ£¬Òª²»ºóÃæºÜÂé·³
compat-libstdc++-33-3.2.3-61
elfutils-libelf-0.125-3.el5
elfutils-libelf-devel-0.125-3.el5
glibc-2.5-12
glibc-devel-2.5-12
glibc-common-2.5-12
gcc-4.1.1-52.el5
gcc-c++-4.1.1-52.el5
libgcc-4.1.1-52.el5
libaio-0.3.106-3.2
libaio-devel-0.3.106-3.2
libstdc++-4.1.1-52.el5
libstdc++
Ïà¹ØÎĵµ£º
Àí½â
Linux
µ÷ÓŲÎÊý
ÔÚÎÒÃǽéÉÜ
Linux
ϵͳµÄ¸÷ÖÖµ÷ÓŲÎÊýºÍÐÔÄÜ
¼à²â¹¤¾ß֮ǰ£¬ÐèÒªÏÈÌÖÂÛһЩ¹ØÓÚÐÔÄܵ÷ÓŵIJÎÊý¡£ÒòΪ
Linux
ÊÇÒ»¸ö¿ªÔ´²Ù×÷ϵͳ£¬ËùÒÔÓÖ´óÁ¿¿ÉÓõÄÐÔÄܼà²â¹¤¾ß¡£¶ÔÕâЩ¹¤¾ßµÄÑ¡ÔñÈ¡¾öÓÚÄãµÄ¸öÈËϲºÃºÍ¶ÔÊý¾Ý
ϸ½ÚµÄÒªÇó¡£ËùÓеÄÐÔÄܼà²â¹¤¾ß¶¼Êǰ´ÕÕͬÑùµÄ¹æÔòÀ´¹¤×÷µÄ£¬ËùÒÔÎÞÂÛÄãʹÓÃÄÄÖÖ¼ ......
ת×Ô£ºhttp://www.yayu.org/look.php?id=162
µ±´ÅÅÌ´óС³¬¹ý±ê׼ʱ»áÓб¨¾¯Ìáʾ£¬ÕâʱÈç¹ûÕÆÎÕdfºÍduÃüÁîÊǷdz£Ã÷ÖǵÄÑ¡Ôñ¡£
df¿ÉÒԲ鿴һ¼¶Îļþ¼Ð´óС¡¢Ê¹ÓñÈÀý¡¢µµ°¸ÏµÍ³¼°Æä¹ÒÈëµã£¬µ«¶ÔÎļþÈ´ÎÞÄÜΪÁ¦¡£
du¿ÉÒԲ鿴Îļþ¼°Îļþ¼ÐµÄ´óС¡£
Á½ÕßÅäºÏʹÓã ......
1 Ê×ÏÈORACLE_SIDÎÊÌâ
[oracle@paopao ~]$ echo $ORACLE_SID
orcl
ÒòΪҪ´´½¨µÄÊý¾Ý¿âÃûΪorcl1£¬ËùÒÔ¸ü¸ÄORACLE_SIDÈçÏ£º
[oracle@paopao ~]$ export ORACLE_SID=orcl1
2 ×¼±¸³õʼ»¯²ÎÊýÎļþ
##########################################################################
####
# Copyright (c) 19 ......
±¸·Ý¿ØÖÆÎļþ°üÀ¨ÈýÖÖ·½·¨£º
(1)ͨ¹ý²Ù×÷ϵͳÃüÁîÔÚÊý¾Ý¿â¹Ø±Õʱ¶Ô¿ØÖÆÎļþ½øÐÐCOPY£»
(2)ÀûÓÃALTER DATABASE BACKUP CONTROLFILE TOÃüÁ¿ØÖÆÎļþ±¸·Ýµ½¶þ½øÖÆÎļþ£»
SQL> alter database backup controlfile to 'E:\oracle\product\10.2.0\orcl\controlfile01.bak';
Êý¾Ý¿âÒѸü¸Ä¡£
(3)ÀûÓÃALTER DATABASE BACKU ......
CREATE OR REPLACE FUNCTION F_HPS_SPLIT
/*
* ¹¦ ÄÜ: split.
* ÊäÈë²ÎÊý: Liststr string
* ÊäÈë²ÎÊý: Sepe index
* ÊäÈë²ÎÊý: Sepe separator. default is ','.
* return sepeCount
*/
(
......