Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!rip!news.webusenet.com!feed2.newsreader.com!newsreader.com!priapus.visi.com!orange.octanews.net!news.octanews.net!news-out.visi.com!petbe.visi.com!news.state.mn.us!not-for-mail
From: Turkbear <john.g@dot.spamfree.com>
Newsgroups: comp.databases.oracle.server
Subject: Re: Can't connect to database using 'sqlplus <username>/<password>', even when ORACLE_SID is set.
Date: Fri, 12 Dec 2003 08:54:51 -0600
Organization: Minnesota Governmental/Educational Agencies
Lines: 42
Message-ID: <dhljtv4897ta393fcq5o253m1nv48nqh5f@4ax.com>
References: <ec4cec95.0312110342.855c34a@posting.google.com> <828Cb.95$BQ5.60@fed1read03> <ec4cec95.0312120006.6e4db9aa@posting.google.com>
Reply-To: johng@mm.nospam.com
NNTP-Posting-Host: gateway.dot.state.mn.us
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Trace: news.state.mn.us 1071240891 8155 156.98.4.11 (12 Dec 2003 14:54:51 GMT)
X-Complaints-To: news@news.state.mn.us
NNTP-Posting-Date: Fri, 12 Dec 2003 14:54:51 +0000 (UTC)
X-Newsreader: Forte Agent 1.93/32.576 English (American)
Xref: newssvr20.news.prodigy.com comp.databases.oracle.server:249980

jeffyee@hotmail.com (Jeffrey Yee) wrote:

>"Ana C. Dent" <anacedent@hotmail.com> wrote in message news:<828Cb.95$BQ5.60@fed1read03>...
>> Jeffrey Yee wrote:
>> 
>> > Hi,
>> > 
>> > As oracle user, I can use 'sqlplus <username>/<password>' to log in to
>> > a database, when ORACLE_SID is set. But when I'm login as root, and
>> > then set the ORACLE_SID, but 'sqlplus <username>/<password>' will give
>> > me the following error:
>> > ERROR:
>> > ORA-01034: ORACLE not available
>> 
>> No OS or version! :-(
>> No Oracle version! :-(
>> 
>> When connecting to a local database (using BEQ protocol & not SQL*Net),
>> both ORACLE_SID & ORACLE_HOME need to be correct & exported. Plus, PATH
>> needs to include $ORACLE_HOME/bin & if on *nix LD_LIBRARY_PATH needs to
>> include $ORACLE_HOME/lib
>
>My apology for not providing enough information. Here you go:
>database version: 8.1.6.3
>os version: HP-UX B.11.11
>
>In fact, I tried running the oracle user's .profile to set all the
>environment variables, but I still cannot connect to the database
>without using '@bscs_rtx'.
>
>I don't know why my company is using root to run bcv backup. I would
>prefer using oracle user, but this practice been around for a few
>years.

Set one more variable and try:

set LOCAL = bscs_rtx