¹ØÓÚ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½Ö裬Èç¹ûÓÐЩɾ³ý²»Á˵ϰ£¬¾ÍÖØÆôÄãµÄ¼ÆËã»úÔÙ¼ÌÐøÉ¾³ý....
Ïà¹ØÎĵµ£º
1.desc(ÃèÊö£© emp ÃèÊöempÕâÕűí
2.desc dept ²¿Ãűí
3.desc salgrade нˮµÈ¼¶
4.select *from table ²éÕÒ±íÖеÄÔªËØ
5.dual &nbs ......
×îÐÂoracle ²¹¶¡ÏÂÔØ
ʹÓÃѸÀ×н¨ÈÎÎñÏÂÔØµØÖ·Ìîд
ftp://updates.oracle.com/<patch_num>/p<patch_num>_<version>_<os>.zip
¾Í¿ÉÒÔÏÂÔØµ½ÄãÏëÒªµÄ²¹¶¡ÁË¡£
ÒÔÏÂÊǼ¸¸ö³£Óò¹¶¡µÄÏÂÔØµØÖ·¡£
(10.2.0.3 patch)
ftp://updates.oracle.com/5337014/p5337014_10203_WINNT.zip ftp://updates.o ......
ÓÃQt¿ª·¢Oracle³ÌÐòʱ£¬³£»áÓöµ½QOCIÇý¶¯ÎÊÌ⣬Ö÷Òª±íÏÖΪ³ÌÐòÔËÐÐʱ³öÏÖÏÂÃæµÄ´íÎó¡£
QOCI driver not loaded
available drivers: QSQLITE QODBC3 QODBC
Õâ˵Ã÷ûÓа²×°QtÖ§³ÖOracleµÄÇý¶¯¡£
.
ÒªÏë±ÜÃâÕâ¸öÎÊÌ⣬µÚÒ»ÖÖ·½·¨ÊÇʹÓÃЧÂʵÍϲ¢ÇÒ·ÑʵÄODBC£»µÚ¶þÖÖ·½·¨¾ÍÊǰ²×°QOCIÇý¶¯¿©~
.
Ҫ˵һϵÄÊÇ£ºQOCIÔÚqt ......
F.1×Ö·ûº¯Êý——·µ»Ø×Ö·ûÖµ
ÕâЩº¯ÊýÈ«¶¼½ÓÊÕµÄÊÇ×Ö·û×åÀàÐ͵IJÎÊý(CHR³ýÍâ)²¢ÇÒ·µ»Ø×Ö·ûÖµ.³ýÁËÌØ±ð˵Ã÷µÄÖ®Íâ,ÕâЩº¯Êý´ó²¿·Ö·µ»ØVARCHAR2ÀàÐ͵ÄÊýÖµ.×Ö·ûº¯ÊýµÄ·µ»ØÀàÐÍËùÊܵÄÏÞÖÆºÍ»ù±¾Êý¾Ý¿âÀàÐÍËùÊܵÄÏÞÖÆÊÇÏàͬµÄ,±ÈÈç: VARCHAR2ÊýÖµ±»ÏÞÖÆÎª2000×Ö·û(ORACLE 8ÖÐΪ4000×Ö·û),¶øCHARÊýÖµ±»ÏÞÖÆÎª255×Ö·û(Ô ......