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

¹ØÓÚoracleµÄ³¹µ×жÔØÎÊÌâ

oracle9iжÔØ
1,ÔÚ·þÎñÖÐÍ£Ö¹oracleµÄËùÓзþÎñ
2,ÔÚ³ÌÐòÁËжװËùÓÐOracle²úÆ·£¬(µ«Universal Installer±¾Éí²»Äܱ»É¾³ý)
3,ɾ³ý×¢²á±í:
(1)ÔËÐÐregeditÑ¡ÔñHKEY_LOCAL_MACHINE\SOFTWARE\ORACLE£¬É¾³ýÕâ¸öÏî
(2)Ñ¡ÔñHKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Oracle,ɾ³ýÕâ¸öÏî.
(3),Ñ¡ÔñHKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Eventlog\Application\Oracleɾ³ý.
4,ɾ³ý»·¾³±äÁ¿CLASSPATHºÍPATH=D:\oracle\ora92\bin;ÖÐÓйØOracleµÄÉ趨
5,ɾ³ý\Program Files\OracleĿ¼
6,ÖØÐÂÆô¶¯¼ÆËã»ú£¬ÖØÆðºó²ÅÄÜÍêȫɾ³ýOracleµÄÏà¹ØĿ¼
7,ɾ³ýÓëOracleÓйصÄÎļþ£¬Ñ¡ÔñOracleËùÔÚµÄȱʡĿ¼C:\Oracle£¬É¾³ýÕâ¸öÈë
¿ÚĿ¼¼°ËùÓÐ×ÓĿ¼£¬²¢´ÓWindows 2000Ŀ¼£¨Ò»°ãΪC:\WINNT£©ÏÂɾ³ýÒÔÏÂÎÄ
¼þORACLE.INI¡¢oradim73.INI¡¢oradim80.INI¡¢oraodbc.iniµÈµÈ
ɾ³ýÁÙʱÀ¬»øÎļþ
1.Í£Ö¹ËùÓÐOracle·þÎñ£ºÔÚ¿ØÖÆÃæ°å -> ¹ÜÀí¹¤¾ß -> ·þÎñ -> Í£Ö¹ËùÓÐ oracle ·þÎñ
2.жÔسÌÐò£ºÔÚ¿ªÊ¼²Ëµ¥Ñ¡ÔñoracleµÄ Universal InstallerÑ¡Ïî жÔØËùÓÐoracle ²úÆ·£¨Universal Installer±¾Éí²»Äܱ»É¾³ý£©
3.Çå³ý×¢²á±íÐÅÏ¢£ºÔËÐÐ regedit£¬½øÈë×¢²á±í±à¼­
1>Ñ¡Ôñ HKEY_CLASSES_ROOT,ɾ³ýËùÓÐ oracle Èë¿Ú£¬ÈçÒÔoracle£¬orcl£¬ora¿ªÍ·µÄ
2>Ñ¡Ôñ HKEY_LOCAL_MACHINE\SOFTWARE £¬É¾³ýOracleĿ¼
3>Ñ¡Ôñ HKEY_LOCAL_MACHINE\SYSTEM\ControlSet001(»òÕßControlSet002¡¢ControlSet003)\Services £¬É¾³ýËùÓÐOracleÏî
4>Ñ¡Ôñ HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\ServicesÏ£¬É¾³ýËùÓÐOracleÏî
5>Ñ¡Ôñ HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Eventlog\Applicationɾ³ýËùÓÐOracleÏî
4.ɾ³ý»·¾³±äÁ¿£ºÔÚ¿ØÖÆÃæ°å ->ϵͳ -> ¸ß¼¶ -> »·¾³±äÁ¿ -> ɾ³ý»·¾³±äÁ¿CLASSPATHºÍPATHÖÐÓйØOracleµÄÉ趨
5.ɾ³ýÎļþ£ºÉ¾³ýÔÚ C:\Program Files Ŀ¼Ï嵀 oracle Îļþ¼Ð£¬É¾³ý°²×°Ä¿Â¼ÏµÄoracle°²×°Îļþ¼Ð£¬É¾³ýËùÓÐÓйØOracleµÄ×éºÍͼ±ê£¬
ɾ³ýËùÓÐOracleÏà¹ØµÄODBCµÄDSNºÍµ½Ê¼þ²é¿´Æ÷ÖÐɾ³ýOracleÏà¹ØµÄÈÕÖ¾£¨Èç¹ûÓУ©¡£
      
ÒÔÉϵIJ½Ö裬Èç¹ûÓÐЩɾ³ý²»Á˵Ļ°£¬¾ÍÖØÆôÄãµÄ¼ÆËã»úÔÙ¼ÌÐøɾ³ý....


Ïà¹ØÎĵµ£º

ÇóÖú oracle 10g Á¬²»ÉÏ ÄÄλÅóÓÑ°ïæ½â¾öÒ»ÏÂ

Ï£Íû¸ßÊÖ¿ÉÒÔ°ïæһÏ  ²»Ê¤¸Ð¼¤
C:\Documents and Settings\Administrator>sqlplus /nolog
SQL*Plus: Release 10.2.0.3.0 - Production on ÐÇÆÚËÄ 5ÔÂ 20 17:23:05 2010
Copyright (c) 1982, 2006, Oracle.  All Rights Reserved.
SQL> conn system/manager as sysdba;
ÒÑÁ¬½Óµ½¿ÕÏÐÀý³Ì¡£
SQL> ......

oracleÍü¼Çsys¡¢systemÃÜÂë½â¾ö

Õâ¸öÆäʵºÜ¼òµ¥£¬²»¹ý×Ô¼º¾­³£Íü¼Ç£¬ËùÒÔ¼ÇÏÂÀ´
    sqlplus /nolog£»
    connect / as sysdba
    alter user sys identified by password£»
    alter user system identified by  password£» ......

Oracle SQL Developer¹¤¾ß

ÏÂÔؽâѹÁËOracle SQL Developer¹¤¾ß£¬ÔËÐÐʱ£¬Æô¶¯²»ÁË£¬±¨´íÐÅÏ¢ÈçÏ£º
---------------------------
Unable to create an instance of the Java Virtual Machine
Located at path:
<SQLDEVELOPER>\jdk\jre\bin\client\jvm.dll
---------------------------
ÊÇJVM²ÎÊýÉèÖõÄÎÊÌ⣬ÎҵĽâ¾ö·½°¸ÈçÏ£º
<SQ ......

oracleº¯Êý´óÈ« ×Ö·û´¦Àíº¯Êý

F.1×Ö·ûº¯Êý——·µ»Ø×Ö·ûÖµ
ÕâЩº¯ÊýÈ«¶¼½ÓÊÕµÄÊÇ×Ö·û×åÀàÐ͵IJÎÊý(CHR³ýÍâ)²¢ÇÒ·µ»Ø×Ö·ûÖµ.³ýÁËÌرð˵Ã÷µÄÖ®Íâ,ÕâЩº¯Êý´ó²¿·Ö·µ»ØVARCHAR2ÀàÐ͵ÄÊýÖµ.×Ö·ûº¯ÊýµÄ·µ»ØÀàÐÍËùÊܵÄÏÞÖƺͻù±¾Êý¾Ý¿âÀàÐÍËùÊܵÄÏÞÖÆÊÇÏàͬµÄ,±ÈÈç: VARCHAR2ÊýÖµ±»ÏÞÖÆΪ2000×Ö·û(ORACLE 8ÖÐΪ4000×Ö·û),¶øCHARÊýÖµ±»ÏÞÖÆΪ255×Ö·û(Ô ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ