Thanks for the replies. I had to set the TWO_TASK environmental variable on
HPUX to correspond to tnsnames to get the connection.
Rick Wessman wrote in message ...
>Check your listener.ora on the remote machine. Make that sure that the
address
>to which you are connecting specifies the correct ORACLE_SID and
ORACLE_HOME.
>
> Rick
>"Dan Knott" <dankno_at_saif.com> writes:
>
>> I'm trying to connect from SQL*Plus 3.3.4 on a HPUX 10.2 server to an
8.1.5
>> database on NT4 SP5.
>>
>> After changing the ORACLE_SID environmental variable, I launch SQL*Plus
and
>> get the following error when I try to log on.
>>
>> ERROR: ORA-01034: ORACLE not available
>> ORA-07318: smsget: open error when opening sgadef.dbf file.
>> HP-UX Error: 2: No such file or directory.
>>
>> I'm able to signon with SQL*Plus to a local database and do a successful
>> conn scott/tiger_at_nt8i. I'm also able to create and use a database link
from
>> the local database to the 8.1.5 database.
>>
>> Why is SQL*Plus looking for the address of a remote SGA on launch?
>>
>> Thanks for any help.
>>
>>
>>
>
>--
> Rick Wessman
> Security and Directory Technologies
> Server Technologies
> Oracle Corporation
> rwessman_at_us.oracle.com
Received on Mon Aug 09 1999 - 15:33:15 CDT
