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
Ïà¹ØÎĵµ£º
-----------------------------------------------------------------------------------
DOS:
1. sqlplus
2.
Óû§Ãû:sqlplus ¡¢conn
ÃÜÂë:as sysdba ¡¢as sysdba
½âËø£º
3. ALTER USER DBSNMP ACCOUNT UNLOCK£»
½âËø£ºsystem
4. alter user system identified by manage ......
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Êý¾Ý¿âËø»úÖÆµÄÑо¿£¬Ê×ÏȽéÉÜÁËOracleÊý¾Ý¿âËøµÄÖÖÀ࣬²¢ÃèÊöÁËʵ¼ÊÓ¦ÓÃÖÐÓöµ½µÄÓëËøÏà¹ØµÄÒì³£Çé¿ö£¬Ìرð¶Ô¾³£Óöµ½µÄÓÉÓڵȴýËø¶øÊ¹ÊÂÎñ±»¹ÒÆðµÄÎÊÌâ½øÐÐÁ˶¨Î»¼°½â¾ö£¬²¢¶ÔËÀËøÕâÒ»±È½ÏÑÏÖØµÄÏÖÏó£¬Ìá³öÁËÏàÓ¦µÄ½â¾ö·½·¨ºÍ¾ßÌåµÄ·ÖÎö¹ý³Ì¡£
Êý¾Ý¿âÊÇÒ»¸ö¶àÓû§Ê¹ÓõĹ ......
¹ú¶¼ºÅÂëÊý¾Ý¿âÉè¼ÆËµÃ÷
V1
Îĵµ±ä¸ü¼Ç¼
ÐòºÅ
±ä¸üÄÚÈÝ˵Ã÷
°æ±¾ºÅ
°æ±¾ÈÕÆÚ
Ö´±ÊÈË
1
³õ¸å
V ......