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
> >
>
>
>
Received on Fri May 22 1998 - 16:12:39 CDT
