Re: Strange problem logging on...

From: Volker Hetzer <volker.hetzer_at_ieee.org>
Date: Tue, 13 May 2003 19:26:34 +0200
Message-ID: <b9r9sa$u2s$1@dackel.pdb.sbs.de>

Hans Forbrich wrote:
> Volker Hetzer wrote:
>
>> Hi!
>> (9i, suse linux)
>> I've got a very strange problem when I try to log on to
>> my database (redhat 8) from a suse linux client:
>>
>> sqlplus kurs@$ORACLE_SID/kurs
>> works
>>
>> but sqlplus kurs/kurs
>> returns with ORA-12545: Connect failed because target host or object
>> does not exist
>>
>> Any idea what that could be?
>
> The oracle authentication string is generally user/passwd_at_target - in
sqlplus kurs/kurs@$ORACLE_SID works too. Only when sqlplus has to take the SID from the environment, it fails.

> the simplest environment the target is defined in the tnsnames.ora on
> the client machine in the $ORACLE_HOME/network/admin directory.
>
> Therefore, how is your tnsnames.ora configured?

# TNSNAMES.ORA Network Configuration File: /opt/oracle/client/9.2.0.1.0/network/admin/tnsnames.ora # Generated by Oracle configuration tools. ECADTST.ECAD =

(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = database1.ecad)(PORT = 1521))

)
(CONNECT_DATA =
(SERVICE_NAME = ECADTST.ecad)
)
)

Anything wrong with that?

Greetings and thanks!
Volker

--
While it is a known fact that programmers
never make mistakes, it is still a good idea
to humor the users by checking for errors at
critical points in your program.
-Robert D. Schneider, "Optimizing INFORMIX
 Applications"

Received on Tue May 13 2003 - 12:26:34 CDT