ÎÒÓÃpl/sqlÁ¬Êý¾Ý¿âµÄʱºòûÓÐÎÊÌ⣺ username: dbo password:sunshine Ö÷»ú×Ö·û´®£º aodb
µ«ÎÒÓÃÏÂÃæµÄasp´úÂëÁ¬½Óʱȴ±¨¡°ORA-01017: ÎÞЧµÄÓû§Ãû/¿ÚÁµÇ¼±»¾Ü¾ø ¡±£¬ÕâÊÇʲôÔÒòÄØ£¿
<% ......
create table t_client (id number(4) primary key,
pid number(4) not null,
name varchar2(30) not null,
client_id varchar2(10),
client_level char(3),
bank_acct_no varchar2(30),
contact_tel varchar2(30),
address varchar2(30),
zip_code varchar2(10),
is_leaf ......
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 /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_9087.trc:
ORA-00313: open failed for members of ......
×î½ü×öSQL´æ´¢¹ý³ÌÏòOracleµÄÇ¨ÒÆ£¬ÒÔǰû½Ó´¥¹ýOracleÓÐЩÓï·¨²»ÖªµÀ£¬Âé·³¸÷λ¸ø½â¾öÒ»ÏÂÍøÉÏÒ²²»ºÃ²é£¬
1£¬SQLÖÐ select * from......,select * from......,select * from......,select * from......,¿ÉÒÔÖ±½Ó·µ»ØÒ»¸öÊý¾Ý¼¯£¬µ«ÊÇÔÚOracleÖв»Ö§³Ö£¬ÇëÎÊÔõô½â¾ö¡£
2£¬OracleÖÐÈçºÎÔÚ´æ´¢¹ý³ÌÖÐÌø×ªµ÷Óõ½ÁíÒ»¸ö´æ´ ......
ÓÖÓöµ½ÎÊÌâÁË£¬JavaÁ¬½ÓOracleʱ³ö´í£¬´ó¼Ò°ïæ¿´¿´¹þ£¬Ð»Ð»¹þ¡£
ÅäÖÃÎļþÁ¬½ÓÓï¾ä´úÂëÈçÏ£º
DBType=3
OracleDriver=oracle.jdbc.driver.OracleDriver
OracleURL=jdbc:oracle:thin:@localhost:1521:XE
datasource.username=system
datasource.password=yaoyao123456
......
¸Õ¸Õ½Ó´¥Oracle²»¾Ã Ïë¸ã¶®OracleÖнÇÉ«ºÍȨÏÞµÄÀí½â£¬
Ï£Íû´ó¼Ò¿ÉÒÔ˵µÄÏêϸһµã°¡£¬²»È»ÎÒ¿´²»¶®~~ллÀ²
1¡¢È¨ÏÞ ¹ËÃû˼Ò壬ֻÓÐÓÐÏàÓ¦µÄȨÏÞ²ÅÄܲÙ×÷Êý¾Ý¿â×öÏàÓ¦µÄ²Ù×÷£¬±ÈÈç ÄãÖ»ÓоßÓÐ create session ȨÏÞ²ÅÄÜÁ¬½Óµ½Êý¾Ý¿âÉÏ£¬Ö»ÓоßÓÐ create table ȨÏÞÔÙÄܽ¨±í¡£
2¡¢¾ÍÉÏÃæÕâô˵ÄãÄܲ»ÄÜ¿´³öÀ´£¬Èç ......