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

Thanks for the reply, but I just get the error "ORA-01031: insufficient privileges"

In article <7rnl86$emt$1_at_taliesin.netcom.net.uk>,   "Alex Hudghton" <alex_at_alenda.freeserve.co.uk> wrote:
>
> 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
>
>

--
dominic.edwards.remove-to-reply_at_bigfoot.com

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Thu Sep 16 1999 - 07:17:24 CDT