[ÇóÖú] 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
Ïà¹ØÎÊ´ð£º
ÈÕǰÓÃociº¯Êý²éѯoracleÊý¾Ýʱ³öÏÖ¸öÎÊÌ⣬¾ÍÊÇÔÚ²éѯµ½dateÀàÐ͵ÄÊý¾Ýʱ£¬Ê¹ÓÃpl/sql ²éѯoracle¿âÖеÄÊý¾ÝÏÔʾÊÇ
2009-9-29 12:12:12
µ«ÊÇͨ¹ýÓï¾äselect * from tablename ²éѯ£¬Ê¹ÓÃoci_fetch_array£¨£© ......
ʹÓÃt-sqlÓï¾ä½«sqlserver2kÊý¾Ýµ¼ÈëparadoxµÄ¹¦ÄÜÎÒÒÑʵÏÖ£¬ÓõÄÊÇinsert into ... from table in [ODBC][ODBC;Driver=SQL Server...]µÄ°ì·¨£¬µ±ÎÒ×¼±¸Èç·¨ÅÚÖÆÍê³Éparadoxµ¼Èë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 ......
ÎҵijÌÐòÐèÒªÁ¬½ÓÁíһ̨µçÄÔÉϵÄoracle·þÎñÆ÷£¬Èç¹û·þÎñÆ÷¿ªÆô£¬Á¬½Ó²Ù×÷Ò»ÇÐÕý³£¡£
µ«ÊÇÈç¹ûoracle·þÎñÆ÷ûÓпªÆô£¬³ÌÐòÒª½«½ü20²Å·µ»ØÎÞ·¨Á¬½ÓÊý¾Ý·¡£
VC³ÌÐòͨ¹ýADO·½Ê½·ÃÎÊoracleÊý¾Ý¿â
m_pConnection ......