Re: Warning when logging on Oracle on Windows NT

Vikram Goel wrote:
>
> From: hts_at_sasdata.no (Haakon T. Soenderland)
> Newsgroups: comp.databases.oracle
> Subject: Warning when logging on Oracle on Windows NT
> Date: 2 Nov 1995 12:35:30 GMT
> Organization: Scandinavian Airlines Data Norge A/S
> Mime-Version: 1.0
> Message-ID: <47adui$kt9_at_news.dax.net>
>
> Hi all,
>
> I'm getting this annoying warning when logging on to our
> Oracle DB on Windows NT:
>
> Warning: Product user profile information not loaded!
> Error in disabling roles in product user profile.
>
> Connected to:
> Oracle7 Server Release 7.1.3.3.6 - Production Release
> With the distributed option
> PL/SQL Release 2.1.3.2.1 - Production
>
> Anyone know what could be the cause? (and how to get rid of it!)
>
> BTW, we are using SQL*Net V2.
>
> Thanks,
> Haakon
>
> --
> hts_at_sasdata.no | htsoend_at_ibm.net | Haakon T. Soenderland
> Scandinavian Airlines Data Norway A/S
> ---
> "40 skiver og et herpa anlegg, en leilighet som trenger aa spyles. Ingen
> venner og ingen penger, alt jeg har er mine klamme hender.." Jokke '94
> ------------------------------------------------------------------------
> Windows 95: A another first from Microsoft!
> The first OS to be obsolete *before* it was released.

Haakon,
Search for a file by the name pupbld.sql under your $ORACLE_HOME ( or ORAWIN ) directory. Run this script - i think under SYSTEM schema.

-- 
Cheers

Sridhar Subramaniam
Avion Consulting Services
Sydney - Australia
Email : ssubrama_at_nibucorp.ccdn.otc.com.au / avion_at_ozemail.com.au

Disclaimer : All opinions are truly and just mine.