Re: Problems creating databases in 9i

Robert Vabo wrote:
>
> 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

The 'internal' user is gone. Use SYS/change_on_install AS SYSDBA.

-- 
Ron Reidy
Oracle DBA
Reidy Consulting, L.L.C.