Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

CentOS 5ϰ²×°Oracle 11g

Oracle¹«Ë¾Ðû³ÆÔÚLinuxϰ²×°Oracle9iÊý¾Ý¿âÖÁÉÙÒªÓÐ512MBµÄÄÚ´æºÍÖÁÉÙ1GB»òÕßÁ½±¶     
ÄÚ´æ´óСµÄ½»»»¿Õ¼ä£¬¶ÔÓÚϵͳÄÚ´æ´óÓÚ2GBµÄ·þÎñÆ÷£¬½»»»¿Õ¼ä¿ÉÒÔ½éÓÚ2GB—4GBÖ®¼ä¡£     
Èç¹ûÊÇΪÁËÔÚһ̨½öÓÐ256MÄÚ´æµÄÆÕͨPC»úÉÏÊÔÓÃOracle9i£¬ÔÚ·ÖÅäÁË1GB×óÓҵĽ»»»¿Õ¼äµÄÇé¿öÏ£¬Ò²¿ÉÒÔÕý³£ÔËÐÐOracleÊý     
¾Ý¿â¡£     
Òª¼ì²éÄÚ´æ¿Õ¼ä£¬µÇ¼½øÈëLinux£¬ÔÚÃüÁîÐз½Ê½£¨bash»·¾³£©ÏÂÖ´ÐÐÈçÏÂÃüÁ     
grep MemTotal /proc/meminfo     
Òª¼ì²é½»»»¿Õ¼ä£¬ÔÚÃüÁîÐÐÏÂÖ´ÐÐÈçÏÂÃüÁ     
grep SwapTotal /proc/meminfo
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-libel


Ïà¹ØÎĵµ£º

Oracle 10GR2 DataGuard ʵÀý

server A: 10.85.10.44  SID=orcl ­
target server B: 10.85.10.43 ­
oracle version:10.2.0.1 ­
OS platform : windows XP ­
­
Data GuardĬÈÏÊÇmaximize performance£¬ ¿ÉÒÔÓÃÒÔÏÂÓï¾äÀ´½øÐÐģʽ¼äµÄÇл»¡£ ­
ALTER DATABASE SET STANDBY DATABASE TO MAXIMIZE {PROTECTION | AV ......

One good feature flashback of oracle 10g

1. use database as archive log mode and set archive dest location
alter system set LOG_ARCHIVE_DEST_1 = 'LOCATION=/u04/arch/orcl' scope=spfile;
2. configuration retention days/size/distination
ALTER SYSTEM SET DB_FLASHBACK_RETENTION_TARGET=43200; --30 days
ALTER SYSTEM SET db_recovery_file_dest_ ......

ORACLE PL/SQL ´¥·¢Æ÷(trigger)ѧϰ±Ê¼Ç

1¡¢´¥·¢Æ÷µÄ¸ÅÄî
´¥·¢Æ÷Ò²ÊÇÒ»ÖÖ´øÃûµÄPL/SQL¿é¡£´¥·¢Æ÷ÀàËÆÓÚ¹ý³ÌºÍº¯Êý£¬ÒòΪËüÃǶ¼ÊÇÓµÓÐÉùÃ÷¡¢Ö´ÐкÍÒì³£´¦Àí¹ý³ÌµÄ´øÃûPL/SQL¿é¡£Óë°üÀàËÆ£¬´¥·¢Æ÷±ØÐë´æ´¢ÔÚÊý¾Ý¿âÖв¢ÇÒ²»Äܱ»¿é½øÐб¾µØ»¯ÉùÃ÷¡£
¶ÔÓÚ´¥·¢Æ÷¶øÑÔ£¬µ±´¥·¢Ê¼þ·¢ÉúµÄʱºò¾Í»áÏÔʽµØÖ´Ðиô¥·¢Æ÷£¬²¢ÇÒ´¥·¢Æ÷²»½ÓÊܲÎÊý¡£
 
´´½¨´¥·¢Æ÷µÄÓï·¨È ......

Oracle ѧϰ±Ê¼Ç: RMAN³£ÓÃÃüÁî

1 . set database to archivelog mode
Sql´úÂë
SQL> shutdown immediate;   
Database closed.   
Database dismounted.   
ORACLE instance shut down.   
  
SQL> startup mount;   
ORACLE&n ......

Oracle·ÖÒ³²éѯÓï¾ä£¨Ò»£©

OracleµÄ·ÖÒ³²éѯÓï¾ä»ù±¾ÉÏ¿ÉÒÔ°´ÕÕ±¾Îĸø³öµÄ¸ñʽÀ´½øÐÐÌ×Óá£
 
·ÖÒ³²éѯ¸ñʽ£º
SELECT * from
(
SELECT A.*, ROWNUM RN
from (SELECT * from TABLE_NAME) A
WHERE ROWNUM <= 40
)
WHERE RN >= 21
ÆäÖÐ×îÄÚ²ãµÄ²éѯSELECT * from TABLE_NAME±íʾ²»½øÐз­Ò³µÄԭʼ²éѯÓï¾ä¡£ROWNUM <= 40ºÍRN ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ