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µÄ ¿ÉÒÔÓÃÁË Ð»Ð»´ó¼Ò
Ïà¹ØÎÊ´ð£º
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
ÔÚÖ´ÐаüµÄʱºòÒýÓÃ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¸üÐÂÊý¾ÝʱºòÈçºÎ´¦Àí²¢·¢´¦ÀíÄØ£¿¸÷λ´óÏÀ·¢±íºÃµÄ¹Ûµã°¡£¬ÔÚÏߵȴý£¡
oracleÊý¾Ý¸üÐÂʱ£¬»á×Ô¶¯Ä¬ÈÏÐÐËø¶¨£¬Â¥Ö÷²»Òª²ÙÐÄ£¬Oracle¶Ô²¢Ðд¦ÀíÒѾºÜ³ÉÊìÁË
ÒýÓÃ
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 / ......
²é¿´ÊÂÎñ¸ôÀë¼¶±ðµÄÃüÁ
MySQLʹÓõÄÊÇselect @@tx_isolation;
ÔÚOracleÖв鿴ÊÂÎñ¸ôÀë¼¶±ðµÄÃüÁîÊÇÄĸö£¿
SQL code:
SELECT /*+ rule */ s.username,decode(l.type,'TM','TABLE LOCK','TX','ROW LOCK', ......