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

OracleµÄÏà¹ØÎÊÌâ

·þÎñÆ÷ÖйØÓÚOracleµÄ·þÎñ¶¼ÒÑÆô¶¯,µ«ÊÇOracleµÄÆóÒµ¹ÜÀíÆ÷ºÍISQLPLUS»¹ÊÇû°ì·¨

isqlplusctl start

Ò»°ã°²×°ºóÆóÒµ¹ÜÀíÆ÷ºÍisqlplusûÓÐÎÊÌ⣬Èç¹ûÐÞ¸ÄIPºó£¬¿ÉÄܵ¼µ½²»ÄÜʹÓÃ
½¨ÒéʹÓõÚÈý·½¹¤¾ßtoad¡¢pl/sql developerºÍoracle×Ô´øµÄsqlplus

¸ÕÊÔ¹ýoracle×Ô´øµÄsqlplus Ò²Óò»ÆðÀ´Ñ½ ÔεÄÁË

²»»á°É£¬ÊDZ¾»úÁ¬½ÓÂð£¿
Èç¹û±¾»úÁ¬½Ó£¬Ö»ÐèÒªÊäÈëÓû§Ãû³ÆºÍ¿ÚÁî¾Í¿ÉÒÔÁË£¬¿´ÊÇ·ñ¿ÉÒÔÁ¬½Ó
Èç¹ûÊý¾Ý¿â²»ÔÚ±¾»úÉÏ£¬ÔòÒªÅäÖÃ%ORACLE_HOME%\NETWORK\ADMIN\tnsnames.oraÖеÄÁ¬½Ó´®(·þÎñÃû)
ÅäºÃÒԺ󣬿ÉÒÔʹÓÃtnsping Á¬½Ó´®Ãû(·þÎñÃû)À´²âÊÔÊÇ·ñÁ¬Í¨

ÊDZ¾µØÁ¬½ÓµÄѽ ÎÒ¸Õ¸Õ°²×°ºÃµÄʱºòÓùýÁ赀 ¿ÉÒÔÁ¬½ÓµÄÉÏÈ¥ ¿ÉÊǵڶþ´Î¾Í²»ÐÐÁË ÎÒÃǰàºÜ¶àÈË·¢ÉúÕâÑùµÄÇé¿öѽ ²»¶®Ôõô½â¾ö ÀÏʦҲ²»ÖªµÀ

´íÎóÌáʾÐÅÏ¢ÊÇʲô£¿

sqlplus

Â¥Ö÷˵µÄÐÅÏ¢ºÜ²»È«Ãæ
ÖÁÉÙÒª°Ñ¾ßÌåµÄ³ö´íÐÅÏ¢Ìù³öÀ´°¡


ÆóÒµ¹ÜÀíÆ÷(em)ºÍISQLPLUSÊÇÒªµ¥¶ÀÆôµÄ
osÖÐ
$] lsnrctl start
$] emctl start dbconsole

ÎÒÖØÐÂ×°µÄ10.1µÄ ¿ÉÒÔÓÃÁË Ð»Ð»´ó¼Ò


Ïà¹ØÎÊ´ð£º

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

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

oracle spatial¿Õ¼äº¯Êý³ö´í - Oracle / ¸ß¼¶¼¼Êõ

ÔÚÖ´ÐаüµÄʱºòÒýÓÃoracle spatial¿Õ¼äº¯Êý³ö´í£¬³ö´íÇé¿öÈçÏÂ
Errors in file
/user/oracle/app/oracle/admin/grid/udump/grid1_ora_143768.trc: ORA-29902:
error in executing ODCIIndexStart() routine ORA-0 ......

oracle²¢·¢´¦ÀíSOS - Oracle / ¿ª·¢

ÎÒÔÚ¿ª·¢µÄÕâ¸öÓ¦Óò¢·¢ÐԱȽϸߣ¬oracle¸üÐÂÊý¾ÝʱºòÈçºÎ´¦Àí²¢·¢´¦ÀíÄØ£¿¸÷λ´óÏÀ·¢±íºÃµÄ¹Ûµã°¡£¬ÔÚÏߵȴý£¡
oracleÊý¾Ý¸üÐÂʱ£¬»á×Ô¶¯Ä¬ÈÏÐÐËø¶¨£¬Â¥Ö÷²»Òª²ÙÐÄ£¬Oracle¶Ô²¢Ðд¦ÀíÒѾ­ºÜ³ÉÊìÁË

ÒýÓÃ
oracle ......

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

Çë½Ì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ºÅ