Re: problem in creating database

From: lkw <lkw_at_axiomatique.com>
Date: Thu, 21 Dec 2000 10:27:58 +0800
Message-ID: <91rpud$ujv$1_at_violet.singnet.com.sg>


yes, i did. so what could be the reason then?

Dennis <dwehlman_at_my-deja.com> wrote in message news:91q7i5$q43$1_at_nnrp1.deja.com...
> Have you set $ORACLE_SID before running your statement?
>
> Dennis
>
>
> In article <91ptke$pq9$1_at_violet.singnet.com.sg>,
> "lkw" <lkw_at_axiomatique.com> wrote:
> > hi all,
> >
> > when i try to create another database, i encounter error below. what
 could
> > be the reason?
> >
> > SVRMGR> _at_/appln/oracle/product/8.1.5/makedb.sql
> > Connected.
> > ORA-27146: post/wait initialization failed
> > create database TEST
> > *
> > ORA-03114: not connected to ORACLE
> >
> > below is my makedb.sql file.
> >
> > >connect internal
> > >startup nomount pfile=/appln/oracle/product/8.1.5/dbs/initTEST.ora
> > >create database TEST
> > > maxinstances 12
> > > maxlogfiles 32
> > > maxdatafiles 1022
> > > character set "US7ASCII"
> > > datafile
> > > '/appln/oracle/oradata/TEST/SYSTEM_01.DBF' size 50M
> > > logfile
> > > '/appln/oracle/oradata/TEST/RLOG_01.DBF' size 10M,
> > > '/appln/oracle/oradata/TEST/RLOG_02.DBF' size 10M;
> >
> > hope that everybody can help me, the problem has with me for more
 than 1
> > day.
> > ....thanks alot.
> >
> > lkw.
> >
> >
>
>
> Sent via Deja.com
> http://www.deja.com/
Received on Thu Dec 21 2000 - 03:27:58 CET

Original text of this message