oracleÓÃ127.0.0.1½ÓÁ¬²»ÉÏ - Oracle / »ù´¡ºÍ¹ÜÀí
oracleÓÃ127.0.0.1½ÓÁ¬²»ÉÏ,ÓÐÈË˵ÊÇÒòΪ°²×°Ê±ÊÇÁªÍø°²×°µÄ£¬ËùÒÔ²»ÁªÉÏ£¬Óñ¾»úip¿ÉÒÔ
¸÷λ´ó¸ç£¬ÏÖÔÚÔõôÐ޸ģ¬Ð»Ð»ÁË
¼ÈÈ»ÊDZ¾»ú£¬·þÎñÃûtnsname.oraºÍlistener.ora¶¼¿É²»Å䣬¾Í¿ÉÒÔÁ¬½Ó¡£
127.0.0.1 localhost
ÖØÐÂÅäÖÃÒ»±é¼àÌý£¡
ÔõÃ´ÖØÐÂÅäÖã¬
ÓÃ127.0.0.1²»ÐУ¬µ«±¾»úµÄipÄÜÐУ¬ËûÃÇ˵ÔÒòÊǰ²×°Ê±Ã»ÓжÎÍø£¬ËùÒÔ³öÏÖÕâÑùµÄÎÊÌâ
ÏÖÔÚ²»ÖªµÀ£¬Ôõô´¦Àí£¿£¿£¿
ÄãÓ¦¸ÃÅäÖÃÁË´úÀíÁ˰ɡ£
IEÅäÖÃÀïÃæÉèÖÃÏÂ
¼ì²éÒ»ÏÂwindows µÄhosts Îļþ¡£ ¿´ÀïÃæÊÇÔõôдµÄ.
------------------------------------------------------------------------------
Blog£º http://blog.csdn.net/tianlesoftware
ÍøÉÏ×ÊÔ´£º http://tianlesoftware.download.csdn.net
Ïà¹ØÊÓÆµ£ºhttp://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx
DBA1 Ⱥ£º62697716(Âú); DBA2 Ⱥ£º62697977
¼àÌýµÄ²»ÊÇÕâ¸öÍø¿¨µÄIP£¬Äã×ÔÈ»Á¬½Ó²»ÉÏ¡£
Ïà¹ØÎÊ´ð£º
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
ÔÚϵͳÔËÐеÄʱºò×ÜÊÇÓÐÒ»¿é´ÅÅÌʼÖÕÉÁºìµÆ£¬½øÈëϵͳºó
#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 ÕýÈ ......
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 10g¾¹ýÒ»·¬Å¬Á¦Äܹ»Ë³ÀûµÄÁ¬½ÓÉÏÁË£¬
µ«ÊÇÎÒÒÔǰÓõÄÊÇsql server ËûµÄÆóÒµ¹ÜÀíÆ÷ÖÐÄÜ¶Ô±í½øÐпÉÊÓ»¯¹ÜÀí
ÔÚoracleÖÐÎÒÒ²¿´µ½ÁËÓпÉÊÓ»¯µÄem
µ«ÊÇÎÒ¾ÍÊÇ¿´²»µ½±íµÄÄÚÈÝÀ´
ÇëÎÊÓÐûÓдóϺÄܰï°ïà ......