can tnsping but sqlplus gets ora-12545:Connect failed because target host or object does not exist

rwmeyer17
rwmeyer17 used Ask the Experts™
on
I've installed Oracle 10g client software, and I trying to connect to an Oracle 9i remote database running on a virtual server in a different domain. I've had Oracle 7.x client installed on machine, but have removed. Can tnsping the 9i databse, but when I try to connect to it via SQLPlus, I get ora-12545:Connect failed because target host or object does not exist.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®

Author

Commented:
Still not having any luck, I've verified I only have a single sqlnet.ora and tnanames.ora file on client, oracle_home looks OK, and I've tried a service name both with and without domain name suffix, nothing working yet.
When you do tnsping does it say it makes use of the TNSNAMES.ora file? Can you take a screenshot of the tnsping result? Is there a SQLNET.ORA file present?
Success in ‘20 With a Profitable Pricing Strategy

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Author

Commented:
Here's a screen shot of the tnsping, and yes, there's a sqlnet.ora present
Ora12545Document1.doc
Sorry! I don't have any DOC viewer installed in my laptop yet.. Can you please post it as a JPEG file?

Also provide the TNSNames.ora file entry. In that, there would be a server name. Are you able to ping that server using "ping" command?

Author

Commented:
I've attached the jpg, I am able to ping the server, here's the tnanames.ora file

# tnsnames.ora Network Configuration File: C:\oracle\product\10.2.0\ClientOnly\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.

ULTRAPACS =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.170.8.180)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = SHARED)
      (SERVICE_NAME = pacs)
    )
  )


ORA12545Error.JPG
Global database name is of the format database_name.domain_name. In your case database_name is pacs and domain_name is something else (probably .world??)

So your tnsnames entry should be <something>.world. You can update the tnsnames.ora file to name the entry in this convention.

Other option is to comment out the NAMES.DEFAULT_DOMAIN parameter in SQLNet.ora file. Hope this helps!

Author

Commented:
I've tried it with and without the domain name, on both the entry name and service name, results are the same either way. I don't have a DEFAULT_DOMAIN entry in sqlnet.ora
Is the Oracle listener running properly on the server machine?
can you show a screenshot of the actual error?
Commented:
Question PAQ'd, 250 points not refunded, and stored in the solution database.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial