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

oracleÆô¶¯¼àÌý

СÐÍ»ú²Ù×÷ϵͳÊÇAIX
ϵͳÆô¶¯µÄʱºòÐèÒªÆô¶¯¼àÌýºÍÈý¸öʵÀý£¬ÎÒÊÇÓÃÅú´¦ÀíÖ´Ðе쬴úÂëÈçÏ£º

su - oracle -c "lsnrctl start"

su - oracle -c "export ORACLE_SID=orcl1
sqlplus /nolog < < eof
conn /as sysdba
startup
eof"

su - oracle -c "export ORACLE_SID=orcl2
sqlplus /nolog < < eof
conn /as sysdba
startup
eof"


su - oracle -c "export ORACLE_SID=orcl3
sqlplus /nolog < < eof
conn /as sysdba
startup
eof"


ÿ´ÎÖ´ÐÐÖ®ºó¶¼ÊÇÈý¸öʵÀý¶¼ÆðÀ´ÁË£¬¼àÌýÈ´Æð²»À´£¬ÎÒÈç¹ûÖ±½ÓÔÚ¿ØÖÆÌ¨Ê¹ÓÃrootÖ´ÐÐsu - oracle -c "lsnrctl start"¿ÉÒÔÆô¶¯¼àÌý£¬ËµÃ÷ÃüÁîÓ¦¸ÃÊÇûÓÐÎÊÌâµÄ£¬¿É²»ÖªµÀΪʲôʹÓÃrootÓû§Ö´ÐÐÕâ¸öÅú´¦ÀíµÄʱºò¼àÌý¾ÍÆð²»À´¡£
su ÃüÁî²»ºÏÊʰɣ¿
sudo ¸üÊʺÏÕâÖÖÓ¦Óá£

ÒýÓÃ
su ÃüÁî²»ºÏÊʰɣ¿
sudo ¸üÊʺÏÕâÖÖÓ¦Óá£


ÓеÀÀí

ÓÃshell½Å±¾

sudo£¬»òÕßshell½Å±¾£¬ÄÜ˵µÄ¾ßÌåµãÂð£¿


¿ÉÒÔдһ¸öshell ½Å±¾ ×Ô¶¯Æô¶¯£¡



×îºóÔÙÆð¼àÌý£¿

studing


Ïà¹ØÎÊ´ð£º

oracleºº×ÖתƴÒô

Çë¸÷λ¸ßÊÖ°ïæ oracleºº×ÖתƴÒô
±ÈÈçÏÖÔÚÓиöÁÐ ÀïÃæµÄºº×ÖΪÄãºÃ ÎÒÏë²é³öÀ´µÄÊÇN ÇëÎʸ÷λ¸ßÊÖÈçºÎʵÏÖ ¸ø¸öÏêϸµÄ¿´¿´ лÁË
ÓÐÖªµÀµÄ¸æËßÒ»Éù ллÁË


ûÕÒµ½°¡ Äܸø·¢Ò»¸öÂð

ÄÄλ˧¸çÄܸøÏêϸµÄËµÒ ......

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

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

SQL²éѯÎÊÌ⣨oracle) - Oracle / ¿ª·¢

ÈçÏÂ2ÕÅ±í£º
table1:
node_id
parent_id
root_id
value
table2:
node_id
status
±í1´æ´¢ÁËÒ»¿ÃÊ÷£¬±í2´æ´¢Á˽ڵã״̬£¬ÎÊÌâÈçÏ£º
ÈçºÎÓÃSQLÓï¾ä»ñµÃ״̬statusΪ1µÄ½ÚµãµÄËùÓÐ×Ó½ÚµãÒÔ¼°ÆäÏÂ×ÓÊ÷ÖÐËùÓÐ½Ú ......

oracleÖÐÒ»¸öSQLÓï¾äµÄÇø±ð - Oracle / »ù´¡ºÍ¹ÜÀí

OracleÖÐSQLÓï¾äÖÐ
drop table ±íÃû cascadeconstraints
Óë
drop table ±íÃû cascadeconstraint
ÓÐÊ²Ã´Çø±ð£¿
constraintºÍconstraintsÔÚoracleÖÐÊÇÒ»ÑùʹÓõÄ
¹Ù·½½¨ÒéʹÓÃconstraint

ÒýÓÃ
constraintºÍc ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ