ÖØ×°²Ù×÷ϵͳºóµÄoracleʵÀý»Ö¸´
ÖØ×°²Ù×÷ϵͳºó,Èç¹ûÊý¾ÝÎļþ,¿ØÖÆÎļþ,ÈÕÖ¾Îļþ¶¼ÍêºÃµÄ»°(ÔÚitpub¿´¹ýºÜ¶àÈËÌá¹ýÕâ¸ö»°Ìâ,¶àÊýÈ˶¼Êǽ«Õâ3¸öÎļþ·ÅÔÚͬһĿ¼oradata),Ö»ÐèÖØа²×°oracle(¸úÖØ×°²Ù×÷ϵͳǰͬ°æ±¾)µ½ÔĿ¼ºó,Öؽ¨ÊµÀý·þÎñºÍÃÜÂëÎļþ,ÅäÖÃÒ»ÏÂlistenerºÍtns¼´¿ÉÕý³£Æô¶¯Êý¾Ý¿â.
¹ý³ÌÈçÏÂ(¼ÙÉèÔʵÀýÃûΪorcl,°æ±¾Îª9i):
1.½«ÔÀ´µÄoracleÎļþ¼ÐÖØÃüÃû,±ÈÈçoracle_old;È»ºóÖØа²×°oracleµ½ÔĿ¼,¼´¸úÖØ×°²Ù×÷ϵͳǰͬһĿ¼,¼ÙÉèΪd:\oracle;°²×°¹ý³ÌÑ¡Ôñ"Ö»°²×°Èí¼þ"¼´²»´´½¨Êý¾Ý¿â,ÕâÑù¿ÉÒÔ½ÚÊ¡ºÜ¶àʱ¼ä.
2.ÅäÖÃlistenerºÍtns:
ÔËÐÐlsnrctl start,¼´¿ÉÔÚ´´½¨¼àÌý·þÎñ;
ʹÓÃnet managerÅäÖÃtns,µ«²»Òª²âÊÔ(Êý¾Ý¿âûÓÐÆðÀ´¿Ï¶¨²âÊÔ²»Í¨¹ýµÄ);
3.½«oradataÎļþ¼Ð¿½±´»ØÔĿ¼(Èçd:\oracle\oradata);
4.½«spfile¿½±´»ØÔĿ¼(Èçd:\oracle\ora92\database);
5.´´½¨ÊµÀý·þÎñ:
oradim -new -sid orcl -startmode auto
6.Öؽ¨¿ÚÁîÎļþ:
orapwd file=d:\oracle\ora92\database password=orcl entries=5
7.ÖØÆô¼àÌýºÍʵÀý.
8.Èç¹ûÊý¾Ý¿âûÓÐÆô¶¯¾Í½øÈësqlplusÊÖ¹¤´ò¿ªÊý¾Ý¿â
sqlplus /nolog
sql>conn sys/orcl@orcl as sysdba
sql>startup;
9.Èç¹ûÊý¾Ý¿â˳Àû´ò¿ª,Õû¸öʵÀý»Ö¸´¹ý³Ì¼´Íê³É.
Ïà¹ØÎĵµ£º
replace¾ÍÊÇÒ»°ãÒâÒåÉϵÄ×Ö·û´®Ìæ»»£¬translateÖ»ÊÇÒ»¸ö×Ö·ûÌæ»»¶ÔÓ¦µÄÒ»¸ö×Ö·û£¬ÏÂÃæÓÐÊÖ²á˵Ã÷£¬»¹ÓÐÀý×Ó O(∩_∩)O¹þ¹þ~
REPLACE
Syntax
Purpose
REPLACE returns char with every occurrence of search_string replaced with replacement_string. If replacement_string is omitted or null, then all occu ......
²é¿´sessionµÈ´ýʼþ£º
select sid,event from v$session_wait where event not like 'rdbms%' and event not like 'SQL*Net message%';
°´pid²é¿´ÕýÔÚÖ´ÐеijÌÐò£º
select sid,program from v$session b where paddr in (selec ......
ÓÐÈçϱíTest
City People Make
¹ãÖÝ 1 A
¹ãÖÝ 2 B
¹ãÖÝ 3 C
ÉϺ£ 4 A
ÉϺ£ 5 ......
ORACLEÅàѵ(OCA)ÈÏÖ¤½éÉÜ
Oracle10g Certified Associate (OCA) Oracle ÈÏ֤רԱ¡£
¿¼ÊԳɼ¨Í¨¹ýÄÜ»ñµÃOracle¹«Ë¾ÎªÄú°ä·¢µÄÈ«ÇòÈÏÖ¤µÄÓ¢ÎÄOCAÖ¤Êé¡£OCAÓÉOracle¹«Ë¾³öÌâ¡£
¸ÃÖ¤Êé¿É×÷Ϊ¸÷ÆóÊÂÒµµ¥Î»Êý¾Ý¿â¹ÜÀíÈËÔ±ÉϸڵÄÒÀ¾Ý¡£
Ä¿Ç°ÒѳÉΪ¸÷IT¹«Ë¾¼°Ïà¹ØÆóÒµÕùÏྺƸµÄÊý¾Ý¿â¹ÜÀíά»¤È˲ţ¬ÊÇÊý¾Ý¿âά»¤¹ÜÀíÈËÔ ......