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

ÅäÖû·¾³±äÁ¿oracleÔÚ XP - Oracle / »ù´¡ºÍ¹ÜÀí

ÅäÖû·¾³±äÁ¿oracleÔÚ XP
 ÐüÉÍ·Ö£º105 - ½â¾öʱ¼ä£º2008-9-23 23:39 
ÎÒÖ»°Ñoracle×°ÔÚÁËE:\oracleÖÐ
»·¾³±äÁ¿²»ÖªµÀÈçºÎÅäÖÃ.


XPϰ²×°ORACLE ûÓÐÐèÒªÅäÖõĻ·¾³±äÁ¿
¿ÉÒÔͨ¹ýEMÅäÖÃÏ·þÎñÃûºÍIP¾Í¿ÉÒÔÁË
»òÕßÖ±½ÓÅäÖð²×°Ä¿Â¼ÏµÄADMIN/NETWORK/TNS¡£ORAÎļþ

LINUXϰ²×°ORACLEËùÐèµÄ»·¾³±äÁ¿ÔÚXP¶¼±»×Ô¶¯Ð´½ø×¢²á±íÁË£¬²»ÐèÒªÅäÖÃÁË
°²×°Íê³É£¬Èç¹ûÊÇ·þÎñÆ÷±¾»úµÇ¼£¬¿ÉÒÔ²»ÓÃÈκÎÅäÖã¬Ö±½Ó
c:>sqlplus <Óû§Ãû>/<ÃÜÂë>
¾Í¿ÉÒԵǼʹÓÃÁË£¬Èç¹ûÔÚÆäËü¿Í»§¶ËµÇ¼£¬ÔòÐèÒªÅäÖüàÌýºÍTNSNAMES

windows

»·¾³±äÁ¿°²×°Ê±¶¼±»×Ô¶¯Ð´½ø×¢²á±íÁË

ÎÒÏëÎʵÄÊÇÔõÑù²ÅÄÜÐ޸Ļ·¾³±äÁ¿£¿Ð»Ð»

ÐÞ¸Ä×¢²á±íÁË¡£¡£¡£¡£¡£¡£

ÄܾßÌåµÄ˵˵¸ÃÔõôÐÞ¸ÄÂð£¿ÎÒÊdzõѧÕß
лл


http://www.hackline.net/a/Special/Linux/application/2009/1107/1424.html

ÒýÓÃ

ÎÒÏëÎʵÄÊÇÔõÑù²ÅÄÜÐ޸Ļ·¾³±äÁ¿£¿Ð»Ð»

Õâ¸ö¿ÉÄÜÄãÒªµ½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 ......

Çë½ÌsqlÓï¾ä¡£ - Oracle / ¿ª·¢

ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
  ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......

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

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

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

[Ô­´´] ORACLE Á¬½Ó×Ö´® - Oracle / ·Ç¼¼ÊõÇø

¼ÙÉètable01 ÖÐÓÐ ÒÔÏÂ×ÊÁÏ
emp_no emp_name
------- ------------
0001 TOM
0002 JOHN
0003 MARY
³£Óõ绰 
¶øÎÒÃÇÒªµÃµ½ÒÔϵÄOUTPUT (»òÊǸ÷ÖÖÆäËûµÄoutput)
0001,TOM
0002,JOHN ......

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ºÅ