Re: Strange problem logging on...

Volker Hetzer wrote:

> Hans Forbrich wrote:
> > Volker Hetzer wrote:
> >
> 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)
> )
> )

Looks reasonable - however tnsnames.ora is extremely (let's say rediculously) sensitive to formatting. The header indicating it is generated is comforting.

This is a basic troubleshooting process - instead of going through the beginner level basics (and potentially inadvertently insulting you), please describe what you have done/not done and are capable of doing. For example - what about tnsping? what about your Oracle related environment variables? Received on Tue May 13 2003 - 12:54:10 CDT