ÖØ×°²Ù×÷ϵͳºóµÄ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.Èç¹ûÊý¾Ý¿â˳Àû´ò¿ª,Õû¸öʵÀý»Ö¸´¹ý³Ì¼´Íê³É.
Ïà¹ØÎĵµ£º
select * from (select pro_id, sum(decode(month, '01', summ)) one,
sum(decode(month, '02', summ)) two,
&nb ......
1 ½«Êý¾Ý¿âTESTÍêÈ«µ¼³ö,Óû§Ãûsystem ÃÜÂëmanager µ¼³öµ½D:daochu.dmpÖÐ
exp system/manager@TEST file=d:daochu.dmp full=y
2 ½«Êý¾Ý¿âÖÐsystemÓû§ÓësysÓû§µÄ±íµ¼³ö
exp system/manager@TEST file=d:daochu.dmp owner=(system,sys)
3 ½«Êý¾Ý¿âÖеıíinner_notify¡¢notify_ ......
@echo off
:dosmenu
REM Ñ¡Ôñ²Ëµ¥
echo Windows ·þÎñÆô¶¯»ò¹Ø±Õ By hope 2008Äê2ÔÂ7ÈÕ
echo.
echo [1]Æô¶¯Sql Server2005 [2]¹Ø±ÕSql Server2005
echo [3]Æô¶¯Oracle9i [4]¹Ø±ÕOracle9i
echo.
echo ......
-----------------------------------------------------------------------------------
DOS:
1. sqlplus
2.
Óû§Ãû:sqlplus ¡¢conn
ÃÜÂë:as sysdba ¡¢as sysdba
½âËø£º
3. ALTER USER DBSNMP ACCOUNT UNLOCK£»
½âËø£ºsystem
4. alter user system identified by manage ......
ORACLEÅàѵ(OCA)ÈÏÖ¤½éÉÜ
Oracle10g Certified Associate (OCA) Oracle ÈÏ֤רԱ¡£
¿¼ÊԳɼ¨Í¨¹ýÄÜ»ñµÃOracle¹«Ë¾ÎªÄú°ä·¢µÄÈ«ÇòÈÏÖ¤µÄÓ¢ÎÄOCAÖ¤Êé¡£OCAÓÉOracle¹«Ë¾³öÌâ¡£
¸ÃÖ¤Êé¿É×÷Ϊ¸÷ÆóÊÂÒµµ¥Î»Êý¾Ý¿â¹ÜÀíÈËÔ±ÉϸڵÄÒÀ¾Ý¡£
Ä¿Ç°ÒѳÉΪ¸÷IT¹«Ë¾¼°Ïà¹ØÆóÒµÕùÏྺƸµÄÊý¾Ý¿â¹ÜÀíά»¤È˲ţ¬ÊÇÊý¾Ý¿âά»¤¹ÜÀíÈËÔ ......