oracleÊý¾Ý¿â1521¶Ë¿Ú´ò²»¿ª!
ÎÒµÄORACLE×òÌ컹´òµÄ¿ª£¬½ñÌìͨ¹ý1521¶Ë¿Ú·ÃÎÊ£¬·ÃÎʲ»³É£¬ä¯ÀÀÆ÷һֱûÏìÓ¦¡£OracleOracle9iTNSListenerÒ²Æô¶¯²»ÁË¡£
µ«ÊÇͨ¹ýhttp://host:7778/isqlplusµÄ¶Ë¿ÚÈ´¿ÉÒÔ·ÃÎÊ¡£
ÕâÊÇʲôÔÒò£¬Á½¸ö¶Ë¿ÚÓÐÊ²Ã´Çø±ð£¿
ÄãµÄtnslistener·þÎñûÓÐÆô¶¯£¬ËùÒÔ1521²»ÄÜÁ¬½Ó¡£
isqlplusÊÇÁíÒ»¸ö·þÎñ£¬Õâ¸ö·þÎñÊÇÆô¶¯³É¹¦µÄ£¬ËùÒÔÄã¿ÉÒÔÓÃisqlplusÁ¬½Ó¡£
1521ÊÇsqlplusµÄÁ¬½Ó¶Ë¿Ú£¬ËùÒÔ²»ÊÇÓÃä¯ÀÀÆ÷´ò¿ªµÄ¡£
ÄãÏÈ¿´¿´listenerΪʲô·þÎñ²»ÄÜÆô¶¯¡£
ÄãÔÚÃüÁîÐÐģʽÔËÐÐÃüÁî lsnrctl start¿´¿´ÓÐûÓÐʲô´íÎó»òÕßÐÅÏ¢¡£
¶Ë¿ÚÊÇÔÚ$ORACLE_HOME\install\portlist.iniÎļþÀïÖ¸¶¨µÄ£¬Ð޸Ķ˿ںóÖØÆô·þÎñ¾Í¿ÉÒÔÉúЧÁË£¿
SQL code:
iSQL*Plus HTTP ¶Ë¿ÚºÅ =5560
Enterprise Manager Console HTTP ¶Ë¿Ú (orcl10g) = 1158
Enterprise Manager ´úÀí¶Ë¿Ú (orcl10g) = 3938
inthirties:
ÔËÐÐlsnrctl startºóÏÔʾ¡£
LSNRCTL for 32-bit Windows: Version 9.2.0.1.0 - Production on 16-9ÔÂ -2009 15:59
:48
Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.
Æô¶¯tnslsnr£ºÇëÉÔºò...
Service OracleOracleTNSListener already running.
TNS-12560: TNS: ÐÒéÊÊÅäÆ÷´íÎó
TNS-00530: ÐÒéÊÊÅäÆ÷´íÎó
32-bit Windows Error: 1056: Unknown error
¼àÌýÆ÷Æð²»À´ÊÇʲôÔÒò£¿
ÏÖÔÚ7778Ò²½ø²»È¥ÁË£¬ÊäÈëÓû§ÃûºÍÃÜ
Ïà¹ØÎÊ´ð£º
ÔÚlomboz eclipseÖеÄwindow->show view->others->ÖеÄÔõÑù¼ÓÈëconnectivityÖеÄdata sourceÖÐÁ¬½ÓoracleʱֻÓÐ8,9,10ÕâÈý¸ö°æ±¾£¬ÔõÑù²ÅÄÜÁ¬½Óoracle11Õâ¸ö°æ±¾ÄØ£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿
......
Êý¾Ý¿â£ºOracle10g(10.2)
Ó¦ÓãºÒ»¸öC#µÄ³ÌÐòдÊý¾Ý¿â£¬Ò»¸öJSP³ÌÐò¶ÁÊý¾Ý¿â
¸ºÔØ£ºÄ¿Ç°´¦ÓÚ¿ª·¢½×¶Î£¬»ù±¾ÉÏÖ»ÓÐ3-4¸öÓû§·ÃÎÊJSPÍøÕ¾¡£
ÏÖÏó£ºÖØÐÂÆô¶¯ºóµÄÊý¾Ý¿â²éѯ·Ç³£¿ì£¬µ«ÊÇÓÃ×ÅÓÃ×ÅÔ½À´Ô½Âý£¬ËùÓÐJSPÍøÒ ......
°²×°ÁËOracle 10g£¬Ä¬Èϰ²×°ÁËorclÊý¾Ý¿â£¬Õâ¸öÊý¾Ý¿âÄܲ»ÄÜɾ³ý°¡£¬»¹ÓÐÎÒÈç¹ûн¨ÁËÆäËûÊý¾Ý¿â£¬Ôõô֪µÀÔÚwebÖеǽ²»Í¬Êý¾Ý¿âµÄµØÖ·°¡£¿
1
¿ÉÒÔɾ³ý
2
ÔÚWEBµØÖ·À¸ÖÐÊäÈëµØÖ·µÄʱºòÖ¸¶¨Ð´´½¨µÄÊý¾Ý¿âµÄIP ......
ÇëÎÊÔÚoracleÖÐÈçºÎʵÏÖЧ¹û¾ÍÏñÔÚSQL ServerÖÐ"select top " + pageSize + " * from tb_user where id not in (select top " + curPage*pageSize + " id from tb_user) and units_id=1&qu ......