real
brief, real quick. this is just to get an example of how to get a system
up and running, it doesn't take into consideration security, role, licensing,
etc.
<SPAN
class=911181116-15032001>
<SPAN
class=911181116-15032001>general considerations:
<SPAN
class=911181116-15032001>
<SPAN
class=911181116-15032001>computing and processing power. oracle
minimum/general requirements a Pentium 300, 3G of hard drive space and +256M
RAM; of course they list various levels of processors, storage, and memory
dependant upon your requirements and needs. Many components are available
but there are licensing considerations as well as usage considerations.
Oracle is very complex, i can't stress that enough. sizing, tuning,
management, and associated tasks/components will need a lot of
consideration.
<SPAN
class=911181116-15032001>
To
setup 8.1.7 personal edition:
<SPAN
class=911181116-15032001>
launch
the setup.exe which will load the universal installer, a nifty interface for
adding, removing oracle components. based on needs and resources you'll
choose the type of installation reading applicable prompts and using help where
required. once it's complete you'll want to modify some of the
built-in/internal system credentials and users; the ones that jump out at me
are: system, sysman, sys, internal. you'll want to change these from the
default as well as adding applicable roles and authorities such as: connect,
dba, sysdba, *_administrator, etc. make consideration for
authentication/security, an oracle maintained password, externally auth'ed by
O/S, globally via directory service. in general lock it down appropriately
for your environment and it's role.
<SPAN
class=911181116-15032001>
<SPAN
class=911181116-15032001>important tools/utilities
oracle
enterprise manager: management interface, jobs, alerts, servers and
resources
dba
studio: management of databases, tables, security, storage
net8:
configuration and management of naming and client
connections
<SPAN
class=911181116-15032001>
now
it's pretty much ready for use, db design and development are another
story.
<SPAN
class=911181116-15032001>
<SPAN
class=911181116-15032001>
<SPAN
class=911181116-15032001>
<SPAN
class=911181116-15032001>
===========================================Lerone
StreeterSystem AnalystAbbott
LBGStreeLA2_at_hpd.abbott.com===========================================
Received on Thu Mar 15 2001 - 13:26:27 CST
