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

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
Received on Thu Jun 12 1997 - 00:00:00 CDT