Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Error starting sqlplus

Re: Error starting sqlplus

From: Jared Still <jkstill_at_gmail.com>
Date: Mon, 14 May 2007 09:26:17 -0700
Message-ID: <bf46380705140926l280221a2ge6ed235515e4bcea@mail.gmail.com>


That makes sense. It seemed like a permissions error.

SUID bit?

On 5/14/07, John Dunn <JDunn_at_sefas.com> wrote:
>
> Thanks for all the replies...the issue was that I needed to apply patch
> 4516865
>
> John
>
>
> ------------------------------
> *From:* Mercadante, Thomas F (LABOR) [mailto:
> Thomas.Mercadante_at_labor.state.ny.us]
> *Sent:* 14 May 2007 15:43
> *To:* John Dunn; oracle-l
> *Subject:* RE: Error starting sqlplus
>
> 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
>
>
>

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

--
http://www.freelists.org/webpage/oracle-l
Received on Mon May 14 2007 - 11:26:17 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US