Re: Scripted 8.1.5 DB creation on WinNT 4.0

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