ORACLEÊý¾Ý¿âÓû§ÓëȨÏÞ¹ÜÀí
ORACLEÊǶàÓû§ÏµÍ³£¬ËüÔÊÐíÐí¶àÓû§¹²Ïíϵͳ×ÊÔ´¡£ÎªÁ˱£Ö¤Êý¾Ý¿âϵͳµÄ°²È«£¬Êý¾Ý¿â¹ÜÀíϵͳÅäÖÃÁËÁ¼ºÃµÄ°²È«»úÖÆ¡£
2. 1 ORACLEÊý¾Ý¿â°²È«²ßÂÔ
½¨Á¢ÏµÍ³¼¶µÄ°²È«±£Ö¤
ϵͳ¼¶ÌØȨÊÇͨ¹ýÊÚÓèÓû§ÏµÍ³¼¶µÄȨÀûÀ´ÊµÏÖ£¬ÏµÍ³¼¶µÄȨÀû£¨ÏµÍ³ÌØȨ£©°üÀ¨£º½¨Á¢±í¿Õ¼ä¡¢½¨Á¢Óû§¡¢ÐÞ¸ÄÓû§µÄȨÀû¡¢É¾³ýÓû§µÈ¡£ÏµÍ³ÌØȨ¿ÉÊÚÓèÓû§£¬Ò²¿ÉÒÔËæʱ»ØÊÕ¡£ORACLEϵͳÌØȨÓÐ80¶àÖÖ¡£
½¨Á¢¶ÔÏ󼶵ݲȫ±£Ö¤
¶ÔÏó¼¶ÌØȨͨ¹ýÊÚÓèÓû§¶ÔÊý¾Ý¿âÖÐÌض¨µÄ±í¡¢ÊÓͼ¡¢ÐòÁеȽøÐвÙ×÷£¨²éѯ¡¢Ôö¡¢É¾¸Ä£©µÄȨÀûÀ´ÊµÏÖ¡£
½¨Á¢Óû§¼¶µÄ°²È«±£Ö¤
Óû§¼¶°²È«±£ÕÏͨ¹ýÓû§¿ÚÁîºÍ½ÇÉ«»úÖÆ£¨Ò»×éȨÀû£©À´ÊµÏÖ¡£ÒýÈë½ÇÉ«»úÖƵÄÄ¿µÄÊǼò»¯¶ÔÓû§µÄÊÚȨÓë¹ÜÀí¡£×ö·¨ÊÇ°ÑÓû§°´ÕÕÆ书ÄÜ·Ö×飬Ϊÿ¸öÓû§½¨Á¢½ÇÉ«£¬È»ºó°Ñ½ÇÉ«·ÖÅä¸øÓû§£¬¾ßÓÐͬÑù½ÇÉ«µÄÓû§ÓÐÏàͬµÄÌØȨ¡£
2.2 Óû§¹ÜÀí
ORACLEÓû§¹ÜÀíµÄÄÚÈÝÖ÷Òª°üÀ¨Óû§µÄ½¨Á¢¡¢Ð޸ĺÍɾ³ý
Óû§µÄ½¨Á¢
SQL>CREATE USER jxzy
>IDENTIFIED BY jxzy_password
>DEFAULT TABLESPACE system
>QUATA 5M ON system; //¹©Óû§Ê¹ÓõÄ×î´ó¿Õ¼äÏÞ¶î
Óû§µÄÐÞ¸Ä
SQL>CREATE USER jxzy
>IDENTIFIED BY jxzy_pw
>QUATA 10M ON system;
ɾ³ýÓû§¼°ÆäËù½¨¶ÔÏó
SQL>DROP USER jxzy CASCADE; //ͬʱɾ³ýÆ佨Á¢µÄʵÌå
2.3ϵͳÌØȨ¹ÜÀíÓë¿ØÖÆ
ORACLE ÌṩÁË80¶àÖÖϵͳÌØȨ£¬ÆäÖÐÿһ¸öϵͳÌØȨÔÊÐíÓû§Ö´ÐÐÒ»¸ö»òÒ»ÀàÊý¾Ý¿â²Ù×÷¡£
ÊÚÓèϵͳÌØȨ
SQL>GRANT CREATE USER,ALTER USER,DROP USER
Ïà¹ØÎĵµ£º
¹ØÓÚдÐò£¬È˵ÄÒ»±²×ÓÓкܶàµÄµÚÒ»´Î£¬¸øÊéдÐò£¬¶ÔÎÒÀ´ËµÒ²ÊǵÚÒ»´Î£¬¶øÇÒÊǺÜÄѵõÚÒ»´Î¡£Ò»°ãÈËÊéдÍêÁË£¬¶¼»áÕÒÒ»¸öÓеãÃûÆøµÄÈËÀ´ÎªÖ®×öÐò£¬ÔÚÕâÀïÎÒÖ»ÄܲÑÀ¢Ò»ÏÂ
¡£ÒòΪÎÒ×ܾõµÃ¸øÒ»±¾ÊéдÐòµÄÈË£¬ÔÚÊéµÄÄÚÈÝ·½Ã棬ÖÁÉÙÒ²µÃÊÇ°ë¸öר¼Ò£¬È»ºó²ÅÄÜÓз¢ÑÔȨ¡£¶ø±¾ÈËÔÚoracle·½Ã棬Á¬°ëÍ°Ë®µÄËã²»ÉÏ¡£ÕâÒ»´ÎÒ²¿ÖÅÂÖ»ÄÜÊÇ ......
жÔØOracle £º
1¡¢Í£Ö¹ËùÓÐOracle·þÎñ£¬µãUniversal InstallerжÔØ
2¡¢É¾³ý×¢²á±íÖеÄËùÓйØÓÚOracleÏî
£¨1£©ÔÚHKEY_LOCAL_MACHINE\SOFTWAREÏ£¬É¾³ýOracleĿ¼
£¨2£©ÔÚHKEY_LOCAL_MACHINE\SYSTEM\ControlSet001\ServicesÏ£¬É¾³ýËùÓÐOracleÏî
£¨3£©ÔÚHKEY_LOCAL_MACHINE\SYSTEM\ControlSet002\ServicesÏ£¬É¾³ýË ......
racle·ÖÒ³²éѯÓï¾ä
ĬÈÏ·ÖÀà 2009-12-23 18:17 ÔĶÁ43 ÆÀÂÛ0 ×ֺţº ´ó´ó ÖÐÖРСС Oracle·ÖÒ³²éѯÓï¾ä
±¾ÎÄתÔØ×Ô£ºyangtingkun.itpub.net/post/468/100278
OracleµÄ·ÖÒ³²éѯÓï¾ä»ù±¾ÉÏ¿ÉÒÔ°´ÕÕ±¾Îĸø³öµÄ¸ñʽÀ´½øÐÐÌ×Óá£
·ÖÒ³²éѯ¸ñʽ£º
sql ´úÂë
......
×°ÍêÁËOracle 10gÊý¾Ý¿â£¬ÍüÁ˸øscottÕË»§½âËø¡£Õâʱ¿ÉÒÔÔÚsql plus¹¤¾ßÀ¿ªÊ¼|ËùÓгÌÐò|<Oracle-Home>|Ó¦ÓóÌÐò¿ª·¢|SQL Plus£©£¬Ò²¿ÉÒÔÔÚ¿ØÖÆ̨ͨ¹ýÃüÁîÐиøscottÕË»§½âËø¡£
ÔÚµÚÒ»ÖÖÇé¿öÏ£¬ÒÔsystemÕË»§µÇ¼SQL Plus£¬È»ºóʹÓÃÃüÁî“alter user scott account unl ......
begin
sys.dbms_job.submit(job => :job,
what => 'check_err;',
  ......