Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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¹Ù·½ÍøÕ¾¿´¿´

»¹ÊÇû¿´Ã÷°×°¡


Ïà¹ØÎÊ´ð£º

OracleÀëÏß·ÃÎÊ---ÇóÖú - Oracle / »ù´¡ºÍ¹ÜÀí

´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæµÄԭʼÎļþ,ÏÂÔØµ½±¾»úÁË.ÎÒÏëÔÚ±¾»ú·ÃÎÊÊý¾Ý¿âÔõôÉèÖð¡.ÊDz»ÊÇÀàËÆ¿ÉÒÔ½¨Á¢Ò»¸öʲôÐéÄâ·þÎñÆ÷À´ÊµÏÖ.Çë´ó¼Ò³ö³öÖ÷Òâ
ÒýÓÃ
    ´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæ ......

oracle 9i ×î½ü·¢Ïֵǽ±¨´í - Oracle / »ù´¡ºÍ¹ÜÀí

ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡
  ORA-01034:ORACLE not available
  ORA-27101:shared memory realm does not exist
ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡

1. Oracle sid ÕýÈ ......

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 / ......

ÇóÒ»sqlÓï¾ä - Oracle / ¿ª·¢

Á½¸ö±í
Çë¿´ "Persons" ±í£º
name banji shunxu
yiyang 01 1
yiyang 02 1
lili 01 2
  
½ÓÏÂÀ´Çë¿´ "xueke" ±í£º
name kemu shunxu
yiy ......

oracle֪ʶ - Oracle / »ù´¡ºÍ¹ÜÀí

ÔÚOracle Êý¾Ý¿âÖÐÔõô²éǰÈýÌõ¼Ç¼½µÐò£»
select * from
  (select * from table order by col_name desc)
where rownum<=3;

select * from
(
select s.*,rownum rn 
from t3 s
)
where ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ