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

½ñÌì×°ORACLE µÄµãµãµÎµÎ£¡

ËäÈ»ÒÔǰÓÃÁ˼¸ÄêµÄORACLE µÄpl/sql  µ«°²×°½ñÌ컹ÊǵÚÒ»´Î£º
1£º »¹ÊÇÏȲο¼Ò»ÏÂÍøÕ¾£ºhttp://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx
  1. Oracle 10g windows ƽ̨ϰ²×°
¡¡¡¡ÏÂÔØµØÖ·£º  http://download.csdn.net/source/1850497¡¡¡¡
¡¡¡¡ÔÚÏß¹Û¿´µØÖ·£ºhttp://v.youku.com/v_show/id_XMTM0NzA5MjY0.html
  2. ÐéÄâ»úÉϰ²×°Linux ²Ù×÷ϵͳ
     Ï  ÔØ µØ   Ö·£ºhttp://download.csdn.net/source/1855603
     ÔÚÏß¹Û¿´µØÖ·£ºhttp://v.youku.com/v_show/id_XMTM1MTM5MzQ0.html
2: ÎÒÊÇÏȰ²×°PL/SQL £¬ÔÚ°²×°ORACLE µÄ¿Í»§¶Ë£º
    2.1 ×°¸öPL/SQL Ó¦¸ÃûÎÊÌâµÄ£¬ÔÚÈ¥
http://www.oracle.com/technology/software/products/database/index.html
ÏÂÔØORACLE 10 ºó (¾ßÌåµÄ°²×°·½·¨¿ÉÒÔ¿´ÊÓÆµµÄ£©£º
    ×¢Ò⣺ORACLE °²×°µÄ³É¹¦¿ÉÒÔ¿´£º
           1:OEM ÊÇ·ñÄÜ´ò¿ª
           2£ºORACLE ×Ô´øµÄSQLPLUS ÊÇ·ñ¿ÉÒÔʹÓã¡
    2.2 Òª¶ÔPL/SQL ½øÐÐÅäÖ㺣¨²Î¿¼£ºhttp://blog.csdn.net/zwxrain/archive/2008/07/16/2663464.aspx £©
         ½Ó×Å´ò¿ªPL/SQL£¬ÔÚperferenceÀïÃæÉèÖÃOCI LibraryºÍOracle_home£¬ÎÒµÄÉèÖÃÊÇOCI Library=D:\oracle\product\10.2.0\db_1\BIN\oci.dll,Oracle_home=D:\oracle\product\10.2.0\db_1\BIN¡£
    2.3 ¿´Ò»ÏÂÔÚD:\oracle\product\10.2.0\db_1\NETWORK\ADMIN ϵÄtnsnames.ora ÎļþµÄÅäÖãº
SHENG =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = a8de304cce9047f)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = SHENG.US.ORACLE.COM.CN)
    )
  )
ÔÚPL/SQL Á¬µÄʱºò£¬Ñ¡Ò»Ï¾ͿÉÒÔÁË¡£
ID : system 
password : admin
connect server: SHENG
server : SYSDBA
3 : ÔÚ×°ORACLE µÄʱºò£¬Á˽âÁËOEM £¨oracle enterprice Manager)
  ͬÑù£º
ID : system 
password : ad


Ïà¹ØÎĵµ£º

oracle¸´Ï°£¨Ò»£© Ö®OracleÌåϵ½á¹¹

      ѧϰOracle DBAÒ²°ë¸ö¶àѧÆÚÁË£¬½ñÌìÃÍÈ»²Å·¢ÏÖ£¬Ô­À´ÎÒµÄÊ黹ÊǺÜеģ¬ÉϿβÙ×÷ʱºòÒ²Ö»ÊÇÖªµÀ´ó¸ÅÔõô×ö£¬µ«ÊÇÒªÕæµÄÈ«²¿×Ô¼º×ö£¬¶ø²»È¥·­Ê黹ÊÇÓÐÒ»¶¨µÄÄѶȵģ¬ËùÒÔÄØ£¬½ñÌ쿪ʼ½«DBA´ÓÍ·¸´Ï°Ò»±é£¬Í¬Ê±ÔÙ²Ù×÷Ò»±é¡£
      µÚÒ»Õ£¬Ñ§µÄÊÇOracleµÄÌåϵ½á¹¹£ ......

ORACLE»¹Ô­¶ÎµÄÀàÐÍ

ϵͳ»¹Ô­¶Î
½öΪϵͳ±í¿Õ¼äÖеĶÔÏó±ä»¯ËùÓá£ËüÊÇÔÚÊý¾Ý¿â´´½¨Ê±ÔÚϵͳ±í¿Õ¼äÖд´½¨µÄ¡£ÏµÍ³»¹Ô­¶Î¼È¿ÉÒÔ´æÔÚ²¢¹¤×÷ÔÚ×Ô¶¯Ä£Ê½Ï£¬Ò²¿ÉÒÔ´æÔÚ²¢¹¤×÷ÔÚÊÖ¶¯Ä£Ê½Ï¡£
·Çϵͳ»¹Ô­¶Î
ΪÆäËû±í¿Õ¼äÖжÔÏóµÄ±ä»¯ËùʹÓᣵ±Ò»¸öÊý¾Ý¿â¾ßÓжà¸ö±í¿Õ¼äʱ¾ÍÐèÒªÖÁÉÙÒ»¸öÊÖ¶¯µÄ·Çϵͳ»¹Ô­¶Î»òÒ»¸ö×Ô¶¯¹ÜÀíµÄ»¹Ô­±í¿Õ¼ä¡£
×Ô¶¯Ä£Ê½ ......

OracleÈ«¾ÖÊý¾Ý¿âÃû¡¢»·¾³±äÁ¿ºÍsidµÄÇø±ð


http://www.haoxiai.net/shujuku/Oracle/111145.html
Ò»¡¢Êý¾Ý¿âÃû
ʲôÊÇÊý¾Ý¿âÃû
Êý¾Ý¿âÃû¾ÍÊÇÒ»¸öÊý¾Ý¿âµÄ±êʶ£¬¾ÍÏñÈ˵ÄÉí·ÝÖ¤ºÅÒ»Ñù¡£ËûÓòÎÊýDB_NAME±íʾ£¬Èç¹ûһ̨»úÆ÷ÉÏ×°Á˶àÈ«Êý¾Ý¿â£¬ÄÇôÿһ¸öÊý¾Ý¿â¶¼ÓÐÒ»¸öÊý¾Ý¿âÃû¡£ÔÚÊý¾Ý¿â°²×°»ò´´½¨Íê³ÉÖ®ºó£¬²ÎÊýDB_NAME±»Ð´Èë²ÎÊýÎļþÖ®ÖС£¸ñʽÈçÏ£º
DB_NAME=m ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ