Database startup and shutdown

Feb 1 posted in Oracle (RSS), 93 views.

Oracle Server two major components:

Instance: refers to background processes, threads and shared memory regions, such as: pmon, dbwr, PGA, SGA

Database: that is stored in memory on the physical file

---

1. DATABASE
Oracle Database starts with the following three steps:
(1) starts to nomount state;
(2) start to mount state;
(3) start to open state.
---
nomount Status
a.Oracle to go first parameter file (pfile / spfile).
b. According to parameter file, create an instance, the allocation of memory, Kai background processes.

PS:
1. As long as the parameter files are available - "Start an instance (Instance), this step will not be used: control files, data files.
2. This step problem may be the kernel parameters, shared memory, and so on, need to check if the allocation of adequate resources.

Start Method:

1.cd $ ORACLE_HOME / dbs
2.sqlplus "/ as sysdba"
3.startup nomount

PS: 9i, select the parameter file order.
1. Spfile <sid>. Ora -> spfile.ora -> init <sid>. Ora (in front of not only finding the back).
2. The above three documents do not exist, Oracle will not be able to create and start the instance.
3. Pfile file to ensure consistency, a lot of time will be spfile <sid>. Ora soft link to the init <sid>. Ora.

======== The following is the Kai to nomount state alert_ <sid>. Log =========

Tue Feb 2 19:34:35 2010
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
IMODE = BR
ILAT = 18
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.1.0.
System parameters with non-default values:
processes = 150
__shared_pool_size = 75497472
__large_pool_size = 4194304
__java_pool_size = 4194304
__streams_pool_size = 0
nls_language = SIMPLIFIED CHINESE
nls_territory = CHINA
sga_target = 264241152
control_files = / opt/oracle/oradata/modl/control01.ctl, / opt / oracle / oradata / modl / contr
ol02.ctl, / opt/oracle/oradata/modl/control03.ctl
db_block_size = 8192
__db_cache_size = 171966464
compatible = 10.2.0.1.0
db_file_multiblock_read_count = 16
db_recovery_file_dest = / opt / oracle / flash_recovery_area
db_recovery_file_dest_size = 2147483648
undo_management = AUTO
undo_tablespace = UNDOTBS1
remote_login_passwordfile = EXCLUSIVE
db_domain = localhost
dispatchers = (PROTOCOL = TCP) (SERVICE = modlXDB)
job_queue_processes = 10
background_dump_dest = / opt / oracle / admin / modl / bdump
user_dump_dest = / opt / oracle / admin / modl / udump
core_dump_dest = / opt / oracle / admin / modl / cdump
audit_file_dest = / opt / oracle / admin / modl / adump
db_name = modl
open_cursors = 300
pga_aggregate_target = 88080384
PMON started with pid = 2, OS
PSP0 started with pid = 3, OS
MMAN started with pid = 4, OS
DBW0 started with pid = 5, OS
LGWR started with pid = 6, OS
CKPT started with pid = 7, OS
SMON started with pid = 8, OS
RECO started with pid = 9, OS
CJQ0 started with pid = 10, OS
MMON started with pid = 11, OS
Tue Feb 2 19:34:43 2010
starting up 1 dispatcher (s) for network address' (ADDRESS = (PARTIAL = YES) (PROTOCOL = TCP ))'...
MMNL started with pid = 12, OS
Tue Feb 2 19:34:43 2010
starting up 1 shared server (s) ...

======== The following is the Kai to nomount state alert_ <sid>. Log =========

View the current database using the pfile file method:

In sql * plus in the implementation of the show parameter spfile

SQL> show parameter pfile

NAME TYPE VALUE
------------------------------------ ----------- --- ---------------------------
spfile string / opt/oracle/102/dbs/spfilemodl
. ora
SQL>

After the state started to nomount in the background we can see the following processes:

smon, pmon, dbwr, lgwr, ckpt, arch

[oracle @ cnsz001 ~] $ ps-ef | grep ora_
oracle 5773 1 0 19:34? 00:00:00 ora_pmon_modl
oracle 5775 1 0 19:34? 00:00:00 ora_psp0_modl
oracle 5777 1 0 19:34? 00:00:00 ora_mman_modl
oracle 5779 1 0 19:34? 00:00:00 ora_dbw0_modl
oracle 5781 1 0 19:34? 00:00:00 ora_lgwr_modl
oracle 5783 1 0 19:34? 00:00:00 ora_ckpt_modl
oracle 5785 1 0 19:34? 00:00:00 ora_smon_modl
oracle 5787 1 0 19:34? 00:00:00 ora_reco_modl
oracle 5789 1 0 19:34? 00:00:00 ora_cjq0_modl
oracle 5791 1 0 19:34? 00:00:00 ora_mmon_modl
oracle 5793 1 0 19:34? 00:00:00 ora_mmnl_modl
oracle 5795 1 0 19:34? 00:00:00 ora_d000_modl
oracle 5797 1 0 19:34? 00:00:00 ora_s000_modl
oracle 5836 5800 0 19:35 pts / 2 00:00:00 grep ora_