ÈçÌâ
ûÓÐÊÔ¹ý£¬
²»¹ýÓ¦¸Ã¿ÉÓã¬
µ«Ö§³Ö²»Èçsql serverºÃ¡£¡£¡£¡£
²»Ö§³Ö
http://blogs.msdn.com/charlie/archive/2008/02/28/link-to-everything-a-list-of-linq-providers.aspx
Ö§³Ö...
http://linqtooracle.codeplex.com/
ÈÈÁÒ»¶Ó.NET³ÌÐòÔ±¼ÓÈë108860028Ⱥ,ÎÒÃǹ²Í¬½ø²½,×·Öð¸÷×ÔµÄÃÎÏë!
ÈÈÁÒ» ......
Ä£ºý²éѯoracleÖÐÓжàÉÙÕÅ±í£¿
select * from tabs;
select count(*) from tabs;
select sum(1) from all_all_tables;
select count(1) from dba_tales;
SELECT COUNT(1) from DBA_OBJECTS WHERE OBJECT_TYPE='TABLE';
SQL code:
SQL> select count(*) from user_tables;
COUNT(*)
----------
......
ÔÚoracle±¸·ÝÍê³ÉÒÔºó,ÈçºÎ²é¿´±¸·ÝÊÇ·ñ³É¹¦,ËüÓÐûÓÐÈÕÖ¾Îļþ,Èç¹ûÓÐÔÚʲôµØ·½,Ôõô²é¿´!лл
ʲô²Ù×÷ϵͳ°¡£¬Ä㲻˵ÎÒ¾ÍĬÈÏÊÇlinuxÁË¡£
ÓÐÈÕÖ¾Îļþ£¬alert.log £¬ÊÔÊÔshow parameter background_dump_dest µÄ·¾¶ÏÂÕÒÕÒ£¬ÒªÊÇûÓоÍfind / -name alert.log
²é¿´±¸·ÝÊÇ·ñ³É¹¦£¬
rman
connect target /
list b ......
ʹÓà JDBC Á¬½Ó Oracle ʱ£¬Èç¹û URL д³É£ºjdbc:oracle:thin:@192.168.1.100:1521:sid (192.168.1.100 ÊDZ¾»ú IP)
´ËʱÔÚ»ñÈ¡ Connection ʱ½«³öÏÖÒÔÏÂÒì³£¡£
Java code:
java.sql.SQLException: The Network Adapter could not establish the connection
µ«Èç¹û½« URL д³É jdbc:oracle:thin:@localhost:1521:sid ......
ÕâÒ»¸öÐÇÆÚ¶ÔOracle ½øÐÐÁËÍ»»÷ѧϰ£¬¸Ðµ½ºÜÀÛ°¡¡¡
ÓкܶණÎ÷Òª¼ÇµÄ¡¡ÓкöàsqlÓï¾ä¸Ð¾õºÜÂé·³£¬
¹òÇó¸÷λ´óϺÃÇ ÓÐʲôºÃµÄѧϰ·½·¨£¬¸øÎÒÒ²½éÉÜһϣ¬
СµÜÔÚ´ËÏÈл¹ýÁË
Â¥Ö÷¼ÓÓÍ
ÎÒÒ²ºÜÀÛ°¡£¬ÎÒÏëÓÐÈ˽ÌÎÒ£¬¿Éϧһ¸öûÓа¡
ÂýÂýÀ´£¬³¤³Ç²»ÊÇÒ»Ì콨³ÉµÄ¡£
......
ÈçÌâ:
1.ÈçºÎ²é¿´ºÍµ÷ÕûÊý¾Ý¿âµÄ×î´óÁ¬½ÓÊý£¿
2.linuxϲ鿴alert log?
3.ÔÚ×Ô¶¨ÒåµÄÀàÐͺóÃæ¼ÓÉÏindex by pls_integer ±íÊÇʲôÒâ˼£¿
4.oracleÖÐ×ÔÖÎÊÂÎñpragma autonomous_transaction µÄÀí½â£¿
5.Õâ¾ä»°ÔõôÀí½â£º
Èç¹ûijһ²Ù×÷°üº¬´óÁ¿µÄSQL´úÂë»ò·Ö±ð±»¶à´ÎÖ´ÐУ¬ÄÇô´æ´¢¹ý³ÌÒª±ÈÅú´¦ÀíµÄÖ´ÐÐËÙ¶È¿ìº ......