Help! How to create additional database. Was: Re: ORA-00205: error in

Hello,

I have a database running on our lab's NetWare server (Oracle 7.1.x) and tried to create another one to fulfil some of my interests. The guys who created this database graduated long time ago so there is nobody who could help me get started with Oracle. I've visited www.oracle.com and get some information regarding how to create a database, but unfortunately oracle guys address only the issue of creating new database (not adding another one to already created). Anyway I've done all the things they said, i.e.

1.Modified init.ora file (added people database stuff).

db_name = ex
rollback_segments = (r00,r01,r02,r03,r04) db_files = 20
control_files = VOL1:ORANW\DATABASE\ctl01ex.ora

open_cursors=150
< ... snip ....>

############################################################################### 

#
#	PEOPLE DATABASE

############################################################################### 

db_name = people
db_files = 20
control_files = VOL1:ORANW\DATABASE\ctl_ppl.ora < ... snip ....>

2. Created trivial sql script

CREATE DATABASE people

3.Started sqldba, connected as internal, started up oracle with nomount option, executed my sql script, shutdowned oracle.

Like they say by doing these steps I should create a database, but bang when I try to startup I've got
ORA-00205: error in identifying control file 'VOL1:ORANW\DATABASE\ctl_ppl.ora'
ORA-09202: sfifi: error indentifying file ....

and oracle is right. There is no cttl_ppl.ora file.

What did I do wrong? How could I actually create additional database?

Please email any advise to zander_at_cnext.crec.mipt.ru for I don't read this group often and it's heavily overloaded.

Thanks in advance.
Aleksey.

In article <4cs6kc$i2g_at_inet-nntp-gw-1.us.oracle.com>, you wrote:
> Hi Carroll,
>
> If the message you have provided is verbatim, try changing
your> INIT.ORA parameter control_files from %RDBMS70-CONTROL%\CTL.ORA to a> fully qualified file name i.e. locate CTL.ORA then set
>
> control_files = '<directory>\CTL.ORA'
>
> The error reports RDBMS70-CONTROL. On almost all ports we use
 '_' for
> such paramters. The error shows '-'?
>
> If you don't want to hardcode the file path in the init.ora :
> (1) check the value of RDBMS70_CONTROL setting in your
ORACLE.INI> (typically in the WINDOWS dir). The value of this parameter typically is
> the RDBMS70 subdir of ORACLE_HOME.
>
> (2) Check if you have a file called CTL.ORA in the directory
 pointed to
> by RDBMS70_CONTROL.
>
> (3) Alter the control_files entry in the INIT.ORA to
> '%RDBMS70_CONTROL%\CTL.ORA'
>

Aleksey Sudakov
1A-1 Kerchenskaya Street
Moscow 113303,Russia.

Home:	+7(095)121-6100 + 3-45, +7(095)121-0561 + 3-45
EMail:	zander_at_cnext.crec.mipt.ru	(NeXTMail & MIME are OK)
WWW:	http://www.crec.mipt.ru/~zander/