Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Problems creating databases in 9i
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 mailReceived on Wed Nov 28 2001 - 02:32:47 CST