oracleÆô¶¯·ÖÎö
oracleÆô¶¯·½Ê½ÓëÃüÁî²ÎÊý»ã×Ü
±¾ÎÄÖ÷ÒªÊǶÔoracleµÄÆô¶¯·½Ê½ºÍÏà¹ØµÄÃüÁî²ÎÊý½øÐÐÒ»¸ö»ã×Ü£¬ÓÃÒÔ¼ÓÉîÓ¡Ïó¡£
OracleµÄÆô¶¯·½Ê½£º
startup nomount
startup mount
startup open (startupµÄĬÈÏÑ¡Ïî)
ÆäËû³£ÓõIJÎÊý£ºread only ,read write ,force,restrict
ÕâЩ²ÎÊý¿ÉÒÔÒ»ÆðʹÓÃ,±ÈÈç startup Óë startup open read write ÊÇÒ»ÑùµÄЧ¹û¡£
OracleµÄÆô¶¯¹ý³Ì£ºÆô¶¯ÊµÀý -> ×°ÔØÊý¾Ý¿â -> ´ò¿ªÊý¾Ý¿â
ÓëÖ®¶ÔÓ¦µÄ¶ÁÈ¡ÏàÓ¦ÎļþµÄ˳Ðò£º ²ÎÊýÎļþ -> ¿ØÖÆÎļþ -> Êý¾ÝÎļþ
ÎÒÃÇÑéÖ¤Ò»ÏÂÕâЩ²½ÖèµÄÇø±ð£º
startup nomount
ʹÓÃnomount·½Ê½Æô¶¯Êý¾Ý¿âʱ£¬±íʾֻÆô¶¯Êý¾Ý¿âʵÀý£¬²»×°ÔØÊý¾Ý¿â£¬²»´ò¿ªÊý¾Ý¿â
Õâʱֻ¶ÁÈ¡²ÎÊýÎļþ£¬Ö÷ÒªÓÐÁ½²¿·Ö¹¤×÷£ºÒ»ÊÇ·ÖÅäÄÚ´æSGAÇø£¬¶þÊÇÆô¶¯Oracleºǫ́½ø³Ì
ÈçÏÂÎÒÃÇÐÞ¸Äoracle²ÎÊýÎļþµÄÃû³Æ£¬²¢ÒÔnomount µÄ·½Ê½Æô¶¯Êý¾Ý¿â
ÕâÀïÐèÒª½«pfile,spfile ¶¼½øÐÐÐ޸ģ¬Êý¾Ý¿âĬÈÏʹÓÃspfileÆô¶¯£¬ÔÚÕÒ²»µ½spfileʱÓÃpfileÆô¶¯¡£
[oracle@localhost dbs]$ pwd
/oracle/orc10g/product/10.1.0/db_1/dbs
[oracle@localhost dbs]$ mv initorcl.ora initorcl1.ora
[oracle@localhost dbs]$ mv spfileorcl.ora spfileorcl1.ora
SYS@orcl>shutdown abort
ORACLE instance shut down.
SYS@orcl>startup nomount
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/oracle/orc10g/product/10.1.0/db_1/dbs/initorcl.ora'
SYS@orcl>
#±£³Ö²ÎÊýÎļþÕýÈ·£¬Ð޸ĿØÖÆÎļþÃû³Æ
[oracle@localhost orcl]$ pwd
/oracle/orc10g/oradata/orcl
[oracle@localhost orcl]$ mv control01.ctl control01a.ctl
[oracle@localhost orcl]$ mv control02.ctl control02a.ctl
[oracle@localhost orcl]$ mv control03.ctl control03a.ctl
.....
SYS@orcl>startup nomount
ORACLE instance started.
Total System Global Area 167772160 bytes
Fixed Size 778212 bytes
Variable Size 61874204 bytes
Database Buffers 104857600 bytes
Redo Buffers 262144 bytes
SYS@orcl>
ÔÚnomountµÄ·½Ê½ÏÂÐ޸ĿØÖÆÎļþÃû³Æ£¬²¢Ã»Óб¨´í¡£ËµÃ÷ÔÚnomountµÄ·½Ê½Ï£¬²¢Ã»ÓжÁÈ¡¿ØÖÆÎļþ¡£
¼ÌÐøÒÔÉϵIJ½Ö裬ÎÒÃÇÒÔmountµÄ·½Ê½Æô¶¯£º
SYS@orcl>alter database mount;
alter database mount
*
ERROR at line 1:
ORA-00205: error in identifying
Ïà¹ØÎĵµ£º
1. °²×°Ç°µÄϵͳÅäÖÃ
1.1. ÅäÖÃϵͳsystemÎļþ
ʹÓÃrootÓû§µÇ½Ö÷»ú£¬ÐÞ¸Ä/etc/systemÎļþ£¬Ìí¼ÓÈçÏÂ×ֶΣº
set noexec_user_stack=1
set semsys:seminfo_semmni = 100
set semsys:seminfo_semmns = 1024
set semsys:seminfo_semmsl = 256
set semsys:seminfo_semvmx = 32767
set shmsys ......
Windows 7ÕæÊÇÈÃÈËÓÖ°®ÓÖºÞ°¡£¡±¾È˵çÄÔ֮ǰÒÑ°²×° SQL Server 2005£¬°²×°¹ý³Ì¶¼Ã»Ê²Ã´ÎÊÌ⣬ºÜ¿ì¸ã¶¨£¬¿ÉÊÇ×°Ò»¸öOracle 10gÈ´»¨ÁËÎÒÒ»¸öÍíÉϵÄʱ¼ä£¡²»¹ý×ÜËã°²×°³É¹¦ÁË£¡ËäÈ»»¹Ã»ÓÐÕýʽ¿ªÊ¼Ê¹Ó㬵«ÊÇÐË·ÜÖ®ÓàÆȲ»¼°´ýÒªºÍ´ó¼Ò·ÖÏíһϾÑ飡
Ê×ÏÈÒªÏÂÔØÖ§³ÖVista°æ±¾µÄOracle 10g£¨ÒÔÏÂÁ´½ÓµØÖ·ÔÚä¯ÀÀÆ÷Öдò¿ªÃ»Ó㬸´ ......
DECODEº¯ÊýÊÇORACLE PL/SQLÊǹ¦ÄÜÇ¿´óµÄº¯ÊýÖ®Ò»£¬Ä¿Ç°»¹Ö»ÓÐORACLE¹«Ë¾µÄSQLÌṩÁ˴˺¯Êý£¬ÆäËûÊý¾Ý¿â³§É̵ÄSQLʵÏÖ»¹Ã»Óд˹¦ÄÜ¡£DECODEÓÐʲôÓÃ;ÄØ£¿Ïȹ¹ÔìÒ»¸öÀý×Ó£¬¼ÙÉèÎÒÃÇÏë¸øÖÇÐÇÖ°Ô±¼Ó¹¤×Ê£¬Æä±ê×¼ÊÇ£º¹¤×ÊÔÚ8000ÔªÒÔϵĽ«¼Ó20£¥£»¹¤×ÊÔÚ8000ÔªÒÔÉϵļÓ15£¥£¬Í¨³£µÄ×ö·¨ÊÇ£¬ÏÈÑ¡³ö¼Ç¼ÖеŤ×Ê×Ö¶ÎÖµ? select sa ......
ÔÚʵ¼ÊµÄ¹¤×÷»·¾³ÖУ¬Ðí¶àÈËΪÁËÊÊÓ¦¿Í»§µÄ»·¾³£¬×ÜÊÇÐèҪƵ·±¸ü¸ÄIPµØÖ·£¬µ«ÊÇÔÚIPµØÖ·±ä»»ºó£¬Oracle 10g¾Í»á³öÏÖÆô¶¯²»Á˵ÄÏÖÏó¡£ÍøÉÏÏà¹ØÎÊÌâµÄ¼¼ÊõÎÄÕ´ó¶àÊýÊÇÕë¶ÔOracle 9i£¬»òÕßÒÔÇ°µÄOracle 8iµÄ°æ±¾£¬¶ÔÓëOracle 10gµÄ°æ±¾£¬´ó¶àÖ»ÊǽéÉÜÁË´ó¸Å£¬²¢Ã»Óиø³ö¾ßÌåµÄ²½Öè!±¾ÎÄÖУ¬ÎÒÃǽ«Õë¶ÔÕâÒ»ÎÊÌâ¸ø³ö¾ßÌåµÄ½â¾ö² ......
ÔÚÊý¾Ý¿âÆô¶¯2Сʱºó£¬¿ÉÒÔͨ¹ýÒÔÏÂSQLÀ´²âÊÔÊý¾Ý¿âÐÔÄÜ
1. »º³åÇøÃüÖÐÂÊ:
»º³åÇøÃüÖÐÂʱíʾÔÚ²»ÐèÒª½øÐдÅÅÌ·ÃÎʵÄÇé¿öÏÂÔÚÄÚ´æ½á¹¹ÖÐÕÒµ½³£ÓÃÊý¾Ý¿éµÄƵÂÊ
select (1-(sum(decode(name, 'physical reads',value,0))/(sum(decode(name, 'db block gets',value,0))
......