Re: Personal Oracle7.3.2.1.1 has password on INTERNAL account.

You don't connect to internal through SQL*Plus. Do it through Server Manager, and no password is needed. It's protection is operating system based.

Johnny Verhoeven <Johnny.Verhoeven_at_ping.be> wrote in article <33A0BF9A.3F94_at_ping.be>...
> CATPROC must be run under SYS not SYSTEM. Normaly the installer does it
> for you.
>
> Johnny Verhoeven
> Technic And Technology
>
> Richard_Popovich_at_Whittman-Hart.com wrote:
> >
> > I recently installed Personal Oracle7.3.2.1.1 on Win95, along with
> > DES1.3.2.2. I wanted to run the CATPROC.SQL script from SQLPLUS. I
> > logged on as SYSTEM; however, the script generated erros stating that
> > user SYSTEM had INSUFFICIENT privelages!!
> >
> > I then read through the BUILDALL.SQL script and noticed that the script
> > logged on as INTERNAL, this script calls CATPROC.SQL. However, this
> > script bombs because it prompts the user for the password on the
 special
> > user INTERNAL. I did not place a password on this account, the default
> > database came with the restriction on user INTERNAL.
> >
> > Note that from svrmgr> You do not need a password when CONNECTING as
> > INTERNAL. from SQLPLUS> You DO need to enter a password for user
> > INTERNAL.
> >
> > Thanks in adnvance,
> >
> > Richard Popovich
> >
> > -------------------==== Posted via Deja News

 ====-----------------------


> >       http://www.dejanews.com/     Search, Read, Post to Usenet