Re: Help SQLPlus

From: Roderick Manalac <rmanalac_at_us.oracle.com>
Date: 1995/05/27
Message-ID: <3q5vto$bdo_at_inet-nntp-gw-1.us.oracle.com>#1/1


bhash_at_mlrohp1.atsc.allied.com (Bhashyam Nallappa) writes:
|> I have a problem with SQLPLUS on a HP-UX platform. When I type sqlplus from
|> the command line. I get the following error message
|>
|> "Message 231 not found; No message file for product=SQLPlus, facility=SP2
|> Message 428 not found"
|>
|> And Oracle does not allow me to log into the database.
|> But from the login account named oracle, I am able to run
|> sqlplus fine.
|>
|> Further even if I type the command sqlplus username/password,
|> I get the same message.
|> I have tried everything from setting the .cshrc correctly to
|> include $ORACLE_HOME to adding an entry to the product_user_profile
|> table.

If $ORACLE_HOME is indeed set correctly, and the error still occurs, make sure the user has read privilege on the $ORACLE_HOME/sqlplus/mesg/ sp2us.msg and sp2us.msb files. This will probably also mean making sure execute permissions are enabled for all directories from / down to the messages directory.

Hope this helps.

Roderick Manalac
Oracle Corporation
Insert favorite disclaimer here. Received on Sat May 27 1995 - 00:00:00 CEST

Original text of this message