Re: Problems creating databases in 9i

Connecting as Internal has been deprecated since Oracle 8.0, and 9i now makes it obsolete.

Every script you possess that uses it must be changed to read 'connect <something> as sysdba'.

The 'something' there will depend on whether you are using password file or operating system authentication. If password file, it will be 'sys/password' (and the password itself will probably be 'oracle' in the first instance) and if O/S, it will just be '/'.

They've been flagging this change for ages. It's finally happened. (And it is quite well documented).

Regards
HJR

--
Resources for Oracle: http://www.hjrdba.com
===============================


"Robert Vabo" <robert_vabo_at_hotmail.com> wrote in message
news:Pi1N7.13286$pK1.367206_at_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

>

>