Re: Can't connect to database using 'sqlplus <username>/<password>', even when ORACLE_SID is set.

From: Ana C. Dent <anacedent_at_hotmail.com>
Date: Fri, 12 Dec 2003 17:17:22 -0800
Message-ID: <AMtCb.2930$BQ5.2566@fed1read03>

Jeffrey Yee wrote:

> "Ana C. Dent" <anacedent_at_hotmail.com> wrote in message news:<828Cb.95$BQ5.60_at_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 fixed this very problem today for one of my sandbox DBs. While logged on as user "oracle" or whoever owns all the Oracle files cd $ORACLE_HOME/bin
ls -l oracle
chmod u+s oracle
chmod g+s oracle

Hopefully now the problem has been solved. Received on Fri Dec 12 2003 - 19:17:22 CST