Re: Creating new SID

In article <01bd85c6$2f729860$62e89e26_at_lagisettpc.commos.com>,   "Prashanth" <lagisett_at_commos.com> wrote:
>
> Hi,
> I followed the steps mentioned in the document they provide to create new
> database,
> and ran into a strange problem. When I try to do a startup nomount it says
> that
> cannot start already running oracle!! okay at this poing I tried to do a
> shutdown and it says not logged on!!
> All the environment variables are set correctly!!
> ORACLE_HOME
> ORACLE_SID
> and I've even tried setting the NLS_LANG
> any help in this matter is welcome
> Regards,
> Prashanth.
>
> Venkat <vreddy_at_no_spamix.netcom.com> wrote in article
> <6k467l$5ne_at_sjx-ixn8.ix.netcom.com>...
> > Follow these steps
> > 1. Make a copy of the current initSID.ora file and rename it with the new
> > SID. Make appropriate changes (db_name, control_files, trace file
> locations
> > etc) to reflect the new SID
> > 2. SET ORACLE_SID=newSID
> > 3. STARTUP NOMOUNT pfile=full path to new initSID file
> > 4. Run create database script. A sample script can be found in one of
> the
> > directories in $ORACLE_HOME.
> >
> > Be sure that you have set the new SID (SET ORACLE_SID) before running the
> > create database script. Otherwise it will mess up/overwrite your current
> > database. Read the manuals before you venture into this. If you have
> > access to Oracle support call and ask them to fax the paper 'creating a
> > second database on UNIX'. You can also get it from
> > http://support.oracle.com/metalink if you have access to it.
> >
> > HTH
> > Venkat
> >
> > >We had already installed oracle 8.0.4 on our solaris box with the
> > >sid=ora1 and we decided to make ora1 as our test database and create new
> > >sid for our actual production database, is it possible to have two sid
> > >on same server ,if so what is required to be done..., i mean do i have
> > >to install whole oracle again in new oracle home and oracle base with
> > >new sid... or can i use the same oracle home and if i use same oracle
> > >home will it delete any tables from old sid(ora1).....
> > >any comments or help in this matter welcome...
> > >thank you all...
> > >Jayesh Thakker
> > >jthakker_at_nortel.com
> > >
> >
> >
> >
>

Prashanth:

Whenever I have problems in creating the database, first thing I would do is to execute the command "SHUTDOWN ABORT" by connecting to the database as 'INTERNAL".
Then I would remove all the database files which the CREATE DATABASE command created.

This way I am leaving no trace of the previous CREATE DATABASE command and I will be ready for next CREATE DATABASE command.

To be precise, "not logged on!!" message you got is due to the fact that the CREATE DATABASE command SQL script might have diconnected you from the database. Connect again to the database as INTERNAL and execute the SHUTDOWN ABORT command. This will shutdown the already running instance.

Analyze why your CREATE DATABASE command failed, then remove the files which are created by the CREATE DATABASE command SQL script(Only if you are using the File System files and not raw files). You will do okay.

Hope it helps.

Regards

Ajay Reddy

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Fri May 22 1998 - 22:16:00 CDT