¶ÔÓÚÆô¶¯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.
Ïà¹ØÎĵµ£º
½â¾ö°ì·¨£º
1.ʹÓÃOracleÓû§µÇ¼ϵͳ£¬ÔÚCMDÖÐÆôÓÃSQLPLUS
2.sqlplus /nolog
3.SQL> connect /as sysdba
¡¡¡¡¡¡ Connected.
4.SQL> alter user system account unlock;
¡¡¡¡¡¡ User altered.
Ëø¶¨Õ˺ŷ½·¨£º
1.SQL> alter user system account lock;
¡¡¡¡¡¡ & ......
ÎÊÌâ
£¨1£©±íemployeesºÍdepartment´æÔÚ²ÎÕÕÍêÕûÐÔÔ¼Êø£¬ÔÚ±íemployeesÖвåÈë¼Ç¼£¨‘70’£¬‘999’£©department_idΪ‘999’ʱ£¬department±íÖл¹²»´æÔÚdepartment_idΪ‘999’µÄ¼Ç¼£¬ËùÒÔÎ¥±³Á˲ÎÕÕÍêÕûÐÔÔ¼Êø,³öÏÖ“Integrity constraint violation error”ÌáʾÐÅÏ ......
×î½üÔÚÂÛ̳ÉÏÒ»Ö±¿´µ½ÓÐÅóÓѶÔÊý¾Ý×ÖµäÀïµÄÄÚÈݸ㲻̫Çå³þ£¬±ÈÈç˵V$¡¢V_$¡¢GV$µÈµÈ£¬µ½µ×ÄĸöÊÇͬÒå´Ê£¬ÄĸöÊÇÊÓͼ£¬Äĸö»ùÓÚÄĸö´´½¨¡£½ñÌìÕýºÃ¿´µ½¸Ç¹úÇ¿µÄ¡¶ÉîÈëdz³öORACLE¡·µÚÈýÕ½²µ½Õâ·½ÃæÄÚÈÝ£¬×ܽáһϣ¬Ò²·½±ã´ó¼Òѧϰ¡£
Êý¾Ý×ÖµäÓÉËIJ¿·Ö×é³É£º
1¡¢ÄÚ²¿RDBMS(X$)±í
X$ÊÇOracleÊý¾Ý¿âµÄºËÐIJ¿·Ö£¬ÕâЩ ......
£¨1£© Ñ¡Ôñ×îÓÐЧÂʵıíÃû˳Ðò(Ö»ÔÚ»ùÓÚ¹æÔòµÄÓÅ»¯Æ÷ÖÐÓÐЧ)£º
ORACLEµÄ½âÎöÆ÷°´ÕÕ´ÓÓÒµ½×óµÄ˳Ðò´¦Àífrom×Ó¾äÖеıíÃû£¬from×Ó¾äÖÐдÔÚ×îºóµÄ±í(»ù´¡±í driving table)½«±»×îÏÈ´¦Àí£¬ÔÚfrom×Ó¾äÖаüº¬¶à¸ö±íµÄÇé¿öÏÂ,Äã±ØÐëÑ¡Ôñ¼Ç¼ÌõÊý×îÉٵıí×÷Ϊ»ù´¡±í¡£Èç¹ûÓÐ3¸öÒÔÉϵıíÁ¬½Ó²éѯ, ÄÇ ......
·½°¸1 ÊÊÓÃÓÚoracle9iÒÔÉÏ£¡
select * from
(select row_number() over(order by sendid desc) rn,m.* from xxt_msgreceive m )
where rn <1010 and rn>=1000
·½°¸2
SELECT * from (SELECT A.*, ROWNUM RN from (SELECT * from xxt_msg where sendstatus=1 order by msgid desc) A WHERE ROWNUM < ......