CentOS 5ϰ²×°Oracle 11g
Ê×ÏÈÐèÒªµÄÈí¼þÓУº
1¡¢
linux_11gR1_database.zip
//¿ÉÔÚOracleµÄ
¹Ù·½ÍøÕ¾
ÏÂÔØµÃµ½£¬ÓÐ1.71GB¹»´ó°É¡£
2¡¢ ±ðÍüÁË×¼±¸Ò»·ÝOracleµÄ¹Ù·½°ïÖúÎĵµ
£¬ÊÇ×îȨÍþµÄ¡£
3¡¢
CentOS-5.2-i386-bin-DVD.iso
//¿ÉÔÚCentOS
¹Ù·½ÍøÕ¾
ÏÂÔØµÃµ½£¬ÓÐ3.74GB³¬¼¶´ó¡£ºÇºÇ£¡£¡£¡
ÕâЩ׼±¸¹¤×÷×öºÃÁËÖ®ºó£¬ÎÒÃǾͿªÊ¼°²×°Linux²Ù×÷ϵͳ£¬ÔÚÐéÄâ»úÖа²×°£¬Ïêϸ°²×°¹ý³ÌÕâÀï¾Í²»ÃèÊö£¬²»¹ý£¬ÖµµÃÌáÐѵÄÊÇÐéÄâ»úÔÚÅäÖÃÐéÄâÓ²¼þ»·¾³
ʱ£¬ÄÚ´æ±ØÐë´óÓÚ»òµÈÓÚ1G£¬Ó²Å̿ռäÖÁÉÙ15G¡£
ÔÚ°²×°ºÃÐéÄâL inux
ϵͳ֮ºó£¬ÒòΪÊDzËÄñ¼¶µÄÂËùÒÔÖ»ÓÐÔÚͼÐνçÃæÏÂÀ´²Ù×÷ÁË¡£½«ÊÂÏÈÏÂÔØºÃµÄ linux_11gR1_database.zip ¿½±´ÖÁLinuxÐéÄâ»úÀï±ß£¬½¨Á¢Ò»¸ö´æ·ÅĿ¼È磺
/u01/linux_11gR1_database.zip
½«Æä½âѹ£¬ÔÚÖÕ¶ËÊäÈëЩÃüÁîÖ´ÐУº
[root@oracle
u01]# unzip linux_11gR1_database.zip
½âѹºóµÄ´æ·ÅÎļþ¼ÐÃûΪ database
Ê×ÏȲ鿴ÄãLinuxÄں˰汾ÊÇ·ñ·ûºÏoracle°²×°Ìõ¼þ£º
[root@oracle
u01]# cat /proc/version
È·¶¨Äں˰汾ºó£¬¼ì²é´Ë°æ±¾Linux»·¾³Ï°²×°OracleËùÐèÒªÓõ½µÄ°ü£º
[root@oracle
u01]# rpm -qa | grep <package_name>
binutils-2.17.50.0.6-2.el5
compat-libstdc++-33-3.2.3-61
elfutils-libelf-0.125-3.el5
elfutils-libelf-devel-0.125
gcc-4.1.1-52
gcc-c++-4.1.1-52
glibc-2.5-12
glibc-common-2.5-12
glibc-devel-2.5-12
glibc-headers-2.5-12
libaio-0.3.106
libaio-devel-0.3.106
libgcc-4.1.1-52
libstdc++-4.1.1
libstdc++-devel-4.1.1-52.e15
make-3.81-1.1
sysstat-7.0.0
unixODBC-2.2.11
unixODBC-devel-2.2.11
Èô¼ì²éÖ®ºóËùȱʧµÄ°ü£¬ÔÚ CentOS-5.2-i386-bin-DVD.iso ÖÐ CentOS Ŀ¼ÖÐÕÒµ½¶ÔÓ¦µÄ°üÃû£¬¸´ÖÆ
/u01/rpmpackage
ÎļþÖС£»òÕßÖ±½Ó°²×°ÕâЩÎÒ»òÕß¿ÉÒÔͨ¹ýÃüÁîµÄ·½Ê½°²×°ÕâЩ°ü£º
[root@oracle
u01]# rpm -ivh <package_name>.rpm
¼ì²éÖ÷»úÃûÊÇ·ñÍêÕûºÏ¸ñ£º
[root@oracle
~]# cat /etc/hosts
ÒòΪÊÇ×÷Ϊ·þÎñÆ÷ʹÓã¬ËùÒÔ±ØÐëÊǾ²Ì¬µÄIP£¬ÈôÊÇDHCP·ÖÅäµÄ£¬ÔòÐÞ¸ÄΪ¾²Ì¬µÄ¡£
[root@oracle
~]# vi /etc/hosts
# Do not
Ïà¹ØÎĵµ£º
Oracle Êý¾Ý¼¯³É½â¾ö·½°¸
¡¡¡¡OracleÊý¾Ý¼¯³É½â¾ö·½°¸ÓÃÓÚÔÚSOA¡¢BIºÍÊý¾Ý²Ö¿â»·¾³Öй¹½¨¡¢²¿ÊðºÍ¹ÜÀíÒÔʵʱÊý¾ÝΪÖÐÐĵļܹ¹£¬°üº¬ÁËÊý¾Ý¼¯³ÉµÄËùÓÐÒªËØ——ʵʱÊý¾ÝÒÆ¶¯¡¢×ª»»¡¢Í¬²½¡¢Êý¾ÝÖÊÁ¿¡¢Êý¾Ý¹ÜÀíºÍÊý¾Ý·þÎñ——ÄÜÈ·±£¸÷¸ö¸´ÔÓϵͳµÄÐÅÏ¢¼°Ê±¡¢×¼È·¡¢Ò»Ö¡£
¡¡¡¡Í¨¹ýʹÓÃOracleÊý¾Ý¼¯³É£¬Æó ......
replace¾ÍÊÇÒ»°ãÒâÒåÉϵÄ×Ö·û´®Ìæ»»£¬translateÖ»ÊÇÒ»¸ö×Ö·ûÌæ»»¶ÔÓ¦µÄÒ»¸ö×Ö·û£¬ÏÂÃæÓÐÊÖ²á˵Ã÷£¬»¹ÓÐÀý×Ó O(∩_∩)O¹þ¹þ~
REPLACE
Syntax
Purpose
REPLACE returns char with every occurrence of search_string replaced with replacement_string. If replacement_string is omitted or null, then all occu ......
ORACLEÅàѵ(OCA)ÈÏÖ¤½éÉÜ
Oracle10g Certified Associate (OCA) Oracle ÈÏ֤רԱ¡£
¿¼ÊԳɼ¨Í¨¹ýÄÜ»ñµÃOracle¹«Ë¾ÎªÄú°ä·¢µÄÈ«ÇòÈÏÖ¤µÄÓ¢ÎÄOCAÖ¤Êé¡£OCAÓÉOracle¹«Ë¾³öÌâ¡£
¸ÃÖ¤Êé¿É×÷Ϊ¸÷ÆóÊÂÒµµ¥Î»Êý¾Ý¿â¹ÜÀíÈËÔ±ÉϸڵÄÒÀ¾Ý¡£
ĿǰÒѳÉΪ¸÷IT¹«Ë¾¼°Ïà¹ØÆóÒµÕùÏྺƸµÄÊý¾Ý¿â¹ÜÀíά»¤È˲ţ¬ÊÇÊý¾Ý¿âά»¤¹ÜÀíÈËÔ ......
֨װ²Ù×÷ϵͳºó,Èç¹ûÊý¾ÝÎļþ,¿ØÖÆÎļþ,ÈÕÖ¾Îļþ¶¼ÍêºÃµÄ»°(ÔÚitpub¿´¹ýºÜ¶àÈËÌá¹ýÕâ¸ö»°Ìâ,¶àÊýÈ˶¼Êǽ«Õâ3¸öÎļþ·ÅÔÚͬһĿ¼oradata),Ö»ÐèÖØÐ°²×°oracle(¸ú֨װ²Ù×÷ϵͳǰͬ°æ±¾)µ½ÔĿ¼ºó,ÖØ½¨ÊµÀý·þÎñºÍÃÜÂëÎļþ,ÅäÖÃÒ»ÏÂlistenerºÍtns¼´¿ÉÕý³£Æô¶¯Êý¾Ý¿â.
¹ý³ÌÈçÏÂ(¼ÙÉèÔʵÀýÃûΪorcl,°æ±¾Îª9i):
1.½«ÔÀ´µÄor ......
ÒÔϵÄÎÄÕÂÖ÷Òª½²ÊöµÄÊÇOracleɾ³ýÓû§±íµÄʵ¼Ê²Ù×÷·½°¸£¬±¾ÎÄÖ÷ÒªÊÇÒÔÏà¹ØÊµ¼ÊÓ¦ÓôúÂëµÄ·½Ê½À´Òý³öÆäʵ¼ÊµÄ²Ù×÷²½Ö裬ÒÔϾÍÊÇÎÄÕµľßÌåÄÚÈÝÃèÊö£¬ÍûÄãÔÚä¯ÀÀÖ®ºó»áÓÐËùÊÕ»ñ¡£
1.
select 'Drop table '||table_name||';' from all_tables where owner='Ҫɾ³ýµÄÓû§Ãû£¨×¢ÒâÒª´óд£©';
2.Oracleɾ³ýÓû§±í ÒÔÓ ......