ÎÞ·¨Æô¶¯ 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ô£¿ ʲôÒâ˼ ͻȻ¼äÕâÑùµÄÂð£¿ÓиĹýʲô¶«Î÷Âð£¿ÒýÓà ͻȻ¼äÕâÑùµÄÂð£¿ÓиĹýʲô¶«Î÷Â𣿠ÊǵÄ~~~È
Ïà¹ØÎÊ´ð£º
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£ ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î date(Ö÷) outid(Ö÷) inid(Ö÷) num amt 2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡ ORA-01034:ORACLE not available ORA-27101:shared memory realm does not exist ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡ 1. Oracle sid ÕýÈ ......
ORACLEÅàѵ(OCA)ÈÏÖ¤½éÉÜ Oracle10g Certified Associate (OCA) Oracle ÈÏ֤רԱ¡£ ¿¼ÊԳɼ¨Í¨¹ýÄÜ»ñµÃOracle¹«Ë¾ÎªÄú°ä·¢µÄÈ«ÇòÈÏÖ¤µÄÓ¢ÎÄOCAÖ¤Êé¡£OCAÓÉOracle¹«Ë¾³öÌâ¡£ ¸ÃÖ¤Êé¿É×÷Ϊ¸÷ÆóÊÂÒµµ¥Î»Êý¾Ý¿ ......
1.ÏÖÔÚϵͳÊÇ64λµÄserver2003£¨web·þÎñÆ÷IIS6.0£©×°µÄÊÇ10gµÄoracle¿Í»§¶Ë¡£ 2.Êý¾Ý¿â·þÎñÆ÷ͬÑùÊÇ32λµÄserver2003µÄoracle10g¡£ 3.web·þÎñÆ÷ÉÏÓÃsqlplus·ÃÎÊÊý¾Ý¿â-Õý³££» vs2008ÄÚ²¿½¨Á¢Êý¾ÝÔ´£¬·ÃÎÊ ......