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
Ïà¹ØÎĵµ£º
oracle±í¿Õ¼ä²Ù×÷Ïê½â
1
2
3×÷Õߣº À´Ô´£º ¸üÐÂÈÕÆÚ£º2006-01-04
5
6
7½¨Á¢±í¿Õ¼ä
8
9CREATE TABLESPACE data01
10DATAFILE '/ora ......
1. ϵͳÅäÖùý³Ì
2.1. oracle°²×°Ìõ¼þ¼ì²é
2.1.1. Ó²¼þ¼ì²é
¼ì²éÓ²¼þÇé¿öÊÇ·ñ·ûºÏoracle 10g µÄ°²×°ÒªÇó¡£ÒÔrootµÇ¼ϵͳ£¬ÓÃϱíÃüÁîÊä³öµÄÖµÓ¦´óÓÚ»òµÈÓÚ½¨ÒéÖµ¡£
¼ì²éÏîÄ¿
ÃüÁî ......
Ç¿ÖÆÇл»ÖØ×öÈÕÖ¾
ALTER SYSTEM SWITCH LOGFILE; Ç¿ÖƲúÉú¼ì²éµã
ALTER SYSTEM CHECKPOINT; ¼ä½Ó²úÉú¼ì²éµã(É趨ʵÀý»Ö¸´Ê±¼ä²»³¬¹ýmmÃë,Ò༴ִÐмì²éµãÖ®ºóÔËÐг¬¹ýÕâ¸öʱ¼ä¾ÍÔÙ´ÎÖ´Ðмì²éµã)
ALTER SYSTEM SET FAST_START_MTTR_TARGET = ÃëÊý; »ñÈ¡ÖØ×öÈÕÖ¾ÎļþÐÅÏ¢
SELECT group#, ......
http://www.51testing.com/?uid-16403-action-viewspace-itemid-101605
Ò»¡¢ORACLE10g×Ô¶¯ÊÕ¼¯Í³¼ÆÐÅÏ¢--×Ô¶¯analyze
´ÓOracle Database 10g¿ªÊ¼£¬OracleÔÚ½¨¿âºó¾ÍĬÈÏ´´½¨ÁËÒ»¸öÃûΪGATHER_STATS_JOBµÄ¶¨Ê±ÈÎÎñ£¬ÓÃÓÚ×Ô¶¯ÊÕ¼¯CBOµÄͳ¼ÆÐÅÏ¢¡£
Õâ¸ö×Ô¶¯ÈÎÎñĬÈÏÇé¿öÏÂÔÚ¹¤×÷ÈÕÍíÉÏ10£º00-6£º00ºÍÖÜÄ©È«Ìì¿ªÆ ......
DB2 תOracle
ijÌìÊÇÐÇÆÚ¼¸µÄº¯Êý
DB2:
select a.yyxe,a.zblb,a.ysdm,a.daynum,b.zjxm from zy_yspb a ,zy_zjlb b where a.ysdm=b.id and a.ksdm=10000 order by abs( a.daynum -DAYOFWEEK(current date)+1) desc,a.daynum,a.zblb
sql.executeQuery:ORA-00936: ȱʧ±í´ïʽ
Oracle :
......