Xref: alice comp.databases.oracle.server:39647
Path: alice!news-feed.fnsi.net!netnews.com!howland.erols.net!newsfeed.cwix.com!208.166.96.61!AUTOCONNECT.Cox.com
Newsgroups: comp.databases.oracle.server
From: "Rodgers, Tony (CEI-Atlanta)" <Tony.Rodgers@cox.com>
Subject: PRODUCT_USER_PROFILE
Message-ID: <529B47EE34C4D1118D0800A0C99ABC9830A6EE@EATL0S04>
Sender: "Rodgers, Tony (CEI-Atlanta)" <Tony.Rodgers@cox.com>
Date: Tue, 2 Feb 1999 11:10:17 -0500 
Lines: 22
X-Newsreader: Microsoft (R) Exchange Internet News Service Version 5.5.1960.3
References: <36B7091D.41C67EA6@ornl.gov>

When you created the database, did you run catproc.sql ?  This catalogs
standard procedures into your database and includes the package on which
you are getting the error message (dbms_application_info).



> -----Original Message-----
> From:	D S Tharpe [SMTP:i5t@ornl.gov]
> Posted At:	Tuesday, February 02, 1999 9:18 AM
> Posted To:	comp.databases.oracle.server
> Conversation:	PRODUCT_USER_PROFILE
> Subject:	PRODUCT_USER_PROFILE
> 
> Anyone,
> 
> The following error prompted me to run the pupbld.sql. I ran the 
> script, but am still getting this same error. Any clues? 
>   
> TIA, 
>   
> D. THARPE  
> 
> 
>     
> Enter user-name: i5t@central_oreis 
>  Enter password: ****** 
>  ERROR: 
>  ORA-03113: end-of-file on communication channel 
>   
>   
>  Error accessing PRODUCT_USER_PROFILE 
>  Warning:  Product user profile information not loaded! 
>  You may need to run PUPBLD.SQL as SYSTEM 
>  Error accessing package DBMS_APPLICATION_INFO 
>  ERROR: 
>  ORA-03114: not connected to ORACLE 
>   
>   
>  Error accessing package DBMS_APPLICATION_INFO 
>  You may need to install the Oracle Procedural option 
>  SET APPINFO requires Oracle Server Release 7.2 or later 
>  Use of Oracle SQL feature not in SQL92 Entry Level.

