ÔõôÆô¶¯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¡£
Ïà¹ØÎÊ´ð£º
ÎÒ°²×°Ò»Ì¨redhat linux5+oracle 10gµÄ·þÎñÆ÷£¬±Ê¼Ç±¾£¨XPϵͳ£©°²×°ÁËoracle 10g¿Í»§¶Ë,½á¹ûÀÏÊdzö12560µÄ´íÎó£¬Çë¸ßÊÖÖ¸µãÒ»¶þ£¬
-A RH-Firewall-1-INPUT -m state –state NEW -m tcp -p tcp –dpor ......
ÎÒÏÖÔÚÓÐһЩsasÉÏÃæµÄÊý¾ÝÎļþ ÏÖÔÚÎÒÐèÒª°Ñsasµ¼Èëµ½oracle
ÏÖÔÚ°ÑÒ»¸ösasÎļþµ¼Èëµ½Ò»¸öoracleÖеÄÒ»¸ö±íÖÐÎÒÒѾ֪µÀÔõôŪÁË
µ«ÊÇ ÎÒÏÖÔÚÐèÒª°ÑsasÖеÄÁíÒ»¸öÎļþ×·¼Óµ½oracleÖеÄÒ»¸öÓÐÊý¾ÝµÄÒ»¸ö±íÉÏà ......
´ó¼ÒºÃ£¬ÔÚ¿ª·¢µÄʱºò£¬Óöµ½ÕâÑùµÄÎÊÌ⣺
δÄܼÓÔØÎļþ»ò³ÌÐò¼¯¡°Oracle.DataAccess, Version=10.1.0.200, Culture=neutral, PublicKeyToken=89b483f429c47342¡±»òËüµÄijһ¸öÒÀÀµÏϵͳÕÒ²»µ½Ö¸¶¨µÄÎļþ¡£ ......
ÒÔǰ³ÌÐòºÃºÃµÄ,ÄܽøÐÐÈκβÙ×÷
µ«´Ó×òÌ쿪ʼͻȻÁ¬½ÓÊý¾Ý¿âʧ°Ü,´úÂëÈçÏÂ:
try
{
::CoInitialize(NULL);
hr=m_pConnection.Creat ......
ƽʱ¶¼ÊÇÁ¬½ÓMSSQL û̫עÒâÕâ¸öÎÊÌâ..½ñÌìÒòΪÐèÒª.ÔÚÍøÉÏÕÒÁËÒ»ÏÂ..Óкöà.. ¶¼ÊÔÁË.²»ÐÐ
ºÜ¶à¶¼ÊDZ¨:
δ´¦ÀíµÄÒì³£;System.Exception System.Data.OracleCilent ÐèÒª Oracle ¿Í»§¶ËÈí¼þ 8.1. ......