oracle启动于关闭的过程,Oracle 数据库实例启动关闭过程

五、演示*/

[root@robinson ~]# su - Oracle

--查看未启动实例前的进程情况

[oracle@robinson ~]$ ps -aef |grep oracle

root333233000 12:20 pts/100:00:00 su - oracle

oracle333333320 12:20 pts/100:00:00 -bash

oracle336533330 12:20 pts/100:00:00 ps -aef

oracle336633330 12:20 pts/100:00:00 grep oracle

--使用ipcs查看当前进程间通讯所用到的共享资源，内存段及信号量，

--可以看出当前无任何通信设备及共享资源

[oracle@robinson ~]$ ipcs -a

------ Shared Memory Segments --------

keyshmidownerpermsbytesnattchstatus

------ Semaphore Arrays --------

keysemidownerpermsnsems

------ Message Queues --------

keymsqidownerpermsused-bytesmessages

--登陆到sqlplus

[oracle@robinson ~]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Thu Apr 29 13:07:29 2010

Copyright (c) 1982, 2005, Oracle.All rights reserved.

Connected to an idle instance.

--再次查看进程情况，多出了进程

SQL> !ps -aef | grep oracle

root333233000 12:20 pts/100:00:00 su - oracle

oracle333333320 12:20 pts/100:00:00 -bash

oracle397233330 13:07 pts/100:00:00 sqlplusas sysdba

oracle397339720 13:07 ?00:00:00 oracleorcl (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))

oracle397439720 13:07 pts/100:00:00 /bin/bash -c ps -aef | grep oracle

oracle397539740 13:07 pts/100:00:00 ps -aef

--再次查看进程间通讯资源，同样是没有任何分配

SQL> !ipcs -a

------ Shared Memory Segments --------

keyshmidownerpermsbytesnattchstatus

------ Semaphore Arrays --------

keysemidownerpermsnsems

------ Message Queues --------

keymsqidownerpermsused-bytesmessages

--启动到nomount

SQL> startup nomount

ORACLE instance started.

Total System Global Area398458880 bytes

Fixed Size1219640 bytes

Variable Size117441480 bytes

Database Buffers276824064 bytes

Redo Buffers2973696 bytes

--可以看到多出了一些后台进程，即为Oracle的后台进程。从开始。

SQL> !ps -aef | grep oracle

root333233000 12:20 pts/100:00:00 su - oracle

oracle333333320 12:20 pts/100:00:00 -bash

oracle397233330 13:07 pts/100:00:00 sqlplusas sysdba

oracle398110 13:09 ?00:00:00 ora_pmon_orcl

oracle398310 13:09 ?00:00:00 ora_psp0_orcl

oracle398510 13:09 ?00:00:00 ora_mman_orcl

oracle398710 13:09 ?00:00:00 ora_dbw0_orcl

oracle398910 13:09 ?00:00:00 ora_lgwr_orcl

oracle399110 13:09 ?00:00:00 ora_ckpt_orcl

oracle399310 13:09 ?00:00:00 ora_smon_orcl

oracle399510 13:09 ?00:00:00 ora_reco_orcl

oracle399710 13:09 ?00:00:00 ora_cjq0_orcl

oracle399910 13:09 ?00:00:00 ora_mmon_orcl

oracle400110 13:09 ?00:00:00 ora_mmnl_orcl

oracle400310 13:09 ?00:00:00 ora_d000_orcl

oracle400510 13:09 ?00:00:00 ora_s000_orcl

oracle400639720 13:09 ?00:00:00 oracleorcl (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))

oracle400939720 13:10 pts/100:00:00 /bin/bash -c ps -aef | grep oracle

oracle401040090 13:10 pts/100:00:00 ps -aef

--可以看到已经分配了SGA

SQL> !ipcs -a

------ Shared Memory Segments --------

keyshmidownerpermsbytesnattchstatus

0x99eb282c 65537oracle64040265318414

------ Semaphore Arrays --------

keysemidownerpermsnsems

0x6df43ca0 98304oracle640127

0x6df43ca1 131073oracle640127

0x6df43ca2 163842oracle640127

------ Message Queues --------

keymsqidownerpermsused-bytesmessages

--查看控制文件，没有任何数据，因为此阶段控制文件并没有打开

SQL> select * from v$controlfile;

no rows selected

--查看数据文件和日志文件，提示database not mounted

SQL> select * from v$datafile;

select * from v$datafile

*

ERROR at line 1:

ORA-01507: database not mounted

SQL> select * from v$logfile;

select * from v$logfile

*

ERROR at line 1:

ORA-01507: database not mounted

--切换到mount阶段

SQL> alter database mount;

Database altered.

--可以查看控制文件的相关信息

SQL> select * from v$controlfile;

STATUSNAMEIS_ BLOCK_SIZE FILE_SIZE_BLKS

------- -------------------------------------------------- --- ---------- --------------

/u01/app/oracle/oradata/orcl/control01.ctlNO16384430

/u01/app/oracle/oradata/orcl/control02.ctlNO16384430

/u01/app/oracle/oradata/orcl/control03.ctlNO16384430

--可以查看数据文件的相关信息

SQL> select FILE#,STATUS,ENABLED,CHECKPOINT_CHANGE#,CHECKPOINT_TIME,ONLINE_TIME,NAME from v$datafile;

FILE# STATUSENABLEDCHECKPOINT_CHANGE# CHECKPOIN ONLINE_TI NAME

---------- ------- ---------- ------------------ --------- --------- --------------------------------------------------

1 SYSTEMREAD WRITE2027235 28-APR-10 06-APR-10 /u01/app/oracle/oradata/orcl/system01.dbf

2 ONLINEREAD WRITE2027235 28-APR-10 06-APR-10 /u01/app/oracle/oradata/orcl/undotbs01.dbf

3 ONLINEREAD WRITE2027235 28-APR-10 06-APR-10 /u01/app/oracle/oradata/orcl/sysaux01.dbf

4 ONLINEREAD WRITE2027235 28-APR-10 06-APR-10 /u01/app/oracle/oradata/orcl/users01.dbf

5 ONLINEREAD WRITE2027235 28-APR-10/u01/app/oracle/oradata/orcl/example01.dbf

6 ONLINEREAD WRITE2027235 28-APR-10/u01/app/oracle/oradata/orcl/Test.dbf

7 ONLINEREAD WRITE2027235 28-APR-10/u01/app/oracle/oradata/orcl/ORCL/datafile/o1_mf_s

_5vrl1t7h_.dbf

--可以查看日志文件的相关信息

SQL> select * from v$logfile;

GROUP# STATUSTYPEMEMBERIS_

---------- ------- ------- ------------------------------------------------------------ ---

3ONLINE/u01/app/oracle/oradata/orcl/redo03.logNO

2ONLINE/u01/app/oracle/oradata/orcl/redo02.logNO

1ONLINE/u01/app/oracle/oradata/orcl/redo01.logNO

--数据不可访问，因为在此阶段，数据文件，日志文件并没有打开

SQL> select * from scott.emp;

select * from scott.emp

*

ERROR at line 1:

ORA-01219: database not open: queries allowed on fixed tables/views only

--切换到open阶段

SQL> alter database open;

Database altered.

--再次查看进程信息，多出了之后的相关进程

SQL> !ps -aef | grep oracle

oracle398110 13:09 ?00:00:00 ora_pmon_orcl

oracle398310 13:09 ?00:00:00 ora_psp0_orcl

oracle398510 13:09 ?00:00:00 ora_mman_orcl

oracle398710 13:09 ?00:00:00 ora_dbw0_orcl

oracle398910 13:09 ?00:00:00 ora_lgwr_orcl

oracle399110 13:09 ?00:00:00 ora_ckpt_orcl

oracle399310 13:09 ?00:00:00 ora_smon_orcl

oracle399510 13:09 ?00:00:00 ora_reco_orcl

oracle399710 13:09 ?00:00:00 ora_cjq0_orcl

oracle399910 13:09 ?00:00:00 ora_mmon_orcl

oracle400110 13:09 ?00:00:00 ora_mmnl_orcl

oracle400310 13:09 ?00:00:00 ora_d000_orcl

oracle400510 13:09 ?00:00:00 ora_s000_orcl

root406840360 13:29 pts/100:00:00 su - oracle

oracle406940680 13:29 pts/100:00:00 -bash

oracle410140690 13:29 pts/100:00:00 sqlplus

oracle410241010 13:29 ?00:00:01 oracleorcl (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))

oracle413710 13:54 ?00:00:00 ora_qmnc_orcl

oracle413910 13:54 ?00:00:01 ora_j000_orcl

oracle414110 13:54 ?00:00:00 ora_j001_orcl

oracle414310 13:54 ?00:00:00 ora_j002_orcl

oracle414510 13:54 ?00:00:00 ora_j003_orcl

oracle414710 13:54 ?00:00:00 ora_j004_orcl

oracle414910 13:54 ?00:00:00 ora_j005_orcl

oracle415910 13:54 ?00:00:00 ora_q001_orcl

oracle416710 13:56 ?00:00:00 ora_q002_orcl

oracle416910 13:57 ?00:00:00 ora_q003_orcl

oracle417241010 13:58 pts/100:00:00 /bin/bash -c ps -aef | grep oracle

oracle417341720 13:58 pts/100:00:00 ps -aef

--数据已可正常访问

SQL> select * from scott.emp where ename = 'SCOTT';

EMPNO ENAMEJOBMGR HIREDATESALCOMM

---------- ---------- --------- ---------- --------- ---------- ----------

DEPTNO

----------

7788 SCOTTANALYST7566 19-APR-873000

--查看告警日志文件路径

SQL> show parameter background_dump_dest

NAMETYPEVALUE

------------------------------------ ----------- ------------------------------

background_dump_deststring/u01/app/oracle/admin/orcl/bdu

mp

--查看动态性能视图

SQL> select sql_text,executions from v$sql where cpu_time >2000000;

SQL_TEXT

--------------------------------------------------------------------------------

EXECUTIONS

----------

select s.synonym_name object_name, o.object_type from all_synonyms s,sys.a

ll_objects o where s.owner in ('PUBLIC', :schema) and o.owner = s.table_owner an

d o.object_name = s.table_name and o.object_type in ('TABLE', 'VIEW', 'PACKAGE',

'TYPE', 'PROCEDURE', 'FUNCTION', 'SEQUENCE')

2

SQL> select username,status,server,state from v$session where program = 'plsqldev.exe';

USERNAMESTATUSSERVERSTATE

------------------------------ -------- --------- -------------------

SYSINACTIVE DEDICATED WAITING

SYSINACTIVE DEDICATED WAITING

SQL> select sid,ctime from v$lock where sid = 275;

SIDCTIME

---------- ----------

2759607

2759270

2759243

/*