Re: Conecting to Oracle - TNS problems

Mike Brodbelt wrote:
>
> Hi,
>
> I have an Oracle 8i database (8.1.5) running on a Sun machine. I have a
> number of clients which need to connect to this machine. Most of these
> are Windows machines, and for these, I have simply installed the Oracle
> supplied Net8/ODBC clients for Windows, and can connect fine.
>
> I also have a couple of Linux machines which I want to be able to
> connect to the database. I searched around, and found someone who had
> some pre-packaged rpm's containing enough Oracle files to allow me to
> compile the Perl DBD::Oracle module, and both the machines in question
> can run Perl scripts that successfully connect to the database and
> retrieve data.
>
> However, I cannot successfully connect to the Oracle instance from
> SQLPlus, or other applications I'm trying to use (TOra). I get this
> error:-
>
> $ export ORACLE_HOME=/opt/oracle
> $ export ORACLE_SID=SCORPIO
> $ sqlplus
>
> SQL*Plus: Release 8.0.5.0.0 - Production on Thu Oct 4 12:41:22 2001
>
> (c) Copyright 1998 Oracle Corporation. All rights reserved.
>
> Enter user-name: system
> ERROR:
> ORA-12545: Connect failed because target host or object does not exist
>
> Enter user-name:
>

What about "sqlplus system_at_scorpio" ?

The Net*8 protocol needs to know: which host, which port, and which instance on that machine (ORACLE_SID). Just by setting ORACLE_SID you don't provide enough information.

Normally you leave ORACLE_SID unset on the client and provide just a net alias via tnsnames.ora. This contains the mapping alias -> (host, port, SID). Uwe

-- 
Uwe Schneider       | Telefon +49 7251 / 82587
Karlsdorfer Str. 31 | Mail    pi_at_richard-schneider.de
DE-76646 Bruchsal   | http://www.richard-schneider.de/uwe
Linux - OS al dente!