Database Reference
In-Depth Information
ora12cr1 18538 1 0 14:43 ? 00:00:00 ora_smon_ora12c
ora12cr1 18540 1 0 14:43 ? 00:00:00 ora_reco_ora12c
ora12cr1 18542 1 0 14:43 ? 00:00:00 ora_lreg_ora12c
ora12cr1 18544 1 0 14:43 ? 00:00:00 ora_mmon_ora12c
ora12cr1 18546 1 0 14:43 ? 00:00:00 ora_mmnl_ora12c
ora12cr1 18547 18500 0 14:43 ? 00:00:00 oracleora12c (DESCRIPTION=(LOCAL=YES)
(ADDRESS=(PROTOCOL=beq)))
ora12cr1 18566 18500 0 14:45 pts/0 00:00:00 /bin/bash -c ps -aef | grep ora12cr1
ora12cr1 18567 18566 0 14:45 pts/0 00:00:00 ps -aef
ora12cr1 18568 18566 0 14:45 pts/0 00:00:00 grep ora12cr1
Additionally, ipcs , for the first time, reports the use of shared memory and semaphores—two important
interprocess communication devices on UNIX/Linux:
SQL> !ipcs -a
------ Shared Memory Segments --------
key shmid owner perms bytes nattch status
0x10d1c894 13074435 ora12cr1 660 10485760 38
0x00000000 13107204 ora12cr1 660 322961408 19
------ Semaphore Arrays --------
key semid owner perms nsems
0xfc46e83c 425986 ora12cr1 660 171
0xfc46e83d 458755 ora12cr1 660 171
0xfc46e83e 491524 ora12cr1 660 171
0xfc46e83f 524293 ora12cr1 660 171
0xfc46e840 557062 ora12cr1 660 171
------ Message Queues --------
key msqid owner perms used-bytes messages
Note we have no “database” yet. We have the name of a database (in the parameter file we created), but no actual
database. If we try to “mount” this database, it would fail because, quite simply, the database does not yet exist. Let's
create it. I've been told that creating an Oracle database involves quite a few steps, but let's see:
SQL> create database;
Database created.
That is actually all there is to creating a database. In the real world, however, we'd use a slightly more complicated
form of the CREATE DATABASE command because we would want to tell Oracle where to put the online redo log files,
data files, control files, and so on. But we do now have a fully operational database. We still need to run the
$ORACLE_HOME/rdbms/admin/catalog.sql script and other catalog scripts to build the rest of the data dictionary
we use every day (the views we use such as ALL_OBJECTS are not yet present in this database), but we have an actual
database here. We can use a simple query against some Oracle V$ views, specifically V$DATAFILE , V$LOGFILE , and
V$CONTROLFILE , to list the files that make up this database.
 
Search WWH ::




Custom Search