1830132 Members
2416 Online
109998 Solutions
New Discussion

SQL*Plus Error

 
xiandao
Occasional Advisor

SQL*Plus Error

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!
4 REPLIES 4
twang
Honored Contributor

Re: SQL*Plus Error

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.
twang
Honored Contributor

Re: SQL*Plus Error

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;
xiandao
Occasional Advisor

Re: SQL*Plus Error

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?
twang
Honored Contributor

Re: SQL*Plus Error

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.