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

oracle ³¹µ×ɾ³ý

  ºÜ¶àÅóÓÑÖ»ÓÃÁËoracleµÄɾ³ý£¬µ«ºÜ¶àÇé¿öÏ£¬Ëû»á·¢ÏÖÖØÐ°²×°Ê±£¬µãÁËÏÂÒ»²½°²×°½çÃæ¾ÍÏûʧÁË£¬ÍùÍùÎÞÄÎÏÂÖ»ºÃÖØ×°ÏµÍ³£¬ÆäʵֻÊÇÄãÊý¾Ý¿âûɾ¸É¾»£¬É¾¸É¾»¾Í²»»á³öÏÖÕâÖÖÇé¿öÁË¡£
    ʵÏÖ·½·¨£º
    1¡¢ ¿ªÊ¼£­£¾ÉèÖã­£¾¿ØÖÆÃæ°å£­£¾¹ÜÀí¹¤¾ß£­£¾·þÎñ Í£Ö¹ËùÓÐOracle·þÎñ¡£
    2¡¢ ¿ªÊ¼£­£¾³ÌÐò£­£¾Oracle - OraHome81£­£¾Oracle Installation Products£­£¾ Universal Installer жװËùÓÐOracle²úÆ·£¬µ«Universal Installer±¾Éí²»Äܱ»É¾³ý
    3¡¢ ÔËÐÐregedit£¬Ñ¡ÔñHKEY_LOCAL_MACHINE\SOFTWARE\ORACLE£¬°´del¼üɾ³ýÕâ¸öÈë¿Ú¡£
    4¡¢ ÔËÐÐregedit£¬Ñ¡ÔñHKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services£¬¹ö¶¯ Õâ¸öÁÐ±í£¬É¾³ýËùÓÐOracleÈë¿Ú¡£
   5¡¢ ÔËÐÐrefedit£¬HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Eventlog\Application£¬ ɾ³ýËùÓÐOracleÈë¿Ú¡£
   6¡¢¿ªÊ¼£­£¾ÉèÖã­£¾¿ØÖÆÃæ°å£­£¾ÏµÍ³£­£¾¸ß¼¶£­£¾»·¾³±äÁ¿É¾³ý»·¾³±äÁ¿CLASSPATHºÍPATHÖÐÓйØOracleµÄÉ趨
   7¡¢ ´Ó×ÀÃæÉÏ¡¢STARTUP£¨Æô¶¯£©×é¡¢³ÌÐò²Ëµ¥ÖУ¬É¾³ýËùÓÐÓйØOracleµÄ×éºÍͼ±ê
    8¡¢É¾³ý\Program Files\OracleĿ¼
    9¡¢ ÖØÐÂÆô¶¯¼ÆËã»ú£¬ÖØÆðºó²ÅÄÜÍêȫɾ³ýOracleËùÔÚĿ¼
    10¡¢ ɾ³ýÓëOracleÓйصÄÎļþ£¬Ñ¡ÔñOracleËùÔÚµÄȱʡĿ¼C:\Oracle£¬É¾³ýÕâ¸öÈë¿ÚĿ¼¼°ËùÓÐ×ÓĿ¼£¬²¢´ÓC:\WINDOWSÏÂɾ³ýÒÔÏÂÎļþORACLE.INI¡¢oradim73.INI¡¢oradim80.INI¡¢oraodbc.iniµÈµÈ¡£
    11¡¢ WIN.INIÎļþÖÐÈôÓÐ[ORACLE]µÄ±ê¼Ç¶Î£¬É¾³ý¸Ã¶Î
    12¡¢ ÈçÓбØÒª£¬É¾³ýËùÓÐOracleÏà¹ØµÄODBCµÄDSN
    13¡¢ µ½Ê¼þ²é¿´Æ÷ÖУ¬É¾³ýOracleÏà¹ØµÄÈÕÖ¾ ˵Ã÷£º Èç¹ûÓиö±ðDLLÎļþÎÞ·¨É¾³ýµÄÇé¿ö£¬Ôò²»ÓÃÀí»á£¬ÖØÐÂÆô¶¯£¬¿ªÊ¼Ðµİ²×°£¬ °²×°Ê±£¬Ñ¡ÔñÒ»¸öеÄĿ¼£¬Ôò£¬°²×°Íê±Ï²¢ÖØÐÂÆô¶¯ºó£¬ÀϵÄĿ¼¼°Îļþ¾Í¿ÉÒÔɾ³ýµôÁË¡£


Ïà¹ØÎĵµ£º

Ò»´Îoracle 10g rac¹ÊÕÏ´¦Àí

Ò»´Îoracle 10g rac¹ÊÕÏ´¦Àí:
rhel4-1->crs_stat -t
Name           Type           Target    State     Host       
------------ ......

oracleÖеÄÈ«¾ÖÊý¾Ý¿âÃû³ÆºÍsidµÄÇø±ð

Êý¾Ý¿âÃû(DB_NAME)¡¢ÊµÀýÃû(Instance_name)¡¢ÒÔ¼°²Ù×÷ϵͳ»·¾³±äÁ¿(ORACLE_SID)
ÔÚORACLE7¡¢8Êý¾Ý¿âÖÐÖ»ÓÐÊý¾Ý¿âÃû(db_name)ºÍÊý¾Ý¿âʵÀýÃû(instance_name)¡£ÔÚORACLE8i¡¢9iÖгöÏÖÁËеIJÎÊý£¬¼´Êý¾Ý¿âÓòÃû(db_domain)¡¢·þÎñÃû(service_name)¡¢ÒÔ¼°²Ù×÷ϵͳ»·¾³±äÁ¿(ORACLE_SID)¡£ÕâЩ¶¼´æÔÚÓÚͬһ¸öÊý¾Ý¿âÖеıêʶ£¬ÓÃÓÚ ......

OracleÐÐתÁÐʵÀý

ѪҺÃ÷ϸ±íÈçÏ£º
create table "blood"."OC_CarryOrderD"  (
     ID                   nvarchar2(20)              &n ......

³éÏóÊý¾ÝÀàÐÍ£¬ÈÃOracleÊý¾Ý¿âÊý¾Ý¹ÜÀí¸ü¼ÓÈÝÒ×

2¡¢ ³éÏóÊý¾ÝµÄÒýÓá£
¡¡¡¡µ±½¨Á¢ºÃ³éÏóÊý¾ÝÀàÐ͵Äʱºò£¬Êý¾Ý¿â¹ÜÀíÔ±¾Í¿ÉÒÔÏò»ù±¾Êý¾ÝÀàÐÍÄÇÑù£¬ÒýÓóéÏóÊý¾ÝÀàÐÍ£¬°üÀ¨ÔÚ½¨Á¢±í»òÕß¶ÔÏà¹Ø×ֶνøÐи³ÖµµÄʱºò£¬¶¼Õâô·½±ã¡£
¡¡¡¡ÈçÔÚ½¨Á¢±íµÄʱºò£¬¿ÉÒÔ°ÑÕâ¸ö³éÏóÊý¾ÝÀàÐÍÖ±½Ó¸úij¸ö×ֶιØÁªÆðÀ´¡£Èç
¡¡¡¡Create Table USERS
¡¡¡¡(F­­_Adress Adress );
¡¡¡ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ