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

Oracle ÎﻯÊÓͼ²»ÄÜÓÉsys´´½¨Âð£¿

֮ǰÓÃsys×ܱ¨´í  ¸ÄÓÃÆäËûÓû§¾ÍºÃʹÁË£¿ÎªÊ²Ã´£¿ 
Õâ¸öÓ¦¸Ã¸úSYSÓû§Ã»¹ØÏµ
°ÑÄã¾ßÌåµÄ´íÎóÌùÉÏÀ´

ÒýÓÃ
Õâ¸öÓ¦¸Ã¸úSYSÓû§Ã»¹ØÏµ
°ÑÄã¾ßÌåµÄ´íÎóÌùÉÏÀ´


ORA-30354: Query rewrite not allowed on SYS relations
ORA-30354: Query rewrite not allowed on SYS relations
ORA-30354: Query rewrite not allowed on SYS relations
ORA-30354: Query rewrite not allowed on SYS relations

up
up up

²éÑ¯ÖØÐ´µÄÏÞÖÆ°üÀ¨£º


1.Èç¹ûÎﻯÊÓͼ°üÀ¨±¾µØ±íºÍÔ¶¶Ë±í£¬ÔòÖ»Óб¾µØ±íÖ§³Ö²éÑ¯ÖØÐ´£»


2.<span style="font-size:24px">»ù±íºÍÎﻯÊÓͼ¶¼²»ÄÜ´¦ÓÚSYSÓû§ÏÂ</span>£»


3.ÎﻯÊÓͼµÄ²éѯÖÐÈç¹û°üº¬SELECTºÍGROUP BYÁÐ±í£¬Ôò¶þÕß±ØÐë±£³ÖÒ»Ö£»


4.¾Û¼¯º¯Êý±ØÐëÔÚ±í´ïʽµÄ×îÍâ²ã£»


5.²»ÔÊÐíCONNECT BYÓï¾ä¡£


²»ÊÇ˵SYS²»ÄÜ´´½¨ÎﻯÊÓͼ£¬¶øÊÇORACLE¹æ¶¨£¬²éÑ¯ÖØÐ´»ù±íºÍÎﻯÊÓͼ¶¼²»ÄÜ´¦ÓÚSYSÓû§Ï¡£


²éÑ¯ÖØÐ´£¬ËÀÐİɡ£½â¾ö·½·¨Óжþ£º

1  ¿´¿´ÄÜ·ñ¸ÄΪ²»ÐèÒªÖØÐ´µÄÎﻯÊÓͼ¡£

2  ʹ»ù±íºÍÎﻯÊÓͼ¹éÊôÆäËûÆÕͨÓû§¡£





Ïà¹ØÎÊ´ð£º

OracleÀëÏß·ÃÎÊ---ÇóÖú - Oracle / »ù´¡ºÍ¹ÜÀí

´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæµÄԭʼÎļþ,ÏÂÔØµ½±¾»úÁË.ÎÒÏëÔÚ±¾»ú·ÃÎÊÊý¾Ý¿âÔõôÉèÖð¡.ÊDz»ÊÇÀàËÆ¿ÉÒÔ½¨Á¢Ò»¸öʲôÐéÄâ·þÎñÆ÷À´ÊµÏÖ.Çë´ó¼Ò³ö³öÖ÷Òâ
ÒýÓÃ
    ´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæ ......

javaÔõôÁ¬½ÓOracle£¬¼±°¡ - Java / JavaÏà¹Ø

private static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl";
private static final String USERNAME = "sys";
private static final String PASSWORD = "s ......

oracle²¢·¢´¦ÀíSOS - Oracle / ¿ª·¢

ÎÒÔÚ¿ª·¢µÄÕâ¸öÓ¦Óò¢·¢ÐԱȽϸߣ¬oracle¸üÐÂÊý¾ÝʱºòÈçºÎ´¦Àí²¢·¢´¦ÀíÄØ£¿¸÷λ´óÏÀ·¢±íºÃµÄ¹Ûµã°¡£¬ÔÚÏߵȴý£¡
oracleÊý¾Ý¸üÐÂʱ£¬»á×Ô¶¯Ä¬ÈÏÐÐËø¶¨£¬Â¥Ö÷²»Òª²ÙÐÄ£¬Oracle¶Ô²¢Ðд¦ÀíÒѾ­ºÜ³ÉÊìÁË

ÒýÓÃ
oracle ......

oracle 9i ×î½ü·¢Ïֵǽ±¨´í - Oracle / »ù´¡ºÍ¹ÜÀí

ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡
  ORA-01034:ORACLE not available
  ORA-27101:shared memory realm does not exist
ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡

1. Oracle sid ÕýÈ ......

oracle °²×° 01092 ´íÎó - Oracle / »ù´¡ºÍ¹ÜÀí

oracle 11g °²×° 01092 ´íÎó,
ÈÕÖ¾ÐÅÏ¢£º
[oracle@linux trace]$ vi alert_orcl.log 
MMON started with pid=14, OS id=9089
RESETLOGS after incomplete recovery UNTIL CHANGE 522752
Errors in file / ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ