oracleÊý¾Ý¿â¿ª·¢ÎÊÌâ - Oracle / »ù´¡ºÍ¹ÜÀí
ʹÓÃhibernateÓ³ÉäÎļþÅäÖÃÊý¾Ý¿â±íµÄ¹ØÏµ£¬Ö´ÐÐʱ±¨£ºSQL ÃüÁîδÕýÈ·½áÊø ´íÎó
ºÜÃ÷ÏԵĴíÎó£¬SQLÓï·¨´íÎó£¬Ìù³ö´úÂë²ÅÖªµÀÔΪ¡£
SQLÓï·¨´íÎó --ÌṩµÄÐÅϢ̫ÉÙ£¬Ïë°ïÄãҲûÕÞ
Hibernate: select informatio0_.×ÊѶ±àºÅ as ×ÊѶ±àºÅ2_, informatio0_.ÐÅÏ¢ÀàÐÍ1 as ÐÅÏ¢ÀàÐÍ2_2_, informatio0_.ÐÅÏ¢ÀàÐÍ2 as ÐÅÏ¢ÀàÐÍ3_2_, informatio0_.ÐÅÏ¢±êÌâ as ÐÅÏ¢±êÌâ2_, informatio0_.ÐÅϢͼƬ as ÐÅϢͼƬ2_, informatio0_.·¢²¼ÈË as ·¢²¼ÈË2_, informatio0_.·¢²¼ÈÕÆÚ as ·¢²¼ÈÕÆÚ2_, informatio0_.ÐÅÏ¢ÄÚÈÝ as ÐÅÏ¢ÄÚÈÝ2_, informatio0_.Éϼ¶ÀàÐÍ as Éϼ¶ÀàÐÍ2_, informatio0_.µã»÷ÂÊ as µã»÷ÂÊ2_ from system.wz_information informatio0_ where informatio0_.ÐÅÏ¢ÀàÐÍ2='·þÎñÐÅÏ¢'
Hibernate: select user0_.Óû§±àºÅ as Óû§±àºÅ10_, user0_.Óû§Ãû as Óû§Ãû10_, user0_.ÃÜÂë as ÃÜÂë10_, user0_.ÐÕÃû as ÐÕÃû10_, user0_.½ÇÉ«±àºÅ as ½ÇÉ«±àºÅ10_, user0_.µØÖ· as µØÖ·10_, user0_.״̬ as ״̬10_, user0_.´´½¨ÈÕÆÚ as ´´½¨ÈÕÆÚ10_ from system.wz_user user0_ where user0_.Óû§Ãû='system' and user0_.ÃÜÂë='system'
Hibernate: select userrole0_.½ÇÉ«±àºÅ as ½ÇÉ«±àºÅ13_0_, userrole0_.½ÇÉ«Ãû³Æ as ½ÇÉ«Ãû³Æ13_0_, userrole0_.½ÇÉ«ÃèÊö as ½ÇÉ«ÃèÊö13_0_, userrole0_.½Çɫ״̬ as ½Çɫ״̬13_0_ from system.wz_userrole userrole0_ where userrole0_.½ÇÉ«±àºÅ=?
Hibernate: select sysrolerig0_.½ÇÉ«±àºÅ as ½ÇÉ«±àºÅ1_, sysrolerig0_.ȨÏÞ±àºÅ as ȨÏÞ±àºÅ1_, userright1_.ȨÏÞ±àºÅ as ȨÏÞ±àºÅ11_0_, userright1_.ȨÏÞ¸¸¼¶±àºÅ as ȨÏÞ¸¸¼¶±àºÅ11_0_, userright1_.ȨÏÞÀàÐÍ as ȨÏÞÀàÐÍ11_0_, userright1_.ȨÏÞ as ȨÏÞ11_0_, userright1_.ȨÏÞÁ¬½ÓµØÖ·
Ïà¹ØÎÊ´ð£º
private static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl";
private static final String USERNAME = "sys";
private static final String PASSWORD = "s ......
ÎÒÔÚ¿ª·¢µÄÕâ¸öÓ¦Óò¢·¢ÐԱȽϸߣ¬oracle¸üÐÂÊý¾ÝʱºòÈçºÎ´¦Àí²¢·¢´¦ÀíÄØ£¿¸÷λ´óÏÀ·¢±íºÃµÄ¹Ûµã°¡£¬ÔÚÏߵȴý£¡
oracleÊý¾Ý¸üÐÂʱ£¬»á×Ô¶¯Ä¬ÈÏÐÐËø¶¨£¬Â¥Ö÷²»Òª²ÙÐÄ£¬Oracle¶Ô²¢Ðд¦ÀíÒѾºÜ³ÉÊìÁË
ÒýÓÃ
oracle ......
ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡
ORA-01034:ORACLE not available
ORA-27101:shared memory realm does not exist
ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡
1. Oracle sid ÕýÈ ......
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 / ......
¿´µ½ÓÐÒ»¸öSUNµÄÔªÀÏ´ÓOracle¹«Ë¾´ÇÖ°£¬¶øÇÒÊÇJava´´Ê¼ÈË——´óÃû¶¦¶¦µÄJames Gosling£¬
ÐÄÖÐÏ൱ÊÜ´ò»÷£¡ºÜ±¯Í´£¡
OrableÕâÊÇÔõôÁË£¬ÄѵÀÕâ¾ÍÊÇËùνµÄÈںϣ¨Ö«½â£¬·Ö»¯£¬Ïûʧ£©Âð£¿
SUNµÄÒ»°ïÀÏÔ±¹¤¶ ......