Oracle Key Concepts - Make Sure You Know All!
The content taken from
Title: Oracle Database Administration Concepts &
Implementation Made Simple
ISBN: 0-9770739-0-4
Author: Asim Abbasi
Oracle Key Concepts - Make Sure You Know All!
121. Oracle software is free for learning purpose and can be downloaded
form Oracle website.
122. Oracle Universal Installer installs the Oracle system on the
machine.
123. OUI is java based and hence the process of installation is totally
independent of underlying OS.
124. Two ways to achieve same goals i.e. development of Oracle Database.
125. Those two ways are DBCA & Manual.
126. Before starting DBCA we need to set certain OS environment
variables.
127. Those environment variables are ORACLE_BASE, ORACLE_HOME,
ORALCE_SID and, PATH.
128. DBCA can be run through the start menu in Windows or by entering
the dbca command in Unix OS.
129. DBCA comes with four pre-built templates.
130. Global Database name is usually described in name.domain format and
is the unique identification of Oracle database.
131. SID is the name of the instance on the machine. You can never have
two or more instance having the same name on the same machine.
132. We can either run Oracle in Dedicated Server Mode or Shared Server
Mode.
133. Memory architecture of Oracle can be configured through this window
of DBCA.
134. Oracle Server can be run in ARCHIVELOG mode or NOARCHIVELOG mode.
135. In archive log mode Redo Log files get archived to the destination
you specify.
136. In no archive mode once Redo Log files get filled up, Oracle will
start overwriting them.
137. Redo Log Files size remains the same.
138. spfile has made possible the ALTER SYSTEM statement to get utilized
in changing any initialization parameter with no need to restart the
Oracle Server.
139. Four very important initialization parameters viz., ORACLE_BASE,
ORACLE_HOME, DB_NAME and ORACLE_SID
140. We can select and deselect any of the initialization parameters and
edit the values.
Oracle Key Concepts - Make Sure You Know All!
Share with others: