Database Reference
In-Depth Information
and then, once we get back into SQL*Plus:
[ora12cr1@dellpe dbs]$ sqlplus / as sysdba
SQL*Plus: Release 12.1.0.1.0 Production on Mon Sep 2 14:42:27 2013
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup nomount
ORACLE instance started.
Total System Global Area 329895936 bytes
Fixed Size 2287960 bytes
Variable Size 272631464 bytes
Database Buffers 50331648 bytes
Redo Buffers 4644864 bytes
We used the
nomount
option to the
startup
command since we don't actually have a database to mount yet
(the SQL*Plus documentation includes all of the startup and shutdown options).
■
On windows, prior to running the
startup
command, you'll need to execute a service creation statement using
the
oradim.exe
utility.
Note
Now we have what I'd call an instance. The background processes needed to actually run a database are all there,
including process monitor (
pmon
), log writer (
lgwr
), and so on (these processes are covered in detail in Chapter 5).
Let's take a look:
SQL> !ps -aef | grep ora12cr1
root 18392 15416 0 14:31 pts/1 00:00:00 su - ora12cr1
ora12cr1 18401 18392 0 14:31 pts/1 00:00:00 -bash
ora12cr1 18499 18401 0 14:42 pts/1 00:00:00 rlwrap /home/ora12cr1/app/ora12cr1/product/12.1.0/
dbhome_1/bin/sqlplus / as sysdba
ora12cr1 18500 18499 0 14:42 pts/0 00:00:00 /home/ora12cr1/app/ora12cr1/product/12.1.0/dbhome_1/
bin/sqlplus as sysdba
ora12cr1 18508 1 0 14:43 ? 00:00:00 ora_pmon_ora12c
ora12cr1 18510 1 0 14:43 ? 00:00:00 ora_psp0_ora12c
ora12cr1 18512 1 0 14:43 ? 00:00:00 ora_vktm_ora12c
ora12cr1 18516 1 0 14:43 ? 00:00:00 ora_gen0_ora12c
ora12cr1 18518 1 0 14:43 ? 00:00:00 ora_mman_ora12c
ora12cr1 18522 1 0 14:43 ? 00:00:00 ora_diag_ora12c
ora12cr1 18524 1 0 14:43 ? 00:00:00 ora_dbrm_ora12c
ora12cr1 18526 1 0 14:43 ? 00:00:00 ora_dia0_ora12c
ora12cr1 18528 1 0 14:43 ? 00:00:00 ora_dbw0_ora12c
ora12cr1 18530 1 0 14:43 ? 00:00:00 ora_lgwr_ora12c
ora12cr1 18532 1 0 14:43 ? 00:00:00 ora_ckpt_ora12c
ora12cr1 18534 1 0 14:43 ? 00:00:00 ora_lg00_ora12c
ora12cr1 18536 1 0 14:43 ? 00:00:00 ora_lg01_ora12c
