Re: Oracle Error and general slow running

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Thu, 09 Dec 1999 17:49:07 +0800
Message-ID: <384F7B13.2243@yahoo.com>

Ross Macadam wrote:
>
> Sorry I should have elaborated - the message is shown when we start
> SQLplus...
> "Ross Macadam" <ross_at_iicon.co.uk> wrote in message
> news:82mfmj$bdu$1_at_infoserv.netkonect.net...
> > Hi,
> > we've just installed oracle 7.3.4. on Open server 5.0.5 and set up
> Developer
> > 2000.
> > During the first pass through we received an error on installing Oracle
> > server 7.3.4 but on re-try it seemed to install OK.
> > However we get an error as follows:
> >
> > ORA-00900: invalid SQL statement
> >
> > Error accessing package DBMS_APPLICATION_INFO
> > youmay need to install the Oracle Procedural Option
> > SET APPINFO requires Oracle server release 7.2 or later
> >
> > The system also does not seem to be responsive - import of a 14Mb .dmp
> file
> > claims to be being processed but at last count had run for 3.5 hours now!!
> >
> > Is this normal behaviour and are there any routine tests we can do to test
> > system operation??
> >
> > Any help gratefully received!
> >
> > Regards Ross
> >
> >

Ensure the $ORACLE_HOME/rdbms/admin/catproc.sql (as SYS) and $ORACLE_HOME/sqlplus/admin/pupbld.sql (as SYSTEM) have been run

--

---

Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Thu Dec 09 1999 - 03:49:07 CST