Re: creating second db

vissuyk_at_yahoo.com (Vissu) wrote in message news:<2bedd6a7.0209030950.1d551f86_at_posting.google.com>...
> Hi,
>
> I have installed Oracle 92 on my our production machine. It is up and
> running. I want to create another database on the same machine. I want
> to create the database manually. Should I bring down the primary
> instance (the first instance) before issuing the create database
> command ?.
>
> I am assuming that it is as simple as shutting down the db, bring up
> SQLPLUS and issues create database command. Is there anything I am
> missing or watch out for?
>
> Thanks a million for your help
>
> Vissu

You do not need to shutdown your existing instance. If you are running your instance on UNIX. then do the following.

> export ORACLE_SID=newsid
> sqlplus /nolog
> connect / as sysdba

 connected to idle instance.
> startup nomount
> (use your create database scripts as usual)

Hope this helps. Received on Wed Sep 04 2002 - 19:00:29 CEST