PL/SQL Á¬½ÓOracle£¬N¾ÃûÁ¬ÉÏ£¡¾È¼±
±¾ÈË×°µÄÊÇplsql7.0£¬»úÆ÷ÉÏûÓа²×°Oracle¿Í»§¶Ë£¬ÊDzÉÈ¡ÍøÉÏÄÇÖÖ¼òÒ×°²×°À´°²×°µÄ£¬ ¿ªÊ¼Ö®³õÊÇ¿ÉÒÔÁ¬ÉÏOracleÊý¾Ý¿â·þÎñÆ÷£¬¿ÉÊÇijÌìÖØÐ°²×°ÁËÒ»´ÎOracle¿Í»§¶Ë£¬ÇÒ°ÑOracle¿Í»§¶Ëɾ³ýºó£¬ ÔÙÀûÓÃÍøÉϵÄÂÌÉ«Á¬½ÓOracle·½·¨£¬¾Í²»¿ÉÐÐÁË ´óÅ£ÃÇ£¬¾È¾È¼±°¡°¡°¡°¡°¡£¡£¡
ÕÒÏÂtnsnames.oraÎļþ£¬¿´¿´Á¬½ÓÊÇ·ñÅäÖÃÕýÈ· plsqlÖÐÓиöÑ¡ÏÉèÖóÉoracleName¾Í¿ÉÒÔÁËÒýÓà ÕÒÏÂtnsnames.oraÎļþ£¬¿´¿´Á¬½ÓÊÇ·ñÅäÖÃÕýÈ· up ÓÐʲôÌáʾ£¬Ìù³öÀ´¿´Ò»Ï¡£ÒýÓà ÒýÓà 1 Â¥ csuxp2008 µÄ»Ø¸´: ÕÒÏÂtnsnames.oraÎļþ£¬¿´¿´Á¬½ÓÊÇ·ñÅäÖÃÕýÈ· up ÎÒµÄtnsnames.oraÎļþÈçÏ£º # TNSNAMES.ORA Network Configuration File: C:\oracle\ora92\NETWORK\ADMIN\tnsnames.ora # Generated by Oracle configuration tools.(SERVER = DEDICATED) # Çë¸ù¾Ýʵ¼ÊÇé¿öÔÚ±¾ÎļþÖÐÔö¼ÓÏàÓ¦µÄÁ¬½Ó²ÎÊý DDDD_X.X.X.X = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = X.X.X.X)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = DDDD_192.168.242.26) ) ) ²é¿´²¢È·ÈÏÄãµÄʵÀýÃûÊÇ·ñÊÇDDDD_192.168.242.26 ¸öÈ˾õµÃ×îºÃ±ðÓÃ. ¼ì²éÁ¬½ÓÊÇ·ñÕýÈ· ÔÚPLSQL DeveloperÖÐÑ¡Ôñ ¹¤¾ß-Ê×Ñ¡Ïî£Á¬½Ó,ÒÔÏÂÁ½ÏîÐèÕýÈ·ÅäÖà Oracle Ö÷Ŀ¼Ãû OCI¿âÒýÓà ¼ì²éÁ¬½ÓÊÇ·ñÕýÈ· ÔÚP
Ïà¹ØÎÊ´ð£º
ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£ ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£ ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£ ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......
ÔÚÖ´ÐаüµÄʱºòÒýÓÃoracle spatial¿Õ¼äº¯Êý³ö´í£¬³ö´íÇé¿öÈçÏ Errors in file /user/oracle/app/oracle/admin/grid/udump/grid1_ora_143768.trc: ORA-29902: error in executing ODCIIndexStart() routine ORA-0 ......
¸÷λ´ó¸ç£¬°ï¸öæ¡£ ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ 10GºÍ11GµÄ http://www.oracle.com/technology/software/products/database/index.html ------------------------------------------- ......
ÔÚϵͳÔËÐеÄʱºò×ÜÊÇÓÐÒ»¿é´ÅÅÌʼÖÕÉÁºìµÆ£¬½øÈëϵͳºó #topas²é¿´×ÜÊÇÓÐÒ»¿é´ÅÅÌ%BUSYΪ90%ÒÔÉÏ£¬ Êý¾Ý¿â°æ±¾£ºoracle 9.2.0.7 Êý¾ÝÎļþ¹ÒÔØµÄ½Úµã£º/oradata/pcs/ Âß¼¾íºÅlv04 #lslv -l lv04
......