topic Re: SQL*Plus Error in Operating System - HP-UX

SQL*Plus Error

xiandao — Mon, 26 Apr 2004 02:01:07 GMT

I'v installed ora7.3.2.2 in hpux 11.00
TNS(lsnrctl) listener started successfully
db started(dbstart) successfully

so I run sqlplus, but a error occured :
---------------------------------------------
ERROR:
ORA-00900: invalid SQL statement

Error accessing package DBMS_APPLICATION_INFO
ERROR:
ORA-00900: invalid SQL statement

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
---------------------------------------------

why this happened?
How to install the Oracle Procedural option?
Pls help!

Re: SQL*Plus Error

twang — Mon, 26 Apr 2004 02:08:02 GMT

Set the COMPATIBLE parameter in init.ora to the version of your Oracle Server. SQL*Plus issues a series of SQL statements in order to configure it's environment on startup. Some of this SQL may be incompatible with different builds of the Oracle server. Then retry the execution.

Re: SQL*Plus Error

twang — Mon, 26 Apr 2004 02:13:11 GMT

In addition, do you add anything on "login.sql" if it exists?
Please verify that the procedural option is installed with the following SQL statement:
select * from v$version;

Re: SQL*Plus Error

xiandao — Mon, 26 Apr 2004 03:56:38 GMT

1.Here is the result I run select * from v$version;
----------------------------------------
Oracle7 Server Release 7.3.2.2.0 - Production Release
Oracle7 Server Release 7.3.2.2.0 - Production Release
CORE Version 3.5.2.0.0 - Production
TNS for HPUX: Version 2.3.2.1.0 - Production
NLSRTL Version 3.2.2.0.0 - Production

2.the value of COMPATIBLE parameter I should write to init.ora is Oracle7 Server Release 7.3.2.2.0, right?

3. I heared need to run :
------------------------------
$sqldba lmode=y
SQLDBA>connect internal
SQLDBA>@catproc.sql
------------------------------
to install Oracle Procedural option

But I cannot find sqldba in $ORACLE_HOME/bin
Something I forget to install?

Re: SQL*Plus Error

twang — Mon, 26 Apr 2004 04:04:05 GMT

If PL/SQL is not installed, get it from the base Oracle Server distribution CD-ROM. Otherwise, you need to re-link Oracle with the procedural option as follows:
% cd $ORACLE_HOME/rdbms/lib
% make -f ins_rdbms.mk procopt ioracle
Subsequently, you should run catalog.sql and catproc.sql as connect internal or as SYS.