By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,197 Members | 974 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,197 IT Pros & Developers. It's quick & easy.

Connecting from Windows

P: n/a
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
Jul 19 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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.
Jul 19 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Browse more Oracle Database Questions on Bytes