Re: Help! I don't have an internal user

From: Alex Hudghton <alex_at_alenda.freeserve.co.uk>
Date: Wed, 15 Sep 1999 09:26:43 +0100
Message-ID: <7rnl86$emt$1@taliesin.netcom.net.uk>

Dom <edwardsd7650_at_my-deja.com> wrote in message news:7rm9ke$1vb$1_at_nnrp1.deja.com...
> On our system (NT 4, Oracle 8), we have two databases - a Live and a
> Test. However when I re-create the Test database using scripts
> provided by the product supplier, I don't seem to have an internal user
> when then scripts are finished.
>
> The scripts themselves use the internal user (with the password of
> oracle), but when I try to log on as internal when the scripts have
> finished I get the an oracle logon error (as if it is the wrong
> username or password, which it is not).
>
> I'm not sure if this is related, but if the database is subsequently
> shutdown (by restarting NT - with no internal user I can't use svrmgr
> to do a shutdown commmand), it will not restart, and it doesn't give
> any reason for this in the alert log.
>
> Any help would be appreciated

Use 'connect / as sysdba'

Alex Received on Wed Sep 15 1999 - 03:26:43 CDT