¶ÔÓÚÆô¶¯Oracle 10gʱ ORA
ÎÊÌâÃèÊö
=======
ÔÚÊÔͼÆô¶¯Êý¾Ý¿âµÄʱºò,Oracle±¨¸æÏÂÁдíÎó£º
ERROR:
ORA-27101 Shared memory realm does not exist
ORA-01034 ORACLE not available
»ù±¾½âÊÍ
=======
Error: ORA-27101
Text: shared memory realm does not exist
-------------------------------------------
Cause: Unable to locate shared memory realm
Action: Verify that the realm is accessible
ÈçºÎ½â¾ö
=======
Õâ¸öÎÊÌâÆäʵÓÃÒ»¾ä»°¾Í¿ÉÒÔ˵Çå³þ£º
ORACLE_HOME»òÕßORACLE_SIDÉèÖò»ÕýÈ·¡£
ÔÚÒÔÇ°µÄ°æ±¾ÖУ¬Èç¹ûORACLE_SID²»ÕýÈ·£¬Ò»°ã¶¼Ö»ÌáʾORA-01034¡£Oracle¡¡8.1.7 ¸ø³öÒ»¸ö¶îÍâµÄÐÅÏ¢£ºORA-27101¡£
->Èç¹ûÊÇUnix£¬ÔÚShellÀï°ÑORACLE_SIDÉèÖÃÕýÈ·¼´¿É(×¢Òâ´óСдÃô¸ÐµÄÎÊÌâ)¡£
¡¡´ËÍ⣬¼ì²éORACLE_HOME»·¾³±äÁ¿¡£ÈçºÎ¼ì²é²Î¿¼ÈçϵÄÃüÁ
% echo $ORACLE_SID
% ps -ef |grep smon
->Èç¹ûÊÇWindows£¬Ò»°ã¶¼ÊÇÒòΪϵͳÖÐÓжà¸öʵÀýÔì³ÉµÄ¡£
¡¡¿ÉÒÔÔÚÃüÁîÐÐÏ¡¡C:>set ORACLE_SID=DEMO
¡¡°ÑÕâÀïµÄDEMO»»ÎªÄãÏàÓ¦µÄʵÀýÃû¡£
¡¡Èç¹û»¹²»ÐеĻ°£¬¼ì²é×¢²á±íÖеÄORACLE_HOME¡£
¡¡´ËÍ⣬ÔÚWindows»·¾³ÏÂÓеÄʱºòÁ¬½Ó²»ÉÏÔ¶³ÌµÄÊý¾Ý¿â£¬»á±¨¸æÈç´ËµÄ´íÎó¡£
¡¡½â¾ö°ì·¨ÊÇ°Ñsqlnet.oraÎļþÖеÄ
¡¡SQLNET.AUTHENTICATION_SERVICES = (NTS) NTS»»ÎªNONE.
Ïà¹ØÎĵµ£º
ËäȻѧϰJavaºÜ¾ÃÁË£¬×Ô¼ºÒ²Á¬½Ó¹ýһЩÊý¾Ý¿â£¬±ÈÈçmysqlÖ®ÀàµÄ£¬Èç½ñÄØ£¬Ò²Ñ§Ï°ÁËÒ»¶Îʱ¼äµÄOracle£¬È»¶øÄØ£¬½ñÌìÊÇÎÒµÚÒ»´ÎÁ¬½ÓOracle£¬ºÙºÙ£¬Ó¦¸Ã»¹²»ËãÌ«³Ù°É¡£
½ñÌìÄØ£¬Óе㱿׾£¬´ó¼ÒĪЦ£¡
ÎÒÕâÊÇÒ»¸ö²éѯÀý×Ó
Ê×ÏÈ£¬Ô ......
ÏÈÀ´¼òµ¥µÄ˵һÏÂORACLEµÄ±¸·Ý·½Ê½£¬Ïêϸ¹¦ÄÜ¿ÉÒÔËÑË÷һϡ£
Ò»ÖÖÊÇÂß¼±¸·Ý£¬¼´ËùνµÄµ¼³ö(Export)ºÍµ¼Èë(Import)ÃüÁÕâÖÖ·½Ê½µÄÓŵãÊÇ£¬Äܹ»¶ÔÊý¾Ý¿âÖеÄÿ¸ö¶ÔÏó½øÐб¸·Ý£¬²¢ÇÒʵÏÖ²»Í¬Æ½Ì¨ÏµÄÊý¾ÝǨÒÆ£¬µ«±¸·ÝµÄʱºòÊý¾Ý¿â²»ÄÜÊǹرյģ¬´ÓCMDÃüÁî½ ......
ĬÈÏÇé¿öÏ£¬ÔÚOracleµÄÖ÷»úÉÏ£¨linuxϵͳ£©µÄOracle²Ù×÷ϵͳÓû§Ï£¬ÒÔsysÓû§µÇ½Êý¾Ý¿âʱ¿ÉÒÔ²»ÓÃÊäÈëÃÜÂëÖ±½ÓµÇ¼¡£Êµ¼ÊÉÏ£¬Ö»ÒªÊÇÊôÓÚdba×飨linux£©»òosdba×飨windows£©Ï£¬¶¼¿ÉÒÔ²»ÓÃÃÜÂë½øÐеǼ¡£ÕâÊÇÈÏÖ¤·½Ê½³ÆΪOSÈÏÖ¤¡£
ÕâÖֵǼ·½Ê½µÄ¿ØÖÆ£¬ÊÇͨ¹ý$ORACLE_HOME/network/admin/sqlnet.oraÖеģº
SQLNET.AUTH ......
---------Êýѧº¯Êý
1.¾ø¶ÔÖµ
S:select abs(-1) value
O:select abs(-1) value from dual
2.È¡Õû(´ó)
S:select ceiling(-1.001) value
O:select ceil(-1.001) value from dual
3.È¡Õû£¨Ð¡£©
S:select floor(-1.001) value
O:select floor(-1.001) value from dual
4.È¡Õû£¨½ØÈ¡£©
S:select cast(-1.002 as int) v ......
£¨1£© Ñ¡Ôñ×îÓÐЧÂʵıíÃû˳Ðò(Ö»ÔÚ»ùÓÚ¹æÔòµÄÓÅ»¯Æ÷ÖÐÓÐЧ)£º
ORACLEµÄ½âÎöÆ÷°´ÕÕ´ÓÓÒµ½×óµÄ˳Ðò´¦Àífrom×Ó¾äÖеıíÃû£¬from×Ó¾äÖÐдÔÚ×îºóµÄ±í(»ù´¡±í driving table)½«±»×îÏÈ´¦Àí£¬ÔÚfrom×Ó¾äÖаüº¬¶à¸ö±íµÄÇé¿öÏÂ,Äã±ØÐëÑ¡Ôñ¼Ç¼ÌõÊý×îÉٵıí×÷Ϊ»ù´¡±í¡£Èç¹ûÓÐ3¸öÒÔÉϵıíÁ¬½Ó²éѯ, ÄÇ ......