ÎÒÔÚwin2008 32bitÉÏ×°oracle databaseʱ³öÏÖ"δ֪ δ֪ δ֪"´íÎó,²»ÖªµÀÊÇʲôÔÒò,ÓÐÄÄλ¸ßÊÖÖªµÀµÄ,Ö¸µ¼Ï°¡
ÒÔǰװ¹ýOracleûÓÐ???Èç¹ûÔø¾×°¹ý,ÏÈÇå¿ÕËùÓÐoracleÄÚÈÝ
www.oracle.com
È·ÈÏÄãÏÂÔØµÄ°æ±¾ÕýÈ·¡£
ÎÒ×°µÄÊÇoracle10g 10.2.0,¾Ídatabase×°²»ÉÏ,client¿ÉÒÔ×°³É¹¦µÄ
¾Í2008ÉÏ× ......
±¾µØ»úÆ÷tnsnames.ora
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = fuqiang)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
SER ......
ÓÐÖªµÀµÄ¸ø¸öÕýÈ·µÄ´ð°¸£¬²ôË®²»¸øÄã·ÖŶ
ÄÇÒª¿´Äã´æµÄÊÇʲôÁË
ÄãÒª´æ¸öabc½øÈ¥¿Ï¶¨²»Ðа¡
Ö»ÒªÊÇ´¿Êý×ֵϰ¿ÉÒÔµÄ,ORACLEÊÇ»á×Ô¶¯×ª»»ÀàÐ͵Ä
Äãдһ¾äÊÔÊÔ°¡£¡
Ö»Òª¶¼ÊÇÊý×־ͿÉÒÔ£¬µ«ÊÇÖ»ÒªÓÐÒ»ÐÐÊý¾Ý²»ÊÇÊý×־ͻᱨ´í¡£
SQL code:
SQL> select '1234'+'1234' from dual;
'1234'+'1234'
-- ......
ÒªÔõôÅäÖòÅÄÜʵÏÖ£¬¿Í»§¶ËÈ¥Á¬½Ó·þÎñÆ÷ÄØ£¬ÓÐûÓиßÈË¿ÉÒÔÏêϸ˵Ã÷һϡ£
ÅäÖúÃÑù±¾£º
SERVER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST =88.88.88.88)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
......
ÈçÌ⣬ÎÒ×Ô¼ºµÄÀí½âÊÇvalidºÍinvalid״̬±íʾ±àÒëÄܲ»ÄÜͨ¹ýµÄ״̬£¬enable/disable±íʾµÄÊÇ£º±àÒëͨ¹ýÁË£¬Ö»ÊÇÉèÖÃÁ˿ɲ»¿ÉÓÃ״̬¡£
²»ÖªµÀÎÒÕâÑùÀí½â¶Ô²»¶Ô£¿
Èç¹û´¥·¢Æ÷ÓÃʱ¼ä³¤ÁË£¬ÆäËûµÄʲôÔÒò£¬²»¹¤×÷ÁË£¬µ«ÊDZàÒë¿ÉÒÔͨ¹ý,´úÂëûÓÐÎÊÌ⣬ÄÇôenable »á±ä³Éinvalid£¬»¹ÊDZä³É disable °¡£¿
enable±ä ......
±¾ÈËÏë×öÒ»¸öÏÔʾOracleÖÐͼƬµÄ½çÃæ£¬µ«ÊǽñÌìÉÏÍøÕÒÁËÒ»ÌìҲûÓз¢ÏֱȽÏÏêϸµÄ½éÉÜ£¬¶¼Ìáµ½ÒªÓÃTTableºÍTDatabase£¬µ«ÊÇÎÒÅä²»¶ÔTTable£¬×ÜÊDZ¨"general error ORA:90036 ȱʧ±í´ïʽ"µÄ´í£¬ÄÄλ¸ßÊÖÄܸøÖ¸µãϰ¡
×îºÃÄÜÓиö¼òµ¥µÄʾÀý£¬½²½âÏÂÔõôÍê³É¶ÁȡͼƬµÄ£¬Ð»ÁË¡£
LazarusÉÏÓиö TOracleConnection ......