ÔõôÆô¶¯ORACLE·þÎñ(10g)
ÎÒµÄÊý¾Ý¿âÃû:FMS
ÏÖÔÚÔÚ¿ØÖÆÃæ°å/¹ÜÀí¹¤¾ß/·þÎñ ÖÐÕÒ²»µ½ OracleServiceFMSÁË,ÇëÎÊÎÒÔõô²ÅÄÜÆô¶¯¸Ã·þÎñÄØ?
ÓÒ»÷¸ÃÑ¡ÏѡÔñÆô¶¯£¡Èç¹û²»¿ÉÒÔÏÈÑ¡ÔñÊôÐÔ£¬Ñ¡ÔñÊÖ¶¯»ò×Ô¶¯ÔÚÆô¶¯
ÓÃoradminÏÈÊÔÊÔ
ÄѵÀ²»ÊÇÔÚÔËÐÐÀï¼üÈëservices.msc È»ºóÆô¶¯¼àÌýºÍ·þÎñÁ½¸ö·þÎñÏÎÒµÄÒ²ÊÇÓõÄ10gµÄ°¡
½ûÓÃµÄÆôÓã¬Í£Ö¹µÄÆô¶¯¾Í¿ÉÒÔÁË£»
LZ˵µÄÊÇÕÒ²»µ½Õâ¸ö·þÎñ
lsnrctl¼àÌýһϣ¬ºÇºÇ
¿ªÊ¼²Ëµ¥-ÔËÐÐ-ÊäÈëcmd-½øÐÐÃüÁîÐÐÊäÈëÈçÏÂÃüÁîÊÔÊÔ
net start OracleServiceFMS
ÊÔÁË,Ìáʾ·þÎñÃûÎÞЧ.
±¾À´·þÎñÁбíÀïÓеÄ
ÓÐÒ»´Î±»360°²È«ÎÀÊ¿¸ø¸ÉÁË
dos ÏÂ
sqlplus /nolog
conn /as sysdba
startup
!lsnrctl start fms
ÿ¾äÒ»ÐУ¬Ò»ÐÐÒ»»Ø³µ£¬¿´µ½Äijö´í£¬³öʲô´í£¿
Óà oradim ÃüÁîÖØ½¨Ò»¸ö·þÎñ¡£¡£¡£¡£¡£
ʹÓÃijÖÖÈí¼þ»ò´´½¨Êý¾Ý¿â²»ÕýÈ·Ôì³É¶Ô×¢²á±íµÄ·þÎñ¶ªÊ§£¬Ê¹ÓÃÉÏÃæ·½·¨¿ÉÐÐ
ÔÚnomout״̬ÏÂн¨Ò»¸ö·þÎñFMS
ÈçÔÚcmdģʽÏÂÊäÈ룺
1¡¢sqlplus "/as sysdba"
2¡¢oradim -new -sid FMS -startmode auto
3¡¢alter dabase open
ÔÚHKEY_LOCAL_MACHINE/SOFTWARE/ORACLE/HOME0ÏÂÊÇ·ñÓÐ×Ö·û´®ORACLE_SID£¬ÖµÎªFMS¡£
Ïà¹ØÎÊ´ð£º
ÎÒ¶ÔSQL SERVERºÍACCESS±È½ÏÊ죬ËùÒÔÊý¾Ý¿âµÄͨÓûù´¡¶«Î÷¿ÉÒÔ˵¶¼ÕÆÎյIJ¶àÁË£¬ÎÒÏÖÔÚÏëÒªµÄ¾ÍÊÇÒÔÉÏÁ½Êý¾Ý¿âµÄ¶ÀÌØÖ®´¦µÄ½éÉܺÍÓ¦ÓýéÉÜ¡£
ÁíÍâÊé×îºÃ¶ÔÓ¦×îа汾 oracleÊÇ11g°É 10µÄÒ²ÐУ»mysqlÊÇ5.1°É
л ......
oracle not available
shared memory realm does not exist
ÇëÎʸßÊÖÕâ¸öÎÊÌâÈçºÎ½â¾ö£¿
http://www.inthirties.com/thread-109-2-1.html
Ö¸¶¨ÏÂORACLE_SID,ORACLE_HOME¿´¿´£¬²»ÐоÍÓÃ1Â¥µÃ·½·¨ÁË..
cm ......
oracleÁ¬½ÓɶÕâô¸´ÔÓ°¡.
oracle 10g
ÓÃps/sql devÔõôҲÁ¬²»ÉÏ.
ÓÃsqlplus¿ÉÒԵǽ.net manager֮ǰ²âÊÔÁ¬½ÓÁ˳ɹ¦µÄ.ÏÖÔÚ¸ãµÃÒ²Á¬½Ó²»ÁË.
listener.ora:
SID_LIST_LISTENER =
(SID_LIST =
......
Êý¾Ý¿â£ºOracle10g(10.2)
Ó¦ÓãºÒ»¸öC#µÄ³ÌÐòдÊý¾Ý¿â£¬Ò»¸öJSP³ÌÐò¶ÁÊý¾Ý¿â
¸ºÔØ£ºÄ¿Ç°´¦ÓÚ¿ª·¢½×¶Î£¬»ù±¾ÉÏÖ»ÓÐ3-4¸öÓû§·ÃÎÊJSPÍøÕ¾¡£
ÏÖÏó£ºÖØÐÂÆô¶¯ºóµÄÊý¾Ý¿â²éѯ·Ç³£¿ì£¬µ«ÊÇÓÃ×ÅÓÃ×ÅÔ½À´Ô½Âý£¬ËùÓÐJSPÍøÒ ......
ÎÒÓÃÕâ¸ö¹¤¾ß,
´´½¨ÁËÒ»¸ö±í
Ìí¼ÓÁËÒ»Ìõ¼Ç¼
È»ºó²éѯȴ²éѯ²»µ½;
¶øÇÒÈ¥Êý¾Ý¿âÖвéÕÒÒ²ÕÒ²»µ½Õâ¸ö±í;
ÒÔΪδ´´½¨³É¹¦.
ÖØÐ´´½¨±íÈ´ÌáʾÃû³ÆÒÑ´æÔÚ.
Çë½Ì¸÷λ´óÏÀ.Õâ¸öÊÇÔõô»ØÊ°¡
СµÜ³õ ......