Re: Help a newbie....

From: Ian Cary <cary_at_gatwick.geco-prakla.slb.com>
Date: 1997/12/05
Message-ID: <34881600.1ECCC74F@gatwick.geco-prakla.slb.com>#1/1

Sam Chepkevich wrote:

> I just installed Oracle Server 7.3.2.1 for solaris and am trying to get
> started. Please don't say RTFM, because I have none.

Firstly you need to set ORACLE_HOME and ORACLE_SID e.g.

export ORACLE_HOME = <full path of top level Oracle software directory> export ORACLE_SID = <your instance name>

and also

export PATH=$PATH:$ORACLE_HOME/bin
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib

Your posting indicates that you have an init.ora file and normally I would never suggest using Oracle's default one as the parameters are sooo poor, however if you are unsure of the contents of your's it may be best to use ora
cle's for the time being. Either way I would suggest the file is renamed to $ORACLE_HOME/dbs/init$ORACLE_SID.ora
Also the entry for db_name should = $ORACLE_SID (the real value rather than the environment variable) and the control_files entry should point to at least two real files (only the owning directory need exist as the files will be created along with the database)

You should now be able to do the following from svrmgrl;

connect internal;
startup nomount;

create database datafile '........'
            logfile group 1 ('.......','........') size nM,
            logfile group 2 ('.......','........') size nM

maxdatfiles 255
maxlogfiles 16;

Then you will need to run;

@?/rdbms/admin/catalog.sql
@?/rdbms/admin/catproc.sql

and

connect system/manager

@?/rdbms/admin/catdbsyn.sql
@?/sqlplus/admin/pupbld.sql

You will probably then have to create additional tablespaces and rollback segments but hopefully your books should tell you how to do that and this should be enough to get you going.

Good Luck,

Ian Received on Fri Dec 05 1997 - 00:00:00 CST