AIDA RODRÍGUEZ CAMPESINO Universidad Autónoma de Madrid
2. El New Deal: “The period of social pioneering is only at its beginning”
DBCA
Oracle 9i Database Administration in 10 Minutes
Before even Assistant) w variables. OR
Figure 20: Be
Whereas in U
% setenv ORA ORACLE_HO le software we can set it u
e the DOS prom RACLE_BASE
efore using DBCA
Unix we write t ACLE_BASE E describes th will be inst using the SET c
mpt is C:\>.
E C:\Oracle
A we have to set c variables.
the command a /Oracle es the directo here where Or timal Flexible
should
tabase Config the OS envir he top most d talled. In W command.
certain OS enviro
as shown below
ory that lies
Oracle 9i Database Administration in 10 Minutes
ORACLE_BASE/product/release#. Let’s suppose the DOS prompt is C:\>.
C:\> SET ORACLE_HOME C:\Oracle\database\9_2
Whereas in Unix we write the command as shown below.
% setenv ORACLE_HOME /Oracle/product/9_2
ORACLE_SID is the instance name or rather default instance name on the machine having Oracle installed. Let’s suppose the DOS prompt is C:\>.
C:\> SET ORACLE_SID test
Whereas in Unix we write the command as shown below.
% setenv ORACLE_SID test
PATH is the environment variable and its usually set to ORACLE_HOME/bin folder. The bin folder contains all the tools that shipped with Oracle.
Step 2:
After setting the above mentioned parameters the next step would be to run DBCA. DBCA can be invoked from the Windows operating system start menu as shown below or by entering the following Unix command.
dbca
Figure 21: In windows operating system click: <Start>, <All Programs>,
<Oracle>, <Configuration & Migration Tools> and finally <Database Configuration Assistance>.
Step 3:
Click the <Ne
Figure 22: Firs
Oracle 9i Database
ext> button.
t window of DBC brief description
e Administration in
CA is basically a W on the purpose o
10 Minutes
Welcome messag f this tool.
ge with a
Step 4:
Using DBCA existing data manage temp selected and t
Figure 23: DBC database i.e. co
A you can creat abase, delete lates. Make su then click ‘Nex
CA can assist DBA onfiguring databa
and m
te a new datab an already e ure that ‘Create
xt’ button.
A with 3 other tas ase options in a da manage templates.
ase, configure xisting databa e a Database’ o
sks besides creatin atabase, delete a d
already ase and option is
ng a new database
Step 5:
DBCA has c using “Gener that ‘General button.
Figure 24: Ea template
Oracle 9i Database
certain built-in ral Purpose” d
Purpose’ opti
ach template has p has settings good
e Administration in
n templates. O atabase templa ion is selected
predefined setting d for Analytical P
10 Minutes
Over here we ate option. Ma and then click
gs e.g. Data Ware rocessing purpose
will be ake sure k ‘Next’
ehouse es.
Step 6:
Decide on Identifier (SID case we hav Name and tes then click the
Figure 25
Global Datab D) will be the ve entered tes st will come u e ‘Next’ button
: You can assign
base Name name of the O st.takveen as up automatical n.
any name to Glob
& Domain.
Oracle Instance the Global D ly as SID. On
bal Database Nam
System e. In our Database ce done
me.
Step 7:
Decide on th Oracle Instan Mode.
Figure 26: This run our Orac
Oracle 9i Database
he mode of o nce either in D
s window is mean le Server in ‘dedi
e Administration in
operation of in Dedicated Ser
nt for make a dec icated server mod
mode’.
10 Minutes
nstance. We c rver or Shared
ision whether we de’ or the ‘shared
can run d Server
e want to server
Step 8:
Decide on SG Here you ca memory arch your needs. O that the stuff
Figure 27: Cus
GA sizing. Us an either use hitecture of Or
Once done cli in there is acco
stom option will a to
se either Typic the default racle or chang ick the ‘Archi ording to your
allow you to selec o you needs.
cal or Custom values provid ge them accor ive’ tab to ma
Step 9:
Archive Log files will be a
‘DB Sizing’ t to your requ default values
Oracle 9i Database
Mode: if you s archived befor tab to make sur uirement. All
s.
e Administration in
select this opti re overwritten re that the stuf these tabs wi
10 Minutes
ion then the Re . Once done c ff in there is ac ill already be
edo Log click the ccording
having
Step 10:
Parameter Fil tab. All the d screen are ac about it.
Figure 29: Th
le and Trace F default locatio
cording to stan
his tab will be hav Oracl
Files locations ons and file na
ndards. So you
ving the informati le physical files.
can be set us ames specified u don’t have t
ion about location
sing this d in this o worry
n of all
Step 11:
Make sure t values you s Location Var of these ORALCE_HO OK button an
Figure 30:
Oracle 9i Database
the OS enviro set before sta riables’ button four vari OME, DB_NA nd you will be b
These four param
e Administration in
onment variab arting DBCA.
to see and to iables viz., AME and SID.
back to the pre
meters are present
10 Minutes
bles reflect th . Click on th
make sure the ORACLE_
. Once done c evious window
t in init(SID).ora
he same
Step 12:
To see the co
‘All Initializa will be havin those you hav be a comple deselect any click ‘Close’
window and t
Figure 31: Th parameter
mplete list of i ation Paramete g complete lis ve selected and etely editable of the parame
button and it then click the ‘
his window provi rs. Oracle Instanc
initialization p ers’ button. Th t of all the init d those you ha window i.e.
ters and edit t will take you
‘Next’ button.
des the complete e reads the file at
arameters click he popped up w
tialization para aven’t select. I you can sel the values. On u back to the p
list of init(SID).o t the time of start
Oracle 9i Database
Figure 32: A
e Administration in
A close-up of figu
10 Minutes
ure 31.
Step 13:
If you click t pane you will with their loc
Figure 33: Each window you ca be
the Control file l see all the mu ation. Once do
h Oracle database an set-up your con e on different driv
e item on the multiplexed con one click the ‘O
e requires one Con ntrol file location ves for greater fau
left pane, on t ntrol files name
Options’ tab.
ntrol file and thro n(s). Mirror copies
ult tolerance.
the right es along
ough this s should
Step 14:
The options t log groups an database cou
‘Datafiles’ ite
Figure 34: Se
Figure 35: Clic
Oracle 9i Database
tab defines the nd log membe uld ever possi em on the right
et the maximum n
cking ‘Datafiles’ w
e Administration in
e maximum lim ers in each red
iblely has. O t pane.
number of datafil
will change the ri
10 Minutes
mit on data fil do log group t Once done the
es, redo log group
ght pane view to
Step 15:
Once you clic will show al along with the
Figure 36: Clic view to show a
ck the ‘Data f ll the data file
eir location in
cking ‘1’ under Re all the member of log group should
files’ in the rig es your datab
the system.
edo Log Groups w f that particular re d have at least one
ght pane, the le base is compri
will change the ri edo log group. Ea e member.
eft pane ised off
ght pane ach redo
Step 16:
Click the red will change. W of each other location whe information a viewing the
‘Next’.
Figure 37: Eith
Oracle 9i Database
o log group ‘1 Within a Redo r. You can ad ere you want about redo log
information r
her you can chang or go what is d
e Administration in
1’ and informa o Log Group a dd more memb
to place the g group 2 and regarding redo
ge the default file default using this w
10 Minutes
ation in the rig all members ar
bers and speci em. Click ‘2’
similarly for 3 o log group 3
Step 17:
Configuration clone databa based on the just save the both. Once d window. done click ‘Fi
can also save the clone dat
entered in DB ent. You can n settings you settings as a te inish’ button
settings for your abase developme
BCA can be sa create the D provided or y emplate or you
and it take yo
r database in a tem ent.
mplate for
Step 18:
One should SYSTEM ac locked. After you will be b database crea
Figure 39: It’s c
Oracle 9i Database
change the counts. Make r changing the back on the pr ation process w
s better to change clicking the <Pass
e Administration in
standard pass sure that SC e password, c revious screen will start.
e all the default pa sword Manageme
10 Minutes
sword for SY COTT account click ‘Ok’ but
. Click ‘Exit’
asswords at this p ent> button.
YS and t is not
ton and and the
point by
Figure 40: Cha
checkange the passwor
mark in the correrd and make sure
esponding “Lock the account is not Account?” field.t have a
Oracle 9i Database Administration in 10 Minutes
Step 19:
Once you see the message, database has been created successfully. Open up OEM (Oracle Enterprise Manager) as shown in the figure below.
Figure 41: Use Oracle Enterprise Manager (OEM) to test connection to your recently developed database. OEM is located under <Start>, <All
Programs>, <Oracle> folder.
Figure 42: A close-up of the figure 41.
Once you c window will standalone or Server. Oracl we haven’t
‘standalone’.
Fig
The next pop OEM. From running all o one database
click ‘Enterpr popup asking r you want to le Managemen installed it s Click Ok.
gure 43: Select th
pped up windo here you can over the world
i.e. TEST.
rise Manager you whether y o login to the nt Server is an so we will b
he ‘Launch standa
w will be the n control all th d. Right now i
Console’, fo you want to ru Oracle Mana n add-on prod be running O
alone’ option.
main control p he databases t’s showing y
ollowing
Figure 44: Th
Oracle 9i Database
he ‘TEST’ databa OEM (Oracl
database that w TEST item in g you for cr need to specify om ‘Connect a
e Administration in
ase will be visible le Enterprise Man
we have devel the tree, the fo edentials i.e.
y the login and as’ drop down
10 Minutes
e in the tree hierar nager).
loped using DB following wind
login and pa d password jus
option box an
rchy of
Now you would be able to expand the tree under TEST database. If you click ‘Tablespaces’ under ‘Storage’ item, you would be able to see the list of all the tablespaces and corresponding data files that DBCA has developed for you. Let me give you a closer look to this window in the following picture. We will learn in depth about OEM and other good stuff later in this book.
Figure 46: Expand the “Tablespaces” item in the tree to see the list of tablespaces within TEST database.
Oracle 9i Database Administration in 10 Minutes