CentOS5.2ÉÏ°²×°Oracle 10g 10.0.2.1.0
×¢Ò⣺ΪSWAP·ÖÅäµÄ¿Õ¼äÒª³¬¹ý1G£¬Òª²»È»ºóÃæ×°Oralce»áÒòΪ¿Õ¼ä²»×ã¶øÎÞ·¨°²×°¡£²¢ÇÒÒª¹Ø±Õ·À»ðǽ£¬¹Ø±ÕSELIINUX
ÐÞ¸ÄhostÎļþ
Hosts File
# vi /etc/hosts
192.168.10.10 oracle oracle.localdomain oracle
127.0.0.1 oracle localhost.localdomain localhost
×¢Ò⣺ÄãÒª°Ñ192.168.10.10¸Ä³ÉÄã×Ô¼ºµÄIP£¬ÎÒÕâÀïÖ»ÊÇдÎÒ±¾»úµÄIPµÄ¡£
ÉèÖÃÄں˲ÎÊý
# vi /etc/sysctl.conf
ÔÚÐÐÄ©Ìí¼ÓÒÔÏÂÄÚÈÝ
#use for oracle
#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
ÔÙÔËÐÐsysctl -pÓ¦ÓÃÒÔÉϲÎÊý
# /sbin/sysctl -p
ÉèÖÃ×î´ó´ò¿ªÎļþÊý
# vi /etc/security/limits.conf
ÔÚÐÐÄ©Ìí¼ÓÒÔÏÂÄÚÈÝ
#use for oracle
* soft nofile 65536
* hard nofile 65536
ÉèÖûỰ
# vi/etc/pam.d/login
ÐÐÄ©Ìí¼ÓÒÔÏÂÄÚÈÝ
sessionrequired /lib/security/pam_limits.so
²éѯËùÐè°²×°°üÊÇ·ñÍêÕû
ÒÔrootÓû§ÔÚÖÕ¶ËÖÐÖ´ÐÐÒÔÏÂÃüÁ
rpm -q gcc make binutils openmotif setarch compat-db compat-gcc compat-gcc-c++ compat-libstdc++ compat-libstdc++-devel
Èç¹ûûÓа²×°ÕâЩ°üµÄ»°£¬¿ÉÒÔÔÚCentOS°²×°¹âÅ̵ÄCentOSĿ¼ÏÂÕÒµ½ÏàÓ¦µÄrmpÎļþÀ´°²×°£¬Èç¹ûÄãµÄ·þÎñÆ÷¿ÉÒÔÁªÍøµÄ»°£¬Ò²¿ÉÒÔͨ¹ýyumµÄ·½Ê½ÏÂÔØ°²×°£¬ÔÚÖÕ¶ËÖÐÖ´ÐÐÒÔÏÂÃüÁ
# yum -y install setarch-2*
# yum -y install make-3*
# yum -y install glibc-2*
# yum -y install libaio-0*
# yum -y install compat-libstdc++-33-3*
# yum -y install compat-gcc-34-3*
# yum -y install compat-gcc-34-c++-3*
# yum -y install gcc-4*
# yum -y install libXp-1*
# yum -y install openmotif-2*
# yum -y install compat-db-4*
°´ÃüÁîÌáʾµÄÏÂÔØ°²×°£¬ËùÐèµÄʱ¼äÈ¡¾öÓÚÄãµÄÍøËÙ¡£Èç¹û²»ÄÜÉÏÍøÔò¿ÉÒÔ´Ó¹âÅÌ°²×°¾ßÌåµÄ°²×°·½·¨ÊÇÏȹÒÔعâÇýʹÓà mount /dev/cdrom /media È»ºócd /media ¾Í¿ÉÒÔ½øÈë¹âÅÌĿ¼ÁË¡£ÔÙʹÓÃrpm -ivh xxx.rpm¸ñʽÀ´°²×°¡££¨×¢ÒâXXXΪÄãÒª°²×°µÄ°²×°°üÃû×Ö£©
¿ÉÄÜ°²×°ÍêÁËÒÔºóÓÃÉÏÊöÃüÁî²é¿´»¹ÊÇ»á³öÏÖijЩ°üûÓа²×°µÄÐÅÏ¢£¬Õâ¸ö²»ÓÃÀí»á£¬¾Ý˵ÊÇrp
Ïà¹ØÎĵµ£º
ת×Ô£ºhttp://www.oracle.com/technology/obe/obe9ir2/obe-cnt/plsql/plsql.htm
¶¼Ëµ¶ÁÊé²»ÇóÉõ½âº¦ËÀÈË£¬Ò»µãÒ²²»´í£¬×î½üÎÒ´ÓÍøÉÏÌÔµ½¹ØÓÚORACLEÈçºÎ´ÓÊý¾Ý¿âĿ¼Ï¶ÁÎļþ£¬ÓÚÊǾÍÓÃÓÚÉú²úÁË£¬½á¹ûÉÏÁËÉú²ú£¬³ÌÐòËÀ»î¾ÍÊÇÅܲ»³öÀ´£¬ÔÒòÊÇÎÒÃǵķþÎñÆ÷×öÁËREC£¬Èç¹ûÔÚÁ½Ì¨»úÆ÷ÉÏÕÒÒ»¸öĿ¼ÄØ£¬ÒÔÇ°ÄØÔÚ×Ô¼ºµÄ³ÌÐòÀï°Ñ·¾ ......
ʹÓÃscott/tigerÓû§ÏµÄemp±íºÍdept±íÍê³ÉÏÂÁÐÁ·Ï°£¬±íµÄ½á¹¹ËµÃ÷ÈçÏÂ
empÔ±¹¤±í(empnoÔ±¹¤ºÅ/enameÔ±¹¤ÐÕÃû/job¹¤×÷/mgrÉϼ¶±àºÅ/hiredateÊܹÍÈÕÆÚ/salн½ð/commÓ¶½ð/deptno²¿ÃűàºÅ)
dept²¿Ãűí(deptno²¿ÃűàºÅ/dname²¿ÃÅÃû³Æ/locµØµã)
¹¤×Ê £½ н½ð £« Ó¶½ð
1£®ÁгöÖÁÉÙÓÐÒ»¸öÔ±¹¤µÄËùÓв¿ÃÅ
2£®Áгöн½ð±È& ......
-- ±Ê¼ÇÖв¿·ÖÄÚÈÝ
SQL> create table tt2 as select * from employee;
Table created.
SQL> drop table tt2;
Table dropped.
SQL> select * from tt2;
select * from tt2
*
ERROR at line 1:
ORA-00942: table or view does not exist
SQL> flashback table tt2 to before drop;
Flashback comp ......
http://tianzt.blog.51cto.com/459544/171759
´ËÎÄ´ÓÒÔϼ¸¸ö·½ÃæÀ´ÕûÀí¹ØÓÚ·ÖÇø±íµÄ¸ÅÄî¼°²Ù×÷:
1.±í¿Õ¼ä¼°·ÖÇø±íµÄ¸ÅÄî
2.±í·ÖÇøµÄ¾ßÌå×÷ÓÃ
3.±í·ÖÇøµÄÓÅȱµã
&nbs ......
Oracle°²×°Íêºó£¬ÆäÖÐÓÐÒ»¸öȱʡµÄÊý¾Ý¿â£¬³ýÁËÕâ¸öȱʡµÄÊý¾Ý¿âÍ⣬ÎÒÃÇ»¹¿ÉÒÔ´´½¨×Ô¼ºµÄÊý¾Ý¿â¡£
¶ÔÓÚ³õѧÕßÀ´Ëµ£¬ÎªÁ˱ÜÃâÂé·³£¬¿ÉÒÔÓÃ'Database Configuration Assistant'Ïòµ¼À´´´½¨Êý¾Ý¿â¡£
´´½¨ÍêÊý¾Ý¿âºó£¬²¢²»ÄÜÁ¢¼´ÔÚÊý¾Ý¿âÖн¨±í£¬±ØÐëÏÈ´´½¨¸ÃÊý¾Ý¿âµÄ ......