Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Problems creating databases in 9i

Problems creating databases in 9i

From: Robert Vabo <robert_vabo_at_hotmail.com>
Date: Wed, 28 Nov 2001 08:32:47 GMT
Message-ID: <Pi1N7.13286$pK1.367206@juliett.dax.net>


I have made a script that creates some databases that works fine in Oracle 7 and 8 but there are some new features in 9. The svrmgrl is substituted with sqlPlus. I get an error when I run my script. It is like this :

SET ORACLE_SID=EPH
Oradim -new -sid EPH -intpwd mypwd -startmode auto -pfile c:\EphOra\eph_db\initeph.ora
Oradim -startup -sid EPH -starttype srvc,inst -usrpwd mypwd -pfile c:\EphOra\eph_db\initeph.ora
sqlplus @ephrun.sql

the ephrun.sql file is like this:
spool c:\EphOra\eph_db\spoolEPHRun.log
set echo on
connect INTERNAL/mypwd
startup nomount pfile=c:\EphOra\eph_db\initEPH.ora CREATE DATABASE Ephorte
LOGFILE 'c:\EphOra\eph_db\log1EPH.log' SIZE 5M,

    'c:\EphOra\eph_db\log2EPH.log' SIZE 5M MAXLOGFILES 32
MAXLOGMEMBERS 2
MAXLOGHISTORY 1
DATAFILE 'c:\EphOra\eph_db\Sys1EPH.dbf' SIZE 50M MAXDATAFILES 254
MAXINSTANCES 1
CHARACTER SET WE8ISO8859P1
NATIONAL CHARACTER SET WE8ISO8859P1;
spool off

The error occured when I try to connect INTERNAL/mypwd.

Any help is good help !

--
Regards
Robert Vabo
http://www.gecko.no/
Please reply to group not by mail
Received on Wed Nov 28 2001 - 02:32:47 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US