Re: Initializing an Oracle database - URGENT

Gerard Benenyan wrote:
>
> I realize that this may be a dumb question but here it goes:
>
> please respond to: kchildre_at_uccs.jpl.nasa.gov
>
> How does one initialize or create a brand new database in Oracle?
>
> Any help as to how to do this or pointer to the right
> documentation will be greatly appreciated.
>
> Gerard B.
Documentation Needed:

	Oracle7 Server Administrators Guide
		(Dark Green Stripe, bundled with all the other generic, cross platform manuals)
	Oracle7 for [YourOS] Installation Manual
		(Purple Stripe, probably bundled with the Oracle Installation Media)

I assume you've already done 1&2, but just incase: 1) Find the Oracle Installation Manual that came with the license you bought. This will have pre & post installation steps you have to run. These steps vary from platform to platform, so I can't tell you what you have to do. You probably also want to check out chapter #2 in the Oracle Administrator's Guide

2) Install the Oracle Executable, Required Support Files, SQL*Net, etc. using the Oracle Installer program. Usually you can install a starter database at this step.

Then-
3) Go into SQL*DBA, and CONNECT INTERNAL then STARTUP. If this works then the starter database was installed. Otherwise, exit SQL*DBA and you'll have to continue on.

4) create/edit parameter files - again check you manuals for details for your platform.

5) Check that your oracle instance parameter is pointing to the database instance you want to create. This is the environment variable ORACLE_SID on unix platforms, but again RTOM (O=Oracle).

• 6) Execute the CREATE DATABASE command. Example: CREATE DATABASE testdb LOGFILE GROUP 1 ('/device1/oracle/logfile1A.dat', '/device2/oracle/logfile1B.dat') SIZE 500K, GROUP 2 ('/device1/oracle/logfile2A.dat', '/device2/oracle/logfile2B.dat') SIZE 500K DATAFILE '/device3/oracle/system1.dat' SIZE 100M; This will create a database with 2 users (SYS/CHANGE_ON_INSTALL and SYSTEM/MANAGER (make sure you change these passwords)). It will have a single tablespace SYSTEM (that is 100M in size) there will be a single rollback segment (also called SYSTEM). You will have create other rollback segments and should create other tablespaces before you do anything meaniningful. (Again RTOM)

The Installation Manual(s) are really key, especially if it's your first time installing Oracle.

Or you skip all of that and:
1) Call an Oracle consultant :-)
2) Give them lots of money $-)

-- 
-------------------------------------------------
Ken Johnson -  Technical Consultant
Tapestry Computing, Inc. http://www.tapestry.com

p.s. You don't look anything like Ron Silver, right? ...right?!?
p.p.s. (Sorry "Arrival" has me a little paranoid)