Connecting from Windows

[Wayne Happ]

I have Oracle 9 running on a Linux RedHat Box V9.0.

But I'm having trouble connecting from a windows machine via PL/SQL
Develover. When I startup the application the instance name appears but when
I try to login as sysdba I get the error.

ORA-12545 Connection failed because target host or object does not exist.

I'm guessing that there's something net8 I have to setup. This is a new
installation. Can someone point me in the right direction?

-Wayne

[Hans Forbrich]

Wayne Happ wrote:

I have Oracle 9 running on a Linux RedHat Box V9.0.

But I'm having trouble connecting from a windows machine via PL/SQL
Develover. When I startup the application the instance name appears but when
I try to login as sysdba I get the error.

ORA-12545 Connection failed because target host or object does not exist.

I'm guessing that there's something net8 I have to setup. This is a new
installation. Can someone point me in the right direction?

-Wayne

Probably a config issue - on your Windows machine, you should find a
TNSNAMES.ORA file, hopefully in the 'ORACLE HOME'/network/admin
directory.

Some common things that could go wrong include: the TNSNAMES.ORA file
has not been set up (you should be able to use 'netca.exe' to configure
that) or you have multiple TNSNAMES.ORA files (in separate
ORACLE_HOME/network/admin directories (due to multiple installs) and you
are not using the right one.

Some tricks to configure the TNSNAMES.ora: copy a working version to the
directory (say from your Linux install); read the http://www.dizwell.com
docco on installing Oracle on Red Hat (has an excellent section on
configuring network); read the "Oracle Networking" docco from
http://docs.oracle.com

HTH
/Hans

BTW: Oracle Networking is the new (Oracle9i) name for Net8, aka
SQL*Net. I'm told the name was changed apparently to better describe
the new functionality.