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

[ÇóÖú] oracleÎÞ·¨Æô¶¯

·þÎñÆ÷ϵ缸Ììºó½ñÌìÉϵ磬Êý¾Ý¿âÈ´ÔõôҲÆð²»ÁËÁË£¬¾ßÌåÇé¿öÈçÏ£º

SQL> startup
ORACLE instance started.

Total System Global Area 5010685952 bytes
Fixed Size                  2159272 bytes
Variable Size            3758099800 bytes
Database Buffers        1207959552 bytes
Redo Buffers              42467328 bytes
ORA-03113: end-of-file on communication channel
Process ID: 5465
Session ID: 665 Serial number: 3


alert.logÎļþƬ¶Î£º
Mon Jul 30 07:40:40 2007
MMNL started with pid=15, OS id=5872
starting up 1 shared server(s) ...
ORACLE_BASE from environment = /opt/oracle
Mon Jul 30 07:40:40 2007
ALTER DATABASE  MOUNT
Errors in file /opt/oracle/diag/rdbms/amw/amw/trace/amw_mman_5858
ORA-27103: internal error
Linux-x86_64 Error: 11: Resource temporarily unavailable
Additional information: -1
Additional information: 1
MMAN (ospid: 5858): terminating the instance due to error 27103
Instance terminated by MMAN, pid = 5858


amw_mman_5858ÎļþÄÚÈÝ£º
Trace file /opt/oracle/diag/rdbms/amw/amw/trace/amw_mman_5858.trc
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, Ora


Ïà¹ØÎÊ´ð£º

Oracle ÈÕÆÚ²éѯÎÊÌâ

ÎÒÓÐÒ»ÕűíÓиö×Ö¶ÎÃû³ÆÊÇstarttime ÀàÐÍÊÇDATE ,ÆäÖÐÓÐÒ»ÐеÄÖµÊÇ"11:00:00",ÎÒÏë°ÑÕâÒ»ÁÐÑ¡³öÀ´,Óï¾äÈçÏÂ:
select * from routebanci where starttime='11:00:00' and routename='*** ......

ÐÂÊÖÌáÎÊ oracle ´æ´¢¹ý³ÌÎÊÌâ

д¸ö´æ´¢¹ý³Ì
±íTMP
NAME  TYPE
СÃ÷  1
С¶þ  1

Èç¹ûÓÐTYPE Ϊ1µÄ ·µ»Ø 1 »¹ÓРСÃ÷,С¶þ      ûÓзµ»Ø0
û¿´Ã÷°×£¬Ôõô¸ö·µ»Ø·¨£¿

·µ»ØÊä³ö²ÎÊý  Ö ......

oracle BLOB´ó×ֶζÁд³öÏÖÎÊÌâ

ÏÂÃæÊÇÎÒÔÚÍøÉÏÕÒµÄBLOB¶Áд³ÌÐò£¬µ«ÊÇÒ»Ö±ÔËÐв»³öÀ´£¬ÓÐÒ»ÐÐ
blob = (BLOB)rst.getBlob(1);
Ò»Ö±±¨´í£¬Exception in thread "main" java.lang.UnsupportedOperationException
at sun.jdbc.odb ......

¼±Ñ°Oracle ERPʵʩ¹ËÎÊ

3-5ÈË£¬¹¤×÷µØµãÉϺ£ÆÖ¶«Èí¼þÔ°£¬2-3Äê¾­Ñ飬ӢÎÄÁ÷Àû£¬ÓÐÒâÕßÇëÁªÏµ38954510-1355£¬15821699737£¬y.ming@live.cn
×Ô¼º¶¥¡£¡£¡£

ûÓÐORACLE ERPµÄ¾­Ñé,ÓÐÓÃÓѺÍTIPTOP¾­Ñé,Ó¢Óï˵²»ºÃ,¿´»¹ÊÇ¿ÉÒÔ!
²»ÖªµÀÓÐûÓÐ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ