ÎÞ·¨Æô¶¯ Oracle ¼àÌýÆ÷ - Oracle / »ù´¡ºÍ¹ÜÀí
ÔÚ Linux ϰ²×° Oracle ºó£¬Ò»ÇÐÔËÐÐÕý³£¡£ ¿ÉÊǵڶþÌìÖØÆô Linux ºó£¬ Oracle µÄ¼àÌýÆ÷Ôõô¶¼Æð²»À´¡£´íÎóÐÅÏ¢ÊÇ£º TNS-12537: TNS:connection closed TNS-12560: TNSrotocol adapter error TNS-00507: Connection closed Linux Error: 29: Illegal seek ÔÚÍøÉÏÕÒ²»µ½½â¾ö·½·¨¡£ listener.ora ÖеÄÅäÖÃÊÇ£º ######################################## LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) ) ) ADR_BASE_LISTENER = /home/oracle_11/app ########################################### /etc/hosts µÄÐÅÏ¢ÊÇ£º ########################################### 127.0.0.1 localhost.localdomain localhost ::1 localhost6.localdomain6 localhost6 ###########################################
ÄãûÓÐhostnameô£¿ ½«localhost»»³ÉÊý¾Ý¿â·þÎñÆ÷µÄipµØÖ·ÊÔÊÔ¿´°É£¡ÒýÓà ½«localhost»»³ÉÊý¾Ý¿â·þÎñÆ÷µÄipµØÖ·ÊÔÊÔ¿´°É£¡ ¸Ä¹ý~~²»Ðа¡~~~ÒýÓà ÄãûÓÐhostnameô£¿ ʲôÒâ˼ ͻȻ¼äÕâÑùµÄÂð£¿ÓиĹýʲô¶«Î÷Âð£¿ÒýÓà ͻȻ¼äÕâÑùµÄÂð£¿ÓиĹýʲô¶«Î÷Â𣿠ÊǵÄ~~~È
Ïà¹ØÎÊ´ð£º
ÔÚÖ´ÐаüµÄʱºòÒýÓÃ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 ......
¿´µ½ÓÐÒ»¸öSUNµÄÔªÀÏ´ÓOracle¹«Ë¾´ÇÖ°£¬¶øÇÒÊÇJava´´Ê¼ÈË——´óÃû¶¦¶¦µÄJames Gosling£¬ ÐÄÖÐÏ൱ÊÜ´ò»÷£¡ºÜ±¯Í´£¡ OrableÕâÊÇÔõôÁË£¬ÄѵÀÕâ¾ÍÊÇËùνµÄÈںϣ¨Ö«½â£¬·Ö»¯£¬Ïûʧ£©Â𣿠SUNµÄÒ»°ïÀÏÔ±¹¤¶ ......
oracle ͨ¹ýBDlink Á¬½Óµ½Ò»Ì¨MS SQL,²éѯ¶¼¿ÉÒÔ,µ«ÊDz»ÖªµÀÈçºÎÔÚoracleͨ¹ýDBLinkµ÷ÓÃMS SQLµÄ´æ´¢¹ý³Ì,Çó½â~лл~ ÒýÓà oracle ͨ¹ýBDlink Á¬½Óµ½Ò»Ì¨MS SQL,²éѯ¶¼¿ÉÒÔ,µ«ÊDz»ÖªµÀÈçºÎÔÚoracleͨ¹ýDBLinkµ÷ÓÃM ......
SQL code: CREATE OR REPLACE PROCEDURE usp_refreshTopN IS BEGIN --Îĵµ INSERT INTO topnresource(resourceId,title,type,cover,brief,properUser,tag,clickAmount,createDate,topNCreateDate,organizat ......