深入浅出Oracle -参数文件与数据库起停 盖国强 (eygle) Mobile:13911812803 MSN: eyglehotmail.com Site : www.eygle.com Mail: eygleeygle.comWho am Ihttp:/www.eygle.com版权所有(20062008) eygle ITPUB论坛超级版主 Oracle ACE Director 咨询顾问、技术支持 个人站点: www.eygle.com今日主题参数与参数文件24数据库的启动过程3 1Oracle启动的内部处理3 3题外话5启动与等待数据库的启动过程 Nomount过程SQL startup nomount; ORA-00600: internal error code, arguments: OSDEP_INTERNAL, , , , , , , ORA-27302: failure occurred at: skgpwreset1 ORA-27303: additional information: invalid shared ctx ORA-27146: post/wait initialization failed ORA-27300: OS system dependent operation:semgetfailed with status: 28 ORA-27301: OS failure message: No space left on device ORA-27302: failure occurred at: sskgpsemsperSQL startup nomount ORACLE instance started.Total System Global Area 80811208 bytes Fixed Size 451784 bytes Variable Size 37748736 bytes Database Buffers 41943040 bytes Redo Buffers 667648 bytes数据库的启动过程 mount过程ORA-00202: controlfile: /opt/oracle/oradata/conner/control01.ctl ORA-27037: unable to obtain file status Linux Error: 2: No such file or directory Additional information: 3*.control_files=/opt/oracle/oradata/conner/control01.ctl, /opt/oracle/oradata/conner/control02.ctl, /opt/oracle/oradata/conner/control03.ctl数据库的启动过程 open过程alter session set events immediate trace name controlf level 10;*.control_files=/opt/oracle/oradata/conner/control01.ctl, /opt/oracle/oradata/conner/control02.ctl, /opt/oracle/oradata/conner/control03.ctlunrecoverable scn: 0x0000.00000000 04/23/2004 01:20:52 Checkpoint cnt:1569 scn: 0x0000.01481939 06/22/2004 19:02:22 Stop scn: 0xffff.ffffffff 06/22/2004 18:58:05 Creation Checkpointed at scn: 0x0000.000000ae 07/16/2003 03:40:10 数据库创建脚本数据库的初始化startup nomount pfile=“C:oracleadmineyglescriptsinit.ora“; CREATE DATABASE“eygle“MAXINSTANCES 8 MAXLOGHISTORY 1 MAXLOGFILES 16 MAXLOGMEMBERS 3 MAXDATAFILES 100 DATAFILE SIZE 300M AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SYSAUX DATAFILE SIZE 120M AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED SMALLFILE DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE SIZE 20M AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED SMALLFILE UNDO TABLESPACE “UNDOTBS1“ DATAFILE SIZE 200M AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED CHARACTER SET ZHS16GBK 。http:/www.eygle.com版权所有(20062008) eygleD:oracleproductadmineyglescriptstail -1 initeygleTemp.ora_no_recovery_through_resetlogs=truesql.bsq文件与数据库创建 数据库初始化文件 创建数据库过程中的调用http:/www.eygle.com版权所有(20062008) eygleSQL GetParDescrb.sql Enter value for par: init_sql old 6: AND x.ksppinm LIKE % Session altered. SQL alter database mount; Database altered. SQL alter database open; Database altered.SQL SELECT a.VALUE| b.symbol| c.instance_name| _ora_ | d.spid| .trc trace_file 2 FROM (SELECT VALUE FROM v$parameterWHERE NAME = user_dump_dest) a, 3 (SELECT SUBSTR (VALUE, -6, 1) symbol 4 FROM v$parameterWHERE NAME = user_dump_dest) b, 5 (SELECT instance_nameFROM v$instance) c, 6 (SELECT spidFROM v$sessions, v$processp, v$mystatm 7 WHERE s.paddr= p.addrAND s.SID = m.SID AND m.statistic# = 0) d 8 /TRACE_FILE - /opt/oracle/admin/eygle/udump/eygle_ora_25660.trc从跟踪文件获得信息http:/www.eygle.com版权所有(20062008) eygleWAIT #1: nam=direct path read ela= 43 p1=1 p2=1 p3=1 WAIT #1: nam=direct path read ela= 4 p1=2 p2=1 p3=1 WAIT #1: nam=direct path read ela= 3 p1=3 p2=1 p3=1 WAIT #1: nam=direct path read ela= 2 p1=4 p2=1 p3=1 WAIT #1: nam=direct path read ela= 2 p1=201 p2=1 p3=1 WAIT #1: nam=db file sequential read ela= 88 p1=1 p2=417 p3=1 WAIT #1: nam=db file sequential read ela= 91 p1=1 p2=377 p3=1 = PARSING IN CURSOR #2 len=188 dep=1 uid=0 oct=1 lid=0 tim=1149404325230977 hv=0 ad=b700de24 create table bootstrap$ ( line# number not null, create table bootstrap$ ( line# number not null, objobj# number not null, # number not null, sql_textsql_textvarchar2(4000) not null) varchar2(4000) not null) storage (initial 50K storage (initial 50K objnoobjno 56 extents (file 1 block 377)56 extents (file 1 block 377) END OF STMT PARSE #2:c=0,e=1173,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=4,tim=1149404325230943 BINDS #2: EXEC #2:c=0,e=473,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=1149404325231638控制文件及数据文件信息分析控制文件的内容分析所有数据文件头获得地址信息http:/www.eygle.com版权所有(20062008) eyglealter session set events immediate trace name FILE_HDRS level 10 alter session set events immediate trace name CONTROLF level 10 Tablespace#0 - SYSTEM rel_fn:1 Creation at scn: 0x0000.00000007 04/24/2006 11:34:39 Backup taken at scn: 0x0004.6c2d657e 02/12/2007 15:54:52 thread:1 reset logs count:0x24dc1f7d scn: 0x0004.6c432ec0 recovered at 04/07/2007 21:04:11 status:0x4 root dba:0x004001a1 chkptcnt: