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

OracleÊý¾Ý¿â·þÎñÆô¶¯Óë¹Ø±Õ

¿ªÆô£º
net start oracledbconsoleorcl
net start oracleOraDb10g_home1iSQL*Plus
net start oracleOraDb10g_home1TNSListener
net start oracleServiceORCL
net start oraclejobschedulerorcl //¿ÉÒÔ½ûÓÃ
¹Ø±Õ£º
net stop oracledbconsoleorcl
net stop oracleOraDb10g_home1iSQL*Plus
net stop oracleOraDb10g_home1TNSListener
net stop oracleServiceORCL
net stop oraclejobschedulerorcl//¿ÉÒÔ½ûÓÃ
¶ÔÓ¦·þÎñÀïÃæµÄÃû³Æ services.msc


Ïà¹ØÎĵµ£º

OracleÅäÖñ¾µØNet·þÎñÃû

Ò».ÅäÖñ¾µØNet·þÎñÃûÊǸÉʲôÓõģ¿
Èç¹ûҪͨ¹ýÍøÂç·ÃÎÊOracleÊý¾Ý¿â»òÆäËû·þÎñ£¬¾Í»áÓõ½Net·þÎñÃû¡£Oracle Net
Configuration AssistantÔÊÐíʹÓÃÓɱ¾µØÃüÃû½âÎöµÄÍøÂç·þÎñÃû¡£
¶þ.ÔõÑùÅäÖñ¾µØNet·þÎñÃû£¿
1.´ò¿ª->³ÌÐò/Oracle - OraClient10g_home1/ÅäÖúÍÒÆÖ²¹¤¾ß/Net
Configuration Assistant´ò¿ªNet Co ......

Oracle 9i Êý¾Ý¿â°²×°ËµÃ÷

1.1.1 °²×°OracleÊý¾Ý¿â·þÎñ¶Ë
°´ÕÕ°²×°Ïòµ¼£¬ÕýÈ·°²×°Oracle 9i¡£
°´ÕÕĬÈÏÑ¡Ïµã»÷ÏÂÒ»²½£¬¼´¿É¡£
 
ͼ 2 2 Oracle °²×°Ïòµ¼ - »¶Ó­Ê¹ÓÃ
ͼ 2 3 Oracle °²×°Ïòµ¼ - Îļþ¶¨Î»
ÕâÀÐè×¢ÒâOracleµÄ°²×°Îļþ·¾¶²»ÄÜ°üº¬¿Õ¸ñºÍÖÐÎÄÃû¡£Ä¬ÈÏ°²×°Â·¾¶ÊÇD:\oracle\ora92,ÕâÀィÒéʹÓÃÕâ¸ö°²×°Â·¾¶¡££¨°²×°£© ......

Oracle procedureÖ®ConstantsÓ¦ÓÃ

µ±OracleµÄ¶à¸ö´æ´¢¹ý³Ì¶¼Ê¹Óù«¹²µÄ³£Á¿Ê±£¬ÎÒÃÇ¿ÉÒÔ½¨Ò»¸öרÃŵÄpackageÓÃÀ´¹ÜÀíËùÓеij£Á¿¡£¶¨ÒåµÄʾÀý´óÖÂÈçÏ£º¡¡
create or replace package GLOBAL_CONSTANT is
  
/*ÊýÖµÀà³£Á¿*/
/*±ÈÂÊ*/
rate_tax CONSTANT NUMBER     := 1.17; -- Ë°ÂÊ       ......

ÈçºÎÐÞ¸ÄOracleĬÈÏÓû§ÃÜÂëÓÐЧÆÚʱ¼ä


ÈçºÎÐÞ¸ÄOracleĬÈÏÓû§ÃÜÂëÓÐЧÆÚʱ¼ä
1¡¢²é¿´Óû§µÄproifleÊÇÄĸö£¬Ò»°ãÊÇdefault£º
sql>SELECT username,PROFILE from dba_users;
2¡¢²é¿´Ö¸¶¨¸ÅÒªÎļþ£¨Èçdefault£©µÄÃÜÂëÓÐЧÆÚÉèÖãº
sql>SELECT * from dba_profiles s WHERE s.profile='DEFAULT' AND resource_name='PASSWORD_LIFE_TIME';
3¡¢½«ÃÜÂëÓÐÐ ......

ÔÚWindows 7Ï°²×°Oracle ½â¾ö·½·¨

Ê×ÏÈÕÒµ½Â·¾¶£º
E:\Oracle Enterprise_Standard Edition_11.1.0.7\database\stage\prereq\db\refhost.xml
ÈçϽڵ㣺
  <!--Microsoft Windows Vista-->
     <OPERATING_SYSTEM>
      <VERSION VALUE="6.0"/>
    </OPERAT ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ