Re: Create database statement on NT : Possible ???

Start a DOS session, go to the \ORANT\BIN directory and run:

oradim72 -new -sid ARPE -intpwd internal_password -startmode auto -pfile c:\orant\database\initarpe.ora

Once this has been executed, run oradin73 - return this will start the GUI instance manager and your new service and instance should indicate services started and instance stopped. At this point you can connect to the idle instance as internal and issue: startup nomount pfile=path\initarpe.ora
When the instance is started call the create database script. @path\script.sql from the sqldba72 prompt. You will also need to add the new SID to the listener.ora file so the listener will listen for remote calls to the server for the new database.

Good Luck.

Matthew Arrocha
marrocha_at_bellsouth.net

Steve Phelan <stevep_at_toneline.demon.co.uk> wrote in article <876923052.2454.0.nnrp-05.c2de712e_at_news.demon.co.uk>...
> I don't think you really have any choice. You have to use IM to create
 the
> instance on NT, as each instance runs under a separate set of services,
> AFAIK.
>
> ARPEGE wrote in message <34439B49.2A03_at_imaginet.fr>...
> >We have developped a script that works perfectly well and does the
> >following :
> >
> > Create database
> > Create tablespaces
> > Create rollback segs
> > Create users
> >
> >But we can't get it to run on NT (Oracle 7.2) because after positionning
> >the ORACLE_SID to ARPE, we have the following error when trying to enter
> >SQLDBA
> >
> > DBA-00314 unable to attach to default host
> > ORA-09352 windows 2 task driver unable to spawn new task
> >
> >We don't want to go through the Instance Manager stuff because our
> >script
> >does a lot more than that and we would like to have a unique script to
> >create an instance on unix or NT...
> >
> >Any idea ??? (Philippe : arpege_at_imaginet.fr )
> >
>
>
>
Received on Tue Oct 28 1997 - 00:00:00 CST