Re: Create database wipes out existing db

Hi Frank,

    For doc - Look for a book named "Oracle7 Workgroup Server for Windows NT - Getting Started" should be contained within the package that came with 7.3. If you find it, chapter 4 has help in using Instance Manager. Otherwise, at a DOS prompt: "ORADIM73 -?". This will give you a list of the parms line mode allows and they are somewhat self-explanatory.

    I've also been testing 7.3 on NT 4, today.     Some of the tools (SVRMGRL being one) don't check for whether a file exists, it simply creates a new version of the file as you specified. The GUI tools seem to be more forgiving in general (probably written within the last 5 years or so). However, I am not completely trusting of them. They will tell you the server is up when it's down, etc with no refresh. The line modes seem to have been written earlier, and therefor check less for (what is now) obvious. Good or bad...
HTH
Greg

Frank Calfo wrote:

> I am testing the create database process on an NT 4.0 test server
> running Enterprise Server 7.3.4
> I am following the Oracle documentation and special bulletin on
> creating a database.
> The steps seem simple enough, but I always seem to destroy the
> existing database when I startup the new one or vice-versa.
> This is not a comforting result.
>
> The Oracle sample database was created as part of the Oracle
> installation and is running fine.
>
> I am trying to deploy our development database onto the test server
> and am using the parameter files and create scripts that successfully
> built that database on our development server.
>
> I have made sure that the parameter file and db create scripts do
> not use the same names as the existing database.
>
> I am careful to set the ORACLE_SID to the new instance value prior
> to running the steps.
>
> After I create the Oracle services via oradim73 I start the database
> via Server Manager, specifically referencing the parameter file
> to use.
>
> The create steps seem to run fine, but when I query the newly
> created database for the expected structure I see the structure
> of the sample database.
>
> I have a feeling that the Oracle start service is not using the
> correct parameter file.
>
> Am I falling into a common problem here?
>
> It seems to easy to wreck an existing database by starting a new
> one with the wrong parameter file. Is there a way to safeguard against
> this?
>
> P.S. where is the documentation on Instance Manager line mode ?
>
> Thanks,
> Frank
Received on Wed Jun 10 1998 - 16:41:52 CDT