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

oracleÁ¬½ÓÎÊÌâ - Oracle / ¸ß¼¶¼¼Êõ

ÎÒÔÚʹÓÃSQLplusÁ¬½ÓoracleµÄʱºòÔõôЭÒéÊÊÅäÆ÷´íÎó£¿ÊDz»ÎÒÓ¦¸Ã¸ÄÏÂÎÒµÄip£¬¸Ä³ÉÎÒ°²×°Ê±ºòµÄip£¡´ó¼Ò°ïÖúÎÒһϣ¡
ÊDZ¾»úµÄ»°,¶øÇÒ±¾»úµÄIPµØÖ·ÓÖ²»ÊÇDNS»ñÈ¡µÄ,¾ÍÊDz»Ëµ±ä»¯µÄ»°¾Í¿ÉÒÔ¸ÄΪ±¾»úIP,µ«ÊÇÈç¹ûÊDZ仯µÄ,¸Ä³É±¾»úµÄϵͳÃû³Æ¼´¿É

¿´¿´ÄãµÄtnsname.oraÎļþÀïµÄ¶«Î÷¿´¿´...
sqlplus username/password@tnsname.oraÎļþÀïµÄÄÚÈÝ

±¾»úIP¿ÉÒÔÖ±½ÓÐ޸ijÉlocalhost£¬ºÇºÇ¡£

¸Ð¾õºÃÏñÊǼàÌýÆ÷µÄÎÊÌâ¡£¿´¿´ÄãlistenerÅäÖÃÊDz»ÊǶԵġ£

ÒýÓÃ
¸Ð¾õºÃÏñÊǼàÌýÆ÷µÄÎÊÌâ¡£¿´¿´ÄãlistenerÅäÖÃÊDz»ÊǶԵġ£


Õâ¸öºÍ¼àÌý¹ØÏµ²»´ó£¬Ö»ÓÐÔ¶³ÌµÇ¼²ÅÐèÒª¼àÌý£¬»¹ÊÇ¿´Ò»ÏÂtnsnameÎļþ°É

Èç¹ûÊDZ¾»úÁ¬½ÓµÄ»°£¬ÊDz»ÐèÒªÅäÖÃtnsnames.oraµÄ

1¡¢È·¶¨±¾»úÊÇ·ñ¸Ä¹ý¼ÆËã»úÃû³Æ
2¡¢ÔÚ×¢²á±íÖв鿴ÊÇ·ñÓÐÏàӦ·¾¶
3¡¢¼ì²étnsnames.ora¡¢listener.oraÎļþ¶ÔÓ¦»úÆ÷Ãû»òipÊÇ·ñÒ»ÖÂ


Ïà¹ØÎÊ´ð£º

oracle·þÎñ״̬ÏÔʾ ¡°Í£Ö¹¡±

ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£

ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇ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 ......

Windows 7 ÔõÑù°²×°Oracle - Oracle / »ù´¡ºÍ¹ÜÀí

¸÷λ´ó¸ç£¬°ï¸öæ¡£

ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ
10GºÍ11GµÄ 
http://www.oracle.com/technology/software/products/database/index.html 
------------------------------------------- ......

oracle´¥·¢Æ÷²åÈëÎÊÌâ - Oracle / ¸ß¼¶¼¼Êõ

ÎÒÓÐÁ½¸ö±í£¨A±íºÍB±í£©£¬»ú¹¹ÍêÈ«Ïàͬ£ºA ±í½¨Á¢´¥·¢Æ÷
µ±insert into A(id,name) values('1','zhangsan'); ÎÒÖ»Ï뽫name=zhangsanµÄʱºò½«insertÓï¾ä²åÈëµ½B±íÖжøA±í²»Ö´ÐвÙ×÷Õâ¸ö´¥·¢Æ÷Ó¦¸ÃÔõôʵÏÖÄØ£¿
È磺 ......

Çë½ÌOracleÊÂÎñ¸ôÀë¼¶±ðÎÊÌâ - Oracle / ·Ç¼¼ÊõÇø

²é¿´ÊÂÎñ¸ôÀë¼¶±ðµÄÃüÁ
MySQLʹÓõÄÊÇselect @@tx_isolation;
ÔÚOracleÖв鿴ÊÂÎñ¸ôÀë¼¶±ðµÄÃüÁîÊÇÄĸö£¿

SQL code:

SELECT /*+ rule */ s.username,decode(l.type,'TM','TABLE LOCK','TX','ROW LOCK', ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ