Re: Create new database

This happened to me. Make sure you have log_archive_start set to false in the init.ora file. Also make sure you are not using using CONTROLFILE REUSE in your CREATE DATABASE sql, unless you know about what it does. Also if you haven't done so, change the names from ctl1orcl.ora ctl2orcl.ora to ctlNEWSID.ora and ctlNEWSID.ora. in the init.ora file.

You may not have to do this, but I ended up having to delete my home Oracle directory and re-install. Better now than in production!

Jackie Marino

Graham Potts wrote:
>
> Hi,
> I'm trying to create a small test database - Oracle 7.3.2 on Solaris
> 2.5 - to be used as a simple test db. I've copied the init.ora file
> for my production database to create a new one for the test db,
> changed ORACLE_SID for my session and simply issued a CREATE DATABASE
> statement while connected internal in svrmgr and after a STARTUP
> NOMOUNT.
>
> This creates all of the .dbf files and then gives me ORA error 603 -
> Oracle server session rerminated by fatal error.
>
> At this point the only file that appears to be missing is the orapw
> file for the instance.
>
> Any idea what error I may be getting here and how to fix it?
>
> Thanks,
> Graham Potts
Received on Mon Feb 02 1998 - 00:00:00 CST