ÎÞ·¨Æô¶¯ 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·þÎñÆ÷ÉÏÃæµÄÔʼÎļþ,ÏÂÔØµ½±¾»úÁË.ÎÒÏëÔÚ±¾»ú·ÃÎÊÊý¾Ý¿âÔõôÉèÖð¡.ÊDz»ÊÇÀàËÆ¿ÉÒÔ½¨Á¢Ò»¸öʲôÐéÄâ·þÎñÆ÷À´ÊµÏÖ.Çë´ó¼Ò³ö³öÖ÷Òâ ÒýÓà ´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæ ......
ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡ ORA-01034:ORACLE not available ORA-27101:shared memory realm does not exist ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡ 1. Oracle sid ÕýÈ ......
ÎҵĴ¦ÀíÊÇÕâÑùµÄ£º ÎÒÓÐÒ»¸öºÜ´óµÄÊý¾Ý¼¯ºÏ£¬´¦ÓÚÐÔÄÜ·½ÃæµÄ¿¼ÂÇÐèҪʹÓÃÁÙʱ±í¹ý¶É£¬²¢ÇÒʹÓ÷ÖÒ³µÄ·½Ê½ÏòÁÙʱ±íÖвåÈëÊý¾Ý£¬Êý¾ÝʹÓÃÍê±Ïºó£¬É¾³ýÁÙʱ±íµÄÊý¾Ý¡£ ³öÏÖµÄÏÖÏ󣺵±OracleÖØÐÂÆô¶¯ºó£¬µÚÒ»Ò³²åÈëµÄ ......
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 ......