Re: Scripted 8.1.5 DB creation on WinNT 4.0

Hi

Have fixed the problem, caused by uncommenting the private rollback segments in the init.ora and not creating them!! duh!!

The wizard worked correctly as well

Thanks for your help on this one
Mark

Mark Gornicki <mark_at_gornicki.freeserve.co.uk> wrote in message news:8e20d3$gsm$1_at_news8.svr.pol.co.uk...
> Hi
> the scripts did indeed generate my second database BUT it will not open
> properly on restart due to conflicting with my first database (it appears
> both the pfile and the pwdfile)?
>
> pfile i can get around by manually doing the startup and specifying its
 name
> and location (after running SET INSTANCE) but ideally i want to do this
> automatically. The pwd file i have no idea yet!!
>
> I am going to try for a third small database done completely by the wizard
> to see what happens.
>
> Any ideas gratefully received
>
> Who says NT is easy
>
> btw does anyone know where any NT specific info is (apart from release
> notes)
>
> Cheers
> Mark
> Mark Gornicki <mark_at_gornicki.freeserve.co.uk> wrote in message
> news:8e00fi$e6r$1_at_news8.svr.pol.co.uk...
> > Hi Sybrand
> >
> > Thanks for responding so fast, yes that does clear it when i rename the
 sid
> > directory.
> >
> > The wizard gives the option of creating a batch file instead of creating
 the
> > database immediately.
> >
> > It uses SET ORACLE_SID=xxxx
> >
> > and uses ORADIM to set some stuff (will have to look this up) (?assume
> > this is NT only?)
> > then executes the scripts to start/nomount and create database + options
> >
> > I hope this info helps anyone else trying to do the same as me.
> >
> > Now i really do wish for Unix again!!
> >
> > Cheers
> > Mark
> > Sybrand Bakker <postbus_at_sybrandb.demon.nl> wrote in message
> > news:956523031.26172.0.pluto.d4ee154e_at_news.demon.nl...
> > >
> > > Mark Gornicki <mark_at_gornicki.freeserve.co.uk> schreef in berichtnieuws
> > > 8dv8ov$gif$1_at_news6.svr.pol.co.uk...
> > > > Hi
> > > > i would like to script the database creation on NT and not use the
 Wizard.
> > > > I took most of my pointers from the build_all.sql script in
 .../rdbms/admin.
> > > >
> > > > I created the directory structures required and created my init.ora
 file
> > > >
> > > > i had one failed attempt which now seems to have blocked the
 database
 name
 i
> > > > wanted to use (tried to use wizard and specied init.ora file i
 created
 but
> > > > said database name already used).
> > > >
> > > > When i stop the Listener and existing OracleSID services i get a
 ORA-12560
> > > > TNS: protocol adapter error
> > > >
> > > > For info running on Standalone PC using MS loopback adapter (and
 connecting
> > > > ok to existing SID)
> > > >
> > > > Please could someone tell me how to free up my DB name if it is
 blocked?
> > > > Please could someone tell me the correct way to script/run these?
> > > >
> > > > PS this used to be so easy on Unix :-)
> > > >
> > > >
> > >
> > > Can answer the first question only.
> > > The installer check for a directory
> > > %ORACLE_HOME%\admin\%ORACLE_SID%
> > > If this directory exists (with subdirectories) you will get above
 error
> > > message.
> > >
> > > Hth,
> > >
> > > Sybrand Bakker, Oracle DBA
> > >
> > >
> > >
> >
> >
>
>
Received on Mon Apr 24 2000 - 00:00:00 CDT