Oracle°²×° - Oracle / »ù´¡ºÍ¹ÜÀí
ÔÚwin7ϰ²×°OracleûÓÐORCL·þÎñ³ÌÐò£¬Çë¸÷λ¸ßÊÖÖ¸µãÖ¸µã°¡£¡
ORACLE°æ±¾ÎÊÌâ,ÀúÊ·Ìù×Ӳο¼ÏÂ.... ÕýÔÚ¼ì²é²Ù×÷ϵͳҪÇó... ÒªÇóµÄ½á¹û: 5.0,5.1,5.2,6.0 Ö®Ò» ʵ¼Ê½á¹û: 6.1 ¼ì²éÍê³É¡£´Ë´Î¼ì²éµÄ×ÜÌå½á¹ûΪ: ʧ°Ü <<<< ÎÊÌâ: Oracle Database 11g δÔÚµ±Ç°²Ù×÷ϵͳÖо¹ýÈÏÖ¤¡£ ½¨Òé°¸: È·±£ÔÚÕýÈ·µÄƽ̨Éϰ²×°Èí¼þ¡£ ======================================================== ÕýÔÚ¼ì²é Service Pack ÒªÇó... ¼ì²éÍê³É¡£´Ë´Î¼ì²éµÄ×ÜÌå½á¹ûΪ: δִÐÐ <<<< OUI-18001: ²»Ö§³Ö²Ù×÷ϵͳ 'Windows Vista °æ±¾ 6.1'¡£ ½¨Òé°¸: Çë°²×°½¨ÒéµÄ Service Pack¡£ ======================================================== Çó½â£¡ Ö±½Ó°²×°32λµÄ¾Í¿ÉÒÔÁË¡£²»ÒªÓÃoracle for vistaµÄ¡£ win7ϰ²×°oracleȷʵÎÊÌâ¶à¶à£¬¿´¹ý¼¸¸öÏà¹ØµÄÌû×Ó£¬ÔÚÐéÄâ»úÀïÊÔÑéÁËÏ»¹ÊÇδÄܳɹ¦¡£ ²Î¿¼ Òѽâ¾öÁË ºÇºÇ ÕÒµ½ refhost.xml Îļþ£¨Î»Öãºdatabase\stage\prereq\db £¬¿ÉÒÔʹÓüÆËã»úµÄËÑË÷¹¦ÄÜ£©£¬´ò¿ª refhost.xml ÅäÖÃÎļþ²¢ÕÒµ½ <CERTIFIED_SYSTEMS> ½Úµã£¬½Ó×ÅÔÚ½ÚµãºóÃæÌí¼ÓÒÔÏÂÄÚÈݲ¢±£´æ¼´¿É£º <!--Microsoft Windows 7--> <OPERATING_SYSTEM> <VERSION VALUE="6.1"/> </OPERATING_SYSTEM>ÒýÓà Òѽâ¾öÁË ºÇºÇ ÕÒµ½ refhost.xml Îļþ£¨Î»Öãºdatabase\stage\prereq\db £¬¿ÉÒÔʹÓüÆËã»úµÄËÑË÷¹¦ÄÜ£©£¬´ò¿ª refhost.xml ÅäÖÃÎļþ²¢ÕÒµ½ <CERTIFIED_SYSTEM
Ïà¹ØÎÊ´ð£º
ÓÃ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
......
java.sql.SQLException: Io Òì³£: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=186646784)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4)))) at oracle.jdbc.dbaccess.DBError.throwSqlException(DBErro ......
oracle ͨ¹ýBDlink Á¬½Óµ½Ò»Ì¨MS SQL,²éѯ¶¼¿ÉÒÔ,µ«ÊDz»ÖªµÀÈçºÎÔÚoracleͨ¹ýDBLinkµ÷ÓÃMS SQLµÄ´æ´¢¹ý³Ì,Çó½â~лл~ ÒýÓà oracle ͨ¹ýBDlink Á¬½Óµ½Ò»Ì¨MS SQL,²éѯ¶¼¿ÉÒÔ,µ«ÊDz»ÖªµÀÈçºÎÔÚoracleͨ¹ýDBLinkµ÷ÓÃM ......
дPL/SQL·¢ÏÖ, DBMS_OUTPUT.PUT_LINE(to_date('2010/05/19','yyyy/MM/dd')); ºǫ́Êä³ö»¹ÊÇ10-05-19 ÎÞÂÛ¸ñʽÔõô¸Ä¶¼ÊÇÕâÑùÊäÈë,²»Ã÷°×°¡!!! ÓÃDevoloperÀ´¿ª·¢µÄ.. dbms_output.put_line()ÀïÃæµÄ²ÎÊýÊ ......