Re: problem creating a database.

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sat, 19 Aug 2000 14:36:06 +0200
Message-ID: <nhvsps8fbnlh6elemqnbhemccaal8mtj80@4ax.com>

On Sat, 19 Aug 2000 10:33:08 GMT, "Cesar" <> wrote:

>Hello,
>i try to create a database and i find the next problem when i connect with
>sqlplus
>
>[oracle_at_goku oracle]$ sqlplus system/manager

>[snip]

>how can i resolve it?
>
>thanks to all
>Cesar Bravo
>
>--

You must :
set ORACLE_SID
create an initial INIT<SID>.ora in $ORACLE_HOME/dbs using the template one, changing at least the db_name parameter and the control_files parameter
start *svrmgrl*
connect internal
startup nomount pfile=<file just created> create database .... etc.
@?/rdbms/admin/catalog.sql
@?/rdbms/admin/catproc.sql

These issue are all well documented in the getting started manual. If you don't have docs refer to http://technet.oracle.com

Hth,

Sybrand Bakker, Oracle DBA Received on Sat Aug 19 2000 - 07:36:06 CDT