ÔõÑù½øÈëoracle web½çÃæ
ÎÒÔÚlinux²Ù×÷ϵͳÉÏ ½øÈë²»ÁË oracleµÄ²Ù×÷½çÃæ
ÊÇÖ¸µÄem dbconsoleô¡£
http://so.csdn.net/BlogSearchResult.aspx?q=dbconsole%20username:inthirties
ÎÒ²Åѧϰoracle ÇëÎÊemÊÇʲô£¿£¿£¿£¿ÎÒÔÚÍøÉÏûÓв鵽¡«¡«
¿´ÁËÉÏÃæÁ¬½ÓûÓÐ
ÊÇÒ»¸öoracleµÃͼÐλ¯µÃ¹ÜÀí½çÃæ
¿´ oracledbconsole·þÎñÆðÁËûÓÐ
¶÷ ¿´ÁËÉÏÃæµÄÁ¬½Ó¡£¡£¡£²»¹ý¡¡Óе㿴²»¶® ²ÅÓÖÀ´Çë½ÌÄú¡¡¿´ÁËÉÏÃæÄúÁôµÄQQºÅ ÕýÔÚÑо¿ÔõôװQQ Äܵ±ÃæÇë½Ì
ÎÒµÄÍøÂçÒ»ÇÐͨ³© ²»ÊÇ´ò²»¿ª¡£¡£¡£ÊÇ ²»ÖªµÀÔõô´ò¿ª¡¡
¿´ÁËÉÏÃæÄúÁôµÄQQºÅ ÕýÔÚÑо¿ÔõôװQQ
Ç¿
Ïà¹ØÎÊ´ð£º
ÔÚϵͳÔËÐеÄʱºò×ÜÊÇÓÐÒ»¿é´ÅÅÌʼÖÕÉÁºìµÆ£¬½øÈëϵͳºó
#topas²é¿´×ÜÊÇÓÐÒ»¿é´ÅÅÌ%BUSYΪ90%ÒÔÉÏ£¬
Êý¾Ý¿â°æ±¾£ºoracle 9.2.0.7
Êý¾ÝÎļþ¹ÒÔØµÄ½Úµã£º/oradata/pcs/ Âß¼¾íºÅlv04
#lslv -l lv04
......
ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡
ORA-01034:ORACLE not available
ORA-27101:shared memory realm does not exist
ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡
1. Oracle sid ÕýÈ ......
¼ÙÉètable01 ÖÐÓÐ ÒÔÏÂ×ÊÁÏ
emp_no emp_name
------- ------------
0001 TOM
0002 JOHN
0003 MARY
³£Óõ绰
¶øÎÒÃÇÒªµÃµ½ÒÔϵÄOUTPUT (»òÊǸ÷ÖÖÆäËûµÄoutput)
0001,TOM
0002,JOHN
......
select count(1) from FX_RETURNBOOKCHECKLIST fxreturnbo0_ where fxreturnbo0_.BOOKID='164 ' AND fxreturnbo0_.RETURNID='00025.S0000001'
ÉÏÃæÒ»¸ö¼òµ¥µÄSQL,Ö´ÐÐʱ¼ä2.6à ......
Á½¸ö±í
Çë¿´ "Persons" ±í£º
name banji shunxu
yiyang 01 1
yiyang 02 1
lili 01 2
½ÓÏÂÀ´Çë¿´ "xueke" ±í£º
name kemu shunxu
yiy ......