Oracle 10G Êý¾Ý¿âÎļþĿ¼½á¹¹
Oracle 10G Êý¾Ý¿âÎļþĿ¼½á¹¹
ÔÚOracle Database 10gÖÐ,OracleµÄĿ¼½á¹¹ÊÇÓÉOracle_Base¼°Æä×ÓĿ¼Oracle_Home¡¢admin¡¢flash_recovery_areaºÍoradataĿ¼¹¹³ÉµÄ¡£Îª·½±ãÌÖÂÛ£¬ÓÃOracle_Base´ú±íOracleĿ¼Ê÷µÄ¸ù£¬ÓÃOracle_Home±íʾ¸ùĿ¼ÏµÄÖ÷Ŀ¼¡£
1.Oracle_BaseĿ¼
Oracle_Base´ú±íOracleĿ¼Ê÷µÄ¸ù¡£Èç¹ûʹÓÃOracle Universal Installer½øÐа²×°,ÔòOracle_BaseÊÇÖ¸system_drive:\oracle\product\10.2.0¡£
2.Oracle_HomeĿ¼
Oracle_HomeÖ÷Ŀ¼λÓÚsystem_drive:\Oracle_Base֮ϣ¬Ëü°üº¬ÓëOracleÈí¼þÔËÐÐÓйصÄ×ÓĿ¼ºÍÍøÂçÎļþÒÔ¼°Ñ¡¶¨µÄ×é¼þµÈ£»ÈôÔÚÖ÷»úÉϵÚÒ»´ÎÇÒÖ»°²×°ÁËOracleÊý¾Ý¿â,ûÓÐÆäËûOracle²úÆ·£¬ÔòʹÓÃĬÈϵÄÖ÷Ŀ¼\db_1£»Èç¹ûÔÚͬһ̨Ö÷»úµÄͬһ¸ö¸ùĿ¼Ï°²×°¶à¸ö²úÆ·»ò°²×°Á˵Ú2´Î£¬ÔòOracle_HomeÖ÷Ŀ¼»áÒÔdb_nµÄÐÎʽ³öÏÖ,¼´db_2¡¢db_3µÈ¡£ÕâÒ²ÊÇΪʲôÔÚOracle_BaseĿ¼¿ÉÒÔÓжà¸öOracle_HomeĿ¼µÄÔµ¹Ê¡£
Oracle_HomeĿ¼ÖаüÀ¨µÄÖ÷Òª×ÓĿ¼ÓÐ:
?\BIN——Ö÷Òª°üº¬ÓÃÓÚÊý¾Ý¿â¹ÜÀíµÄ¸÷ÖÖÃüÁîµÈ¡£
?\css——ÓëOracle Cluster Synchronization·þÎñÓйصÄÎļþ¡£
?\dbs——´æ·ÅÊý¾Ý¿â·þÎñÆ÷¶ËµÄ²ÎÊýÎļþSpfile¡£
?\demo——´æ·ÅÊý¾Ý¿âʵÀýģʽµÄ½Å±¾µÈ¡£
? \install——ÓÃÓÚ´æ´¢ORACLE°²×°ºóµÄ¶Ë¿ÚºÅ,iSQL*PlusÒÔ¼°Enterprise Manager Database ControlÆô¶¯²¢µÇ¼µÄ·½Ê½µÈ¡£
?\network\admin——ÓйؼàÌýÆ÷listener.oraºÍsqlnet.oraÒÔ¼°tnsnames.oraµÈ¡£
?\sysman\config——ÓÃÓÚÓëOracle Enterprise ManagementÓйصĶ˿ڹÜÀíµÈ¡£
3.adminĿ¼
Êý¾Ý¿â¹ÜÀíÎļþ¾ù´æ´¢ÔÚoracle_base\admin\db_nameĿ¼Ï¡£¸÷¸ö×ÓĿ¼µÄÖ÷Òªº¬ÒåÈçÏÂ:
?\bdump——ºǫ́½ø³Ì¸ú×ÙÎļþ¡£
?\cdump——ÐÅϢת´¢Îļþ£¨core dump£©¡£
?\create——Êý¾Ý¿â´´½¨Îļþ¡£
?\exp——Êý¾Ý¿âµ¼³öÎļþ¡£
?\pfile——³õʼ»¯²ÎÊýÎļþ¡£
?\udump——Óû§SQL×·×ÙÎļþ¡£
4.OradataĿ¼
Êý¾Ý¿âÎļþ´æ´¢ÔÚOracle_Base\oradata\db_nameĿ¼ÏÂ,¸ÃĿ¼Ö÷Òª´æ´¢Êý¾Ý¿âµÄ¿ØÖÆÎļþ¡¢Êý¾ÝÎļþ¡¢ÖØ×öÈÕÖ¾Îļþ¡£ÆäÖÐ*.dbfÎļþ¶ÔÓ¦Êý¾Ý¿âÖÐÿ¸ö±í¿Õ¼ä£».ctlÎļþΪ¿ØÖÆÎļþ£».logÎļþ¶ÔÓ¦ÖØ×öÈÕÖ¾Îļþ×é¼°Æä³ÉÔ±¡£
5.flash_recovery_areaĿ¼
flash_recovery_areaĿ¼´æ´¢²¢¹ÜÀíÓ뱸·
Ïà¹ØÎĵµ£º
Ëø¶¨µÄ¸ÅÄËø¶¨ÊÇÊý¾Ý¿âÓÃÀ´¿ØÖƹ²Ïí×ÊÔ´²¢·¢²¼·ÃÎʵĻúÖÆ¡£ÔÚ¶àÓû§»·¾³Ï£¬¶à¸öÓû§¿Éͬʱ·ÃÎÊÏàͬµÄÊý¾Ý¡£Oracle ÌṩËøÒÔÈ·±£ÔÚ¶àÓû§»·¾³ÏÂÊý¾ÝµÄÍêÕûÐÔºÍÒ»ÖÂÐÔ¡£ÔÚÌá½»»ò»Ø¹öÊÂÎñ֮ǰ£¬Oracle »áËø¶¨Õý±»Ð޸ĵÄÊý¾Ý¡£ÔÚÓû§Íê³É»ò»Ø¹öÊÂÎñÖ®ºó£¬Ëø»á×Ô¶¯ÊÍ·Å¡£Ö»ÓÐÔÚÌá½»»ò»Ø¹öÊÂÎïÖ®ºó£¬ÆäËûÓû§²Å¿ÉÒÔ¸üÐÂÕâЩÊý ......
BlobÊÇÖ¸¶þ½øÖÆ´ó¶ÔÏóÒ²¾ÍÊÇÓ¢ÎÄBinary Large ObjectµÄËùд£¬¶øClobÊÇÖ¸´ó×Ö·û¶ÔÏóÒ²¾ÍÊÇÓ¢ÎÄCharacter Large ObjectµÄËùд¡£Óɴ˿ɼûÕâÁ¾¸öÀàÐͶ¼ÊÇÓÃÀ´´æ´¢´óÁ¿Êý¾Ý¶øÉè¼ÆµÄ£¬ÆäÖÐBLOBÊÇÓÃÀ´´æ´¢´óÁ¿¶þ½øÖÆÊý¾ÝµÄ£»CLOBÓÃÀ´´æ´¢´óÁ¿Îı¾Êý¾Ý¡£
ÄÇôÓÐÈ˿϶¨ÒªÎʼÈÈ»ÒѾÓÐVARCHARºÍVARBINARYÁ½ÖÐÀàÐÍ£¬ÎªÊ²Ã´»¹ÒªÔÙÊ ......
oracle±äÁ¿ÀàÐÍ
±êÁ¿ÀàÐÍ
varchar2(n) ÓÃÓÚ¶¨Òå¿É±ä³¤¶ÈµÄ×Ö·û´® nÓÃÓÚÖ¸¶¨×Ö·û´®µÄ×î´ó³¤¶È Æä×î´óֵΪ32767×Ö½Ú ±ØÐëÖ¸¶¨n
char(n) ÓÃÓÚ¶¨Òå¹Ì¶¨³¤¶ÈµÄ×Ö·û´® ÆäÖÐnÓÃÓÚÖ¸¶¨×Ö·û´®µÄ×î´ó³¤¶È£¬Æä×î´óֵΪ32767 Èç¹û²»Ö¸¶¨n ĬÈÏÊÇ1
number(p,s)¸ÃÊý¾ÝÀàÐÍÓÃÓÚ¶¨Òå¹Ì¶¨³¤¶ÈµÄÕûÊýºÍ¸¡µã ......
package cn.edu.bit.test;
import java.sql.*;
public class Jdbc {
public static void main(String[] args)
{
try{
Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
System.out.p ......
DBA Ö°Ôð¼°ÈÕ³£¹¤×÷Ö°Ôð:
1.°²×°ºÍÉý¼¶Êý¾Ý¿â·þÎñÆ÷,ÒÔ¼°Ó¦ÓóÌÐò¹¤¾ß¹¹½¨ºÍÅäÖÃÍøÂç»·¾³.
2.ÊìϤÊý¾Ý¿âϵͳµÄ´æ´¢½á¹¹Ô¤²âδÀ´µÄ´æ´¢ÐèÇó,Öƶ©Êý¾Ý¿âµÄ´æ´¢·½°¸.
3.¸ù¾Ý¿ª·¢ÈËÔ±Éè¼ÆµÄÓ¦ÓÃϵͳÐèÇó´´½¨Êý¾Ý¿â´æ´¢½á¹¹.
4.¸ù¾Ý¿ª·¢ÈËÔ±Éè ......