RE: Error starting sqlplus

From: Mercadante, Thomas F $LABOR$ <Thomas.Mercadante_at_labor.state.ny.us>
Date: Mon, 14 May 2007 10:40:49 -0400
Message-ID: <ABB9D76E187C5146AB5683F5A07336FFE08DDA@EXCNYSM0A1AJ.nysemail.nyenet>

John,

When you type "env" on the $ prompt, do you see the Oracle environmental's defined?

Secondly, try "cd'ing" to the $ORACLE_HOME/bin directory and running Sqlplus right from there and see what you get.

This either an environmental problem, or you do not have permission to read the Oracle directories.

Tom

This transmission may contain confidential, proprietary, or privileged information which is intended solely for use by the individual or entity to whom it is addressed. If you are not the intended recipient, you are hereby notified that any disclosure, dissemination, copying or distribution of this transmission or its attachments is strictly prohibited. In addition, unauthorized access to this transmission may violate federal or State law, including the Electronic Communications Privacy Act of 1985. If you have received this transmission in error, please notify the sender immediately by return e-mail and delete the transmission and its attachments.

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of John Dunn Sent: Monday, May 14, 2007 9:13 AM
To: oracle-l
Subject: Error starting sqlplus

Have just installed Oracle 10.2 on AIX 5. When I run sqlplus as oracle it runs OK. When I run it as another user I get the message below

I thought the environment variables were not set, but .profiles are identical in terms of Oracle values

Any ideas?

Error 6 initializing SQL*Plus

Message file sp1<lang>.msb not found

SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory

John

--
http://www.freelists.org/webpage/oracle-l

Received on Mon May 14 2007 - 09:40:49 CDT