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

¶ÔÓÚÆô¶¯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.


Ïà¹ØÎĵµ£º

ÈçºÎ½â³ýOracle ÕʺÅËø¶¨(the account is locked)

½â¾ö°ì·¨£º
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;
¡¡¡¡¡¡  & ......

С²ËÄñÎÊ£ºoracleÖеÄÒ»¸ö´¥·¢Æ÷ÎÊÌâ

ÎÊÌâ
£¨1£©±íemployeesºÍdepartment´æÔÚ²ÎÕÕÍêÕûÐÔÔ¼Êø£¬ÔÚ±íemployeesÖвåÈë¼Ç¼£¨‘70’£¬‘999’£©department_idΪ‘999’ʱ£¬department±íÖл¹²»´æÔÚdepartment_idΪ‘999’µÄ¼Ç¼£¬ËùÒÔÎ¥±³Á˲ÎÕÕÍêÕûÐÔÔ¼Êø,³öÏÖ“Integrity constraint violation error”ÌáʾÐÅÏ ......

ORACLE¹ØÓÚÊý¾Ý×ÖµäµÄÀ§»ó~

×î½üÔÚÂÛ̳ÉÏÒ»Ö±¿´µ½ÓÐÅóÓѶÔÊý¾Ý×ÖµäÀïµÄÄÚÈݸ㲻̫Çå³þ£¬±ÈÈç˵V$¡¢V_$¡¢GV$µÈµÈ£¬µ½µ×ÄĸöÊÇͬÒå´Ê£¬ÄĸöÊÇÊÓͼ£¬Äĸö»ùÓÚÄĸö´´½¨¡£½ñÌìÕýºÃ¿´µ½¸Ç¹úÇ¿µÄ¡¶ÉîÈëdz³öORACLE¡·µÚÈýÕ½²µ½Õâ·½ÃæÄÚÈÝ£¬×ܽáһϣ¬Ò²·½±ã´ó¼Òѧϰ¡£
 
Êý¾Ý×ÖµäÓÉËIJ¿·Ö×é³É£º
1¡¢ÄÚ²¿RDBMS(X$)±í
X$ÊÇOracleÊý¾Ý¿âµÄºËÐIJ¿·Ö£¬ÕâЩ ......

oracle SQLÐÔÄÜÓÅ»¯

£¨1£©      Ñ¡Ôñ×îÓÐЧÂʵıíÃû˳Ðò(Ö»ÔÚ»ùÓÚ¹æÔòµÄÓÅ»¯Æ÷ÖÐÓÐЧ)£º
ORACLEµÄ½âÎöÆ÷°´ÕÕ´ÓÓÒµ½×óµÄ˳Ðò´¦Àífrom×Ó¾äÖеıíÃû£¬from×Ó¾äÖÐдÔÚ×îºóµÄ±í(»ù´¡±í driving table)½«±»×îÏÈ´¦Àí£¬ÔÚfrom×Ó¾äÖаüº¬¶à¸ö±íµÄÇé¿öÏÂ,Äã±ØÐëÑ¡Ôñ¼Ç¼ÌõÊý×îÉٵıí×÷Ϊ»ù´¡±í¡£Èç¹ûÓÐ3¸öÒÔÉϵıíÁ¬½Ó²éѯ, ÄÇ ......

oracle±È½Ï¿ìµÄ·ÖÒ³sql

 ·½°¸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 < ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ