OracleµÄ¼¸¸ö½ø³Ì¶¼ÓÐʲô×÷Óã¿
³õѧoracle£¬ÎÒ×°µÄÊÇoracle 10g£¬µ«ÔÚ±¾±¾ÉÏÌ«³ÔÄÚ´æÁË£¬ÏëÆ½Ê±¹Ø±ÕûÓõķþÎñÏî
ÓõÄʱºòÔÙ°ÑËüÃÇ´ò¿ª£¬µ«³õѧ£¬²»¸ÒËæ±ã¹Ø±Õ£¬ËùÒÔÔÚÕâÀïÎÊϸ÷λ£¬Ò»Ï½ø³Ì¶¼ÊÇ×öʲôÓõģ¿
×îºÃÄÜÏêϸµã½â´ð£¬Ð»Ð»ÁË~
OracleDBConsoleorcl
OracleJobSchedulerORCL
OracleOraDb10g_home1iSQL*Plus
OracleOraDb10g_home1TNSListener
OracleServiceORCL
OracleServiceORCL ÕâÊÇoralce µÄ·þÎñ½ø³Ì£¬²»ÄܹØ
OracleOraDb10g_home1TNSListener oralce ¼àÌý½ø³Ì ²»¿ÉÒÔ¹Ø
OracleOraDb10g_home1iSQL*Plus sqlplus µÄ½ø³Ì
OracleJobSchedulerORCL ÕâÓ¦¸ÃÊÇÈÎÎñµ÷¶ÈµÄ
OracleDBConsoleorcl Õâ¸ö²»Çå³þ
OracleDBConsoleorcl
oracleÊý¾Ý¿â¿ØÖÆÌ¨£¬Æô¶¯Ö®£¬10gR2Àïͨ¹ýhttp://hostname/ip:1158/em½øÈëÊý¾Ý¿â¹ÜÀí¿ØÖÆÌ¨¡£
OracleJobSchedulerORCL
¶¨Ê±Æ÷µÄ·þÎñ½ø³Ì¡£Ã»Óùý£¬ÆäʵҲûʲôÓá£Ã»ÓÐËü£¬¶¨Ê±·þÎñÒ»ÑùʹÓá£
OracleOraDb10g_home1iSQL*Plus
isqlplus·þÎñ£¬Í¨¹ýIE·½Ê½µ÷ÓÃSQLPLUS¡£
OracleOraDb10g_home1TNSListener
TNS¼àÌý·þÎñ£¬Ã»ÓÐËü£¬¿Í»§¶ËÎÞ·¨·ÃÎÊÊý¾Ý¿â·þÎñÆ÷¡£
OracleServiceORCL
Êý¾Ý¿â·þÎñ¡£¹ËÃû˼Ò壬ûÓÐËü£¬Êý¾Ý¿âÆð²»À´£¬¿Í»§¶Ë¸ü²»¿ÉÄÜ·ÃÎÊÖ®¡£
OracleServiceORCL
׼ȷ˵£¬ÊÇÊý¾Ý¿â¶ÔӦʵÀý£¨instance£©·þÎñ¡£
ÒÔÉϾù»ùÓÚWINDOWS¡£
ƽʱֻÐèÒª
OracleOraDb10
Ïà¹ØÎÊ´ð£º
ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£
ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......
ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡
ORA-01034:ORACLE not available
ORA-27101:shared memory realm does not exist
ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡
1. Oracle sid ÕýÈ ......
ÎÒÓÐÒ»¸öserver 2000ÀïµÄÊý¾Ý,ÏÖÔÚÏëתµ½oracleÊý¾Ý¿âÉÏÓÃ,²»ÖªµÀÓÐûÓиßÊÖÓмòµ¥ÓÖ¿ì½ÝµÄ·½·¨,ǰÌáÊDz»ÄܸÄÔÀ´oracleÀïµÄÔÓеÄÊý¾Ý¿â,Ö»ÄÜн¨
ÒýÓÃ
°²×°£Ï£Ò£Á£Ã£Ì£ÅµÄ£Ï£Ä£Â£Ã£¬È»ºóÓãӣѣ̡¡£Ó£Å£Ò£Ö£Å£ ......
СµÜ£¬×î½üҪתÐÐÈ¥×öoracle¿ª·¢ÁË£¬ÓÉÓÚ´óѧ±Ïҵʱ£¬×ßÁ˸öÍä·£¬ÏÖÔÚºÜСÐÄ£¬ÎÊÏ£¬×öPL/SQLÓÐûÓÐǰ;£¿£¿£¿
µ±È»ÎÒ˵µÄÕâ¸öǰ;ÊÇÖ¸ ÒÔºóÒªÌø²Û£¬Êг¡¶ÔÕâÑùµÄÈ˲ŵÄÐèÇóÁ¿´ó²»´ó£¿£¿
3q ÄÇ¿´À´»¹Ö»ÄÜÏȽӴ ......