Re: problem in creating database

[Quoted] 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 Wed Dec 20 2000 - 13:09:43 CET