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

jeffyee_at_hotmail.com (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 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 Received on Fri Dec 12 2003 - 08:54:51 CST