Oracle Æô¶¯µÄÎÊÌâ
oracle not available
shared memory realm does not exist
ÇëÎʸßÊÖÕâ¸öÎÊÌâÈçºÎ½â¾ö£¿
http://www.inthirties.com/thread-109-2-1.html
Ö¸¶¨ÏÂORACLE_SID,ORACLE_HOME¿´¿´£¬²»ÐоÍÓÃ1Â¥µÃ·½·¨ÁË..
cmd
sqlplus /nolog
connection /as sysdba
select instance_name,host_name,thread#,status from v$instance
Àý³Ì±êʾ£¬Ö÷»úÃû£¬±êÊ¾ÖØ×éÏ̺߳Š£¬±êʾÀý³Ì״̬
ÖØÐÂ×°ÔØ
startup force
Êý¾Ý¿âºÍ¼àÌý¶¼ÖØÆôÒ»ÏÂ
Ïà¹ØÎÊ´ð£º
±í×Ö¶Î
ID NAME TIME AMOUNT
14502 1111 0201 1
14502 1111 0201 5
14 ......
ʹÓÃt-sqlÓï¾ä½«sqlserver2kÊý¾Ýµ¼ÈëparadoxµÄ¹¦ÄÜÎÒÒÑʵÏÖ£¬ÓõÄÊÇinsert into ... from table in [ODBC][ODBC;Driver=SQL Server...]µÄ°ì·¨£¬µ±ÎÒ×¼±¸Èç·¨ÅÚÖÆÍê³Éparadoxµ¼Èëoracleʱȴ²»ÐУ¬²»±¨´íµ«ÊÇÖ´ÐкóÃ»Ó ......
ÏÂÃæÕâ¶Î»°:
¿Í»§ÖÕ¶Ë×Ö·û¼¯£¬nls_lang»·¾³±äÁ¿×Ö·û¼¯£¬Êý¾Ý¿âʹÓõÄ×Ö·û¼¯¡£ÆäÖУ¬¿Í»§Öն˸÷ÖÖ¸÷Ñù£¬±ÈÈçwindowsÏÂcmd£¬unix/linuxÏÂterminal/console,ÉõÖÁÈçtoadµÈ¹¤¾ßÒ²¿ÉÒÔÀí½âΪһ¸öÖÕ¶Ë¡£ÎÒÃÇʹÓÃwindows ......
ÄÄλÐÖµÜÓÐoracle cartradge¿ª·¢×ÊÁÏ£¬Äܲ»Äܹ²Ïíһϣ¿Ð»Ð»£¡
ûÓÐÌý˵¹ý£¬OracleÌ«ÅÓ´óÁË
ÎÒÒ²ÊǸսӴ¥£¬²»Çå³þÔõô×ö£¬Ö»ÖªµÀÕâ¸ö¼¼ÊõÊÇÓÃÀ´¿ª·¢Öмä¼þµÄ
End_rbody_60301247//-->
¸Ã»Ø¸´ÓÚ2009-1 ......
ÎÒÓÐÒ»ÕűíÓиö×Ö¶ÎÃû³ÆÊÇstarttime ÀàÐÍÊÇDATE ,ÆäÖÐÓÐÒ»ÐеÄÖµÊÇ"11:00:00",ÎÒÏë°ÑÕâÒ»ÁÐÑ¡³öÀ´,Óï¾äÈçÏÂ:
select * from routebanci where starttime='11:00:00' and routename='*** ......