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

Oracle ÃÜÂëÎļþѧϰ

½ñÌìÔÚÍøÉÏÂҹ䣬¿´µ½Ò»Æª²»´íµÄÎÄÕ£¬¹ØÓÚORACLEÃÜÂëÎļþµÄ£¬ÀíÂÛѧϰ+¸öÈËʵ¼ù£¬ºÇºÇ£¬¸´ÖƹýÀ´£¬·½±ãÒÔºóѧϰ¡£
===============================================================================
ÀíÂÛ²¿·Ö
Oracle¹ØϵÊý¾Ý¿âϵͳÒÔÆä׿ԽµÄÐÔÄÜ»ñµÃÁ˹㷺µÄÓ¦Ó㬶ø±£Ö¤Êý¾Ý¿â°²È«ÐÔÊÇÊý¾Ý¿â¹ÜÀí¹¤×÷µÄÖØÒªÄÚÈÝ¡£±¾ÎÄÔÚ×ܽáOracleÊý¾Ý¿â°²È«¹ÜÀí¹¤×÷µÄ»ù´¡ÉÏ£¬¶ÔOracleÊý¾Ý¿âϵͳÃÜÂëÎļþµÄ´´½¨¡¢Ê¹ÓúÍά»¤×÷ÁËÏêϸµÄ½éÉÜ£¬¹©´ó¼Ò²Î¿¼¡£
ÔÚOracleÊý¾Ý¿âϵͳÖУ¬Óû§Èç¹ûÒªÒÔÌØȨÓû§Éí·Ý£¨INTERNAL£¯SYSDBA£¯SYSOPER£©µÇ¼OracleÊý¾Ý¿â¿ÉÒÔÓÐÁ½ÖÖÉí·ÝÑéÖ¤µÄ·½·¨£º¼´Ê¹ÓÃÓë²Ù×÷ϵͳ¼¯³ÉµÄÉí·ÝÑéÖ¤»òʹÓÃOracleÊý¾Ý¿âµÄÃÜÂëÎļþ½øÐÐÉí·ÝÑéÖ¤¡£Òò´Ë£¬¹ÜÀíºÃÃÜÂëÎļþ£¬¶ÔÓÚ¿ØÖÆÊÚȨÓû§´ÓÔ¶¶Ë»ò±¾»úµÇ¼OracleÊý¾Ý¿âϵͳ£¬Ö´ÐÐÊý¾Ý¿â¹ÜÀí¹¤×÷£¬¾ßÓÐÖØÒªµÄÒâÒå¡£
OracleÊý¾Ý¿âµÄÃÜÂëÎļþ´æ·ÅÓг¬¼¶Óû§INTERNAL£¯SYSµÄ¿ÚÁî¼°ÆäËûÌØȨÓû§µÄÓû§Ãû£¯¿ÚÁËüÒ»°ã´æ·ÅÔÚORACLE_HOME£ÜDATABASEĿ¼Ï¡£
Ò»¡¢ÃÜÂëÎļþµÄ´´½¨
ÔÚʹÓÃOracle Instance Manager´´½¨Ò»Êý¾Ý¿âʵÀýµÄʱºî£¬ÔÚORACLE_HOME£ÜDATABASEĿ¼Ï»¹×Ô¶¯´´½¨ÁËÒ»¸öÓëÖ®¶ÔÓ¦µÄÃÜÂëÎļþ£¬ÎļþÃûΪPWDSID.ORA£¬ÆäÖÐSID´ú±íÏàÓ¦µÄOracleÊý¾Ý¿âϵͳ±êʶ·û¡£´ËÃÜÂëÎļþÊǽøÐгõʼÊý¾Ý¿â¹ÜÀí¹¤×÷µÄ»ù´£ÔÚ´ËÖ®ºó£¬¹ÜÀíÔ±Ò²¿ÉÒÔ¸ù¾ÝÐèÒª£¬Ê¹Óù¤¾ßORAPWD.EXEÊÖ¹¤´´½¨ÃÜÂëÎļþ£¬ÃüÁî¸ñʽÈçÏ£º
C:£Ü >ORAPWD FILE=£¼FILENAME £¾ PASSWORD =£¼PASSWORD £¾ ENTRIES=< MAX_USERS >
¸÷ÃüÁî²ÎÊýµÄº¬ÒåΪ£º
FILENAME£ºÃÜÂëÎļþÃû£»
PASSWORD£ºÉèÖÃINTERNAL£¯SYSÕʺŵĿÚÁ
MAX_USERS£ºÃÜÂëÎļþÖпÉÒÔ´æ·ÅµÄ×î´óÓû§Êý£¬¶ÔÓ¦ÓÚÔÊÐíÒÔSYSDBA£¯SYSOPERȨÏ޵ǼÊý¾Ý¿âµÄ×î´óÓû§Êý¡£ÓÉÓÚÔÚÒÔºóµÄά»¤ÖУ¬ÈôÓû§Êý³¬³öÁË´ËÏÞÖÆ£¬ÔòÐèÒªÖؽ¨ÃÜÂëÎļþ£¬ËùÒԴ˲ÎÊý¿ÉÒÔ¸ù¾ÝÐèÒªÉèÖõôóһЩ¡£
ÓÐÁËÃÜÂëÎļþÖ®ºó£¬ÐèÒªÉèÖóõʼ»¯²ÎÊýREMOTE_LOGIN_PASSWORDFILEÀ´¿ØÖÆÃÜÂëÎļþµÄʹÓÃ״̬¡£
¶þ¡¢ÉèÖóõʼ»¯²ÎÊýREMOTE_LOGIN_PASSWORDFILE
ÔÚOracleÊý¾Ý¿âʵÀýµÄ³õʼ»¯²ÎÊýÎļþÖУ¬´Ë²ÎÊý¿ØÖÆ×ÅÃÜÂëÎļþµÄʹÓü°Æä״̬¡£Ëü¿ÉÒÔÓÐÒÔϼ¸¸öÑ¡Ï
NONE£ºÖ¸Ê¾Oracleϵͳ²»Ê¹ÓÃÃÜÂëÎļþ£¬ÌØȨÓû§µÄµÇ¼ͨ¹ý²Ù×÷ϵͳ½øÐÐÉí·ÝÑéÖ¤£»
EXCLUSIVE£ºÖ¸Ê¾Ö»ÓÐÒ»¸öÊý¾Ý¿âʵÀý¿ÉÒÔʹÓôËÃÜÂëÎļþ¡£Ö»ÓÐÔÚ´ËÉèÖÃϵÄÃÜÂëÎļþ¿ÉÒÔ°üº¬ÓгýINTERNAL£¯SYSÒÔÍâµÄÓû§ÐÅÏ¢£¬¼´ÔÊÐí½«ÏµÍ³È¨ÏÞSYSOPER£¯SYSDBAÊ


Ïà¹ØÎĵµ£º

Oracle±¸·Ý¹ÜÀí ÌåÑé°æ

Oracle±¸·Ý¹ÜÀí
×î¼òµ¥µÄOracle Âß¼­±¸·ÝÈí¼þ£¬Ç¿´óµÄ¼Æ»®±¸·Ý¼°ÈßÓ౸·Ý¹¦ÄÜ
Èí¼þÌØÉ«£º
1.ÂéȸËäС£¬ÎåÔà¾ãÈ«¡£±¾×ÅʵÓõĽǶȿª·¢Õâ¸öÈí¼þ£¬Í¬Ê±¼æ¹Ë½çÃæÓ빦ÄÜ
2.ÖÇÄÜ»¯±¸·Ý¹¦ÄÜ£¬µ÷ÓÃOracle µÄexp±¸·Ý¹¦ÄÜ£¬ÖÇÄܼì²â±¸·Ý²ÎÊý
3.ÖÇÄÜѹËõ±¸·ÝÎļþ£¬²»Óõ£Ðı¸·ÝÊý¾Ý¹ý´ó¶øÓ²Å̳ÔÁ¦
4.¼°Æä¼òµ¥µÄ²Ù×÷½çÃ棬¼¸·ÖÖÓ¼ ......

Éý¼¶oracleÖеÄJDK°æ±¾

 
Oracle×Ô8iÆð¾ÍÈ«ÃæÖ§³Öjava£¬µ«¸÷¸ö°æ±¾µÄoracleÖÐĬÈÏjdk°æ±¾¾ù²»Ïàͬ£¬oracle8iÖÐΪ jdk1.2,oracle9iÖÐΪjdk1.3,oracle10gÖÐΪjdk1.4~~ÖÁ±ÊÕßÐÐΪ֮¼Ê£¬µ±Ç°µÄ×îа汾Ϊjdk1.5 update 11.
Òò±ÊÕßjava¿ª·¢³öÉí£¬ÔÚ×öoracle¿ª·¢Öо­³£»áÓÃjavaÀ´À©Õ¹ oracle¹¦ÄÜ£¬µ«ÊÇÓÉÓÚoracle×Ô´øjdk°æ±¾¹ýµÍ£¬¿ÉÄÜ»áÔì³ÉһЩ ......

oracle ±Ê¼Ç II Ö®DML:Êý¾Ý²Ù×÷ÓïÑÔ

 DML:Data Manipulation Language Êý¾Ý²Ù×÷ÓïÑÔ
°üÀ¨£ºCRUD
1. insertÓï¾ä
(1) ´ÓÆäËü±íÖи´ÖÆÊý¾Ý,ʵÏÖ·½·¨:ÔÚinsert Óï¾äÖмÓÈë²éѯÓï¾ä
insert into sales_reps(id,name,salary,commission_pct)  select employee_id,last_name,salary,commission_pct
from employees where job_id like '%rep';
(2) up ......

Oracleɾ³ýÖظ´Ðд«ÖDz¥¿Í

 ²éѯ¼°É¾³ýÖظ´¼Ç¼µÄSQLÓï¾ä
1¡¢²éÕÒ±íÖжàÓàµÄÖظ´¼Ç¼£¬Öظ´¼Ç¼ÊǸù¾Ýµ¥¸ö×ֶΣ¨peopleId£©À´ÅжÏ
select * from people
where peopleId in (select   peopleId from   people group by   peopleId having count(peopleId) > 1)
2¡¢É¾³ý±íÖжàÓàµÄÖظ´¼Ç¼£¬Öظ´¼Ç¼ÊǸù¾Ý ......

Oracle Stream Replication¼¼Êõ


Stream ÊÇOracle µÄÏûÏ¢¶ÓÁÐ(Ò²½ÐOracle Advanced Queue)¼¼ÊõµÄÒ»ÖÖÀ©Õ¹Ó¦ÓᣠOracle µÄÏûÏ¢¶ÓÁÐÊÇͨ¹ý·¢²¼/¶©Ôĵķ½Ê½À´½â¾öʼþ¹ÜÀí¡£Á÷¸´ÖÆ(Stream replication)Ö»ÊÇ»ùÓÚËüµÄÒ»¸öÊý¾Ý¹²Ïí¼¼Êõ£¬Ò²¿ÉÒÔ±»ÓÃ×÷Ò»¸ö¿ÉÁé»î¶¨ÖƵĸ߿ÉÓÃÐÔ·½°¸¡£ Ëü¿ÉÒÔʵÏÖÁ½¸öÊý¾Ý¿âÖ®¼äÊý¾Ý¿â¼ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ