ÎÞ·¨Æô¶¯ 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ô£¿ ʲôÒâ˼ ͻȻ¼äÕâÑùµÄÂð£¿ÓиĹýʲô¶«Î÷Âð£¿ÒýÓà ͻȻ¼äÕâÑùµÄÂð£¿ÓиĹýʲô¶«Î÷Â𣿠ÊǵÄ~~~È
Ïà¹ØÎÊ´ð£º
ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡ ORA-01034:ORACLE not available ORA-27101:shared memory realm does not exist ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡ 1. Oracle sid ÕýÈ ......
¼ÙÉètable01 ÖÐÓÐ ÒÔÏÂ×ÊÁÏ emp_no emp_name ------- ------------ 0001 TOM 0002 JOHN 0003 MARY ³£Óõ绰 ¶øÎÒÃÇÒªµÃµ½ÒÔϵÄOUTPUT (»òÊǸ÷ÖÖÆäËûµÄoutput) 0001,TOM 0002,JOHN
......
oracleº¯ÊýÈçÏ£º create or replace function P_WEB_GETCITYID ( p_mobileNumber in VARCHAR2, p_cityid out NUMBER ) Return NUMBER IS p_areacode varc ......
1.ÏÖÔÚϵͳÊÇ64λµÄserver2003£¨web·þÎñÆ÷IIS6.0£©×°µÄÊÇ10gµÄoracle¿Í»§¶Ë¡£ 2.Êý¾Ý¿â·þÎñÆ÷ͬÑùÊÇ32λµÄserver2003µÄoracle10g¡£ 3.web·þÎñÆ÷ÉÏÓÃsqlplus·ÃÎÊÊý¾Ý¿â-Õý³££» vs2008ÄÚ²¿½¨Á¢Êý¾ÝÔ´£¬·ÃÎÊ ......