Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

oracle 10g webµÇ½EMµÄÎÊÌ⣿ - Oracle / »ù´¡ºÍ¹ÜÀí

°²×°ÁËOracle 10g£¬Ä¬ÈÏ°²×°ÁËorclÊý¾Ý¿â£¬Õâ¸öÊý¾Ý¿âÄܲ»ÄÜɾ³ý°¡£¬»¹ÓÐÎÒÈç¹ûн¨ÁËÆäËûÊý¾Ý¿â£¬Ôõô֪µÀÔÚwebÖеǽ²»Í¬Êý¾Ý¿âµÄµØÖ·°¡£¿

1
¿ÉÒÔɾ³ý
2
ÔÚWEBµØÖ·À¸ÖÐÊäÈëµØÖ·µÄʱºòÖ¸¶¨Ð´´½¨µÄÊý¾Ý¿âµÄIPµØÖ·£¨Õâ¸öÎÒûÊÔ¹ý ²ÂµÄ ¾õµÃ¶Ë¿ÚºÅÓ¦¸Ã²»Í¬°É£©



ÒýÓÃ
ËûÃǵĶ˿ÚÊDz»Ò»ÑùµÄ

D:\oracle\product\10.2.0\db_1\install Ŀ¼ÏÂÓиöportlist.iniÎļþ£¬ÀïÃæÖ¸¶¨¶Ë¿ÚµÄ

iSQL*Plus HTTP ¶Ë¿ÚºÅ =5560
Enterprise Manager Console HTTP ¶Ë¿Ú (orcl10g) = 1158
Enterprise Manager ´úÀí¶Ë¿Ú (orcl10g) = 3938
Enterprise Manager Console HTTP ¶Ë¿Ú (TEST) = 1158
Enterprise Manager ´úÀí¶Ë¿Ú (TEST) = 3938

http://localhost:1158/em



£¿ÄãÌù³öÀ´µÄÄÚÈÝÔõôºÃÏñÁ½¸ö¶Ë¿ÚÊÇÒ»ÑùµÄ

»¹ÓÐŶ 
ÎÒûÕÒµ½Äã˵µÄĿ¼ÖеÄÎļþ
oracleÏÂûÓÐproductÕâ¸öÎļþ¼Ð

ÒýÓÃ
ÒýÓà 1 Â¥ tianlesoftware µÄ»Ø¸´:
ËûÃǵĶ˿ÚÊDz»Ò»ÑùµÄ

D:\oracle\product\10.2.0\db_1\install Ŀ¼ÏÂÓиöportlist.iniÎļþ£¬ÀïÃæÖ¸¶¨¶Ë¿ÚµÄ

iSQL*Plus HTTP ¶Ë¿ÚºÅ =5560
Enterprise Manager Console HTTP ¶Ë¿Ú (orcl10g) = 1158
Enterprise Manager ´úÀí¶Ë¿Ú (orcl10g) = 3938
Enterprise Manager Console HTTP ¶Ë¿Ú (TEST) = 1158
Enterprise Manager ´úÀí¶Ë¿Ú (TEST) = 3938

http://localhost:1158/em



£¿ÄãÌù³öÀ´µÄÄÚÈÝÔõôºÃÏñÁ½¸ö¶Ë¿ÚÊÇÒ»ÑùµÄ

»¹ÓÐŶ
ÎÒûÕÒµ½Äã˵µÄĿ¼ÖеÄÎļþ


Ïà¹ØÎÊ´ð£º

ORACLEÊý¾Ý¿âÖÐµÄ group by Óï¾ä£¿

  with adod_dict do
    begin
    close;
    commandtext:='select bgqxcode,count(*) wjsl from wscl_wsda_file where wjnd=:tnd group by bgqxcode'; ......

Oracle Æô¶¯µÄÎÊÌâ

oracle not available
shared memory realm does not exist
ÇëÎʸßÊÖÕâ¸öÎÊÌâÈçºÎ½â¾ö£¿
http://www.inthirties.com/thread-109-2-1.html

Ö¸¶¨ÏÂORACLE_SID,ORACLE_HOME¿´¿´£¬²»ÐоÍÓÃ1Â¥µÃ·½·¨ÁË..

cm ......

Oracle¿Í»§¶Ë°²×°ºóODBCÎÞ·¨Ê¹ÓÃ

°²×°11gµÄ06,´ò²¹¶¡Éýµ½07£¬´ÓODBCÀïÃæ¿´£¬ÓÐ
Oracle in OraOdac11g_home1 11.01.00.07
´Ó×¢²á±í¿´HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\ÏÂÃæµÄDriverºÍSetup¶¼ÊÇÎҵݲװ·¾¶
"D:\\app\\Ad ......

¼±ÎÊÒ»¸öoracle×Ö¶ÎÉèÖõÄÎÊÌâ - Oracle / »ù´¡ºÍ¹ÜÀí

¸÷´óÀÏʦºÃ£¬Çë½ÌÒ»¸öÎÊÌ⣮
ÎÒÉèÖÃÁËÒ»¸öoracle×ֶΣ¬varchar(3000),È»ºó²åÈëÒ»ÌõÊý¾Ý³¤¶È²Å1000,¾Í±¨´íÁË£®È磺net.sf.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
Caused ......

´ÓORACLEµ½DB2µÄSQLÓï¾äÎÊÌâ

ÏÖÔÚÓÐÒ»ORACLEÖеÄSQLÓï¾ä£¬ÐèÒªÒÆÖ²µ½DB2ÖУ¬ÇëÎʸÃSQL¸ÄÈçºÎд
ORACLEÖУº
select floor(months_between(date1,date2)) from A  
date1,date2·Ö±ðΪ±íÖеÄÁ½¸ö×ֶΠ£¬¶¼ÎªÈÕÆÚÐÍ 
DB2ÖÐÈçºÎʹÓÃÐ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ